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

[sherlyk]

http://php.flashwebhost.com/sherly/msqlmsg.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`=\'Neena\', `message`=\'To acquire knowledge, one must study;
but to acquire wisdom, one must observe\'';

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

[admin]

http://php.flashwebhost.com/sherly/msqlmsg.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`=\'Neena\', `message`=\'To acquire knowledge, one must study;
but to acquire wisdom, one must observe\'';

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

Good, only problem is when ever some one visit the page, this data get inserted. That is not an issue as we have no real use for this MySQL database or table.

It will be nice if we show an HTML form with 2 fields. Name and Message, when user submit, data get stored in database, so every time new message can be inserted to MySQL.

For now, we understand how to store data into mysql, that will be fine for now.

[annie]

http://php.flashwebhost.com/annie/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_error;
    exit();
}

$sql = 'INSERT INTO `chat` SET `name`=\'Priya\', `message`=\'Optimism is essential to achievement and it is also the foundation of courage and true progress.
\'';

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

[admin]

http://php.flashwebhost.com/annie/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_error;
    exit();
}

$sql = 'INSERT INTO `chat` SET `name`=\'Priya\', `message`=\'Optimism is essential to achievement and it is also the foundation of courage and true progress.
\'';

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

Good, you can see inserted data on page

http://php.flashwebhost.com/annie/mysql.php

[stefin]

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

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