<?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) {