<?php
// Consider query
"SELECT animal FROM bar WHERE name = :thing";
// For SQL server this is same as creating this function in prepare
function preparedQuery($thing) {
// $databaseBar would be stored in the server itself
$databaseBar = [
['animal' => 'Dog', 'name' => 'Matt'],
['animal' => 'Cat', 'name' => 'John'],
];
foreach ($databaseBar as $row) {
if ($row['name'] === $thing) {
return $row['animal'];
}
}
return null;
}
var_dump(preparedQuery('John'));
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
string(3) "Cat"