[ Поиск ] - [ Пользователи ] - [ Календарь ]
Полная Версия: Не вводится новая запись в базу данных
Страницы: 1, 2
XpertVision
Всем спасибо. Вот правильный рабочий код.


<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>
Add User</title>
</head>
<body>
<form
action="http://proba.com/adduser2.php" method="post">
<h1>
ADD USER</h1>
<table
border=0>
<tr>
<td>
Name</td>
<td><input
type=text name=name maxlength=30 size=13><br></td>
</tr>
<tr>
<td>
Login</td>
<td> <input
type=text name=login maxlength=30 size=30><br></td>
</tr>
<tr>
<td>
Email</td>
<td><input
type=text name=email maxlength=60 size=30><br></td>
</tr>
<tr>
<td>
Password</td>
<td><input
type=text name=pass maxlength=60 size=30><br></td>
<td>
Confirm Pasword</td>
<td><input
type=text name=pass1 maxlength=60 size=30><br></td>
</tr>
<tr>
<td>
Birthday</td>
<td>
<select
name="day">
<option
value = 01>1</option>
<option
value = 02>2</option>
<option
value = 03>3</option>
<option
value = 04>4</option>
<option
value = 05>5</option>
<option
value = 06>6</option>
<option
value = 07>7</option>
<option
value = 08>8</option>
<option
value = 09>9</option>
<option
value = 10>10</option>
<option
value = 11>11</option>
<option
value = 12>12</option>
<option
value = 13>13</option>
<option
value = 14>14</option>
<option
value = 15>15</option>
<option
value = 16>16</option>
<option
value = 17>17</option>
<option
value = 18>18</option>
<option
value = 19>19</option>
<option
value = 20>20</option>
<option
value = 21>21</option>
<option
value = 22>22</option>
<option
value = 23>23</option>
<option
value = 24>24</option>
<option
value = 25>25</option>
<option
value = 26>26</option>
<option
value = 27>27</option>
<option
value = 28>28</option>
<option
value = 29>29</option>
<option
value = 30>30</option>
<option
value = 31>31</option>
</select>
<select
name="month">
<option
value="01">Jan</option>
<option
value=02>Feb</option>
<option
value=03>March</option>
<option
value=04>Apr</option>
<option
value=05>May</option>
<option
value=06>June</option>
<option
value=07>July</option>
<option
value=08>Aug</option>
<option
value=09>Sept</option>
<option
value=10>Oct</option>
<option
value=11>Nov</option>
<option
value=12>Dec</option>
</select>

Input year:<td align=left><input type="text" name="year" size=10></td>
</td>
</tr>
<tr>
<td
colspan=2 align="center"><input type="submit" value="Register"></td>
</tr>
</table>
</form>
</body>
</html>



aadduser2.php


<html>
<
head>
<
title>Add USER</title>
</
head>
<
body>
<
h1>ADD USER</h1>
<?
$name = !empty($_POST['name']) ? $_POST['name'] : '';
$login = !empty($_POST['login']) ? $_POST['login'] : '';
$email = !empty($_POST['email']) ? $_POST['email'] : '';
$pass = !empty($_POST['pass']) ? $_POST['pass'] : '';
$pass1 = !empty($_POST['pass1']) ? $_POST['pass1'] : '';
$day = !empty($_POST['day']) ? $_POST['day'] : '';
$month = !empty($_POST['month']) ? $_POST['month'] : '';
$year = !empty($_POST['year']) ? $_POST['year'] : '';
if (!$name || !$login || !$email || !$pass || !$pass1 || !$day || !$month || !$year)
{
echo "You have not entered all the required details. Please go back and try again.";
exit;
}
$name = addslashes($name);
$login = addslashes($login);
$email = addslashes($email) ;
$pass = addslashes($pass);
$pass1 = addslashes($pass1);
$day = addslashes($day);
$month = addslashes($month) ;
$year = addslashes($year);
if ($pass!=$pass1)
{
echo "Password incorect.";
exit;
}
$date=$year.'-'.$month.'-'.$day;
$number=0;
mysql_connect('localhost','root','12344321') OR die("Dont connect");
mysql_select_db('users') or die(mysql_error());
@mysql_query('set character_set_client="utf8"');
@mysql_query('set collation_connection="utf8_general_ci"');
$query="insert into `users` (`number`, `name`, `login`, `password`, `email`, `birthday`) values (null, '".$name."', '".$login."', '".$pass."', '".$email."', '".$date."')";

mysql_query($query) or die(mysql_error());
echo "User ADD";
mysql_close();
?>
</body>
</
html>


Спасибо всем за помощь. rolleyes.gif
Быстрый ответ:

 Графические смайлики |  Показывать подпись
Здесь расположена полная версия этой страницы.
Invision Power Board © 2001-2025 Invision Power Services, Inc.