How to fetch data using pdo in php

Php pdo fetch from db

$pdo = new PDO('mysql:host=$host; dbname=$database;', $user, $pass);
$stmt = $pdo->prepare('SELECT * FROM auction WHERE name = :name');
$stmt->bindParam(':name', $_GET['searchdivebay']);
$stmt->execute(array(':name' => $name);

-1

Source: stackoverflow.com

How to fetch data using pdo in php

$stmt = $pdo->prepare("SELECT * FROM users LIMIT :limit, :offset");$stmt->execute(['limit' => $limit, 'offset' => $offset]); $data = $stmt->fetchAll();// and somewhere later:foreach ($data as $row) {    echo $row['name']."<br />\n";}

-1

Source: phpdelusions.net

Similar codes

0 vote134 views1 answer
Asas
PHP
1 vote141 views5 answers
Variables in php
PHP
3 votes163 views2 answers
Laravel required if it meet some value from another field
PHP
0 vote178 views1 answer
Php PDO howto columns from table
PHP
0 vote167 views1 answer
Using a variable outside of the while loop (scope)
PHP
0 vote158 views1 answer
Import separate graphql file laravel
PHP Laravel
0 vote136 views1 answer
Php mail in localhost wamp
PHP
66 votes137 views6 answers
Php date
PHP
11 votes170 views4 answers
Session variable in laravel
PHP Laravel
39 votes129 views4 answers
Php artisan make:controller --resource command
PHP