How to Loop Through a MySQL Query with PDO in PHP?

Looping Through a MySQL Query with PDO in PHP

Looping through a MySQL query using PDO in PHP allows for efficient and secure data retrieval. To achieve this, follow these steps:

1. Establish a PDO Connection:
   Instantiate a PDO object with proper credentials and database configuration settings, ensuring that error handling is enabled.
2. Prepare a Parameterized Statement:
   Prepare a SQL statement with placeholders (? or named placeholders like :parameter) to represent dynamic values. This prevents SQL injection vulnerabilities.
3. Bind Parameter Values:
   Bind the dynamic values to the placeholders using bindValue() or bindParam(). Specify the placeholder name or number and the corresponding value.
4. Execute the Query:
   Execute the prepared statement to retrieve the results.
5. Loop Through the Results:
   Use a while loop to fetch each row from the result set as an associative array using fetch(PDO::FETCH_ASSOC). This array contains the column values of the current row.

Example Code:

The following code example demonstrates the steps outlined above:

<code class="php">// Establish PDO Connection
$pdo = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// Prepare Parameterized Statement
$stmt = $pdo->prepare('SELECT * FROM products WHERE product_type_id = ? AND brand = ?');

// Bind Parameter Values
$stmt->bindValue(1, 6);
$stmt->bindValue(2, 'Slurm');

// Execute Query
$stmt->execute();

// Loop Through Results
$products = [];
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $products[] = $row;
}</code>

By following these steps, you can effectively loop through a MySQL query using PDO, ensuring data security and efficient code execution.

The above is the detailed content of How to Loop Through a MySQL Query with PDO in PHP?. For more information, please follow other related articles on the PHP Chinese website!