script rahasia PHP

// ******** untuk koneksi

$con = mysql_connect(”localhost”,”root”,”bchr”);
if (!$con)
{
die(’Could not connect: ‘ . mysql_error());
}

// *********** untuk membuat database
// if (mysql_query(”CREATE DATABASE my_db”,$con))
// {
// echo “Database created”;
// }
// else
// {
// echo “Error creating database: ” . mysql_error();
// }

// ******* untuk memanggil database
mysql_select_db(”my_db”, $con);

// ******* Create table in my_db database
// $sql = “CREATE TABLE person
// (
// personID int NOT NULL AUTO_INCREMENT,
// PRIMARY KEY(personID),
// FirstName varchar(15),
// LastName varchar(15),
// Age int
// )”;
// mysql_query($sql,$con);

// **** insert data

$sql=”INSERT INTO person (FirstName, LastName, Age)
VALUES
(’$_POST[firstname]‘,’$_POST[lastname]‘,’$_POST[age]‘)”;

if (!mysql_query($sql,$con))
{
die(’Error: ‘ . mysql_error());
}
echo “1 record added”;

// ***** untuk melihat dengan hasil $result variabe

// $result = mysql_query(”SELECT * FROM person”);
// while($row = mysql_fetch_array($result))
// {
// echo $row['FirstName'] . ” ” . $row['LastName'];
// echo “
”;
// }

// ***** untuk melihat juga mysql_fetch array function

$result = mysql_query(”SELECT * FROM person”);
echo “

”;
while($row = mysql_fetch_array($result))
{
echo “”;
echo “”;
echo “”;
echo “”;
}
echo “

Firstname	Lastname
” . $row['FirstName'] . “	” . $row['LastName'] . “

”;

// *** System filter hanya nama tertentu yg kelihatan

// $result = mysql_query(”SELECT * FROM person
// WHERE FirstName=’Bagas’”);
// while($row = mysql_fetch_array($result))
// {
// echo $row['FirstName'] . ” ” . $row['LastName'];
// echo “
”;
// }

// ***** order by

// $result = mysql_query(”SELECT * FROM person ORDER BY age”);
// while($row = mysql_fetch_array($result))
// {
// echo $row['FirstName'];
// echo ” ” . $row['LastName'];
// echo ” ” . $row['Age'];
// echo “
”;
// }

// **** update data

// mysql_query(”UPDATE Person SET Age = ‘36′
// WHERE FirstName = ‘Peter’ AND LastName = ‘Griffin’”);

// **** menghapus data
// mysql_query(”DELETE FROM Person WHERE LastName=’Griffin’”);

mysql_close($con);
?>

Posted in: