SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | $db= "lab3"; | |
| 3 | $name = $_POST["name"]; | |
| 4 | $pass = md5($_POST["password"]); | |
| 5 | - | $password = ""; |
| 5 | + | |
| 6 | $date = date("Y-m-d H:i:s");
| |
| 7 | ||
| 8 | - | $servername = "localhost"; |
| 8 | + | $conn=mysql_connect('localhost','root','');
|
| 9 | - | //create connection |
| 9 | + | mysql_select_db($db,$conn); |
| 10 | - | $conn= new mysqli($servername,'root',$password,$db); |
| 10 | + | |
| 11 | - | //check connection |
| 11 | + | $sql_quer = "INSERT INTO user(name, password, email, registration_date) VALUES ('$name','$pass','$email','$date')";
|
| 12 | - | if ($conn->connect_error) {
|
| 12 | + | |
| 13 | - | die("Connection failed: " . $conn->connect_error);
|
| 13 | + | if (mysql_query($sql_quer)==true) {
|
| 14 | echo "New record created successfully!!!"; | |
| 15 | } else {
| |
| 16 | - | $sql = "INSERT INTO user(name, password, email, registration_date) |
| 16 | + | echo "Error! "; |
| 17 | - | VALUES ('$name','$password','$email','$date')";
|
| 17 | + | |
| 18 | ||
| 19 | - | if ($conn->query($sql) === TRUE) {
|
| 19 | + |
