Day 13 - MySQL - Become PHP Expert in 30 days

[sherlyk]

http://php.flashwebhost.com/sherly/mysql.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>' .  $chat->name . '</b> says : ' . $chat->message;
    echo '<br>';
    echo '<hr>';
}

[annie]

http://php.flashwebhost.com/annie/mysql.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>' .  $chat->name . '</b> says : ' . $chat->message;
  echo '<br>';
  echo '<hr>';
}

[admin]

http://php.flashwebhost.com/annie/mysql.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>' .  $chat->name . '</b> says : ' . $chat->message;
  echo '<br>';
  echo '<hr>';
}

Good, we will need this code on Day 14 to see data saved to database.

[stefin]

I corrected the code. Thank you for the help.

http://php.flashwebhost.com/stefin/mysql_1.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>' .  $chat->name . '</b> says : ' . $chat->message;
    echo '<br>';
    echo '<hr>';
}

[admin]

I corrected the code. Thank you for the help.

http://php.flashwebhost.com/stefin/mysql_1.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>' .  $chat->name . '</b> says : ' . $chat->message;
    echo '<br>';
    echo '<hr>';
}

Very nice, you don't need to remember the code, just use this code with little modification when you need to read data from MySQL.

[minisoji]

http://php.flashwebhost.com/mini/mysql.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>' .  $chat->name . '</b> says : ' . $chat->message;
    echo '<br>';
    echo '<hr>';
}

[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>';
}