<?php
 // Connect to the database
 $dbhost = 'localhost';
 $dbusername = 'testuser';
 $dbpasswd = 'testpassword';
 $database_name = 'simple';
 $connection = mysql_connect("$dbhost","$dbusername","$dbpasswd")
  or die ('Couldn\'t connect to server.');
 $db = mysql_select_db("$database_name", $connection)
  or die('Couldn\'t select database.');
 
 // Generate SQL code to store data on database.
 $insert_sql = 'INSERT INTO simple_table (text) VALUES (\'test text, 1,2,3\')';
 
 // Execute SQL code.
 mysql_query( $insert_sql )
  or die ( 'It Didn\’t Work: ' . mysql_error() );
 
 // Tell User we are done.
 echo 'Code Inserted';
?>
 
Create a new file called "test_select_mysql.php" and enter the following code into it:
 
<?php
 // Connect to the database
 $dbhost = 'localhost';
 $dbusername = 'testuser';
 $dbpasswd = 'testpassword';
 $database_name = 'simple';
 $connection = mysql_connect("$dbhost","$dbusername","$dbpasswd")
  or die ('Couldn\'t connect to server.');
 $db = mysql_select_db("$database_name", $connection)
  or die('Couldn\'t select database.');
 
 // Generate code to retrieve data from database.
 $select_sql = 'SELECT text FROM simple_table';
 
 // Retrieve code from database.
 $result = mysql_query( $select_sql )
  or die ( 'It Didn\’t Work: ' . mysql_error() );
 
 // Display results to user.
 while ( $row = mysql_fetch_object ( $result ) )
 {
  echo $row->text . ‘<br>’;
 }
?>

<?php
$host="localhost";
$user="root"  //It may different
$pass=""    //If u use password that write between " "
$database="test"  //you can also use any any created database name.
@mysql_connect($host,$user,$pass) or die("Sorry ,User name Or Password problem);
@mysql_select_db($database);
 
//What's you want to do write in here.
 
//More comple Email me:   <EMAIL SNIPPED>
 
?>