<?php
$host = 'localhost';
    $dbname = 'test';
    $username = 'root';
    $password = '';

    try
    {
        $conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
       /* echo "Connected to $dbname at $host successfully.<br/>"; */
    }
    catch (PDOException $e)
    {
        echo "<h3>Error:</h3>". $e->getMessage();
    }


$customer_id=addslashes($_GET['customer_id']);

$t=time();
$d=date("Y-m-d",$t);


$sql= "INSERT INTO `test`.`orders` (`customer_id`, `date`) VALUES ('$customer_id', '$d');";

$result =$conn->query($sql);
$lastid = $conn->lastInsertId();

if($result==1)
{

    $query = "select * from `orders` where customer_id='$customer_id'";
    $result = $conn->query($query);
    $dbvalue = $result->fetch(PDO::FETCH_OBJ);
    $customer_id=$dbvalue->customer_id;
    $date=$dbvalue->date;


    $details = array(
    'status'=>'sucess',
    'message'=>'customer added sucessfully',
    'id' => $lastid,
    'customer_id' => $customer_id,
    'date' => $date,
    );

    echo  json_encode($details);
}
else
{
    $detail = array(
    'status'=>'unsucess',
    'message'=>'cannot add customer',

    );

    echo  json_encode($detail);
}
?>