PHP
Syntax
Program 3-1.php
<html>
<body>
<?php
echo "Hello World";
?>
</body>
</html>
Hasil
Runing :
Program 3-2.php
<html>
<body>
<?php
//This is a comment
/*
This is
a comment
block
*/
?>
</body>
</html>
Variabel
Program4-1.php.
<html>
<body>
<?php
$txt="Hello World";
echo $txt;
?>
</body>
</html>
Program4-2.php.
<html>
<body>
<?php
$txt1="Hello World";
$txt2="1234";
$Nilai1=1234;
$Nilai2=4321;
$Hasil=$Nilai1+Nilai2;
echo $txt1 . " " . $txt2
;
echo $Hasil;
?>
</body>
</html>
Operator
PHP
Program5-1.php.
<!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=iso-8859-1" />
<title>Untitled
Document</title>
</head>
<body>
<?php
$var1=10;
$var2=20;
print $var1 +
$var2."<br>";
echo $var1 +
$var2."<br>";
$Jum=$var1+$var2;
echo $Jum;
?>
</body>
</html>
Running
:
PHP
If...Else Statements
Program6-1.php
<!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>
<body>
<?php
$d=date("D");
if ($d=="Fri")
echo "Have a nice
weekend!";
else
echo "Have a nice day!";
?>
</body>
</html>
Running
:
Program 6-2.php
<!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>
<body>
Hello!<br />
"Have a nice weekend"
"See you on Monday!"
<?php
$d=date("A");
if ($d=="Sunday")
{
echo "Hello!<br
/>";
echo "Have a nice
weekend!";
echo "See you on
Monday!";
}
?>
</body>
</html>
Running
:
Program6-3.php
<!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" />
<html>
<title>Operator
Aritmetika</title>
<body>
<?php
$nilai = 95;
$keterangan="Tidak
Lulus";
if ($nilai>= 60) {
$keterangan = "Lulus";
}
printf("Nilai =
%d<br>",$nilai);
printf("keterangan=
%s<br>",$keterangan);
?>
</body>
</html>
Running
:
Program 6-4.php
<!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>Operator
Aritmatika</title>
</head>
<body>
<?php
$d=date("D");
if ($d=="Fri")
echo "Have a nice
weekend!";
elseif ($d=="Sun")
echo "Have a nice
Sunday!";
else
echo "Have a nice day!";
?>
</body>
</html>
Running
:
Switch
Program7-1.php
<!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>
<body>
<?php
$x=0;
switch ($x)
{
case 1 : echo "Number 1";
break;
case 2 : echo "Number 2";
break;
case 3 : echo "Number 3";
break;
default: echo "No number
between 1 and 3";
}
?>
</body>
</html>
Running
:
Looping/Pengulangan
Program9-1.php
<!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>
<body>
<?php
$i=1;
while($i<=5)
{
echo "The number is " . $i . "<br
/>";
$i++;
}
?>
</body>
</html>
Runing :
Program9-2.php
<!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>
<body>
<?php
$i=0;
do
{
$i++;
echo "The
number is " . $i . "<br />";
}
while ($i<5);
?>
</body>
</html>
Running :
Program9-3.php
<!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>
<body>
<?php
for ($i=1;
$i<=5; $i++)
{
echo "Hello
World!<br />";
} ?>
</body>
</html>
Running :
Program9-4.php
<!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>
<body>
<?php
$arr=array("one",
"two", "three");
foreach ($arr as $value)
{
echo "Value: " . $value .
"<br />";
} ?>
</body>
</html>
Running :
Fungsi/Function
Program10-1.php
<!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>
<body>
<?php
function writeMyName()
{
echo "Candra Kristanto";
}
writeMyName();
?>
</body>
</html>
Running :
Program 10-2.php
<!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>
<body>
<?php
function writeMyName()
{
echo "Candra Kristanto";
}
echo "Hello world!<br
/>";
echo "My name is ";
writeMyName();
echo ".<br />That's
right, ";
writeMyName();
echo " is my name.";
?>
</body>
</html>
Running :
Program 10-3.php
<!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>
<body>
<?php
function writeMyName($fname)
{
echo $fname . " Candra.<br
/>";
}
echo "My name is ";
writeMyName("Kai Jim");
echo "My name is ";
writeMyName("Hege");
echo "My name is ";
writeMyName("Stale");
?>
</body>
</html>
Running
:
Program 10-4.php
<!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>
<body>
<?php
function
writeMyName($fname,$punctuation)
{
echo $fname . "
Kristanto" . $punctuation . "<br />";
}
echo "My name is ";
writeMyName("Candra",".");
echo "My name is ";
writeMyName("Hege","!");
echo "My name is ";
writeMyName("Ståle","...");
?>
</body>
</html>
Running
:
Program 10-5.php
<!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>
<body>
<?php
function add($x,$y)
{
$total = $x + $y;
return $total;
}
echo "1 + 16 = " .
add(1,16)
?>
</body>
</html>
Running
:
PHP
Forms and User Input
Program 11-1.php
<!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>
<body>
<form action="Program
11-2.php" method="post">
Name: <input
type="text" name="name" />
Age: <input
type="text" name="age" />
<input type="submit"
/>
</form>
</body>
</html>
Running
:
Program 11-2.php
<!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>
<body>
Welcome <?php echo
$_POST["name"]; ?>.<br />
You are <?php echo
$_POST["age"]; ?> years old.
</body>
</html>
Running :
PHP
$_GET
Program12-1.php
<form action="Program12-2.php"
method="get">
Name: <input
type="text" name="name" />
Age: <input
type="text" name="age" />
<input type="submit"
/>
</form>
Running :
Program12-2.php
Welcome <?php echo
$_GET["name"]; ?>.<br />
You are <?php echo
$_GET["age"]; ?> years old!
Running
:
Program12-3.php
Welcome <?php echo
$_REQUEST["name"]; ?>.<br />
You are <?php echo
$_REQUEST["age"]; ?> years old!
Running :
PHP
$_POST
Program13-1.php
<form
action="Program13-2.php" method="post">
Enter your name: <input
type="text" name="name" />
Enter your age: <input
type="text" name="age" />
<input type="submit"
/>
</form>
Running
:
Program13-2.php
Welcome <?php echo
$_POST["name"]; ?>.<br />
You are <?php echo
$_POST["age"]; ?> years old!
Running
:
Program13-3.php
Welcome <?php echo
$_REQUEST["name"]; ?>.<br />
You are <?php echo
$_REQUEST["age"]; ?> years old!
Running
:
PHP
Date()
Program14-1.php
<?php
echo date("Y/m/d");
echo "<br />";
echo date("Y.m.d");
echo "<br />";
echo date("Y-m-d");
?>
Running
:
Program14-2.php
<?php
$tomorrow =
mktime(0,0,0,date("m"),date("d")+1,date("Y"));
echo "Tomorrow is
".date("Y/m/d/", $tomorrow);
?>
Running
:
PHP
Include File
Program
15-1.php
<html>
<body>
<?php
include("header.php"); ?>
<h1>Welcome to my home
page</h1>
<p>Some text</p>
</body>
</html>
Running :
Program15-2.php
<html>
<body>
<a
href="http://www.w3schools.com/default.php">Home</a> |
<a href="http://www.w3schools.com/about.php">About
Us</a> |
<a
href="http://www.w3schools.com/contact.php">Contact Us</a>
<?php
include("menu.php"); ?>
<h1>Welcome to my home
page</h1>
<p>Some text</p>
</body>
</html>
Running :
Program 15-3.php
<html>
<body>
<?php
include("wrongFile.php");
echo "Hello World!";
?>
</body>
</html>
Running :
Program15-4.php
<html>
<body>
<?php
require("wrongFile.php");
echo "Hello World!";
?>
</body>
</html>
Running :
PHP
File Handling
Program16-1.php
<html>
<body>
<?php
$file=fopen("welcome.txt","r");
?>
</body>
</html>
Running :
Program 16-2.php
<html>
<body>
<?php
$file=fopen("welcome.txt","r")
or exit("Unable to open file!");
?>
</body>
</html>
Running
:
Program 16-3.php
<?php
$file =
fopen("test.txt","r");
//some code to be executed
fclose($file);
?>
Running
:
Program 16-4.php
<?php
$file =
fopen("welcome.txt", "r") or exit("Unable to open
file!");
//Output a line of the file until
the end is reached
while(!feof($file))
{
echo fgets($file). "<br
/>";
}
fclose($file);
?>
Running
:
Program16-5.php
<?php
$file=fopen("welcome.txt","r")
or exit("Unable to open file!");
while (!feof($file))
{
echo fgetc($file);
}
fclose($file);
?>
Running
:
Program17-1.php
<html>
<body>
<form
action="upload_file.php" method="post"
enctype="multipart/form-data">
<label
for="file">Filename:</label>
<input type="file"
name="file" id="file" />
<br />
<input type="submit"
name="submit" value="Submit" />
</form>
</body>
</html>
Running
:
upload-File.php
<!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>PHP File Upload
(BAB17)</title>
</head>
<body>
<?php
if
($_FILES["file"]["error"] > 0)
{
echo "Error: " .
$_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " .
$_FILES["file"]["name"] . "<br />";
echo "Type: " .
$_FILES["file"]["type"] . "<br />";
echo "Size: " .
($_FILES["file"]["size"] / 1024) . " Kb<br
/>";
echo "Stored in: " .
$_FILES["file"]["tmp_name"];
}
?>
</body>
</html>
Running
:
Program17-2.php
<?php
if (($_FILES["file"]["type"]
== "image/gif")
||
($_FILES["file"]["type"] == "image/jpeg")
&&
($_FILES["file"]["size"] < 20000))
{
if
($_FILES["file"]["error"] > 0)
{
echo "Error: " .
$_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"]
. "<br />";
echo "Type: " .
$_FILES["file"]["type"] . "<br />";
echo "Size: " .
($_FILES["file"]["size"] / 1024) . " Kb<br
/>";
echo "Stored in: " .
$_FILES["file"]["tmp_name"];
}
}
else
{
echo "Invalid file";
}
?>
Running
:
Program17-3.php
<?php
if
(($_FILES["file"]["type"] == "image/gif")
||
($_FILES["file"]["type"] == "image/jpeg")
&&
($_FILES["file"]["size"] < 20000))
{
if
($_FILES["file"]["error"] > 0)
{
echo "Return Code: " .
$_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " .
$_FILES["file"]["name"] . "<br />";
echo "Type: " .
$_FILES["file"]["type"] . "<br />";
echo "Size: " .
($_FILES["file"]["size"] / 1024) . " Kb<br
/>";
echo "Temp file: " .
$_FILES["file"]["tmp_name"] . "<br />";
if (file_exists("upload/"
. $_FILES["file"]["name"]))
{
echo
$_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"upload/" .
$_FILES["file"]["name"]);
echo "Stored in: " .
"upload/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
?>
Running
:
PHP
Cookies
Program 18-1.php
<?php
setcookie("user",
"Alex Porter", time()+3600);
?>
<html>
<body>
</body>
</html>
Running
:
Program18-2.php
<?php
// Print a cookie
echo $_COOKIE["user"];
// A way to view all cookies
print_r($_COOKIE);
?>
Running
:
Program18-3.php
<html>
<body>
<?php
if
(isset($_COOKIE["user"]))
echo "Welcome " .
$_COOKIE["user"] . "!<br />";
else
echo "Welcome guest!<br
/>";
?>
</body>
</html>
Running
:
Program18-4.php
<?php
// set the expiration date to one
hour ago
setcookie("user", "root",
time()-3600);
?>
Running
:
Program18-5.php
<?php
setcookie("user",
"Alex Porter", time()+3600);
?>
<html>
<head>
<title>PHP Chokies
(BAB18)</title>
</head>
<body>
<form action="welcome.php"
method="post">
Name: <input
type="text" name="name" />
Age: <input
type="text" name="age" />
<input type="submit"
/>
</form>
</body>
</html>
Running
:
welcome.php.
<html>
<body>
Welcome <?php echo
$_POST["name"]; ?>.<br />
You are <?php echo
$_POST["age"]; ?> years old.
</body>
</html>
Running :
PHP
Sessions
Program19-1.php
<?php session_start(); ?>
<html>
<body>
</body>
</html>
Running
:
Program19-2.php
<?php
session_start();
// store session data
$_SESSION['views']=1;
?>
<html>
<body>
<?php
//retrieve session data
echo "Pageviews=".
$_SESSION['views'];
?>
</body>
</html>
Running
:
Program19-3.php
<?php
session_start();
if(isset($_SESSION['views']))
$_SESSION['views']=$_SESSION['views']+1;
else
$_SESSION['views']=1;
echo "Views=".
$_SESSION['views'];
?>
Running
:
Program19-4.php
<?php
unset($_SESSION['views']);
?>
Running
:
Program19-5.php
<?php
//session_destroy();
?>
Running
:
Pengenalan
PHP MySQL
Database
Tabel
Database
dapat terdiri dari satu atau lebih tabel. Setiap table mempunyai
nama.
Setiap tabel mengandung record dan data. Di bawah ini contoh tabel
"Persons":
Query
Dengan
MySQL, kita dapat melakukan query untuk mendapatkan informasi
tertentu
dari database.
Contoh
query
SELECT
LastName FROM Persons
Query
di atas akan menampilkan semua data pada field LastName dari tabel
Persons.
Koneksi
PHP MySQL
MySQL sangat sering digunakan bersama-sama dengan PHP.
Koneksi ke database MySQL
mysql_connect("localhost","root","1234");
Program23-1.php
<!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>
<body>
<?php
$con
= mysql_connect("localhost","root","1234");
if
(!$con)
{
die('Could
not connect: ' . mysql_error());
}
mysql_select_db("tabel",
$con);
mysql_query("INSERT
INTO person (FirstName, LastName, Age)
VALUES
('Peter', 'Griffin', '35')");
mysql_query("INSERT
INTO person (FirstName, LastName, Age)
VALUES
('Glenn', 'Quagmire', '33')");
mysql_close($con);
echo
'anda telah berhasil memasukkan data ke dalam database';
?>
</body>
</html>
Running :
Program23-2.php
<!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>
<body>
<html>
<body>
<form
action="insert.php" method="post">
Firstname: <input
type="text" name="firstname" />
Lastname: <input
type="text" name="lastname" />
Age: <input
type="text" name="age" />
<input type="submit"
/>
</form>
</body>
</html>
</body>
</html>
Running
:
Membuat
Database dan Tabel
Program24-1.php
<!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>
<body>
<?php
$con =
mysql_connect( "localhost", "root", "1234" );
if (
!$con ) {
die( 'Could not connect:
'.mysql_error( ) );
}
mysql_select_db(
"tabel", $con );
$result =
mysql_query( "SELECT * FROM person" );
while (
$row = mysql_fetch_array( $result ) ) {
echo $row['FirstName']."
".$row['LastName'];
echo "<br />";
}
mysql_close(
$con );
?>
</body>
</html>
Running :
.
Program24-2.php
<!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>
<body>
<?php
$con = mysql_connect(
"localhost", "root", "1234" );
if ( !$con ) {
die(
'Could not connect: '.mysql_error( ) );
}
mysql_select_db( "tabel",
$con );
$result = mysql_query( "SELECT
* FROM person" );
echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while ( $row = mysql_fetch_array(
$result ) ) {
echo
"<tr>";
echo
"<td>".$row['FirstName']."</td>";
echo
"<td>".$row['LastName']."</td>";
echo
"</tr>";
}
echo "</table>";
mysql_close( $con );
?>
</body>
</html>
Running :
PHP
MySQL Insert Into
Program25-1.php
<!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>
<body>
<?php
$con = mysql_connect(
"localhost", "root", "1234" );
if ( !$con ) {
die(
'Could not connect: '.mysql_error( ) );
}
mysql_select_db( "tabel",
$con );
$result = mysql_query( "SELECT
* FROM person
WHERE FirstName='Kristantoin'"
);
while ( $row = mysql_fetch_array(
$result ) ) {
echo
$row['FirstName']." ".$row['LastName'];
echo
"<br />";
}
?>
</body>
</html>
Running
:
Program25-2.php
<html>
<body>
<form
action="insert.php" method="post">
Firstname: <input
type="text" name="firstname" />
Lastname: <input
type="text" name="lastname" />
Age: <input
type="text" name="age" />
<input type="submit"
/>
</form>
</body>
</html>
Running
:
insert.php
<!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>
<body>
<?php
$con =
mysql_connect("localhost","root","1234");
if (!$con)
{
die('Could not connect: ' .
mysql_error());
}
mysql_select_db("tabel",
$con);
$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";
mysql_close($con)
?>
</body>
</html>
Running
:
PHP
MySQL Select
Contoh
program dengan nama “Person.php”
<?php
$con
= mysql_connect("localhost","root","1234");
if
(!$con)
{
die('Could
not connect: ' . mysql_error());
}
mysql_select_db("my_db",
$con);
$result
= mysql_query("SELECT * FROM person");
while($row
= mysql_fetch_array($result))
{
echo
$row['FirstName'] . " " . $row['LastName'];
echo
"<br />";
}
mysql_close($con);
?>
Displayresulttabel.php
<?php
$con
= mysql_connect("localhost","root","1234");
if
(!$con)
{
die('Could
not connect: ' . mysql_error());
}
mysql_select_db("my_db",
$con);
$result
= mysql_query("SELECT * FROM person");
echo
"<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while($row
= mysql_fetch_array($result))
{
echo
"<tr>";
echo
"<td>" . $row['LastName'] . "</td>";
echo
"<td>" . $row['FirstName'] . "</td>";
echo
"</tr>";
}
echo
"</table>";
mysql_close($con);
?>
Running :
PHP
MySQL The Where Clause
Person2.php
<?php
$con
= mysql_connect("localhost","root","1234");
if
(!$con)
{
die('Could
not connect: ' . mysql_error());
}
mysql_select_db("my_db",
$con);
$result
= mysql_query("SELECT * FROM person
WHERE
FirstName='Peter'");
while($row
= mysql_fetch_array($result))
{
echo
$row['FirstName'] . " " . $row['LastName'];
echo
"<br />";
}
?>
PHP
MySQL Order By Keyword
Program
26-1.php
<!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>
<body>
<?php
$con =
mysql_connect("localhost","root","1234");
if
(!$con)
{
die('Could
not connect: ' . mysql_error());
}
mysql_select_db("tabel",
$con);
$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
"<br />";
}
mysql_close($con);
?>
</body>
</html>
Running :
PHP
MySQL Update
Program 27-1.php
<!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>
<body>
<?php
$con = mysql_connect(
"localhost", "root", "1234" );
if ( !$con ) {
die(
'Could not connect: '.mysql_error( ) );
}
mysql_select_db( "tabel",
$con );
mysql_query( "UPDATE Person
SET Age = '23'
WHERE FirstName = 'Kristantoin' AND
LastName = 'Candrain'" );
mysql_close( $con );
echo ' Data berhasil di Update ';
?>
</body>
</html>
Running
:
PHP
MySQL Delete From
Program
28-1.php
<!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>
<body>
<?php
$con = mysql_connect(
"localhost", "root", "1234" );
if ( !$con ) {
die(
'Could not connect: '.mysql_error( ) );
}
mysql_select_db( "tabel",
$con );
mysql_query( "DELETE FROM
Person WHERE LastName='Griffin'" );
mysql_close( $con );
echo 'data berhasil di hapus';
?>
</body>
</html>
Running
:
