reference mysql database insertionLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

Insert data into the mysql databse table

Below example will do the insert data into mysql database

<?php
$databasehost = 'localhost';
$databaseuser = 'root';
$databasepassword = '';
$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);
if(! $connection )
{
  die('Could not connect: ' . mysql_error());
}
$sqlqry = 'INSERT INTO mydoubts_data '.
       '(id,name) '.
       'VALUES ( "hello" )';

mysql_select_db('mydoubts_data');
$output = mysql_query( $sqlqry, $connection);
if(! $output )
{
  die('Could not enter data: ' . mysql_error());
}
echo "Entered data successfully\n";
mysql_close($connection);
?>

<?php

$databasehost = 'localhost';

$databaseuser = 'root';

$databasepassword = '';

$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);

if(! $connection )

{

die('Could not connect: ' . mysql_error());

}

$sqlqry = 'INSERT INTO mydoubts_data '.

'(id,name) '.

'VALUES ( "hello" )';

mysql_select_db('mydoubts_data');

$output = mysql_query( $sqlqry, $connection);

if(! $output )

{

die('Could not enter data: ' . mysql_error());

}

echo "Entered data successfully\n";

mysql_close($connection);