// PHP code to establish connection
// with the localserver
connect_error) {
die(‘Connect Error (‘ .
$mysqli->connect_errno . ‘) ‘.
$mysqli->connect_error);
}
// SQL query to select data from database
$sql = “SELECT plate.plate_id,
plate.date_of_plate,
plate.status,
experiment_days_detail.due_date,
experiment_days_detail.day,
plate.experiment_days,
plate.experiment_name
FROM tanguayl_zaap_new.plate plate
INNER JOIN
tanguayl_zaap_new.experiment_days_detail experiment_days_detail
ON (plate.plate_id = experiment_days_detail.ed_plate_id)
WHERE (plate.date_of_plate > 20211103)
AND ((plate.status = ‘P’) OR (plate.status = ‘E’))”;
$result = $mysqli->query($sql);
$mysqli->close();
?>
// HTML code to display data in tabular format
ZAAP Evaluation Status
ZAAP Plate Status
| Plate ID |
Date of Plate |
Date to Screen Plate |
Type of Screening (1 or 5day) |
Experiment Name |
fetch_assoc())
{
?>
|
|
|
|
|
