id: 2 - Name: Don Doe
id: 4 - Name: John Doe
Here is the code for accessing the database and display the information.
<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "DBname"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT id, firstname, lastname FROM MyGuests WHERE lastname='Doe'"; $result = $conn->query($sql); echo "<p><mark>"; if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>"; } } else { echo "0 results"; } echo "</mark></p>"; $conn->close(); ?>
Simular example displayed in a table using "LIKE" and the "%" wildcard
ID | Name | |
---|---|---|
2 | Don Doe | john@example.com |
4 | John Doe | john@deere.net |
6 | Daisy Duck | daisyduck@example.com |
7 | Julie Dooley | juliedooley@example.com |
20 | John Deere | john@deere.net |
22 | Donald Duck | dduckn@example.com |
23 | Daisy Duck | daisyduck@example.com |
24 | Julie Dooley | juliedooley@example.com |
25 | John Deer | johnd@example.com |
27 | John Deer | johnd@example.com |
28 | John Deere | john@deere.net |
29 | John Deer | johnd@example.com |
31 | Donald Duck | dduckn@example.com |
32 | Daisy Duck | daisyduck@example.com |
33 | Julie Dooley | juliedooley@example.com |
42 | John Deer | johnd@example.com |
43 | John Deere | john@deere.net |
45 | Donald Duck | dduckn@example.com |
46 | Daisy Duck | daisyduck@example.com |
47 | Julie Dooley | juliedooley@example.com |
54 | John Deer | johnd@example.com |
55 | John Deere | john@deere.net |
61 | Donald Duck | dduckn@example.com |
62 | Daisy Duck | daisyduck@example.com |
63 | Julie Dooley | juliedooley@example.com |
67 | John Deer | johnd@example.com |
68 | John Deere | john@deere.net |
72 | Donald Duck | dduckn@example.com |
73 | Daisy Duck | daisyduck@example.com |
74 | Julie Dooley | juliedooley@example.com |
75 | John Deere | john@deere.net |
83 | John Deer | johnd@example.com |
85 | John Deer | johnd@example.com |
86 | John Deere | john@deere.net |
92 | Donald Duck | dduckn@example.com |
93 | Daisy Duck | daisyduck@example.com |
94 | Julie Dooley | juliedooley@example.com |
105 | John Deer | johnd@example.com |
106 | John Deere | john@deere.net |
108 | Donald Duck | dduckn@example.com |
109 | Daisy Duck | daisyduck@example.com |
110 | Julie Dooley | juliedooley@example.com |
117 | John Deere | john@deere.net |
119 | Donald Duck | dduckn@example.com |
120 | Daisy Duck | daisyduck@example.com |
121 | Julie Dooley | juliedooley@example.com |
122 | John Deer | johnd@example.com |
128 | Donald Duck | dduckn@example.com |
129 | Daisy Duck | daisyduck@example.com |
130 | Julie Dooley | juliedooley@example.com |
132 | John Deere | john@deere.net |
136 | John Deer | johnd@example.com |
141 | John Deere | john@deere.net |
145 | Donald Duck | dduckn@example.com |
146 | Daisy Duck | daisyduck@example.com |
147 | Julie Dooley | juliedooley@example.com |
153 | John Deer | johnd@example.com |
154 | John Deere | john@deere.net |
158 | Donald Duck | dduckn@example.com |
159 | Daisy Duck | daisyduck@example.com |
160 | Julie Dooley | juliedooley@example.com |
162 | John Deer | johnd@example.com |
163 | John Deere | john@deere.net |
172 | Donald Duck | dduckn@example.com |
173 | Daisy Duck | daisyduck@example.com |
174 | Julie Dooley | juliedooley@example.com |
178 | John Deer | johnd@example.com |
179 | John Deere | john@deere.net |
180 | Donald Duck | dduckn@example.com |
181 | Daisy Duck | daisyduck@example.com |
182 | Julie Dooley | juliedooley@example.com |
188 | Donald Duck | dduckn@example.com |
189 | Daisy Duck | daisyduck@example.com |
190 | Julie Dooley | juliedooley@example.com |
195 | John Deere | john@deere.net |
200 | John Deer | johnd@example.com |
207 | John Deer | johnd@example.com |
208 | John Deere | john@deere.net |
209 | Donald Duck | dduckn@example.com |
210 | Daisy Duck | daisyduck@example.com |
211 | Julie Dooley | juliedooley@example.com |
217 | John Deer | johnd@example.com |
221 | John Deer | johnd@example.com |
222 | John Deere | john@deere.net |
223 | Donald Duck | dduckn@example.com |
224 | Daisy Duck | daisyduck@example.com |
225 | Julie Dooley | juliedooley@example.com |
234 | John Deere | john@deere.net |
239 | John Deer | johnd@example.com |
240 | Donald Duck | dduckn@example.com |
241 | Daisy Duck | daisyduck@example.com |
242 | Julie Dooley | juliedooley@example.com |
250 | John Deere | john@deere.net |
252 | Donald Duck | dduckn@example.com |
253 | Daisy Duck | daisyduck@example.com |
254 | Julie Dooley | juliedooley@example.com |
255 | John Deer | johnd@example.com |
257 | Donald Duck | dduckn@example.com |
258 | Daisy Duck | daisyduck@example.com |
259 | Julie Dooley | juliedooley@example.com |
263 | John Deere | john@deere.net |
268 | John Deer | johnd@example.com |
269 | Donald Duck | dduckn@example.com |
270 | Daisy Duck | daisyduck@example.com |
271 | Julie Dooley | juliedooley@example.com |
276 | John Deere | john@deere.net |
281 | John Deer | johnd@example.com |
282 | Donald Duck | dduckn@example.com |
283 | Daisy Duck | daisyduck@example.com |
284 | Julie Dooley | juliedooley@example.com |
289 | Donald Duck | dduckn@example.com |
290 | Daisy Duck | daisyduck@example.com |
291 | Julie Dooley | juliedooley@example.com |
300 | John Deere | john@deere.net |
301 | John Deer | johnd@example.com |
305 | John Deere | john@deere.net |
309 | Donald Duck | dduckn@example.com |
310 | Daisy Duck | daisyduck@example.com |
311 | Julie Dooley | juliedooley@example.com |
317 | Donald Duck | dduckn@example.com |
318 | Daisy Duck | daisyduck@example.com |
319 | Julie Dooley | juliedooley@example.com |
323 | John Deere | john@deere.net |
328 | John Deer | johnd@example.com |
329 | Donald Duck | dduckn@example.com |
330 | Daisy Duck | daisyduck@example.com |
331 | Julie Dooley | juliedooley@example.com |
344 | John Deer | johnd@example.com |
350 | John Deere | john@deere.net |
355 | Donald Duck | dduckn@example.com |
356 | Daisy Duck | daisyduck@example.com |
357 | Julie Dooley | juliedooley@example.com |
358 | John Deer | johnd@example.com |
363 | Donald Duck | dduckn@example.com |
364 | Daisy Duck | daisyduck@example.com |
365 | Julie Dooley | juliedooley@example.com |
379 | Donald Duck | dduckn@example.com |
380 | Daisy Duck | daisyduck@example.com |
381 | Julie Dooley | juliedooley@example.com |
392 | Donald Duck | dduckn@example.com |
393 | Daisy Duck | daisyduck@example.com |
394 | Julie Dooley | juliedooley@example.com |
395 | John Deere | john@deere.net |
396 | John Deer | johnd@example.com |
399 | John Deere | john@deere.net |
401 | Donald Duck | dduckn@example.com |
402 | Daisy Duck | daisyduck@example.com |
403 | Julie Dooley | juliedooley@example.com |
404 | John Deer | johnd@example.com |
406 | John Deer | johnd@example.com |
407 | John Deere | john@deere.net |
413 | Donald Duck | dduckn@example.com |
414 | Daisy Duck | daisyduck@example.com |
415 | Julie Dooley | juliedooley@example.com |
416 | John Deer | johnd@example.com |
418 | Donald Duck | dduckn@example.com |
419 | Daisy Duck | daisyduck@example.com |
420 | Julie Dooley | juliedooley@example.com |
425 | John Deere | john@deere.net |
430 | John Deere | john@deere.net |
434 | John Deere | john@deere.net |
439 | John Deer | johnd@example.com |
440 | Donald Duck | dduckn@example.com |
441 | Daisy Duck | daisyduck@example.com |
442 | Julie Dooley | juliedooley@example.com |
447 | John Deer | johnd@example.com |
451 | John Deere | john@deere.net |
453 | Donald Duck | dduckn@example.com |
454 | Daisy Duck | daisyduck@example.com |
455 | Julie Dooley | juliedooley@example.com |
457 | John Deer | johnd@example.com |
458 | John Deere | john@deere.net |
464 | Donald Duck | dduckn@example.com |
465 | Daisy Duck | daisyduck@example.com |
466 | Julie Dooley | juliedooley@example.com |
473 | John Deere | john@deere.net |
478 | John Deer | johnd@example.com |
479 | Donald Duck | dduckn@example.com |
480 | Daisy Duck | daisyduck@example.com |
481 | Julie Dooley | juliedooley@example.com |
490 | Donald Duck | dduckn@example.com |
491 | Daisy Duck | daisyduck@example.com |
492 | Julie Dooley | juliedooley@example.com |
502 | Donald Duck | dduckn@example.com |
503 | Daisy Duck | daisyduck@example.com |
504 | Julie Dooley | juliedooley@example.com |
505 | John Deere | john@deere.net |
506 | John Deer | johnd@example.com |
Here is the code for accessing the database and display the information.
<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "DBname"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT id, firstname, lastname, email FROM MyGuests WHERE lastname LIKE 'D%'"; $result = $conn->query($sql); if ($result->num_rows > 0) { echo "<table><tr><th>ID</th><th>Name</th><th>Email></tr>"; // output data of each row while($row = $result->fetch_assoc()) { echo "<tr><td>".$row["id"]."</td><td>".$row["firstname"]." ".$row["lastname"]."</td><td>".$row["email"]."</td></tr>"; } echo "</table>"; } else { echo "<p>0 results</p>"; } $conn->close(); ?>