prepare('SELECT F1 FROM T1 WHERE F2=?') or die(mysqli_error($con));
$stmt->bind_param('s', $f2);
$stmt->execute() or die(mysqli_error($con));
$rs = $stmt->get_result();
if($row = $rs->fetch_array(MYSQLI_ASSOC)) {
$f1 = $row['F1'];
} else {
die("$f2 not found");
}
$stmt->close();
$con->close();
return $f1;
}
function t1_get_all() {
$con = get_connection();
$stmt = $con->prepare('SELECT F1,F2 FROM T1') or die(mysqli_error($con));
$stmt->execute() or die(mysqli_error($con));
$rs = $stmt->get_result();
$res = array();
while($row = $rs->fetch_array(MYSQLI_ASSOC)) {
$res[] = $row;
}
$stmt->close();
$con->close();
return $res;
}
function t1_put($f1, $f2) {
$con = get_connection();
$stmt = $con->prepare('INSERT INTO T1(F1,F2) VALUES(?,?)') or die(mysqli_error($con));
$stmt->bind_param('is', $f1, $f2);
$stmt->execute() or die(mysqli_error($con));
$stmt->close();
$con->close();
}
function t1_remove($f1) {
$con = get_connection();
$stmt = $con->prepare('DELETE FROM T1 WHERE F1=?') or die(mysqli_error($con));
$stmt->bind_param('i', $f1);
$stmt->execute() or die(mysqli_error($con));
$stmt->close();
$con->close();
}
function t1_display($data) {
$rows = "";
foreach($data as $row) {
$f1 = $row['F1'];
$f2 = $row['F2'];
$rows .= sprintf("\r\n| $f1 | \r\n$f2 | \r\n
\r\n");
}
return "\r\n\r\n| F1 | \r\nF2 | \r\n
\r\n$rows
\r\n";
}
function test() {
$f2 = t1_get_one('BB');
echo "$f2
\r\n";
$data = t1_get_all();
echo t1_display($data);
t1_put(999, 'XXX');
$data = t1_get_all();
echo t1_display($data);
t1_remove(999);
$data = t1_get_all();
echo t1_display($data);
}
test();
?>