Hey guys,
<form action="ekle.php" method="POST">
Yazý ismi:
<input type="ad" name="first">
Yazý Kategorisi:
<input name="cat" type="text" value="">
Text :
<textarea name="text"></textarea>
<input type="Submit">
</form>
now we run the script
<?php
$ad= $POST['ad'];
$cat= $POST['cat'];
$text= $_POST['text'];
$username="ad";
$password="sifre";
$database="db";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO makale VALUES ('','$ad','$cat','$text')";
mysql_query($query);
if ($query) {
echo "Yazý Eklendi";
}
else {
echo "Yazý Eklenemedi";
}
mysql_close();
?>
and then we run goster.php
<?php
$ad= $POST['ad'];
$cat= $POST['cat'];
$text= $_POST['text'];
$username="lisetarih";
$password="NqBmyLy6";
$database="lisetarih";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM makale";
$result=mysql_query($query);
mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Veritabani bilgileri</center></b>
";
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$ad=mysql_result($result,$i,"ad");
$cat=mysql_result($result,$i,"cat");
$text=mysql_result($result,$i,"text");
echo "<b>$id $ad</b>
Kategori: $cat
Yazý: $text
";
++$i;
}
OK it seems fine I run ekle.htm to add stuff to my database via ekle.php (these are turkish, first one is add.htm and ekle.php means add.php)
then I run goster.php (which is list.php) to show my database content but what I see is just the id number none of the other variables are added to my database.
see it for yourself
www.lisetarih.com/sql/goster.php //list.php
www.lisetarih.com/sql/ekle.htm //add.htm (form page)
www.lisetarih.com/sql/ekle.php //add.php (action script)
please help me with it
