首页 \ 问答 \ 从SQL数组中添加字符串长度(Adding up string length from SQL array)

从SQL数组中添加字符串长度(Adding up string length from SQL array)

 我想从插入的URL中添加字符长度。 我已从数组中的数据库中获取所有选定的URL，并尝试在foreach函数中添加它们。  
function countLen($email) {

    $countLen = mysql_query("SELECT url FROM urls WHERE user='$email'");
    $resultLen = mysql_result($countLen, 0);

    foreach($resultLen as &$string) {


        $length = strlen($string);
        $totallen = ($totallen + $length);

        return $totallen;




    }





}

I am trying to add up the character length from an inserted URL. I have grabbed all the selected URLs from the database in an array and am trying to add them up in a foreach function. 
function countLen($email) {

    $countLen = mysql_query("SELECT url FROM urls WHERE user='$email'");
    $resultLen = mysql_result($countLen, 0);

    foreach($resultLen as &$string) {


        $length = strlen($string);
        $totallen = ($totallen + $length);

        return $totallen;




    }





}

原文：https://stackoverflow.com/questions/8842557

更新时间：2022-12-10 16:12

最满意答案

 您的问题是您尝试在ng-repeat中的html模板中分配范围变量。 ng-repeat为每个项创建一个嵌套范围，因此赋值仅在该内部范围内发生。  
 要解决此问题，请确保您指定的名称至少包含一个点. 。 一种简单的方法是切换代码以使用'controller as'语法，然后您可以直接引用所需的控制器。 另一种方法是将范围变量推送到对象内而不是直接放在范围内。  
<body ng-app="app" ng-controller="Ctrl as vm">
    <zc-select status-var="vm.CountryOpen">
        <div class="select-head">
            Select a country
        </div>
        <ul class="select-content" ng-show="vm.CountryOpen">
            <li ng-repeat="i in vm.countries" id="{{i.code}}" ng-click="vm.CountryOpen = false">{{i.name}}</li>
        </ul>
    </zc-select>
</body>
 
 然后更新您的控制器以使用this而不是$scope ：  
app.controller('Ctrl', [function() {
   var vm = this;
   vm.CountryOpen = false;
   vm.Country = [];
   vm.countries = [
   ...
 
 （我将ng-init的东西推入控制器，因为尽可能保持尽可能多的代码并保持html尽可能干净是好的） 

Your problem is that you are trying to assign to a scope variable in your html template inside an ng-repeat. The ng-repeat creates a nested scope for each item, so the assignment happens only within that inner scope. 
To fix this make sure the name you assign contains at least one dot .. An easy way to do this is to switch your code to use the 'controller as' syntax and then you can reference the required controller directly. Another way would simply be to push your scope variables inside an object instead of directly on the scope. 
<body ng-app="app" ng-controller="Ctrl as vm">
    <zc-select status-var="vm.CountryOpen">
        <div class="select-head">
            Select a country
        </div>
        <ul class="select-content" ng-show="vm.CountryOpen">
            <li ng-repeat="i in vm.countries" id="{{i.code}}" ng-click="vm.CountryOpen = false">{{i.name}}</li>
        </ul>
    </zc-select>
</body>
 
and then update your controller to use this instead of $scope: 
app.controller('Ctrl', [function() {
   var vm = this;
   vm.CountryOpen = false;
   vm.Country = [];
   vm.countries = [
   ...
 
(I pushed the ng-init stuff into the controller because it's good to keep as much of the code together as you can and keep the html as clean as possible)

从SQL数组中添加字符串长度(Adding up string length from SQL array)

最满意答案

相关问答

ng-click Angularjs ui-grid cell模板不起作用(ng-click in Angularjs ui-grid cell Template doesn't work)[2023-03-29]

为什么ng-click不起作用？(Why is ng-click not working?)[2023-07-27]

AngularJS ng-click不起作用(AngularJS ng-click doesn't work)[2022-03-06]

AngularJS - ng-click按钮不起作用(AngularJS - ng-click buttons not working)[2023-10-14]

AngularJS，. The `ng-click` on the [2024-03-16]

AngularJs ng-click not working指令(AngularJs ng-click not working directive)[2022-07-18]

ng-click在AngularJS中不起作用(ng-click not working in AngularJS)[2023-07-07]

AngularJS ng-click无法在
标签中工作(AngularJS ng-click not working in
tag)[2023-09-29]

AngularJS ng-click由{{$ index}}打破(AngularJS ng-click broken by {{$index}})[2021-12-20]

AngularJs |(AngularJs | ng-click not working)[2023-09-16]

相关文章

最新问答

从SQL数组中添加字符串长度(Adding up string length from SQL array)

最满意答案

相关问答

ng-click Angularjs ui-grid cell模板不起作用(ng-click in Angularjs ui-grid cell Template doesn't work)[2023-03-29]

为什么ng-click不起作用？(Why is ng-click not working?)[2023-07-27]

AngularJS ng-click不起作用(AngularJS ng-click doesn't work)[2022-03-06]

AngularJS - ng-click按钮不起作用(AngularJS - ng-click buttons not working)[2023-10-14]

AngularJS，。(AngularJS, . The `ng-click` on the is not work)[2024-03-16]

AngularJs ng-click not working指令(AngularJs ng-click not working directive)[2022-07-18]

ng-click在AngularJS中不起作用(ng-click not working in AngularJS)[2023-07-07]

AngularJS ng-click无法在标签中工作(AngularJS ng-click not working in tag)[2023-09-29]

AngularJS ng-click由{{$ index}}打破(AngularJS ng-click broken by {{$index}})[2021-12-20]

AngularJs |(AngularJs | ng-click not working)[2023-09-16]

相关文章

最新问答

AngularJS，. The `ng-click` on the [2024-03-16]

AngularJS ng-click无法在
标签中工作(AngularJS ng-click not working in
tag)[2023-09-29]