Breaking News: Grepper is joining You.com. Read the official announcement!

PHP MySQL PDO Select Through rows with DB Connection

Sensei answered on July 19, 2024 Popularity 1/10 Helpfulness 1/10

answer PHP MySQL PDO Select Through rows with DB Connection

related PHP MySQL PDO Select Method with DB Connection

PHP MySQL PDO Select Through rows with DB Connection

Comment

// connect to PDO
    $pdo = new PDO("mysql:host=localhost;dbname=myDatabase", $username, $password);

    // throw Exceptions for every error.   
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // prepare the statement. the placeholders allow PDO to handle substituting
    // Security -> prevents SQL injection
    $stmt = $pdo->prepare("SELECT order_numbers FROM myTable WHERE customer_id =:cId");

    // bind the parameters
    $stmt->bindValue(":order_numbers", $orderNumger);
   

    // initialise an array for the results
    $products = array();
    $stmt->execute();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $orders[] = $row;
    }

 
print_r($orders);

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: connection mysql pdo php rows select

Link to this answer
Share Copy Link

Contributed on Jul 19 2024

Sensei

0 Answers Avg Quality 2/10

Closely Related Answers

PHP MySQL PDO Select Method with DB Connection

Comment

$servername = "localhost";  $username = "root"; $password = "";  $dbname = "myDatabase"; 
try {
  $pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  // set the PDO error mode to exception
  $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  echo "Connected successfully";
}
catch(PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}

$id='1';

$stmt = $pdo->prepare("SELECT * FROM myTable WHERE id =?");
$stmt->execute([$id]); 
$results = $stmt->fetch();

//Close DB connection
$pdo = null;
//return results in an array 
print_r($results);

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: pdo php connection select mysql sql

Link to this answer
Share Copy Link

Contributed on Jul 19 2024

Sensei

0 Answers Avg Quality 2/10

PHP MySQL PDO Select Through rows with DB Connection

Contents

More Related Answers

PHP MySQL PDO Select Through rows with DB Connection

Closely Related Answers

PHP MySQL PDO Select Method with DB Connection

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.