Bir veritabanım var ve başarılı bir şekilde bilgileri databaseye ekliyorum.
Yapmak istediğim UPDATE ile bilgileri güncelleme (değiştirme) yapmak
kodlarım aşağıdaki şekilde
CREATE TABLE IF NOT EXISTS `ayarlar` ( `googleanalytic` longtext collate utf8_turkish_ci NOT NULL, `googlebot` longtext collate utf8_turkish_ci NOT NULL, `yahoobot` longtext collate utf8_turkish_ci NOT NULL, `msnbot` longtext collate utf8_turkish_ci NOT NULL, `siteurl` longtext collate utf8_turkish_ci NOT NULL, `siteismi` longtext collate utf8_turkish_ci NOT NULL, `title` longtext collate utf8_turkish_ci NOT NULL, `baslik` longtext collate utf8_turkish_ci NOT NULL, `slogan` longtext collate utf8_turkish_ci NOT NULL, `hakkimda` longtext collate utf8_turkish_ci NOT NULL, `banner` longtext collate utf8_turkish_ci NOT NULL, `tel` longtext collate utf8_turkish_ci NOT NULL, `description` longtext collate utf8_turkish_ci NOT NULL, `keywords` longtext collate utf8_turkish_ci NOT NULL, `dikeyreklam` longtext collate utf8_turkish_ci NOT NULL, `yatayreklam` longtext collate utf8_turkish_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType)
{
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "ayarekle"))
{
$insertSQL = sprintf("INSERT ayarlar SET(googlebot, yahoobot, msnbot, siteismi, siteurl, baslik, slogan, hakkimda, description, keywords, googleanalytic, tel, dikeyreklam, yatayreklam) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['googlebot'], "text"),
GetSQLValueString($_POST['yahoobot'], "text"),
GetSQLValueString($_POST['msnbot'], "text"),
GetSQLValueString($_POST['siteismi'], "text"),
GetSQLValueString($_POST['siteurl'], "text"),
GetSQLValueString($_POST['baslik'], "text"),
GetSQLValueString($_POST['slogan'], "text"),
GetSQLValueString($_POST['hakkimda'], "text"),
GetSQLValueString($_POST['description'], "text"),
GetSQLValueString($_POST['keywords'], "text"),
GetSQLValueString($_POST['googleanalytic'], "text"),
GetSQLValueString($_POST['tel'], "text"),
GetSQLValueString($_POST['dikeyreklam'], "text"),
GetSQLValueString($_POST['yatayreklam'], "text")
);
mysql_select_db($database_ismi, $baglan);
$Result1 = mysql_query($insertSQL, $baglan) or die("Gerekli alanlar doldurulmadı!<br><a href=\"javascript:history.go(-1);\">geri</a>");
$insertGoTo = "ok.php?islem=ayarlarguncellendi";
if (isset($_SERVER['QUERY_STRING']))
{
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
// Google Bot Kodunu çağırıyoruz
mysql_select_db($database_ismi, $baglan);
$query_gbotgetir = "SELECT siteismi FROM ayarlar";
$gbotgetir = mysql_query($query_gbotgetir, $baglan) or die(mysql_error());
$row_gbotgetir = mysql_fetch_assoc($gbotgetir);
// Yahoo Bot Kodunu çağırıyoruz
mysql_select_db($database_ismi, $baglan);
$query_ybotgetir = "SELECT siteismi FROM ayarlar";
$ybotgetir = mysql_query($query_ybotgetir, $baglan) or die(mysql_error());
$row_ybotgetir = mysql_fetch_assoc($ybotgetir);
// MSN Bot Kodunu çağırıyoruz
mysql_select_db($database_ismi, $baglan);
$query_mbotgetir = "SELECT siteismi FROM ayarlar";
$mbotgetir = mysql_query($query_mbotgetir, $baglan) or die(mysql_error());
$row_mbotgetir = mysql_fetch_assoc($mbotgetir);
// Site ismini çağırıyoruz
mysql_select_db($database_ismi, $baglan);
$query_siteismigetir = "SELECT siteismi FROM ayarlar";
$siteismigetir = mysql_query($query_siteismigetir, $baglan) or die(mysql_error());
$row_siteismigetir = mysql_fetch_assoc($siteismigetir);
// Site url çağırıyoruz
$query_siteurlgetir = "SELECT siteurl FROM ayarlar";
$siteurlgetir = mysql_query($query_siteurlgetir, $baglan) or die(mysql_error());
$row_siteurlgetir = mysql_fetch_assoc($siteurlgetir);
// Site başlığı çağırıyoruz
$query_baslikgetir = "SELECT baslik FROM ayarlar";
$baslikgetir = mysql_query($query_baslikgetir, $baglan) or die(mysql_error());
$row_baslikgetir = mysql_fetch_assoc($baslikgetir);
// Site Sloganını çağırıyoruz
$query_slogangetir = "SELECT slogan FROM ayarlar";
$slogangetir = mysql_query($query_slogangetir, $baglan) or die(mysql_error());
$row_slogangetir = mysql_fetch_assoc($slogangetir);
// Site Sloganını çağırıyoruz
$query_hakkimdagetir = "SELECT hakkimda FROM ayarlar";
$hakkimdagetir = mysql_query($query_hakkimdagetir, $baglan) or die(mysql_error());
$row_hakkimdagetir = mysql_fetch_assoc($slogangetir);
// Site description çağırıyoruz
$query_descgetir = "SELECT description FROM ayarlar";
$descgetir = mysql_query($query_descgetir, $baglan) or die(mysql_error());
$row_descgetir = mysql_fetch_assoc($descgetir);
// Site keywords çağırıyoruz
$query_keywgetir = "SELECT keywords FROM ayarlar";
$keywgetir = mysql_query($query_keywgetir, $baglan) or die(mysql_error());
$row_keywgetir = mysql_fetch_assoc($keywgetir);
// Site google analytic çağırıyoruz
$query_anlytcgetir = "SELECT googleanalytic FROM ayarlar";
$anlytcgetir = mysql_query($query_anlytcgetir, $baglan) or die(mysql_error());
$row_anlytcgetir = mysql_fetch_assoc($anlytcgetir);
// Site tel çağırıyoruz
$query_telgetir = "SELECT tel FROM ayarlar";
$telgetir = mysql_query($query_telgetir, $baglan) or die(mysql_error());
$row_telgetir = mysql_fetch_assoc($telgetir);
// Site Dikey reklam çağırıyoruz
$query_dreklamgetir = "SELECT dikeyreklam FROM ayarlar";
$dreklamgetir = mysql_query($query_dreklamgetir, $baglan) or die(mysql_error());
$row_dreklamgetir = mysql_fetch_assoc($dreklamgetir);
// Site Yatay Reklam çağırıyoruz
$query_yreklamgetir = "SELECT yatayreklam FROM ayarlar";
$yreklamgetir = mysql_query($query_yreklamgetir, $baglan) or die(mysql_error());
$row_yreklamgetir = mysql_fetch_assoc($yreklamgetir);
?><p> SİTE AYARLARI </p>
<form action="<?php echo $editFormAction; ?>" method="post" enctype="multipart/form-data" class="forms" name="ayarekle" >
<b>Site İsmi</b>
<input id="siteismi" name="siteismi" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_siteismigetir['siteismi']; ?>"><br />
<b>Site URL</b>
<input id="siteurl" name="siteurl" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_siteurlgetir['siteurl']; ?>"><br />
<b>Site Başlığı</b>
<input id="baslik" name="baslik" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_baslikgetir['baslik']; ?>"><br />
<b>Site Slogan</b>
<input id="slogan" name="slogan" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_slogangetir['slogan']; ?>"><br />
<b>Hakkımda</td>
<input id="hakkimda" name="hakkimda" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_hakkimdagetir['hakkimda']; ?>"><br />
<b>Description</b>
<input id="description" name="description" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_descgetir['description']; ?>"><br />
<b>Keywords</b>
<input id="keywords" name="keywords" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_keywgetir['keywords']; ?>"><br />
<b>Google Analytic </b>
<input id="googleanalytic" name="googleanalytic" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_anlytcgetir['googleanalytic']; ?>"><br />
<b>Telefon Numaranız</b>
<input id="tel" name="tel" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_telgetir['tel']; ?>"><br />
<b>Dikey Reklam</b>
<input id="dreklam" name="dikeyreklam" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_dreklamgetir['dikeyreklam']; ?>"><br />
<b>Yatay Reklam</b>
<input id="yatayreklam" name="yatayreklam" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_dreklamgetir['dikeyreklam']; ?>"><br />
<b>Google Bot Kodu</b>
<input id="googlebot" name="googlebot" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_gbotgetir['googlebot']; ?>"><br />
<b>Yahoo Bot Kodu</b>
<input id="yahoobot" name="yahoobot" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_ybotgetir['yahoobot']; ?>"><br />
<b>MSN Bot Kodu</b>
<input id="msnbot" name="msnbot" size="49" style="width: 525px;" class="ninput" type="text" value="<?php echo $row_mbotgetir['msnbot']; ?>"><br />
<input type="submit" value="gönder!">
<input type="hidden" name="MM_insert" value="ayarekle">
</form>Yardımcı olursanız sevinirim arkadaşlar