Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE users (
id int,
username varchar(64),
email varchar(64),
password varchar(64),
phone varchar(64)
);
<?php
$_POST = ['username' => 'abc', 'password' => 'qwerty'];
$username = $_POST['username'];
$password = md5($_POST['password']);
$stmt = $pdo->prepare("SELECT id, username, email, phone FROM users WHERE username=? AND password=?");
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute([$username, $password]);
if($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$user = array(
'id'=>$row['id'],
'username'=>$row['username'],
'password'=>$row['password'],
'phone'=>$row['phone']
);
}