I corrected the code. Thank you for the help.
http://php.flashwebhost.com/stefin/mysql_1.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>' . $chat->name . '</b> says : ' . $chat->message; echo '<br>'; echo '<hr>'; }




Reply With Quote
Bookmarks