Day 13 - MySQL - Become PHP Expert in 30 days

[image]

DAY 13 PHP PROGRAMMING

http://php.flashwebhost.com/tom/day_13_mysql_read.php

<?php
$db_server = '127.0.0.1';$db_user = 'fwhphp_user';$db_password = 'k5BJRaX6SFbs';$db_name = 'fwhphp_db';
$mysqli = new mysqli($db_server, $db_user, $db_password, $db_name);
if ($mysqli->connect_errno) {
echo 'connect failed: ' . $mysqli->connect_error;exit();}
$sql = 'SELECT * FROM `chat`';$result = $mysqli->query($sql);echo '<p>MySql have returned ' . $result->num_rows . ' records</p>';
echo '<br>';echo '<hr>';
while ($chat = $result->fetch_object()) {
echo '<b><i>'. $chat->name . '</i></b> says: ' . $chat->message ;
echo '</br>';echo '</hr>';
}

[admin]

Good, working perfectly. If you don't understand any part, ask here. Some times it take some time to understand stuff properly, so you can skip forward, you can come back later as required. When we have done more code like this, you will get a much better idea and things may get easier.