Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
CREATE TABLE user_info(name varchar(64), user_name varchar(64), password varchar(64));

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php $user_name = $_POST["user_name"]; $user_password = $_POST["password"]; $name = $_POST["name"]; //require 'init.php'; $con = &$mysqli; if($con) { $sql = "SELECT * FROM user_info WHERE user_name='$user_name'"; $result = mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { $status = "ok"; $result_code = 0; echo json_encode(array('status'=>$status, 'result_code'=>$result_code)); } else { $sql = "INSERT INTO user_info(name, user_name, password) values('$name', '$user_name', '$password')"; if(mysqli_query($con, $sql)) { $status = "ok"; $result_code = 1; echo json_encode(array('status'=>$status, 'result_code'=>$result_code)); } else { $status = "failed"; echo json_encode(array('status'=>$status), JSON_FORCE_OBJECT); } } } else { $status = "failed"; echo json_encode(array('status'=>$status), JSON_FORCE_OBJECT); } mysqli_close($con);
Copy Clear