Fetch Data From Database With PDO

$host = 'localhost'; // URL to the server
$username = 'root'; // Username (xampp = root)
$password = ''; // Password (xampp = )
$dbname = 'apifile';
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$sql = "SELECT * FROM `prop` WHERE propkey='localhost_100100'";

$q = $pdo->query($sql);

$q->setFetchMode(PDO::FETCH_ASSOC);
$r = $q->fetch();
var_dump($r['propvalue']);

Similar codes

0 vote102 views1 answer
Turnery expression php
PHP
12 votes109 views3 answers
Get featured image url
PHP
1 vote107 views2 answers
Scheduling in laravel in custom cron
PHP
0 vote102 views1 answer
How to use custome functions in laravel
PHP
0 vote133 views1 answer
Delete image s3 laravel
PHP Laravel
0 vote111 views1 answer
Install sass laravel
PHP
1 vote73 views1 answer
Symfony migration
PHP
0 vote108 views1 answer
How to remove text tab in wordpress editor
PHP
37 votes127 views3 answers
Php unset array element
PHP
12 votes100 views6 answers
Php array push key value
PHP