Day 14 - Storing Data in MySQL - Become PHP Expert in 30 days

[admin]

http://php.flashwebhost.com/stefin/mysql_connect.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 = 'INSERT INTO `chat` SET `name`=\'Stefin\', `message`=\'Childhood is the happiest time of life. Be Happy and enjoy your Childhood.\''; 


if ($mysqli->query($sql) === TRUE) { 
    echo '<h1>Data saved into MYSQL</h1>'; 
} else { 
    echo '<h1>Failed to Insert Data to Database</h1>'; 
    echo $mysqli->error; 
}

Nice, working perfectly and good message :)

You can see the data from MySQL on page

http://php.flashwebhost.com/stefin/mysql_1.php

[minisoji]

http://php.flashwebhost.com/mini/mysql_data.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 = 'INSERT INTO `chat` SET `name`=\'Jiya\', `message`=\'My school days were the happiest days of my life\'';

if ($mysqli->query($sql) === TRUE) {
    echo '<h1>Data saved into MYSQL</h1>';
} else {
    echo '<h1>Failed to Insert Data to Database</h1>';
    echo $mysqli->error;
}

[image]

DAY 14 PHP PROGRAMMING

http://php.flashwebhost.com/tom/day_14_mysql_insert.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_errno ;
exit();
}
$sql = 'INSERT INTO `chat` SET `name` = \'Mohanlal\' , `message` = \'Nee Po Mone Dineshaa\'';
if ($mysqli->query($sql) === TRUE) {
echo ' DATA SAVED INTO MYSQL';
} else {
echo ' Failed to Insert Data to Database';
echo $mysql->error; 
}