How can the client-server model be effectively utilized in PHP to handle requests and responses for database operations?

To effectively utilize the client-server model in PHP for handling requests and responses for database operations, you can create a PHP script on the server-side that connects to the database, processes the requests from the client, and sends back the responses. The client can then send HTTP requests to this PHP script to interact with the database. 

<?php

// Server-side PHP script to handle database operations

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Process client requests
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Handle POST requests
    // Example: Insert data into the database
    $data = json_decode(file_get_contents('php://input'), true);
    
    $sql = "INSERT INTO table_name (column1, column2) VALUES ('".$data['value1']."', '".$data['value2']."')";
    
    if ($conn->query($sql) === TRUE) {
        echo "Record inserted successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

// Close database connection
$conn->close();

?>

Keywords

client-server model PHP database operations requests responses

Related Questions