не мога да записвам информация в БД

G

golbez

Registered
Защо немога да добавям информация в базата данни като си правя всичко както си трябва.
Ето и кода. Невиждам да има грешка. Уж успешно ама няма нищо в таблицата.
Код: 
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Add users</title>

</head><body>
<?php
$self= $_SERVER['PHP_SELF'];
$id= $_POST['id'];
$nick= $_POST['nick'];
?>
<form action="<? echo("$self");?>" method="post">
<b>INPUT noumber of player:</b><input type="text" name="id" size="4"><br>
<b>INPUT nick of player:</b><input type="text" name="nick" size="10"><br>
<input type="submit" value="ADD">
</form>
<?php 
if ($id and $nick)
{
include("config.php");

$sql = "insert into turniri ( id, nick) values ($id, $nick)"; //syzdavane na zaqvka
if($sql){
$rs = "mysql_query($sql, $conn)"; // izpylnenie nazaqvkata
if($rs)
{
echo("Success :) ");
}
}
else
{
echo("ERROR: \$sql");}
}
else
{
echo("Enter nick and id ! ");
}
?>
</body>
</html>
 
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Add users</title>

</head><body>
<?php
$self= $_SERVER['PHP_SELF'];
$id= $_POST['id'];
$nick= $_POST['nick'];
?>
<form action="<? echo("$self");?>" method="post">
<b>INPUT noumber of player:</b><input type="text" name="id" size="4"><br>
<b>INPUT nick of player:</b><input type="text" name="nick" size="10"><br>
<input type="submit" value="ADD">
</form>
<?php
$id=$_POST['id'];
$nick=$_POST['nick'];
if ($id and $nick)
{
include("config.php");

$sql = "insert into turniri ( id, nick) values ($id, $nick)"; //syzdavane na zaqvka
if($sql){
$rs = "mysql_query($sql, $conn)"; // izpylnenie nazaqvkata
if($rs)
{
echo("Success :) ");
}
}
else
{
echo("ERROR: \$sql");}
}
else
{
echo("Enter nick and id ! ");
}
?>
</body>
</html>
Увеличете...
 
ц . същата работа . Защо? Незнам :) .
 
Код: 
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Add users</title>

</head><body>
<?php
$self= $_SERVER['PHP_SELF'];
?>
<form action="<? echo("$self");?>" method="post">
<b>INPUT noumber of player:</b><input type="text" name="id" size="4"><br>
<b>INPUT nick of player:</b><input type="text" name="nick" size="10"><br>
<input type="submit" value="ADD">
</form>
<?php
$id=$_POST['id'];
$nick=$_POST['nick'];
if ($id and $nick)
{
include("config.php");
$sql = "insert into turniri ( id, nick) values ($id, $nick)"; //syzdavane na zaqvka
$rs = mysql_query($sql, $conn) or die(mysql_error()); // izpylnenie nazaqvkata
if($rs)
{
echo("Success Smile ");
}
} else {
echo("Enter nick and id ! ");
}
?>
</body>
</html>

:roll:
 
Излиза ми тази грешка
Unknown column 'proba' in 'field list'
:(
Пиша за ник "proba" и неще ако напиша за ник число и става
 
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Add users</title>

</head><body>
<?php
$self= $_SERVER['PHP_SELF'];
$id= $_POST['id'];
$nick= $_POST['nick'];
?>
<form action="<? echo("$self");?>" method="post">
<b>INPUT noumber of player:</b><input type="text" name="id" size="4"><br>
<b>INPUT nick of player:</b><input type="text" name="nick" size="10"><br>
<input type="submit" value="ADD">
</form>
<?php
if ($id and $nick)
{
include("config.php");

$sql = "insert into turniri ( id, nick) values ('$id', '$nick')"; //syzdavane na zaqvka
if($sql){
$rs = mysql_query($sql, $conn); // izpylnenie nazaqvkata
if($rs)
{
echo("Success :) ");
}
}
else
{
echo("ERROR: \$sql");}
}
else
{
echo("Enter nick and id ! ");
}
?>
</body>
</html>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе