fork download
copy 
  1. <?php
  2. // ตั้งค่า header สำหรับการทำ CORS
  3. header('Access-Control-Allow-Origin: *');
  4. header('Content-Type: application/json; charset=utf-8');
  5.  
  6. // เช็คว่า extension mysqli ถูกโหลดและใช้งานอย่างถูกต้องหรือไม่
  7. if (!function_exists('mysqli_connect')) {
  8.     echo json_encode(array('status' => 'error', 'message' => 'The mysqli extension is not loaded.'));
  9.     exit;
  10. }
  11.  
  12. // เชื่อมต่อฐานข้อมูล
  13. $database_hostname = 'localhost';
  14. $database_username = 'team';
  15. $database_password = 'Te@m1234!';
  16. $database_databasename = 'management';
  17.  
  18. $connect_management = new mysqli($database_hostname, $database_username, $database_password, $database_databasename);
  19. date_default_timezone_set('Asia/Bangkok');
  20.  
  21. // ตรวจสอบว่ามีการส่งคำขอแบบ POST มาหรือไม่
  22. if ($_SERVER['REQUEST_METHOD'] == 'POST') {
  23.     // ตรวจสอบว่ามีการอัปโหลดรูปภาพหรือไม่
  24.     if (isset($_FILES['picture']) && $_FILES['picture']['error'] == 0) {
  25.         $picture_name = $_FILES['picture']['name'];
  26.         $picture_tmp_name = $_FILES['picture']['tmp_name'];
  27.         $picture_destination = 'uploads/' . $picture_name;
  28.  
  29.         // ตรวจสอบประเภทของไฟล์ภาพ
  30.         $allowed_types = ['image/jpeg', 'image/png', 'image/jpg'];
  31.         if (in_array($_FILES['picture']['type'], $allowed_types)) {
  32.             // ย้ายไฟล์ภาพไปยังโฟลเดอร์ที่ต้องการ
  33.             if (move_uploaded_file($picture_tmp_name, $picture_destination)) {
  34.                 // อ่านค่า trip_id จากข้อมูลที่ส่งมา
  35.                 $trip_id = isset($_POST['trip_id']) ? $_POST['trip_id'] : null;
  36.  
  37.                 if ($trip_id) {
  38.                     // อัปเดตสถานะทริปใหม่
  39.                     $sql_update_trip_status = "UPDATE ms_trip SET status_trip = status_trip + 1 WHERE id = ?";
  40.                     $stmt_update_trip_status = $connect_management->prepare($sql_update_trip_status);
  41.                     $stmt_update_trip_status->bind_param("i", $trip_id);
  42.                     if ($stmt_update_trip_status->execute()) {
  43.                         echo json_encode(array('status' => 'success', 'message' => 'Trip status updated successfully.'));
  44.                     } else {
  45.                         echo json_encode(array('status' => 'error', 'message' => 'Failed to update trip status.'));
  46.                     }
  47.                 } else {
  48.                     echo json_encode(array('status' => 'error', 'message' => 'Trip ID is missing.'));
  49.                 }
  50.             } else {
  51.                 echo json_encode(array('status' => 'error', 'message' => 'Error uploading picture.'));
  52.             }
  53.         } else {
  54.             echo json_encode(array('status' => 'error', 'message' => 'Invalid file type. Only JPEG, JPG, and PNG files are allowed.'));
  55.         }
  56.     } else {
  57.         echo json_encode(array('status' => 'error', 'message' => 'No picture uploaded.'));
  58.     }
  59. } else {
  60.     echo json_encode(array('status' => 'error', 'message' => 'Invalid request method.'));
  61. }
  62. ?>
  63. <?php
  64.  
  65. // your code goes here
Success #stdin #stdout 0.02s 25936KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
{"status":"error","message":"The mysqli extension is not loaded."}
https://ideone.com/YwZejj
language:
PHP (php 7.3.5)
created:
13 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!