" . parent::current(). "";
}
function beginChildren() {
echo "";
}
function endChildren() {
echo "
" . "\n";
}
}
function query2($q)
{
//echo "Dump table ".$table."
";
echo "";
$connost = "instruct.coe.neu.edu";
$dbname = "3425flavdas";
$dbuser = "3425flavdas";
$dbpass = "B4BehqYU";
$servername = "instruct.coe.neu.edu";
$username = "3425flavdas";
$password = "B4BehqYU";
$dbname = "3425flavdas";
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// $stmt = $conn->prepare("SELECT * FROM ".$table);
// $stmt = $conn->prepare("DESCRIBE ".$table);
$stmt = $conn->prepare($q);
$stmt->execute();
// set the resulting array to associative
$result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
echo $v;
}
$dsn = null;
}
catch(PDOException $e)
{
echo "Error: " . $e->getMessage();
}
$conn = null;
echo "
";
}
function render2($template)
{
$arglist = func_get_args();
include "html/" . $template;
}
include "lib/functions.php";
?>
Education";
query2("SELeCT * FROM EDUCATION");
echo "Doctors
";
query2("SELeCT * FROM DOCTORS");
echo "Doctors / Education
";
query2("SELECT DOCTORS.*,EDUCATION.* FROM DOCTORS,EDUCATION WHERE DOCTORS.DOC_ID=EDUCATION.DOC_ID");
echo "Patients
";
query2("SELECT * FROM PATIENTS");
echo "History
";
query2("SELECT * FROM HISTORY");
echo "Appointments: Doctors x Patients x History
";
query2("SELECT DOCTORS.DOC_LNAME,PATIENTS.PAT_LNAME,HISTORY.* FROM DOCTORS,PATIENTS,HISTORY WHERE DOCTORS.DOC_ID=HISTORY.DOC_ID and HISTORY.HEALTH_RECORD_NUM=PATIENTS.HEALTH_RECORD_NUM");
?>