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 vote296 views4 answers
There is no extension able to load the configuration for "_translation_webui"
PHP
9 votes311 views5 answers
Laravel exist
PHP Laravel
1 vote301 views3 answers
Php convert special characters to normal
PHP
28 votes330 views12 answers
Laravel middleware
PHP Laravel
3 votes310 views1 answer
Php grab year from date
PHP
1 vote333 views4 answers
Laravel get route path uri
PHP Laravel
0 vote328 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP
2 votes320 views4 answers
Enable / Disable modules in PHP
PHP
35 votes330 views6 answers
Php get current date and time
PHP
0 vote310 views1 answer
Override the route parameter names
PHP