Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement