Добавяне в таблица

[sle]

Този код защо не работи?

<?php
echo '
<form action="index.php"  method="post" name="edit">
<input type="submit" value="Добави!"  name="edit" />';

echo '
<tr bgcolor="#D7EBFF">
<td  align="center"><input type="text" name="asd" value="" />','</td>
<td  align="center"><input type="text" name="asdasd" value="" />','</td>
<td  align="center"><input type="text" name="asdasdasd" value="" size="5" /></td>
<td  align="center"><input type="text" name="asdasdasdasd" value="" size="5" /></td>
<td align="center"><input type="text" name="asdasdasdasdasd" value="" size="6" /></td>
</tr>
</form>';

if($_POST['edit'])
{
$a=$_POST['asd'];
$b=$_POST['asdasd'];
$c=$_POST['asdasdasd'];
$d=$_POST['asdasdasdasd'];
$e=$_POST['asdasdasdasdasd'];

$query=mysql_query("INSERT INTO 'posledni' ('match', 'tips', 'hyhy', 'Score', 'Verdict') VALUES('$a', '$b', '$c', '$d', '$e')");
}

}
?>

 

[proba]

<?php
mysql_connect("localhost","username","password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
echo '
<form method="post">
<input type="submit" value="Добави!"  name="edit" />';
echo '
<tr bgcolor="#D7EBFF">
<td  align="center"><input type="text" name="asd" />','</td>
<td  align="center"><input type="text" name="asdasd" />','</td>
<td  align="center"><input type="text" name="asdasdasd" size="5" /></td>
<td  align="center"><input type="text" name="asdasdasdasd" size="5" /></td>
<td align="center"><input type="text" name="asdasdasdasdasd" size="6" /></td>
</tr>
</form>';

if(isset($_POST['edit']))
{
$a=$_POST['asd'];
$b=$_POST['asdasd'];
$c=$_POST['asdasdasd'];
$d=$_POST['asdasdasdasd'];
$e=$_POST['asdasdasdasdasd'];

mysql_query("INSERT INTO `posledni` (match, tips, hyhy, Score, Verdict) VALUES('$a', '$b', '$c', '$d', '$e')");
}
}
?>

Така ?

П.С. само не ми е ясно защо след като формата работи с този фаил и слагаш action=index.php ? и защо слагаш име на формата , като на submita ? И празни value="" ? Също така промених малко заявката , и направих връзка с mysql и с база данни , само си настрой данните.

 

[kriss]

<?php
mysql_connect("localhost","username","password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
echo '<form method="post">';
echo '<tr bgcolor="#D7EBFF">
<td  align="center"><input type="text" name="asd" value="" />','</td>
<td  align="center"><input type="text" name="asdasd" value="" />','</td>
<td  align="center"><input type="text" name="asdasdasd" value="" size="5" /></td>
<td  align="center"><input type="text" name="asdasdasdasd" value="" size="5" /></td>
<td align="center"><input type="text" name="asdasdasdasdasd" value="" size="6" />
<input type="submit" value="Добави!"  name="edit" />
</td>
</tr>
</form>';

if(isset($_POST['edit']))
{
$a=$_POST['asd'];
$b=$_POST['asdasd'];
$c=$_POST['asdasdasd'];
$d=$_POST['asdasdasdasd'];
$e=$_POST['asdasdasdasdasd'];

mysql_query("INSERT INTO `posledni` (`match`, `tips`, `hyhy`, `Score`, `Verdict`) VALUES ('$a', '$b', '$c', '$d', '$e')");
}
}
?>

или така?

 

[embaka]

първо, че в заявката не трябва да имаш '', а ``

<?php
if(isset($_POST['submit']))
{
	$a=$_POST['asd'];
	$b=$_POST['asdasd'];
	$c=$_POST['asdasdasd'];
	$d=$_POST['asdasdasdasd'];
	$e=$_POST['asdasdasdasdasd'];

$query=mysql_query("INSERT INTO `posledni` SET `match`='".$a."', `tips`='".$b."', `hyhy`='".$c."', `Score`='".$d."', `Verdict`='".$e."'");
}

$act = $_SERVER['PHP_SELF'];

echo '
<form action="$act"  method="post">
<tr bgcolor="#D7EBFF">
<td  align="center"><input type="text" name="asd" />','</td>
<td  align="center"><input type="text" name="asdasd" />','</td>
<td  align="center"><input type="text" name="asdasdasd" size="5" /></td>
<td  align="center"><input type="text" name="asdasdasdasd" size="5" /></td>
<td align="center"><input type="text" name="asdasdasdasdasd" size="6" /></td>
</tr>
<input type="submit" value="Добави!" name="submit" />
</form>';



?>