Ajanda Yapımı
17. Ağu, 2010
0 Yorum
PHP ve MySql ile basit ajanda yapımı. Kodları aşagıda bulunmaktadır.
arama.php
<?php
include("config.php");
dbbaglan();
?>
<!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-9" />
<title>Untitled Document</title>
</head>
<body>
<?php
@$islem = $_GET['islem'];
if(empty($islem))
{
?>
<form action="arama.php?islem=sonuc" method="post">
<table border="1">
<tr>
<td>Arama</td>
</tr>
<tr>
<td><label>
<input type="text" name="kelime" id="kelime" />
</label></td>
</tr>
<tr>
<td><label>
<input type="submit" name="button" id="button" value="Submit" />
</label></td>
</tr>
</table>
</form>
<?php
}
elseif($islem == "sonuc")
{
$kelime = $_POST['kelime'];
$query = mysql_query("select baslik,id from randevu where baslik like '%$kelime%'");
while($arr = mysql_fetch_assoc($query))
{
echo $arr['baslik'];
}
echo "<br>".mysql_affected_rows()." kadar sorguda sorgulandı";
}
?>
</body>
</html>
ekle.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-9" />
<title>Untitled Document</title>
</head>
<body>
<?php
@$islem = $_GET['islem'];
if(empty($islem))
{
?>
<form action="ekle.php?islem=kayit" method="post">
<table border="1">
<tr>
<td colspan="2">Not Ekle</td>
</tr>
<tr>
<td>Başlık</td>
<td><label>
<input type="text" name="baslik" id="baslik" />
</label></td>
</tr>
<tr>
<td>Yazi notu:</td>
<td><label>
<textarea name="yazi" id="yazi" cols="45" rows="5"></textarea>
</label></td>
</tr>
<tr>
<td>Başlangıc Tarih</td>
<td><label>
<input type="text" name="baslangictarih" id="baslangictarih" />
</label></td>
</tr>
<tr>
<td>Bitiş Tarih</td>
<td><input type="text" name="bitistarih" id="bitistarih" /></td>
</tr>
<tr>
<td colspan="2"><label>
<input type="submit" name="button" id="button" value="Gönder" />
</label></td>
</tr>
</table>
</form>
<?php
}
if($islem == "kayit")
{
$baslik = $_POST['baslik'];
$yazi = $_POST['yazi'];
$baslangictarih = $_POST['baslangictarih'];
$bitistarih = $_POST['bitistarih'];
include('config.php');
dbbaglan();
$query = mysql_query("insert into randevu (baslik,yazi,baslangictarih,bitistarih,aktif) values ('$baslik','$yazi','$baslangictarih','$bitistarih',1)");
}
?>
</body>
</html>
index.php
<?php
include("config.php");
dbbaglan();
?>
<!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-9" />
<title>Untitled Document</title>
</head>
<body>
<table border="1">
<tr>
<td>id</td>
<td>Başlık</td>
<td>Başlangıc Tarih</td>
<td>Bitiş tarih</td>
</tr>
<?php
$query = mysql_query("select * from randevu");
while($arr = mysql_fetch_assoc($query))
{
echo "<tr><td>".$arr['id']."</td><td>".$arr['baslik']."</td><td>".$arr['baslangictarih']."</td><td>".$arr['bitistarih']."</td></tr>" ;
}
?>
</table>
</body>
</html>
Sql dosyası:
CREATE TABLE IF NOT EXISTS `randevu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `baslik` varchar(110) NOT NULL, `yazi` text NOT NULL, `baslangictarih` varchar(45) NOT NULL, `bitistarih` varchar(45) NOT NULL, `aktif` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin5 AUTO_INCREMENT=1 ;
Henüz Yorum yazılmamış... İlk Yorumu siz yazabilirsiniz!