Archive for December, 2010

Basic PHP with MySQL Database

December 14th, 2010

IIC University of  technology
evening class: B205
file name: dbstudent.php
host: localhost
username: iicdatabase
password: 123456
Note: please un-comment for use some code.

<?php
$host   = "localhost";
$dbuser = "iicphp";
$dbpass = "123456";
$dbname = "iicdatabase";
$connect =  mysql_connect($host,$dbuser,$dbpass);
$dbselect = mysql_select_db($dbname,$connect);
/*$insert = mysql_query("INSERT INTO tblstudent (studname,gender,class) VALUES ('Bopha','Male','B2-05')",$connect);
if($insert){
echo "Insert Completed";
}
else{
echo "Insert Incompleted";
}*/
$delete = mysql_query("DELETE FROM tblstudent WHERE studid='1'",$connect);
if(!$delete){
echo "Could not Delete Record";
}
else{
echo "Record had been deleted";
}
/*$update = mysql_query("UPDATE tblstudent SET gender='Male' WHERE studid='1'",$connect);
if($update){
echo "Update Completed";
}
else{
echo "Update Incompleted";
}*/
/*if(!$connect){
echo "Databae is not Connected";
}
else{
echo "Database is Connected";
if(!dbselect){
echo "Database is not Selected";
}
else {
echo "Database is Selected";
}
}*/
?>

PHP Send Mail

December 2nd, 2010
<?php
if(isset($_POST['btnsend'])){
$mail_to = $_POST['email'];
$mail_from = "From:info@novpiseth.co.cc";
$mail_subject = $_POST['sub'];
$mail_message = $_POST['txtmessage'];

mail($mail_to,$mail_subject,$mail_message,$mail_from);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<form action="#" method="post">
Email:<input type="text" name="email" /><br />
Subject:<input type="text" name="sub" /><br />
Message:<textarea cols="10" rows="3" name="txtmessage"></textarea><br />
<input type="submit" name="btnsend" value="Send" />
</form>
<body>
</body>
</html>
Facebook Auto Publish Powered By : XYZScripts.com