Read multiple entries with a Where clause

Question

I tried to build a User search function but i ran into a problem a while ago. My function, which looks like this:

"Select id, username FROM users WHERE username LIKE '%search%'"

Is showing me only the user Janamaris ( userlist is a bit lower ) but as you see jns.drws has also a j in his username ( J = $search ).

So my Problem now i want to show all users with a J in his/her username

So how can i get all users with WHERE?

My Signed Users are [id, username]

Tolkosino

47, Janamaris

48, TheCrazyMan

49, jns.drws

score 1 · Accepted Answer · edited May 23 '17 at 10:30

1

Beispiel einer Foreach Schleife bzw. While Schleife Posten?

English: Can someone post an example of a foreach e.g. while loop?

The sql is fine and will get all rows you need:

"Select id, username FROM users WHERE username LIKE '%search%'"

If you have problems with upper/lower case then read this: https://stackoverflow.com/a/2876820/4916265

Example with while

if($result = $mysqli->query($sql)){
 if(is_object($result)){
   while($row = $result->fetch_assoc()){
     echo "<div id=\"content-b\">";
     echo "<p class=\"usrsrch\">User ID : " . $row['id'] . "";
     echo "<br>";
     echo "<p class=\"usrsrch\">Username : . $row['username'] . "";
     echo "</div>";
   }
  } else {
    echo 'nix gefunden';
  }
}

edited May 23 '17 at 10:30

Community

1
1

answered Apr 12 '17 at 15:06

JustOnUnderMillions

3,741
9
12

I wonder where the OP went; what you posted should be working for them. – Funk Forty Niner Apr 12 '17 at 15:32
hm im trying right now... somehow it dosnt work right – Tolkosino Apr 12 '17 at 15:40
Ok now i get both users but only showed jns.drws i look how i fix that but anyway thanks for your help – Tolkosino Apr 12 '17 at 15:48
OK guys got this i had to move the div open 2 rows above so the whole while($row .... ) loop is in the div and the div closer also 1 row down. – Tolkosino Apr 12 '17 at 15:56

Read multiple entries with a Where clause

1 Answers1