// Initialize cURL session $curl = curl_init(); // Set the API endpoint and parameters $url = 'https://api.example.com/data'; $params = ['param1' => 'value1', 'param2' => 'value2']; $queryString = http_build_query($params); $fullUrl = "$url?$queryString"; // Set the cURL options curl_setopt($curl, CURLOPT_URL, $fullUrl); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); // Execute the cURL request and retrieve the response $response = curl_exec($curl); // Close the cURL session curl_close($curl); // Parse the response data (assuming it's JSON) $data = json_decode($response, true);
// Set database credentials $host = 'localhost'; $dbname = 'my_database'; $username = 'my_username'; $password = 'my_password'; try { // Connect to database using PDO $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password); // Prepare SQL query and execute it $stmt = $pdo->prepare('SELECT * FROM my_table'); $stmt->execute(); // Retrieve the results as an array of associative arrays $data = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { // Handle database connection errors echo "Database error: " . $e->getMessage(); }In this example, we use the PDO library to connect to a MySQL database and retrieve data from a table. We first set the database credentials and use them to create a new PDO object. We then prepare an SQL query, execute it using `$stmt->execute()`, and retrieve the results as an array of associative arrays using `$stmt->fetchAll(PDO::FETCH_ASSOC)`. We also use a `try...catch` block to handle any database connection errors that may occur.