arkadaşlar ben php ve mysql kullanımında yeniyim
çok acele bir koda ihtiyacım var
acemice oluşturduğum mysql tablo yapım aşağıdaki gibidir
CREATE TABLE `Manset0` (
`manset_baslik` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
`manset_baslik_b_alt` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
`manset_baslik_k_alt` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
`manset_resim_yolu` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
`manset_link` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
PRIMARY KEY ( `manset_baslik` )
) ENGINE = MYISAM ;
-----------------------------------------------------
Form.php sayfam aşağıdaki gibidir formun inputlarına manset0 tablsoundan çekilen veriler geliyor (ama formdan gelen verileri işle php ye gönderiyorum hata oluştu diyor sorunum bu nasıl çözerim )
Forum php sayfası
-------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//TR" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
?><title>Untitled Document</title>
<style type="text/css">
<!--
.style23 {font-style: italic; color: #000000; font-family: "Times New Roman", Times, serif; font-size: 13px; font-weight: bold; }
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" /></head>
<body>
<p><?
$baglan=@mysql_connect(localhost,root,root) ;
if (!$baglan)die ("Mysql Baðlantýsý baþarýsýz oldu") ;
mysql_select_db(muttoli,$baglan)or die ("Veritabaný Baðlantýsý Saðlanamadý") ;
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
$sonuc = mysql_query("SELECT * FROM manset0",$baglan);
$mansetbaslik = $_POST['man_alt_0'];
?>
</p>
<form id="form1" name="form1" method="post" action="isle.php">
<table width="694" height="51" border="1">
<tr>
<td width="684" height="45" bgcolor="#FF0000"><div align="center"><em><strong>MANŞET 0 DÜZENLEME PANELİ </strong></em></div></td>
</tr>
</table>
<table width="693" height="523" border="1" bgcolor="#FFFFFF">
<tr>
<td width="250" bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Başlık</span></td>
<td width="427"><input name="man00" type="text" id="man00" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_baslik"));?>" size="70" /></td>
</tr>
<tr>
<td bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Büyük Resim üstü Alt yazısı ; </span></td>
<td><input name="man01" type="text" id="man01" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_baslik_b_alt"));?>" size="70" /></td>
</tr>
<tr>
<td bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Küçük Resim üstü Alt yazısı </span></td>
<td><input name="man02" type="text" id="man02" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_baslik_k_alt"));?>" size="70" /></td>
</tr>
<tr>
<td bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Resim Adresi </span></td>
<td><input name="man03" type="text" id="man03" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_resim_yolu"));?>" size="70" /></td>
</tr>
<tr>
<td height="407" valign="top" bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Link Adresi </span></td>
<td><p><input name="man04" type="text" id="man04" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_link"));?>" size="70" />
</p>
<p align="center"><strong>
<input type="hidden" name="id" value="<?php echo $id; ?>"/>
Manşet 0 Resim Önizlem</strong>e<img src="<? printf("%s\n", mysql_result($sonuc,0,"manset_resim_yolu"));?>?>" width="300" height="300" /> </p>
<p align="center">
<input type="submit" name="Submit" value="Manşet 0 ' ın Tüm Haber Kayıtları Güncelle" />
</p></td>
</tr>
</table>
<div align="center"></div>
<p> </p>
<label></label>
</form>
</body>
</html>
--------------------------------------------
işle php sayfası
<?
$baglan=@mysql_connect(localhost,root,root) ;
if (!$baglan)die ("Mysql Baðlantýsý baþarýsýz oldu") ;
mysql_select_db(muttoli,$baglan)or die ("Veritabaný Baðlantýsý Saðlanamadý") ;
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
$id="$baglan" ;
$manset01="$_POST[$man00]" ;
$manset02="$_POST[$man01]" ;
$manset03="$_POST[$man02]" ;
$manset04="$_POST[$man03]" ;
$manset05="$_POST[$man04]" ;
$guncelle = mysql_query("update manset0 set manset_baslik='$manset01',set manset_baslik_b_alt='$manset02', set manset_baslik_k_alt='$manset03',set manset_resim_yolu='$manset04', set manset_link='$manset05',where id = '$id'") or die("Hata Olustu!");;
if($guncelle)
{
echo 'Düzenleme islemi basariyla gerçeklesmistir.';
}
?>
çok acele bir koda ihtiyacım var
acemice oluşturduğum mysql tablo yapım aşağıdaki gibidir
CREATE TABLE `Manset0` (
`manset_baslik` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
`manset_baslik_b_alt` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
`manset_baslik_k_alt` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
`manset_resim_yolu` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
`manset_link` VARCHAR( 100 ) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT lisanssız ,
PRIMARY KEY ( `manset_baslik` )
) ENGINE = MYISAM ;
-----------------------------------------------------
Form.php sayfam aşağıdaki gibidir formun inputlarına manset0 tablsoundan çekilen veriler geliyor (ama formdan gelen verileri işle php ye gönderiyorum hata oluştu diyor sorunum bu nasıl çözerim )
Forum php sayfası
-------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//TR" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
?><title>Untitled Document</title>
<style type="text/css">
<!--
.style23 {font-style: italic; color: #000000; font-family: "Times New Roman", Times, serif; font-size: 13px; font-weight: bold; }
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" /></head>
<body>
<p><?
$baglan=@mysql_connect(localhost,root,root) ;
if (!$baglan)die ("Mysql Baðlantýsý baþarýsýz oldu") ;
mysql_select_db(muttoli,$baglan)or die ("Veritabaný Baðlantýsý Saðlanamadý") ;
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
$sonuc = mysql_query("SELECT * FROM manset0",$baglan);
$mansetbaslik = $_POST['man_alt_0'];
?>
</p>
<form id="form1" name="form1" method="post" action="isle.php">
<table width="694" height="51" border="1">
<tr>
<td width="684" height="45" bgcolor="#FF0000"><div align="center"><em><strong>MANŞET 0 DÜZENLEME PANELİ </strong></em></div></td>
</tr>
</table>
<table width="693" height="523" border="1" bgcolor="#FFFFFF">
<tr>
<td width="250" bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Başlık</span></td>
<td width="427"><input name="man00" type="text" id="man00" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_baslik"));?>" size="70" /></td>
</tr>
<tr>
<td bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Büyük Resim üstü Alt yazısı ; </span></td>
<td><input name="man01" type="text" id="man01" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_baslik_b_alt"));?>" size="70" /></td>
</tr>
<tr>
<td bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Küçük Resim üstü Alt yazısı </span></td>
<td><input name="man02" type="text" id="man02" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_baslik_k_alt"));?>" size="70" /></td>
</tr>
<tr>
<td bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Resim Adresi </span></td>
<td><input name="man03" type="text" id="man03" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_resim_yolu"));?>" size="70" /></td>
</tr>
<tr>
<td height="407" valign="top" bordercolor="#000000" bgcolor="#FF0000"><span class="style23">Manşet 0 Link Adresi </span></td>
<td><p><input name="man04" type="text" id="man04" value="<? printf("%s\n", mysql_result($sonuc,0,"manset_link"));?>" size="70" />
</p>
<p align="center"><strong>
<input type="hidden" name="id" value="<?php echo $id; ?>"/>
Manşet 0 Resim Önizlem</strong>e<img src="<? printf("%s\n", mysql_result($sonuc,0,"manset_resim_yolu"));?>?>" width="300" height="300" /> </p>
<p align="center">
<input type="submit" name="Submit" value="Manşet 0 ' ın Tüm Haber Kayıtları Güncelle" />
</p></td>
</tr>
</table>
<div align="center"></div>
<p> </p>
<label></label>
</form>
</body>
</html>
--------------------------------------------
işle php sayfası
<?
$baglan=@mysql_connect(localhost,root,root) ;
if (!$baglan)die ("Mysql Baðlantýsý baþarýsýz oldu") ;
mysql_select_db(muttoli,$baglan)or die ("Veritabaný Baðlantýsý Saðlanamadý") ;
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
$id="$baglan" ;
$manset01="$_POST[$man00]" ;
$manset02="$_POST[$man01]" ;
$manset03="$_POST[$man02]" ;
$manset04="$_POST[$man03]" ;
$manset05="$_POST[$man04]" ;
$guncelle = mysql_query("update manset0 set manset_baslik='$manset01',set manset_baslik_b_alt='$manset02', set manset_baslik_k_alt='$manset03',set manset_resim_yolu='$manset04', set manset_link='$manset05',where id = '$id'") or die("Hata Olustu!");;
if($guncelle)
{
echo 'Düzenleme islemi basariyla gerçeklesmistir.';
}
?>