April 1, 2008 pada 2:26 am (Kumpulan Script)
<html>
<head>
<title>input.php</title>
</head>
<body>
<?
$koneksi=mysql_connect(“localhost”,”root”,”");
mysql_select_db(“masterti”,$koneksi);
mysql_query(“Insert into pengunjung(nama, email, situs)
values(‘$nama’,'$email’,'$situs’)”,$koneksi);
echo “Data telah dimasukkan”;
?>
</body>
</html>
<html>
<head>
<title>input2.php</title>
</head>
<body>
<?
if(($nama!=”")or($email!=”")or($situs!=”"))
{
$koneksi=mysql_connect(“localhost”,”root”,”");
mysql_select_db(“masterti”,$koneksi);
mysql_query(“Insert into pengunjung(nama, email, situs)
values(‘$nama’,'$email’,'$situs’)”,$koneksi);
echo “Data telah dimasukkan”;
}
else
echo “Cek kembali form anda”;
?>
</body>
</html>
<html>
<head>
<title>view.php</view>
</head>
<body>
<?
$host=localhost;//alamat atau host
$user=root;//username
#pass=”";//password
$koneksi=mysql_connect(“#host”,”user”,$pass);
mysql_select_db(“masterti”,$koneksi);
$query=mysql_query(“select*from pengujung”,$koneksi);
$jumlah=mysql_num_rows($query);
echo “<center>Daftar Pengunjung</center>”;
echo “Jumlah Pengunjung :$jumlah”;
while($baris
=mysql_fetch_array($query))
{
echo “<br>”;
echo $baris[0];
echo “<br>”;
echo “Nama :”;
echo $baris[1];
echo “<br>”;
echo “Email :”;
echo $baris[2];
echo “<br>”;
echo “Homepage :
“;
echo $baris[3];
}
?>
</body>
</html>
<html>
<head>
<title>view2.php</view>
</head>
<body>
<?
$host=localhost;//alamat atau host
$user=root;//username
#pass=”";//password
$koneksi=mysql_connect(“#host”,”user”,$root);
mysql_select_db(“masterti”,$koneksi);
$query=mysql_query(“select * from pengujung”,$koneksi);
$jumlah=mysql_num_rows($query);
echo “<center>Daftar Pengunjung</center>”;
echo “<br>”;
echo “Jumlah Pengunjung :$jumlah”;
while($baris=
mysql_fetch_array($query))
{
echo “<br>”;
echo $baris[0];
echo “<br>”;
echo “Nama :”;
echo $baris[1];
echo “<br>”;
echo “Email :”;
echo $baris[2];
echo “<br>”;
echo “Homepage :
“;
echo $baris[3];
echo “<br><a href=edit.php?od=$baris[0]>edit</a>”;
}
?>
</body>
</html>
<html>
<head>
<title>view2.php</view>
</head>
<body>
<?
$host=localhost;//alamat atau host
$user=root;//username
#pass=”";//password
$koneksi=mysql_connect(“#host”,”user”,$root);
mysql_select_db(“masterti”,$koneksi);
$query=mysql_query(“select * from pengujung”,$koneksi);
$jumlah=mysql_num_rows($query);
echo “<center>Daftar Pengunjung</center>”;
echo “<br>”;
echo “Jumlah Pengunjung :$jumlah”;
while($baris=
mysql_fetch_array($query))
{
echo “<br>”;
echo $baris[0];
echo “<br>”;
echo “Nama :”;
echo $baris[1];
echo “<br>”;
echo “Email :”;
echo $baris[2];
echo “<br>”;
echo “Homepage :
“;
echo $baris[3];
echo “<br><a href=edit.php?od=$baris[0]>edit</a>”;
[<a href=delete.php?id=$baris[0]>delete</a>]”;
}
?>
</body>
</html>
<html>
<head>
<title>edit.php</title>
</head>
<body>
<?
$koneksi=mysql_connect(“localhost”,”root”,”");
mysql_select_db(“masterti”,$koneksi);
$query=mysql_query(“select * from pengunjung where
id=’$id’”,$koneksi);
while ($baris=
mysql_fetch_array($query))
{
echo”<form method=\”post\”
action=\”update.php\”>”;
echo “Nama :<input type=\”text\”name=\”nama\”value=\”$baris[1]\”>”;
echo “<br>”;
echo “Email :<input type=\”text\”name=\”email\”value=\”$baris[2]\”>”;
echo “<br>”;
echo “Situs :<input type=\”text\”name=\”situs\”value=\”$baris[3]\”>”;
echo “<br>”;
echo “<input type=\”Submit\” name=\”Submit\”value=\”update\”>;
echo “<input type=\”Hidden\” name=\”id\”value=\”$baris[0]\”>;
echo “</form>”;
}
?>
</body>
</html>
<html>
<head>
<title>update.php</title>
</head>
<body>
<?
$koneksi=mysql_connect(“localhost”,”root”,”");
mysql_select_db(“masterti”,$koneksi);
$query=mysql_query(“Update Pengunjung set id=’$id”
nama=’$nama’,email=’$email’,situs=’$situs’ where id=’$id’”);
echo “Data dengan id=$id telah di update”;
?>
</body>
</html>
<html>
<head>
<title>delete.php</title>
</head>
<body>
<?
$koneksi=mysql_connect(“localhost”,”root”,”");
mysql_select_db(“masterti”,$koneksi);
$query=mysql_query(“Delete Pengunjung where id=’$id”
$koneksi);
echo “Data dengan id=$id telah di hapus”;
?>
</body>
</html>
<html>
<head>
<title>cari.php</title>
</head>
<body>
<center>
$koneksi=mysql_connect(“localhost”,”root”,”");
mysql_select_db(“masterti”,$koneksi);
$query=mysql_query(“select * from pengunjung where $kolom like’%$cari%’
“,$koneksi);
$jumlah=mysql_num_rows($query);
echo “<br>”;
echo “Ditemukan:$jumlah”;
while($baris=mysql_fetch_array($query))
{
echo “<br>”;
echo $baris[0];
echo “<br>;
echo “Nama:”;
echo $baris[1];
echo “<br>”;
echo “Email:”;
echo $baris[2];
echo “<br>”;
echo “Homepage:
“;
echo $baris[3];
}
</center>
</body>
</html>
<html>
<head>
<title>input.html</title>
</head>
<body>
<form method=”post” action=”input.php”>
<pre>
Nama :<input type=”text” name=”nama”>
Email :<input type=”text” name=”email”>
Situs :<input type=”text” name=situs”>
<input type=”submit” name=”Submit” value=”Kirim”><input type=”Reset”
name=”Reset” value=”Reset”>
</pre>
</form>
</body>
</html>
<html>
<head>
<title>cari.htm</title>
</head>
<body>
<center>
<form name methode=”post”
action=”cari.php”>
<select name=”kolom”>
<option value=”id”>id</option>
<option value=”nama”>nama</option>
<option value=”email”>email</option>
<option value=”situs”>situs</option>
</select>
Masukkan kata yang anda cari<input type=”text” type=”text” name=”cari”>
<input type=”Submit” value=”Cari”>
</form>
</center>
</body>
</html>
<html>
<head>
<title>counter.php</title>
</head>
<body>
<?
$log=”counter.txt”;
$open=fopen($log,’r+’);
$counter=fread($open,filesize($log));
fclose($open);
$counter++;
$write=fopen($log,’w');
fputs($write,$counter);
fclose($write);
echo “Anda pengunjung ke:
$counter”;
?>
</body>
</html>
<html>
<head>
<title>counter2.php</title>
</head>
<body>
<?
$koneksi=mysql_connect(“localhost”,”root”,”");
mysql_query(“update counter set counter=counter+1″,$koneksi);
$query=mysql_query(“Select counter from counter”,
$koneksi);
$row=mysql_fetch_array($query);
echo “Anda pengunjung ke:
echo $row[0];
?>
</body>
</html>
Bersambung men…!
Tinggalkan sebuah Komentar
