I am using this code no problem in windows localhost
but when I am using linux server it doesnt add db anything!!
Where is mistake? is it different win or linux coding?
(I have a config.php so I use some function to dont waste time like
$link)
that is my form.php
<?php
include "../../config.php";
opentable("emlak");
//fonksiyon tanimlamalari
function show_form($iemlak="",$mevki="",$resim="http://",$adres="",$metre="",$aciklama="",$fiyat="",$cinsi="",$satkir=""){
echo "<table width=400 align=center cellspacing=1 cellpadding=1>
<form action=\"form.php\" method=\"Post\">
<tr>
<td>Emlak Adi</td>
<td><input type=\"text\" name=\"emlak\" value=\"$emlak\" size=20>
</td>
</tr>
<tr>
<td>mevki</td>
<td><input type=\"text\" name=\"mevki\" value=\"$mevki\" size=20>
</td>
</tr>
<tr>
<td> Emlak Resmi</td>
<td>
<input type=\"text\" name=\"resim\" value=\"$resim\" size=20>
</td>
</tr>
<tr>
<td> Adres</td>
<td colspan=2>
<textarea cols=50 rows=3 name=\"adres\">$adres</textarea>
</td>
</tr>
<tr>
<td> Metrekare</td>
<td>
<input type=\"text\" name=\"metre\" value=\"$metre\" size=20>
</td>
</tr>
<tr>
<td> Açiklama</td>
<td colspan=2>
<textarea cols=50 rows=6 name=\"aciklama\">$aciklama</textarea>
</td>
</tr>
<tr>
<td>Fiyat</td>
<td>
<input type=\"text\" name=\"fiyat\" value=\"$fiyat\" size=20>
</td>
</tr>
<tr>
<td> Cinsi</td>
<td>
<input type=\"text\" name=\"cinsi\" value=\"$cinsi\" size=20>
</td>
</tr>
<tr>
<td> Satilik/Kiralik</td>
<td>
<input type=\"text\" name=\"satkir\" value=\"$satkir\" size=20>
</td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=\"submit\" value=\"Gönder\">
</td>
</tr>
</form>
</table>";
} //function sonu
if (getenv("content_length")==0){
//form post ile gönderilmemis
//formu göster
show_form();
}
else {
//form gönderilmis//form bilgilerini, veritabanina yaz
$emlak=@$HTTP_POST_VARS["emlak"];
$mevki=@$HTTP_POST_VARS["mevki"];
$resim=@$HTTP_POST_VARS["resim"];
$adres =@$HTTP_POST_VARS["adres"];
$metre=@$HTTP_POST_VARS["metre"];
$aciklama=@$HTTP_POST_VARS["aciklama"];
$fiyat=@$HTTP_POST_VARS["fiyat"];
$cinsi =@$HTTP_POST_VARS["cinsi"];
$satkir =@$HTTP_POST_VARS["satkir"];
//bos birakilmamali
if ($emlak=="" || $aciklama==""){
//formu tekrar göster, doldurmus oldugu degerleri de forma yazdir
show_form($iemlak,$mevki,$resim,$adres,$metre,$aciklama,$fiyat,$cinsi,$satkir);
}
else {
//kontrol tamam simdi veritabanina yaz
$link = dbconnect($db_host, $db_user, $db_pass, $db_name);
//gerekli diger bilgiler
//sorgumuz
$sorgu = "INSERT INTO db_emlakmod6";
$sorgu .= "(emlak,mevki,resim,adres,metre,aciklama,fiyat,cinsi,satkir)";
$sorgu .= " VALUES ";
$sorgu .= "('$iemlak','$mevki','$resim','$adres','$metre','$aciklama','$fiyat','$cinsi','$satkir')";
@mysql_query($sorgu);
//islemler tamam simdi deftere dön
header ("Location:index.php");
} // if $isim kontrol
} // if getenv
closetable();
?>
that is my index
<?php
include "../../config.php";
//veritabanina baglan
$link = dbconnect($db_host, $db_user, $db_pass, $db_name);
$sorgu = "SELECT * FROM db_emlakmod6 ORDER By tarih DESC";
$sorgulama = @mysql_query($sorgu);
if (dbrows($sorgulama)>0){
echo "<center><a href=\"form.php\" >Deftere yaz</a></center><br>";
//kayitlari listele
while ($kayit=mysql_fetch_array($sorgulama)){
$emlak=$kayit["emlak"];
$mevki=$kayit["mevki"];
$adres=$kayit["adres"];
$aciklama=$kayit["aciklama"];
$cinsi=$kayit["cinsi"];
$fiyat =$kayit["fiyat"];
echo "<table width=400 align=center cellspacing=1 cellpadding=1
style=\"border:1px solid;\">";
echo "<tr><td>$emlak ";
if ($emlak!="")
echo "<a href=\"Mail mailto:$mevki\">Mail</a> ";
if ($website!="")
echo "<a href=\"$adres\" target=\"_blank\">Site</a>";
echo "</td></tr><tr><td>";
echo "<b>".nl2br(htmlspecialchars($aciklama))."</b>";
echo "</td></tr><tr><td>";
echo "<hr size=1><small>Tarih :$fiyat , IP :<i>$cinsi</i></small>";
echo "</td></tr></table><br>";
} // while sonu
echo "<center><a href=\"form.php\" >Deftere yaz</a></center>";
} else {
//hiç kayit yok
echo "Henüz ilan eklenmemeiş,<a href=\"form.php\">eklemek
istermisiniz</a> ? ";
}
?>
id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
emlak VARCHAR(200) DEFAULT '' NOT NULL,
adres VARCHAR(200) DEFAULT '' NOT NULL,
mevki VARCHAR(200) DEFAULT '' NOT NULL,
metre int(11) NOT NULL default '0',
aciklama VARCHAR(250) DEFAULT '' NOT NULL,
fiyat VARCHAR(50) DEFAULT '' NOT NULL,
resim VARCHAR(50) DEFAULT '' NOT NULL,
cinsi VARCHAR(20) DEFAULT '' NOT NULL,
satkir VARCHAR(20) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;";
and those are my tables(there is no mistake in db I created them)
