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 vote132 views1 answer
Window.location javascript php
PHP
0 vote142 views1 answer
Php shell_exec with root
PHP
0 vote120 views1 answer
Php spreadsheet styles
PHP
1 vote127 views1 answer
Laravel iseed
PHP
4 votes151 views2 answers
Laravel duplicate row
PHP Laravel
0 vote199 views1 answer
Yii2 arraydataprovider
PHP Yii
1 vote136 views1 answer
Get today date magento 2 object manager
PHP
3 votes137 views2 answers
How to add values to an array in laravel
PHP Laravel
0 vote129 views1 answer
Php basename from path
PHP
1 vote142 views1 answer
How to check mobile or desktop in php
PHP