CREATE TABLE IF NOT EXISTS `haberler` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`haberbasligi` varchar(255) NOT NULL,
`habericerigi` text NOT NULL,
`habereklenmetarihidamgasi` varchar(255) NOT NULL,
`habereklenmetarihi` varchar(255) NOT NULL,
`sondakikabitissuresidamgasi` varchar(255) NOT NULL,
`sondakikabitissuresi` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
Yukarıdaki tabloya göre verileri güncellemek istiyorum ancak <select name="sure">
<option value="1">1 Dakika</option> güncelletemedim . Bu kısmı nasıl güncellerim? Dosyalar aşağıdaki gibi ....
-- haberekle.php ---
<?php
include("../ayar.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>
<title>Haber Uygulaması - Yönetim</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-9" />
<meta http-equiv="content-language" content="TR" />
</head>
<body>
<form name="haberformu" method="post" action="habereklesonuc.php"><table width="50%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="20" colspan="3" align="center" valign="middle" bgcolor="#FF0000"><font color="#FFFFFF"><b>Haber Ekleme Formu</b></font></td>
</tr>
<tr>
<td width="140" height="20" align="left" valign="top">Haber Başlığı</td>
<td width="20" height="20" align="left" valign="top">:</td>
<td width="340" height="20" align="left" valign="top"><input type="text" name="baslik" size="50" /></td>
</tr>
<tr>
<td height="20" align="left" valign="top">Haber İçeriği</td>
<td height="20" align="left" valign="top">:</td>
<td height="20" align="left" valign="top"><textarea name="icerik" rows="10" cols="39"></textarea></td>
</tr>
<tr>
<td height="20" align="left" valign="top">Süresi</td>
<td height="20" align="left" valign="top">:</td>
<td height="20" align="left" valign="top"><select name="sure">
<option value="1">1 Dakika</option>
<option value="2">2 Dakika</option>
<option value="3">3 Dakika</option>
<option value="4">4 Dakika</option>
<option value="5">5 Dakika</option>
</select></td>
</tr>
<tr>
<td height="20" align="left" valign="top"> </td>
<td height="20" align="left" valign="top"> </td>
<td height="20" align="left" valign="top"><input type="submit" value="Kaydet ve Yayınla" /></td>
</tr>
</table></form>
</body>
</html>
--- haberduzenle.php ----
<?php
include("../ayar.php");
$gelenid
=
@$_GET["id"];
$istenilenkaydisor
=
@mysql_fetch_assoc(@mysql_query("SELECT * FROM haberler WHERE id='$gelenid' ORDER BY id ASC LIMIT 1"));
$kayittarih = date("d.m.Y H:i:s");
$kayitid
=
@trim(@strip_tags(@addslashes($istenilenkaydisor["id"])));
$kayitbaslik =
@trim(@strip_tags(@addslashes($istenilenkaydisor["haberbasligi"])));
$kayiticerik
=
@trim(@strip_tags(@addslashes($istenilenkaydisor["habericerigi"])));
?>
<!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>
<title>Haber Uygulaması - Yönetim</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-9" />
<meta http-equiv="content-language" content="TR" />
</head>
<body>
<form name="haberformu" method="post" action="haberguncelle.php"><table width="50%" border="0" align="center" cellpadding="0" cellspacing="0">
<input type="hidden" name="islemid" value="<?=$gelenid?>">
<tr>
<td height="20" colspan="3" align="center" valign="middle" bgcolor="#FF0000"><font color="#FFFFFF"><b>Haber Ekleme Formu</b></font></td>
</tr>
<tr>
<td width="140" height="20" align="left" valign="top">Haber Başlığı</td>
<td width="20" height="20" align="left" valign="top">:</td>
<td width="340" height="20" align="left" valign="top"><input type="text" name="baslik" size="50" value="<?=$kayitbaslik?>"/></td>
</tr>
<tr>
<td height="20" align="left" valign="top">Haber İçeriği</td>
<td height="20" align="left" valign="top">:</td>
<td height="20" align="left" valign="top"><textarea name="icerik" rows="10" cols="39"> <?=$kayiticerik?></textarea></td>
</tr>
<tr>
<td height="20" align="left" valign="top">Süresi</td>
<td height="20" align="left" valign="top">:</td>
<td height="20" align="left" valign="top"><select name="sure">
<option value="1">1 Dakika</option>
<option value="2">2 Dakika</option>
<option value="3">3 Dakika</option>
<option value="4">4 Dakika</option>
<option value="5">5 Dakika</option>
</select></td>
</tr>
<tr>
<td height="20" align="left" valign="top"> </td>
<td height="20" align="left" valign="top"> </td>
<td height="20" align="left" valign="top"><input type="submit" value="Haber Güncelle" /></td>
</tr>
</table></form>
</body>
</html>
--- haberguncelle.php ----
<?php
include("../ayar.php");
$kayitid
= @trim(@strip_tags(@addslashes($_POST["islemid"])));
$kayitbaslik = @trim(@strip_tags(@addslashes($_POST["baslik"])));
$kayiticerik = @trim(@strip_tags(@addslashes($_POST["icerik"])));
if(($kayitbaslik!="") and ($kayiticerik!="")){
$guncelle =
@mysql_query("UPDATE haberler SET haberbasligi='$kayitbaslik', habericerigi='$kayiticerik' WHERE id='$kayitid' ORDER BY id DESC LIMIT 1");
if($guncelle){
@header("location:tamam.php");
}else{
@header("location:hata.php");
}
}else{
@header("location:hata.php");
}
?>
Zaman
2016-06-29 11:45:12Php PHP İLE UPDATE acemi düzeyde php ile ilgileniyorum. Ziyaretçi defteri uygulamasında ekleme işlemini aşağıdaki gibi yaptım..Aşağıdaki şablon üzerinden duzenle.php ve guncelle.php dosyalarını ayrı ayrı nasıl yapabilirim. Yardımcı olur musunuz?
----yaz.php----
<?php
include("ayar.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">
<style>
body { margin:0; padding:0; font-family:"Lucida Grande", "Lucida Sans Unicode", "Lucida Sans", "DejaVu Sans", Verdana, sans-serif; font-size:1em; }
</style>
<head>
<title>Ziyaretçi Defteri</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-9" />
<meta http-equiv="content-language" content="TR" />
</head>
<body>
<table width="50%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="35" align="center" valign="middle"><table width="50%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="15" height="35" align="center" valign="middle"><img src="dosyalar/ustbarsol.png" width="15" height="35" title="" alt="" style="border:none;"/></td>
<td width="470" height="35" align="center" valign="middle" style="background:url(dosyalar/ustbarorta.png); background-repeat:repeat-x;"><table width="470" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="40" height="35" align="left" valign="middle"><img src="dosyalar/defter.png" width="30" height="30" title="" alt="" style="border:none;"/></td>
<td width="430" height="35" align="left" valign="middle"><font color="#FFFFFF">Ziyaretçi Defteri</font></td>
</tr>
</table></td>
<td width="15" height="35" align="center" valign="middle"><img src="dosyalar/ustbarsag.png" width="15" height="35" title="" alt="" style="border:none;"/></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td align="center" valign="middle"><form name="ziyaretcidefteri" action="sonuc.php" method="post">
<table width="470" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="150" height="20" align="left" valign="top"><b>Adınız Soyadınız</b></td>
<td width="30" height="20" align="left" valign="top"><b>:</b></td>
<td width="290" height="20" align="left" valign="top"><input type="text" name="adisoyadi" /></td>
</tr>
<tr>
<td height="20" align="left" valign="top"><b>Mesajınız</b></td>
<td height="20" align="left" valign="top"><b>:</b></td>
<td height="20" align="left" valign="top"><textarea name="yorum" rows="5" cols="30"></textarea></td>
</tr>
<tr>
<td height="20" align="left" valign="top"> </td>
<td height="20" align="left" valign="top"> </td>
<td height="20" align="left" valign="top"><input type="submit" value="Gönder" /></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>
----sonuc.php----
<?php
include("ayar.php");
$tarihdamgasi = time();
$tarih = date("d.m.Y H:i:s");
$gelenadsoyadi = @trim(@strip_tags(@addslashes($_POST["adisoyadi"])));
$gelenyorum = @trim(@strip_tags(@addslashes($_POST["yorum"])));
if(($gelenadsoyadi!="") and ($gelenyorum!="")){
$kaydet = @mysql_query("INSERT INTO mesajlar (adisoyadi, yorum, onaydurumu, tarihdamgasi, tarih) values ('$gelenadsoyadi', '$gelenyorum', '0', '$tarihdamgasi ', '$tarih')");
if($kaydet){
@header("location:tamam.php");
}else{
@header("location:hata.php");
}
}else{
echo "Lütfen Formda Boş Alan Bırakmayınız...!<br/>";
echo "Forma Geri Dönmek İçin Lütfen <a href='yaz.php'> Buraya Tıklayınız</a>.";
}
?>
----ziyaretci.sql CREATE TABLE IF NOT EXISTS `mesajlar` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`adisoyadi` varchar(255) NOT NULL,
`yorum` text NOT NULL,
`onaydurumu` int(1) NOT NULL,
`tarihdamgasi` varchar(255) NOT NULL,
`tarih` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin5 AUTO_INCREMENT=5 ;
."; } ?> ----ziyaretci.sql CREATE TABLE IF NOT EXISTS `mesajlar` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `adisoyadi` varchar(255) NOT NULL, `yorum` text NOT NULL, `onaydurumu` int(1) NOT NULL, `tarihdamgasi` varchar(255) NOT NULL, `tarih` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin5 AUTO_INCREMENT=5 ;
Zaman
2015-12-15 02:48:36Php Php Ziyaretçi Defteri