PHP with MySql Connectivity and Datamanipulation
The following example is describe the details of insert delete and view the datas from my sql using PHP script
Example:
<html>
<body>
<table width=”100%” border=”2″>
<tr><td><center>Welcome to PHP script</center></td></tr>
</table>
<?php
$Server = “localhost”;
$Username =”root”;
$Password = “admin”;
mysql_connect($Server,$Username, $Password) or die(mysql_error());
echo “Connected to MySQL<br />”;
mysql_select_db(“emp”) or die(mysql_error());
echo “Connected to Database<br>”;
printData();
insertData();
deleteData();
// insert details to the selected mysql table
// delete details to the selected mysql table
function printData()
{
// Select Details from the table
$result = mysql_query(“SELECT * FROM empm”) or die(mysql_error());
echo “<table border=’1′ width=’50%’>”;
echo “<tr> <th>Id</th> <th>Name </th> <th>Phone No. </th> </tr>”;
while($row = mysql_fetch_array( $result ))
{
echo “<tr><td>”;
echo $row[’empid’];
echo “</td><td>”;
echo $row[‘name’];
echo “</td><td>”;
echo $row[‘pno’];
echo “</td>”;
echo “</tr>”;
}
echo “</table>”;
}
function insertData()
{
// Insert a row of information into the table “example”
mysql_query(“INSERT INTO empm (empid,name,pno) VALUES(‘0006′,’Sri’,’98418′ ) “) or die(mysql_error());
echo “Data Inserted!”;
printData();
}
function deleteData()
{
mysql_query(“Delete from empm where empid =’0006′”) or die(mysql_error());
echo “Data Deleted!”;
printData();
}
?>
</body>
</html>
Screen Shot: