Created
October 20, 2015 20:30
-
-
Save VictorFursa/b36f2b5a849e6365a34e to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!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> | |
| Админ занеси в БД id города -> | |
| <input type="text" name="area_id"><br> | |
| Область:<br> | |
| <select name="area_id"><?php | |
| include_once("bd.php"); | |
| $result = mysql_query("SELECT * FROM area"); | |
| while($area = mysql_fetch_array($result)){ | |
| echo "<option value='".$area['id']."'>".$area['name']."</option>"; | |
| } | |
| ?> | |
| </select> | |
| <input type="submit" name="add" value="Добавить"/><br> | |
| <input type="submit" name="search" 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'])); | |
| $areas = strip_tags(trim($_POST['area_id'])); | |
| mysql_query(" | |
| INSERT INTO city(city,area_id) | |
| VALUES('$city','$areas') | |
| "); | |
| echo "Город успешно добавлен!"; | |
| } | |
| if(isset($_POST['area_id'])){ | |
| if(isset ($_POST['area_id'])){ | |
| $result = mysql_query("SELECT * FROM city LEFT JOIN area ON area_id"); | |
| while($row = mysql_fetch_array($result)){ | |
| echo $row['city']."<br>"; | |
| } | |
| } | |
| } | |
| mysql_close(); | |
| ?> | |
| <br> | |
| </body> | |
| </html> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment