Kalaimaan

Doing simple things to make great life

PHP with MySql Connectivity and Datamanipulation

Posted by kalaimaan on February 3, 2009

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:screen1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: