*************

SQL code: Upload dump Copy Format Clear

CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `trn_date` datetime NOT NULL, PRIMARY KEY (`id`) );

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>Registration</title> <link rel="stylesheet" href="css/style.css" /> </head> <body> <?php require('db.php'); // If form submitted, insert values into the database. if (isset($_REQUEST['username'])){ // removes backslashes $username = stripslashes($_REQUEST['username']); //escapes special characters in a string $username = mysqli_real_escape_string($con,$username); $email = stripslashes($_REQUEST['email']); $email = mysqli_real_escape_string($con,$email); $password = stripslashes($_REQUEST['password']); $password = mysqli_real_escape_string($con,$password); $trn_date = date("Y-m-d H:i:s"); $query = "INSERT into `users` (username, password, email, trn_date) VALUES ('$username', '".md5($password)."', '$email', '$trn_date')"; $result = mysqli_query($con,$query); if($result){ echo "<div class='form'> <h3>You are registered successfully.</h3> <br/>Click here to <a href='login.php'>Login</a></div>"; } }else{ ?> <div class="form"> <h1>Registration</h1> <form name="registration" action="" method="post"> <input type="text" name="username" placeholder="Username" required /> <input type="email" name="email" placeholder="Email" required /> <input type="password" name="password" placeholder="Password" required /> <input type="submit" name="submit" value="Register" /> </form> </div> <?php } ?> </body> </html>

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online