<?php 
	$con=mysqli_connect("localhost","thedotst_thedots","o?rjYMD?ByEV","thedotst_db_online");
	//$_POST["email"]="ram@gmail.com";
	//$_POST["password"]="123";
	if($_POST["status"]=="login"){
		$email=mysqli_real_escape_string($con,$_POST["email"]);
		$password=mysqli_real_escape_string($con,$_POST["password"]);
		$sql="select * from user where email='{$email}' and password='{$password}'";
		$res=$con->query($sql);
		$row=[];
		if($res->num_rows>0){
			$row=$res->fetch_assoc();
			
		}
		echo json_encode($row);
	}
	
	if($_POST["status"]=="register"){
		$user=mysqli_real_escape_string($con,$_POST["user"]);
		$email=mysqli_real_escape_string($con,$_POST["email"]);
		$password=mysqli_real_escape_string($con,$_POST["password"]);
		$row=[
			'status'=>'failed',
		];
		$sql="insert into user(name,email,password) values ('{$user}','{$email}','{$password}')";
		if($con->query($sql)){
			$row["status"]='success';
		}
		echo json_encode($row);
	}
	
	if($_POST["status"]=="getPost"){
		$sql="SELECT * FROM posts p inner join user u on p.id=u.id order by pid desc";
		$res=$con->query($sql);
		$rows=[];
		if($res->num_rows>0){
			while($row=$res->fetch_assoc()){
				$rows[]=$row;
			}
		}
		echo json_encode($rows);
	}
	
	
	if($_POST["status"]=="add_post"){
		$title=mysqli_real_escape_string($con,$_POST["title"]);
		$body=mysqli_real_escape_string($con,$_POST["body"]);
		$id=mysqli_real_escape_string($con,$_POST["id"]);
		$row=[
			'status'=>'failed',
		];
		$sql="insert into posts(title,body,id,create_at) values ('{$title}','{$body}','{$id}',NOW())";
		if($con->query($sql)){
			$row["status"]='success';
		}
		echo json_encode($row);
	}
?>