prepare('SELECT F1 FROM T1 WHERE F2=?') or die(mysqli_error($con));
// bind input
$stmt->bind_param('s', $f2);
// execute
$stmt->execute() or die(mysqli_error($con));
$rs = $stmt->get_result();
// get first row and field F1
if($row = $rs->fetch_array(MYSQLI_ASSOC)) {
$f1 = $row['F1'];
} else {
die("$f2 not found");
}
// close statement
$stmt->close();
// close connection to server
$con->close();
// return value
return $f1;
}
function t1_get_all() {
// connect to server and select database
$con = get_connection();
// prepare SQL statement
$stmt = $con->prepare('SELECT F1,F2 FROM T1') or die(mysqli_error($con));
// execute
$stmt->execute() or die(mysqli_error($con));
$rs = $stmt->get_result();
// create array to contain rows
$res = array();
// get all rows
while($row = $rs->fetch_array(MYSQLI_ASSOC)) {
$res[] = $row;
}
// close statement
$stmt->close();
// close connection to server
$con->close();
// return array with rows
return $res;
}
function t1_put($f1, $f2) {
// connect to server and select database
$con = get_connection();
// prepare SQL statement
$stmt = $con->prepare('INSERT INTO T1(F1,F2) VALUES(?,?)') or die(mysqli_error($con));
// bind input
$stmt->bind_param('is', $f1, $f2);
// execute
$stmt->execute() or die(mysqli_error($con));
// close statement
$stmt->close();
// close connection to server
$con->close();
}
function t1_remove($f1) {
// connect to server and select database
$con = get_connection();
// prepare SQL statement
$stmt = $con->prepare('DELETE FROM T1 WHERE F1=?') or die(mysqli_error($con));
// bind input
$stmt->bind_param('i', $f1);
// execute
$stmt->execute() or die(mysqli_error($con));
// close statement
$stmt->close();
// close connection to server
$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() {
$f1 = t1_get_one('BB');
echo "$f1
\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();
?>