Skip to content

Instantly share code, notes, and snippets.

@VictorFursa
Created October 14, 2015 19:48
Show Gist options
  • Save VictorFursa/9e02e29c5e9bb4cf2943 to your computer and use it in GitHub Desktop.
Save VictorFursa/9e02e29c5e9bb4cf2943 to your computer and use it in GitHub Desktop.
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Города</title>
</head>
<body>
<form method="POST" action="city.php">
Город: <br>
<input type="text" name="city"/><br>
Область:<br>
<input type="text" name="area"/><br>
<input type="submit" name="add" value="Добавить"/><br>
</form>
<?php
mysql_connect("localhost","root","")
or die('Не удалось соединиться: ' . mysql_error());
mysql_select_db("alcohol")
or die('Не удалось выбрать базу данных');
mysql_set_charset("utf8");
if(isset ($_POST['add'])) {
$city = strip_tags(trim($_POST['city']));
$area = strip_tags(trim($_POST['area']));
mysql_query("
INSERT INTO city(city,area)
VALUES('$city','$area')
");
echo "Город успешно добавлен!";
}
mysql_close();
?>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment