| <?php |
| $server = 'localhost';{ |
| $user = 'root'; |
| $password = ''; |
| $database = 'php'; |
| $contact = @mysqli_connect($server, $user, $password); |
| if ($contact) |
| mysqli_select_db ($contact, $database); |
| echo 'error: ' . mysql_error($contact); |
| } else { |
| if (isset($_POST['firstname'])) { |
| $sql = " |
| INSERT INTO |
| friends(firstname, lastname) |
| VALUES ('{$_POST['firstname']}', '{['lastname']}') |
| "; |
| $query = mysqli_query ($contact, $sql); |
| echo 'SQL: ' . $sql; { |
| $sql = "SELECT * FROM friends ORDER BY lastname"; |
| $query = mysqli_query ($contact, $sql); |
| echo '<h1>You have ' . mysqli_num_rows ($query) . ' friends</h1>'; |
| echo '<ul>'; |
| while ($friend = mysqli_fetch_assoc($query)) { |
| echo "<li>{$friend['firstname']} {$friend['lastname']} |
| } |
| echo '<ul>'; |
| mysqli_free_result($query); |
| echo 'Could not connect to the database to build' |
| . mysqli_connect_error($contact); |
| } |
| ?> |