Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // Information needed for MySQL connection
- $host='localhost';
- $database='david';
- $user='david';
- $password='Passw0rd';
- // Connecting to our MySQL database
- $connection = new mysqli($host, $user, $password, $database);
- // Checking for error in connection
- if ($connection->connect_error) {
- die("Connection failed: " . $connection->connect_error);
- }
- ?>
- <HTML>
- <HEAD>
- <TITLE>Форма для заполнения</TITLE>
- <BODY>
- <CENTER>
- Введите личную информацию
- <P>
- <TABLE WIDTH = 400 BORDER = 1>
- <TR><TD align = right>
- <FORM ACTION="getData.php" METHOD="POST">
- <CENTER>
- Ваше имя:<BR>
- <INPUT TYPE="text" NAME="name" SIZE="20" MAXLENGTH="30">
- <P>
- Ваш день рождения:<BR>
- <INPUT TYPE="date" NAME="birthdate" SIZE="20" MAXLENGTH="30">
- <P>
- Ваш адрес:<BR>
- <INPUT TYPE="text" NAME="address" SIZE="20" MAXLENGTH="30">
- <P>
- Время занисения данных:<BR>
- <INPUT TYPE="datetime-local" NAME="date" SIZE="20" MAXLENGTH="30">
- <P>
- Комментарий:<BR>
- <INPUT TYPE="text" NAME="comment" SIZE="20" MAXLENGTH="30">
- <P>
- Пол:<BR>
- <SELECT NAME="gender">
- <OPTION VALUE="M">Мужчина</OPTION>
- <OPTION VALUE="W">Женщина</OPTION>
- </SELECT>
- <P>
- Город:<BR>
- <SELECT NAME="city">
- <?php
- $sql = "SELECT id, name FROM city";
- $result = $connection->query($sql);
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- echo '<OPTION VALUE="'. $row["id"] .'">'. $row["name"] .'</OPTION>';
- }
- }
- ?>
- </SELECT>
- <P>
- Образование:<BR>
- <SELECT NAME="education">
- <?php
- $sql = "SELECT id, name FROM education";
- $result = $connection->query($sql);
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- echo '<OPTION VALUE="'. $row["id"] .'">'. $row["name"] .'</OPTION>';
- }
- }
- ?>
- </SELECT>
- <P>
- Профессия:<BR>
- <SELECT NAME="ocupation">
- <?php
- $sql = "SELECT id, name FROM ocupation";
- $result = $connection->query($sql);
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- echo '<OPTION VALUE="'. $row["id"] .'">'. $row["name"] .'</OPTION>';
- }
- }
- ?>
- </SELECT>
- <P>
- Ваш голос за:<BR>
- <SELECT NAME="vote">
- <?php
- $sql = "SELECT id, name FROM vote";
- $result = $connection->query($sql);
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- echo '<OPTION VALUE="'. $row["id"] .'">'. $row["name"] .'</OPTION>';
- }
- }
- ?>
- </SELECT>
- <P>
- <INPUT TYPE="submit" VALUE="Отправить запрос!">
- </CENTER>
- </FORM>
- </TD></TR>
- </TABLE>
- </CENTER>
- </BODY>
- </HTML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement