<?php
declare(strict_types=1);

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$port = filter_var(getenv('BHYLU_LAB_PORT'), FILTER_VALIDATE_INT, ['options'=>['min_range'=>1024,'max_range'=>65535]]);
if ($port === false) throw new RuntimeException('Set the separate lab port');
$db = new mysqli('127.0.0.1', getenv('BHYLU_LAB_USER'), getenv('BHYLU_LAB_PASSWORD'), 'bhylu_php_lab', $port);
$db->set_charset('utf8mb4');
$db->query('CREATE TEMPORARY TABLE lending_sample (id INT PRIMARY KEY AUTO_INCREMENT, item VARCHAR(60) NOT NULL, quantity INT NOT NULL)');
$db->query("INSERT INTO lending_sample (item,quantity) VALUES ('Spade',2),('Drill',1),('Spade',3)");
$insert = $db->prepare("INSERT INTO lending_sample (item,quantity) VALUES (?,?)");
$item = "Rake"; $quantity = 4;
$insert->bind_param("si",$item,$quantity);
$insert->execute();
echo "New id: ", $db->insert_id, "\n";
echo $insert->affected_rows, " inserted\n";
$insert->close(); $db->close();