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 user_info(name varchar(64), user_name varchar(64), password varchar(64));
<?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);