|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
<?php $mysqli = new mysqli('localhost', 'root', '', 'databasename'); if($mysqli->connect_errno > 0){ die('Unable to connect to database [' . $mysqli->connect_error . ']'); } $sql = "SELECT * FROM client_login WHERE id = 9"; if(!$result = $mysqli->query($sql)){ die('There was an error running the query [' . $mysqli->error . ']'); } while($row = $result->fetch_assoc()){ echo $row['fname'] . '<br />'; echo $row['sname'] . '<br />'; echo $row['number'] . '<br />'; } |
This can be done inline which is shorter code, but harder to read. If you use that variable only once on that page, it should work well.
Sometimes you want to see all the collections or import in one place.
I prefer the first way, as I think it looks nicer in a block, and it helps with my OCD of neatness!
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<?php $sql = $mysqli->query("SELECT id, name, about, position FROM country ORDER BY position"); while($data = $sql->fetch_array()) { echo ' <tr data-index="'.$data['id'].'" data-position="'.$data['position'].'"> <td>'.$data['name'].''.$data['about'].'</td> </tr> '; } ?> |
