Sample Script For Select Statement PHP MYSQL API

<!-- wp:paragraph -->\n<p>Here is a sample script for select statement using bind param for PHP MYSQL API </p>\n<!-- /wp:paragraph -->\n\n<!-- wp:code -->\n<pre class=\"wp-block-code\"><code>&lt;?php\n\n// Enable CORS headers\nheader(\"Access-Control-Allow-Origin: *\");\nheader(\"Access-Control-Allow-Methods: GET, POST\");\nheader(\"Access-Control-Allow-Headers: Content-Type\");\n\n\nrequire_once 'db.php';\n\n// Retrieve the username and password from the POST request\n$username = $_POST&#91;'username'];\n$password = $_POST&#91;'password'];\n\n// Encrypt the password using MD5\n$encryptedPassword = md5($password);\n\n// Query the database to check if credentials match\n$query = \"SELECT * FROM users WHERE user_phone = :username AND user_password = :password AND status = 'Active'\";\n$stmt = $pdo->prepare($query);\n$stmt->bindParam(':username', $username);\n$stmt->bindParam(':password', $encryptedPassword);\n$stmt->execute();\n$user = $stmt->fetch(PDO::FETCH_ASSOC);\n\nif ($user) {\n // Valid credentials\n $response = &#91;\n 'success' => true,\n 'message' => 'Login successful',\n 'user_phone' => $user&#91;'user_phone'],\n 'user_name' => $user&#91;'full_name'],\n 'user_email' => $user&#91;'user_email'],\n 'user_grade' => $user&#91;'user_grade'],\n 'user_school' => $user&#91;'school'],\n 'id' => $user&#91;'id'],\n ];\n} else {\n // Invalid credentials\n $response = &#91;\n 'success' => false,\n 'message' => 'Invalid username or password',\n ];\n}\n\n// Send the response as JSON\nheader('Content-Type: application/json');\necho json_encode($response);</code></pre>\n<!-- /wp:code -->