<?php
    include('connect.php');
if(isset($_REQUEST['social'])){
  $name=$_REQUEST['name'];

  $email=$_REQUEST['email'];
    if($name==''){
    $name=$email;
  }
  $pass='123@egrocery';
  $pass=md5($pass);
  $social=$_POST['social'];
  $query="SELECT * FROM users WHERE email='$email'";
  $res=mysqli_query($con,$query);
  $num=mysqli_num_rows($res);
  if($num>=1){
        $row=mysqli_fetch_array($res);
       
      echo $pass;
         
  }
  else{
  $query="INSERT into users (name,email,password,login_type) Values ('$name','$email','$pass','$social')";
  $res=mysqli_query($con,$query);
  if($res){
      $query="SELECT * FROM users WHERE email='$email'";
  $res=mysqli_query($con,$query);
   $row=mysqli_fetch_array($res);
       // session_start();
    //  $_SESSION['id']=$row['reg_id'];
      echo $pass;
         // header("location:index.php");
  }
}
}





  if(isset($_REQUEST['password'])){

         $email=$_REQUEST['email'];
          $pass=$_REQUEST['password'];
          $pass=$pass; 
 $query= "SELECT * from users where email='$email' and password='$pass'";
 
  $res=mysqli_query($con,$query);
   $row=mysqli_fetch_array($res);

   print_r($row);
     if($res)
  {
    echo $pass;
    echo $msg= "Logged in successfull.";
    echo $row['name'];
            session_start();
     $_SESSION['id']=$row['id'];
       $_SESSION['userid']=$row['id'];
       $_SESSION['name']=$row['name'];
   header("location:index.php");
  }
  else
  {
   echo $msg= "please try again later".mysqli_error($con);
    header("location:index.php");
  }

      
         //header("location:index.php");
  }

?>