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

3 votes156 views1 answer
Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add index `users_userable_type_userable_id_index`(`userable_type`, `userable_id`)
PHP
46 votes168 views6 answers
Php for
PHP
0 vote196 views1 answer
Extensions for laravel command ubuntu 20.04
PHP Laravel
83 votes160 views3 answers
Str_includes php
PHP
0 vote159 views1 answer
How to loop with while in php for array associative
PHP
1 vote224 views1 answer
Laravel artisan progress bar
PHP Laravel
0 vote160 views1 answer
Php iterate through a loop
PHP
0 vote186 views1 answer
Yajra laravel datatables rawcolumn
PHP Laravel
6 votes163 views5 answers
Create date from string php
PHP
0 vote167 views1 answer
Php array splice insert array in array
PHP