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

SQL code: Upload dump Copy Format Clear

-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 08, 2022 at 10:45 AM -- Server version: 10.4.22-MariaDB -- PHP Version: 8.0.13 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `website` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) NOT NULL, `username` varchar(20) NOT NULL, `email` varchar(50) NOT NULL, `password` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `email`, `password`) VALUES (1, 'heyo@gmail.com', 'heyo@gmail.com', '5f4dcc3b5aa765d61d83'), (2, 'iknowwhoiam', 'iknowhoiam@inknow', 'iknow'), (3, 'who', 'who@who', 'who'), (4, 'mohammed', 'mohammed@mohammed', '5f4dcc3b5aa765d61d83'), (5, 'jesus', 'jesus@jesus', '110d46fcd978c24f306c'), (6, 'jesus', '110d46fcd978c24f306cd7fa23464d73', 'nxjnKJ@slajdilkew'), (7, 'jesus', 'prajwal@prajwal', '110d46fcd978c24f306c'); -- -- Indexes for dumped tables -- -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php $con = $mysqli; $con->query("create table users(username varchar(255), email varchar(255), password varchar(255))"); $_REQUEST['username'] = 'foo'; $_REQUEST['email'] = 'bar'; $_REQUEST['password'] = 'baz'; $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); $query = "INSERT into `users` (username, email, password) VALUES ('$username', '$email', '" . md5($password) . "')"; $result = mysqli_query($con, $query); echo json_encode($con->query("select * from users")->fetch_assoc()), "\n"; $username = stripslashes($_REQUEST['username']); // removes backslashes $username = mysqli_real_escape_string($con, $username); $password = stripslashes($_REQUEST['password']); $password = mysqli_real_escape_string($con, $password); // Check user is exist in the database $query = "SELECT * FROM `users` WHERE username='$username' AND password='" . md5($password) . "'"; $result = mysqli_query($con, $query) or die(mysqli_error($con)); $rows = mysqli_num_rows($result); var_dump($rows);

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online