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 vote208 views1 answer
Examples of invalid php variables
PHP
0 vote241 views2 answers
Laravel PackageManifest.php: Undefined index: name
PHP Laravel
0 vote239 views1 answer
Carbon previous day
PHP
102 votes266 views6 answers
Php array push
PHP
11 votes202 views6 answers
Redirect route with parameters laravel
PHP
14 votes189 views3 answers
Laravel setup auth
PHP
0 vote206 views1 answer
Password required wp
PHP Wordpress
0 vote231 views3 answers
Symfony project directory
PHP Symfony
0 vote209 views1 answer
Wordpress pass parameters variables arguments to enqueued script
PHP Wordpress
2 votes179 views1 answer
Check image is available on server php
PHP