chris93
-
Posts
3 -
Joined
-
Last visited
chris93's Achievements
Newbie (1/5)
0
Reputation
-
<b></b>i have written a code that connects to a database using Xampp in php... but it does not sort the database at all. <?php //Step1 $db = mysqli_connect('localhost','root','123','first_db') or die('Error connecting to MySQL server.'); ?> <html> <head> </head> <body> <h1>PHP connect to MySQL</h1> <?php $sql ="INSERT INTO users (id,name,password) VALUES ('7','chris','444')"; mysqli_query($db,$sql); $sql = "SELECT * FROM users ORDER BY id 'ASC'"; $query = mysqli_query($db, $sql); //Step2 $query = "SELECT * FROM users"; mysqli_query($db, $query) or die('Error querying database.'); //Step3 $result = mysqli_query($db, $query); //$row = mysqli_fetch_array($result); while ($row = mysqli_fetch_array($result)) { echo $row[0] . ' ' . $row[1] . ': '. $row[2] .'<br />'; } //Step 4 mysqli_close($db); ?> </body> </html>