Adding up string length from SQL array

Question

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;




    }





}

You appear to be returning from inside the foreach. Did you mean to do that? — seth.miller
– seth.miller, Commented Jan 12, 2012 at 21:29
You need to move your return statement outside of the foreach loop. — Brian Glaz
– Brian Glaz, Commented Jan 12, 2012 at 21:31

webbiedave · Accepted Answer · 2012-01-12 21:29:36Z

6

You could just do it all the summing in SQL:

function countLen($email)
{
    $res = mysql_query("SELECT SUM(LENGTH(url)) as 'sum' FROM urls WHERE user='$email'");
    return current(mysql_fetch_array($res));
}

answered Jan 12, 2012 at 21:29

webbiedave

49k8 gold badges92 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Josh · Accepted Answer · 2012-01-12 21:30:04Z

2

Try:

$total = 0;

$res = mysql_query("SELECT url FROM urls WHERE user='$email'");
while( $row = mysql_fetch_assoc($res) )
{
  $total += strlen( $row['url'] );
}

answered Jan 12, 2012 at 21:30

Josh

12.6k12 gold badges77 silver badges118 bronze badges

Comments

Dipu Raj · Accepted Answer · 2012-01-12 21:30:45Z

1

The return should be out side the loop.. like

function countLen($email) {

  $countLen = mysql_query("SELECT url FROM urls WHERE user='$email'");
  $resultLen = mysql_result($countLen, 0);
  $totallen = 0;
  foreach($resultLen as &$string) {
    $length = strlen($string);
    $totallen = ($length + $totallen);
  }
  return $totallen;
}

answered Jan 12, 2012 at 21:30

Dipu Raj

1,8944 gold badges33 silver badges39 bronze badges

Collectives™ on Stack Overflow

Adding up string length from SQL array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related