php output in alphabetical order after explode

Question

i have a string like

 $email= "[email protected],[email protected],[email protected]";

first i explode this like

 $wordChunks = explode(",", $email);
for($i = 0; $i < count($wordChunks); $i++){

$eex = mysqli_query($database->connection,"SELECT * FROM contacts where email =   '$wordChunks[$i]' and owner = '$session->username'") or die(mysqli_error());
    while($zzz = mysqli_fetch_array($eex)){


     if(empty($zzz['bedrijfsnaam'])){
        $aa = "<font size='2'>".ucfirst($zzz['name'])." ".ucfirst($zzz['lastname'])."</font>";
    }else{
     $aa = "<font size='2'>".ucfirst($zzz['bedrijfsnaam'])."</font>";
    }
    echo $aa;

     }
}

The question is how can i order $aa in alphabetic order

What i tried is

$array = str_split($aa, 1);
sort($array);
foreach ($array as $val) {
echo $val."<br>";
}

But this orders only the string in $aa; example string = hellow output is ehllow. but i want order the output of $aa in the while loop

You can ORDER BY in your SQL statement, if I understand you right. — andrewsi
– andrewsi, Commented Dec 19, 2013 at 13:11
Order is not needed becouse the db output is a single output per email — Yunus
– Yunus, Commented Dec 19, 2013 at 14:21

Suresh Kamrushi · Accepted Answer · 2013-12-19 13:18:58Z

1

No need to use explode() and than loop it. Just put that string in query and it will work.Change your query to use IN() for searching emails and do order by so that you will get the data in ascending order itself. you can try like this:

$eex = mysqli_query($database->connection,"SELECT * FROM contacts where email IN ($email) and owner = '$session->username' order by email") or die(mysqli_error());
    while($zzz = mysqli_fetch_array($eex)){


     if(empty($zzz['bedrijfsnaam'])){
        $aa = "<font size='2'>".ucfirst($zzz['name'])." ".ucfirst($zzz['lastname'])."</font>";
    }else{
     $aa = "<font size='2'>".ucfirst($zzz['bedrijfsnaam'])."</font>";
    }
    echo $aa;

     }

answered Dec 19, 2013 at 13:18

Suresh Kamrushi

16.2k13 gold badges80 silver badges93 bronze badges

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

1 Comment

Yunus Over a year ago

This is not the answer what i am looking for. I must explode $email and use it to get the results in db for each email that is exploded. Each email adresses in $email is also in contacts row of my db with information what i need like name lastname...

sergio · Accepted Answer · 2013-12-19 13:13:02Z

0

Just Use

$aa = 'hellow';
$array = str_split($aa, 1);

foreach ($array as $val) {
echo $val."<br>";
}

Result:

h e l l o w

answered Dec 19, 2013 at 13:13

sergio

5,2607 gold badges27 silver badges47 bronze badges

Collectives™ on Stack Overflow

php output in alphabetical order after explode

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related