<?php
require 'header.php';
require_once 'Database.php';
//Connect to database
$db = new Database('localhost', 'root', 'test123', 'test');
//$db->insert('students', 'Christy', 'Conner', '*****@*****.**', '07983335555');
// $db->query('SELECT * FROM `students` WHERE id=2');
// $db->query("SELECT * FROM students RIGHT JOIN student_addresses ON students.id = student_addresses.student_id");
// $db->query("SELECT SUM(sales) FROM products GROUP BY category");
$db->query("SELECT SUM(sales) FROM products WHERE category='lounge'");
if ($db->numRows() == 0) {
echo "No data available";
} else {
foreach ($db->rows() as $key => $value) {
foreach ($value as $name => $info) {
echo $name . ": ";
echo $info . "<br/>";
}
}
}
?>
<!-- <section id="students">
<div class="student-form">
<h1>Registration</h1><br/>
<form action="" method="post">
<div class="form-group">
<label>First Name</label>
<input type="text" name="firstname" class="form-control" autocorrect="off" placeholder="First Name">
</div>
{
return {
server: __server__
};
},
xmlhttpRequest: GM_xmlhttpRequest
};</script>';
$ShiftSpace .= "<script type=\"text/javascript\" src=\"{$base_url}bootstrap.js\"></script>\n";
$ShiftSpace .= "<script type=\"text/javascript\" src=\"{$base_url}../client/Pin.js\"></script>\n";
$ShiftSpace .= "<script type=\"text/javascript\" src=\"{$base_url}../client/RangeCoder.js\"></script>\n";
$ShiftSpace .= "<script type=\"text/javascript\" src=\"{$base_url}../client/Element.js\"></script>\n";
$ShiftSpace .= "<script type=\"text/javascript\" src=\"{$base_url}../client/Space.js\"></script>\n";
$ShiftSpace .= "<script type=\"text/javascript\" src=\"{$base_url}../client/Shift.js\"></script>\n";
// Build shift_ids array if it wasn't already parsed from id param
if (!count($shift_ids) && !empty($_GET['all_shifts'])) {
$shifts = $db->rows("\n SELECT url_slug\n FROM shift\n WHERE status = 1\n AND href = '{$shift->href}'\n ");
foreach ($shifts as $n => $ashift) {
foreach ($ashift as $key => $val) {
$shift_ids[] = $val;
}
}
} else {
$shift_ids[] = $id;
}
// for single shifts on the proxy
$cshift;
$spaceName;
$userName;
$shifthref;
// Load each requested shift
foreach ($shift_ids as $an_id) {
