MySQL Basic operation

conn.php//Connect MySQL Database

<?php
$id =mysql_connect ("127.0.0.1", "Root", "") or Die (' Connection failed: '. mysql_error ());
if (mysql_select_db ("Test_moonlitshiny", $id))
echo "";
Else
Echo (' Database connection failed: '. mysql_error ());
mysql_query ("Set names UTF8");
?>
select.php//Search Database

<?php
$id =mysql_connect ("127.0.0.1", "Root", "") or Die (' Connection failed: '. mysql_error ());
if (mysql_select_db ("Test_moonlitshiny", $id))
echo "";
Else
Echo (' Database connection failed: '. mysql_error ());
mysql_query ("Set names UTF8");
$lineid = 1;
$query =mysql_query ("select * from Test_moonlitshiny where id= ' $lineid '");
if ($query ==true)
{
while ($myrow =mysql_fetch_array ($query))
{
$helloworld = $myrow [Q1];
$hello = $myrow [Q2];
Echo $helloworld;
Echo $hello;
}
}

insert.php//Inserting data

<?php
$id =mysql_connect ("127.0.0.1", "Root", "") or Die (' Connection failed: '. mysql_error ());
if (mysql_select_db ("Test_moonlitshiny", $id))
echo "";
Else
Echo (' Database connection failed: '. mysql_error ());
mysql_query ("Set names UTF8");

$n 1= "Hello";
$n 2= "World";
$n 3= "HelloWorld";
$query = "INSERT into Test_moonlitshiny (Q1,Q2,Q3) VALUES (' $n 1 ', ' $n 2 ', ' $n 3 ')";
$result =mysql_query ($query);
if ($result ==true)
{
Echo "HELLO ~world!";
}
Else
{
Echo "oh~~thx~~~";
}
?>

Update//Updates
<?php
$id =mysql_connect ("127.0.0.1", "Root", "") or Die (' Connection failed: '. mysql_error ());
if (mysql_select_db ("Test_moonlitshiny", $id))
echo "";
Else
Echo (' Database connection failed: '. mysql_error ());
mysql_query ("Set names UTF8");
$id = 1;
$n 1= "Hello";
$n 2= "World";
$n 3= "HelloWorld";
$query =mysql_query ("Update test_moonlitshiny set q1= ' $n 1 ', q2= ' $n 2 ', q3= ' $n 3 ' where id= ' $id '");
if ($query ==true)
{
Echo "HELLO ~world!";
}
Else
{
Echo "oh~~thx~~~";
}
?>

delete.php//delete
<?php
$id =mysql_connect ("127.0.0.1", "Root", "") or Die (' Connection failed: '. mysql_error ());
if (mysql_select_db ("Test_moonlitshiny", $id))
echo "";
Else
Echo (' Database connection failed: '. mysql_error ());
mysql_query ("Set names UTF8");
$id = 1;
$query =mysql_query ("Delete from Test_moonlitshiny where id= ' $id '");
If ($query ==true)
{
Echo "Delete succeeded";
}
Else
{
Echo "Delete Failed";
}

MySQL basic operations