अध्याय 17: उन्नत MySQLi फीचर्स (Advanced MySQLi Features)

<?php
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
    echo "Name: " . $row['name'] . " - Email: " . $row['email'] . "<br>";
}
?>

<?php
$result = $stmt->get_result();
while ($row = $result->fetch_row()) {
    echo "Name: " . $row[0] . " - Email: " . $row[1] . "<br>";
}
?>

<?php
$result = $stmt->get_result();
while ($row = $result->fetch_object()) {
    echo "Name: " . $row->name . " - Email: " . $row->email . "<br>";
}
?>

DELIMITER //
CREATE PROCEDURE GetUserDetails(IN userId INT)
BEGIN
    SELECT name, email FROM users WHERE id = userId;
END //
DELIMITER ;

स्टोरड प्रोसिड्यर कॉल करना (Calling a Stored Procedure)

<?php
$stmt = $conn->prepare("CALL GetUserDetails(?)");
$stmt->bind_param("i", $userId);
$userId = 1;
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
    echo "Name: " . $row['name'] . " - Email: " . $row['email'] . "<br>";
}
?>

<?php
$sql = "SELECT name FROM users WHERE id = 1;";
$sql .= "SELECT email FROM users WHERE id = 2;";
if ($conn->multi_query($sql)) {
    do {
        if ($result = $conn->store_result()) {
            while ($row = $result->fetch_row()) {
                echo $row[0] . "<br>";
            }
            $result->free();
        }
    } while ($conn->next_result());
}
?>

<?php
$sql = "INSERT INTO users (name, email) VALUES ('User1', 'user1@example.com');";
$sql .= "INSERT INTO users (name, email) VALUES ('User2', 'user2@example.com');";
if ($conn->multi_query($sql)) {
    echo "बैच प्रोसेसिंग सफलतापूर्वक पूरी हो गई।";
} else {
    echo "त्रुटि: " . $conn->error;
}
?>

<?php
function customErrorHandler($errno, $errstr, $errfile, $errline) {
    echo "त्रुटि: [$errno] $errstr - $errfile:$errline";
    error_log("त्रुटि: [$errno] $errstr - $errfile:$errline", 3, "/var/log/php_errors.log");
}

set_error_handler("customErrorHandler");

// एक एरर उत्पन्न करना
echo $undefinedVariable;
?>

<?php
$conn->query("SELECT SLEEP(5)", MYSQLI_ASYNC);
$links = $errors = $reject = array();
$links[] = $conn;
mysqli_poll($links, $errors, $reject, 1);
foreach ($links as $link) {
    if ($result = $link->reap_async_query()) {
        echo "क्वेरी पूरी हो गई।";
    }
}
?>