There is a form:

<!doctype html> <html lang="ru"> <head> <meta charset="UTF-8"> <title>Countries</title> </head> <body> <form action="getForm.php" method="POST"> <label for="country">Введите страну</label> <input type="text" name="country" size="15"><br> <label for="city">Введите город</label> <input type="text" name="city" size="15"><br> <label for="district">Введите район</label> <input type="text" name="district" size="15"> <br> <input type="submit" value="Добавить в базу"> </form> </body> </html>

There is a handler:

 <?php $country=$_POST['country']; $city=$_POST['city']; $district=$_POST['district']; $link = mysql_connect("localhost", "root") or die("Could not connect: " . mysql_error()); mysql_select_db("countries"); mysql_query("SET NAMES UTF8"); mysql_query("SET CHARACTER SET UTF8"); $s="INSERT INTO Country VALUES ('".$country."','".$city."','".$district."');"; mysql_query($s); if($s){ echo "Запись добавлена"; } else { mysql_error(); } mysql_close($link); ?>

As it is already clear, I want the data entered in the form to be inscribed in the database. When checking the echo function is executed, but nothing is written to the database, I break my head ...

Here is the base itself:

 +---------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | name_country | varchar(20) | NO | | NULL | | | name_city | varchar(20) | NO | | NULL | | | name_district | varchar(20) | NO | | NULL | | +---------------+-------------+------+-----+---------+----------------+

Help me to understand :(

  • one
    Please note that the MySQL extension is deprecated since PHP 5.5.0 and removed in PHP 7.0.0. Use MySQLi or PDO_MySQL instead. - labris

1 answer 1

I can be mistaken right now, but in the format of an INSERT INTO query, if you do not specify which fields should be filled in, you must specify the values ​​of absolutely all fields in VALUES — including the primary key.
In other words, it is worth building a query either in this way:

 INSERT INTO Country VALUES(1, 'country', 'city', 'dist');

Or so

 INSERT INTO Country (name_country, name_city, name_district) VALUES ('country', 'city', 'dist');

And I was always amused by the combination of the terms "NOT NULL" and "DEFAULT NULL".