Basic SQL Commands:
* to do: create a function to dump db connectivity details
<html>
<body>
<Form action=”contact.php” method=”post”>
First Name: <input type=”text” name=”fname” />
Last Name : <input type=”text” name=”lname” />
<input type = “submit” name = “submit” value = “Echo Values” />
<input type = “submit” name = “update_db” value = “Update Database” />
<input type = “submit” name = “display_db” value = “Display Records” />
</form>
<?php
if (isset($_POST['submit']))
{
echo ‘Your First Name Is: ‘.$_POST['fname'].’<br />’;
echo ‘Your Last Name Is: ‘.$_POST['lname'].’<br />’;
// mail(‘ayanthianandagoda@hotmail.com’,'PHP mails’,$_POST['fname'].$_POST['lname'],’ayanthi’);
}
if (isset($_POST['update_db']))
{
$host = “localhost”;
$username = “root”;
$password = “”;
$db_name = “contact”;
$tbl_name = “contact_details”;
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$con = mysql_connect(“$host”, “$username”, “$password”) or die(“cannot connect”);
if (!$con)
{
die(“could not connect: ” . mysql_error());
}
mysql_select_db(“$db_name”) or die(“cannot select DB”);
$insert_query = “insert into $tbl_name values(‘$fname’, ‘$lname’)”;
$result = mysql_query($insert_query);
if ($result != 1)
{
echo “insert fail”;
}
}
if (isset($_POST['display_db']))
{
$host = “localhost”;
$username = “root”;
$password = “”;
$db_name = “contact”;
$tbl_name = “contact_details”;
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$con = mysql_connect(“$host”, “$username”, “$password”) or die(“cannot connect”);
if (!$con)
{
die(“could not connect: ” . mysql_error());
}
mysql_select_db(“$db_name”) or die(“cannot select DB”);
{
$select_query = “select * from $tbl_name”;
$result = mysql_query($select_query);
while ($newArray = mysql_fetch_array($result))
{
$first_name = $newArray['first_name'];
$last_name = $newArray['last_name'];
echo $first_name.” “.$last_name.’<br />’;
}
}
}
?>
</body>
</html>