Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE staff (surname varchar(20), birthday datetime);
INSERT INTO staff (surname, birthday) VALUES ('Piet', '1990-01-01'), ('Jones', '1980-12-12'), ('Johnson', '2005-05-31');
SELECT * FROM staff;
<?php
session_start();
//add some dummy session data for the demo:
$_SESSION = array("loggedin"=> true, "name"=>"Piet", "id_staff"=> 9);
var_dump($_SESSION);
// Run query using mysqli
/*$result = $mysqli->query($query);
$version = $result->fetch_object();
printf('DB version (mysqli): %s ' . PHP_EOL, $version->version);*/
class Core
{
public static $link;
public static function getStaffList(){
if ($_SESSION['name'] =="admin" ) {
$sql = "SELECT * FROM staff";
}
else {
$sql = "SELECT * FROM staff where surname = '".$_SESSION['name']."'";
}
echo "Executing the following SQL:".$sql.PHP_EOL;
$result = Core::$link->query($sql);
if (!$result) {
return 'Error: ' . mysqli_error(Core::$link);
}
$return = array();
while ($myrow = mysqli_fetch_assoc($result)) {
if ($myrow['birthday'] !== '0000-00-00') {
$myrow['birthday'] = date("d.m.Y", strtotime($myrow['birthday']));
} else {
$myrow['birthday'] = '';
}
$return[] = $myrow;
}
return $return;
}
}
//some assignment, to make the demo database work:
Core::$link = $mysqli;
$data = Core::getStaffList();
var_dump($data);