DAY 13 PHP PROGRAMMING
http://php.flashwebhost.com/tom/day_13_mysql_read.php
PHP Code:
<?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>';
}
Bookmarks