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

2 votes90 views2 answers
Php unique string
PHP
0 vote100 views1 answer
Do_shortcode not working
PHP
2 votes103 views2 answers
Php mysql update all rows in table new values
PHP
0 vote109 views1 answer
Display picture in pdf generated with laravel
PHP
0 vote101 views1 answer
Hash not found laravel
PHP
1 vote127 views1 answer
Laravel failed jobs retry
PHP
0 vote94 views2 answers
How to add files in child theme in theme editor
PHP
0 vote103 views1 answer
Symfony change php version
PHP
1 vote100 views3 answers
Download file php
PHP
1 vote106 views1 answer
Is php the fucking worst
PHP