Temat: Brak dodawnai rekordów do bazy danych
plik connect .php
<?php
$db_name='calendar';
$host='localhost';
$user='root';
$pass='';
@msql_connect($host, $user, $pass) or die('brak polaczenia z msql');
@msql_select_db($db_name) or die('brak polaczenia z baza danych');?>
plik register.php
<?php
require("connect.php");
date_default_timezone_set("Europe/Warsaw");
setlocale(LC_TIME, "pl");
$date = date('m/d/Y h:i:s a', time());
$name=$_POST['name'];
$surname=$_POST['surname'];
$nick=$_POST['nick'];
$mail=$_POST['email'];
$telefon=$_POST['telefon'];
if (!empty($_POST['name'] && $_POST['surname'] && $_POST['nick'] && $_POST['email'] && $_POST['telefon'])){
$query ="INSERT INTO klient values ('','$name','$surname','$nick','$mail','$telefon',now()";
mysql_query(query);
mysql_close();
}
?>
index.php
<form action="register.php" onsubmit="return przetwarzaj_dane();" method="post">
<fieldset>
<legend>Dane osobowe</legend>
<table>
<tr>
<td>Imię</td>
<td><input type="text" name="name" required></td>
</tr>
<td>Nazwisko</td>
<td><input id="nazwisko"type="text" name="surname"required></td>
</tr>
<tr>
<td>Nick allergo</td>
<td><input id="nick" type="text" name="nick" required></td>
</tr>
<tr>
<td>Numer aukcji</td>
<td><input type="text" name="numer"required></td>
</tr>
<tr>
<td>E-mial</td>
<td><input type="email" name="email" required/></td>
</tr>
<tr>
<td>Telefon</td>
<td><input type="phone" name="telefon"required/></td>
<tr>
</table>
</fieldset>
<br><br>
<input type="submit" name="submit" value="Wyślij">
</tr>
</form>
baza dancyh
CREATE TABLE IF NOT EXISTS `klient` (
`idklienta` int(20) NOT NULL AUTO_INCREMENT,
`imie` varchar(20) NOT NULL,
`nazwisko` varchar(20) NOT NULL,
`nick` varchar(20) NOT NULL,
`numer` varchar(20) NOT NULL,
`email` varchar(50) NOT NULL,
`telefon` varchar(15) NOT NULL,
`dataiczaszam` datetime NOT NULL,
PRIMARY KEY (`idklienta`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
bledy
-Notice: Use of undefined constant query - assumed 'query' in C:\wamp\www\calendar\register.php on line 15
Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\calendar\register.php on line 15