<?php

echo '<pre>';

/*
Have a table like

DROP TABLE `users`;
CREATE TABLE `users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `l` mediumint(8) unsigned DEFAULT NULL,
  `r` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
);

insert into `users` VALUES (1, "Joe", 1, 2),(2, "Jane", 3, 4);

 */

// fill in as needed
$host = 'xxx.xxx.xxx.xxx';
$user = 'cooldude';
$pass = 'awesomepasswordman';
$db   = 'yourdatabase';

////////////////////////////////////////////

echo "Unprepared queries\n";

$m = new mysqli($host, $user, $pass, $db);
print_r(
	$v = $m->query('SELECT `name`, `id`, `l`, `r` FROM users WHERE id = 1')->fetch_assoc()
);

$pdo = new PDO("mysql:dbname=$db;host=$host;port=3306", $user, $pass);
print_r(
	$pdo->query('SELECT `name`, `id`, `l`, `r` FROM users WHERE id = 1')->fetchAll(PDO::FETCH_ASSOC)
);

////////////////////////////////////////////

echo "Prepared queries\n";

$m = new mysqli($host, $user, $pass, $db);
$stmt = $m->prepare('SELECT `name`, `id`, `l`, `r` FROM users WHERE id = ?');
$id = 1;
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result()->fetch_assoc();
print_r(
	$result
);

$pdo = new PDO("mysql:dbname=$db;host=$host;port=3306", $user, $pass, [
	PDO::ATTR_EMULATE_PREPARES => false,
]);
$stmt = $pdo->prepare('SELECT `name`, `id`, `l`, `r` FROM users WHERE id = ?');
$stmt->execute([1]);
print_r(
	 $stmt->fetchAll(PDO::FETCH_ASSOC)
);