function search($objDb, $sKeywords)
{
$aRes = $objDb->Search($sKeywords);
display_results($aRes, $objDb);
if (!empty($aRes)) {
printf('<div class="tally">Found %d documents.</div>', count($aRes));
}
}
$_POST['Fill'] = 'true';
} else {
//Show the record that's about to be deleted.
echo "Records deleted:<br />";
echo "Event information:<br />";
display_results(my_trusted_mysql_query("SELECT * FROM EVENT WHERE Event_ID = {$Event_ID_num}"));
display_results(my_trusted_mysql_query("SELECT * FROM LOCATION WHERE Event_ID = {$Event_ID_num}"));
display_results(my_trusted_mysql_query("SELECT * FROM CLASS_DATES WHERE Event_ID = {$Event_ID_num}"));
echo "<br />Company's association by hosting this event:<br />";
display_results(my_trusted_mysql_query("SELECT * FROM COMPANY WHERE Email IN (SELECT Email FROM HOSTS WHERE Event_ID={$Event_ID_num})"));
//display_results(my_trusted_mysql_query( "SELECT Event_ID, Email FROM HOSTS WHERE Event_ID = $Event_ID_num" ));
//display_results(my_trusted_mysql_query( "SELECT Event_ID, Email FROM S_ATTEND WHERE Event_ID = $Event_ID_num" ));
//display_results(my_trusted_mysql_query( "SELECT Event_ID, Email FROM C_ATTEND WHERE Event_ID = $Event_ID_num" ));
echo "<br />People attending this event:<br />";
display_results(my_trusted_mysql_query("SELECT * FROM SCREEN_PARTICIPANT WHERE Email IN (SELECT Email FROM S_ATTEND WHERE Event_ID={$Event_ID_num})"));
display_results(my_trusted_mysql_query("SELECT * FROM CLASS_PARTICIPANT WHERE Email IN (SELECT Email FROM C_ATTEND WHERE Event_ID={$Event_ID_num})"));
my_trusted_mysql_query("DELETE FROM EVENT WHERE Event_ID={$Event_ID_num}");
my_trusted_mysql_query("DELETE FROM LOCATION WHERE Event_ID={$Event_ID_num}");
my_trusted_mysql_query("DELETE FROM CLASS_DATES WHERE Event_ID={$Event_ID_num}");
my_trusted_mysql_query("DELETE FROM HOSTS WHERE Event_ID={$Event_ID_num}");
my_trusted_mysql_query("DELETE FROM CLASS_PARTICIPANT WHERE Email IN (SELECT Email FROM C_ATTEND WHERE Event_ID={$Event_ID_num})");
my_trusted_mysql_query("DELETE FROM SCREEN_PARTICIPANT WHERE Email IN (SELECT Email FROM S_ATTEND WHERE Event_ID={$Event_ID_num})");
my_trusted_mysql_query("DELETE FROM C_ATTEND WHERE Event_ID = {$Event_ID_num}");
my_trusted_mysql_query("DELETE FROM S_ATTEND WHERE Event_ID = {$Event_ID_num}");
my_mysql_close();
$_POST['Fill'] = 'false';
}
}
} else {
echo "An unexpected selection has been made. <br />";
my_mysql_close();
header('Content-Length: ' . filesize($script));
header('ETag: "' . filemtime($script) . '"');
readfile($script);
} else {
header("HTTP/1.1 404 Not Found");
}
} elseif (!empty($_REQUEST['result'])) {
display_result_details(!empty($_REQUEST['branch']) ? $_REQUEST['branch'] : $branch, $_REQUEST['result'], true);
} elseif (!empty($_REQUEST['run'])) {
$output = array();
exec($cmd = 'php ./caldavtests.php ' . (!empty($_REQUEST['branch']) ? escapeshellarg('--branch=' . $_REQUEST['branch']) . ' ' : '') . escapeshellarg('--run=' . $_REQUEST['run']), $output, $ret);
error_log($cmd . ' returned ' . $ret);
// return results
display_result_details(!empty($_REQUEST['branch']) ? $_REQUEST['branch'] : $branch, $_REQUEST['run'], true);
} else {
display_results($branch, true);
// true = return html
}
exit;
/**
* from here on only functions called from above controlers for cli or webserver
*/
/**
* Guess config from git clone
*
* @param string $git_sources
*/
function config_from_git($git_sources)
{
global $branch, $revision, $commit_url;
// only run git stuff, if sources exist, are git and git cli is available
</tr>
</table></td>
<td align="left" width="100%" style="background-color: #FFFFFF" class="style26">
<center>Current classes in the database:<br /><br /></center>
<?php
include "includes/functions.php";
//Connect to the database
my_mysql_connect();
display_results(my_trusted_mysql_query("SELECT Event_ID, Event_Name, Start_Date, End_Date, Start_Time, End_Time, Comments FROM EVENT WHERE E_Type = 'c'"));
$total_class = count(my_trusted_mysql_query("SELECT * FROM EVENT WHERE E_Type = 'c'"));
echo "<br />Total classes: ";
echo "{$total_class}";
echo "<br />Average number of people per class: ";
//Displays the avrage number of people attending all classes
display_results(my_trusted_mysql_query("SELECT AVG(Class_Attendees) FROM ( SELECT Event_ID, count(Email) Class_Attendees FROM C_ATTEND GROUP BY Event_ID) AS cnt_table"));
my_mysql_close();
?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2"><table align="left" border="1" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td height="38" background="/images/index_r17_c9.jpg" class="style21">
<div align="center">Patents and Copyrights owned by Maelstrom, Not for use by others</span><strong>.</strong><br>
</div></td>
</tr>
</table>
</td>
<html>
<title>
Company Test
</title>
<body>
<!-- The php script for generating the table and handling database queries -->
<?php
include "includes/functions.php";
my_mysql_connect();
echo "<h1><CENTER>Class</CENTER></h1>";
//Displays the total people at each class
display_results(my_trusted_mysql_query("SELECT Event_ID, count(Email) FROM C_ATTEND GROUP BY Event_ID"));
echo "<h1><CENTER>Session</CENTER></h1>";
//Displays the total people at each Session
display_results(my_trusted_mysql_query("SELECT Event_ID, count(Email) FROM S_ATTEND GROUP BY Event_ID"));
my_mysql_close();
?>
</body>
</html>
display_results(my_trusted_mysql_query("SELECT * FROM COMPANY WHERE Email = '{$q['Email']}'"));
//display_results( my_trusted_mysql_query( "SELECT Email, Number FROM COMPANY_PHONE WHERE Email = '$q[Email]'" ));
my_mysql_close();
$_POST['Fill'] = 'false';
}
} else {
if ($_POST['query_type'] == 'delete') {
//Company is not in the database.
if (count(my_trusted_mysql_query("SELECT Email FROM COMPANY WHERE Email = '{$q['Email']}'")) == 0) {
echo "The company with the e-mail " . $q['Email'] . " does not exist in the database. " . "To add this company's information, please select insert.<br /><br />";
$_POST['Fill'] = 'true';
} else {
//Show the record that's about to be deleted.
echo "Record deleted:";
display_results(my_trusted_mysql_query("SELECT * FROM COMPANY WHERE Email = '{$q['Email']}'"));
display_results(my_trusted_mysql_query("SELECT Email, Number FROM COMPANY_PHONE WHERE Email = '{$q['Email']}'"));
$company_query = "DELETE FROM COMPANY WHERE Email='{$q['Email']}'";
my_trusted_mysql_query($company_query);
$company_phone_query = "DELETE FROM COMPANY_PHONE WHERE Email='{$q['Email']}'";
my_trusted_mysql_query($company_phone_query);
my_mysql_close();
$_POST['Fill'] = 'false';
}
} else {
echo "An unexpected selection has been made. <br />";
my_mysql_close();
die;
}
}
}
}
} else {
echo "<p>\$mysqli is NOT instance of mysqli</p>";
}
if (isset($mysqli)) {
echo "<p>\$mysqli is set</p>";
} else {
echo "<p>\$mysqli is NOT set</p>";
}
// Verify connection
if ($mysqli->connect_errno) {
echo "<p class='status-error'>Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error . "</p>";
unset($mysqli);
// No really necessary
exit;
} else {
echo "<p class='status-success'>Connected ok!</p>";
}
// Establish character encoding
$mysqli->set_charset('utf-8');
// Make query
$query = "select host,user from user";
if ($res = $mysqli->query($query, MYSQLI_STORE_RESULT)) {
display_results($res);
$res->free();
} else {
// If no records were returned.
echo "<p class='status-error'>Query failed: (" . $mysqli->errno . ") " . $mysqli->error;
}
$mysqli->close();
unset($mysqli);
// Not really necessary
echo "<br />New updated record:";
display_results(my_trusted_mysql_query("SELECT * FROM SCREEN_PARTICIPANT WHERE Email = '{$q['Email']}'"));
my_mysql_close();
$_POST['Fill'] = 'false';
}
} else {
if ($_POST['query_type'] == 'delete') {
//Person is not in the database.
if (count(my_trusted_mysql_query("SELECT Email FROM SCREEN_PARTICIPANT WHERE Email = '{$q['Email']}'")) == 0) {
echo "The person with the e-mail " . $q['Email'] . " is not currently in the database as a screening participant. " . "To add this person's information, please select insert.<br /><br />";
$_POST['Fill'] = 'true';
} else {
//Show the record that's about to be deleted.
echo "Records deleted:";
display_results(my_trusted_mysql_query("SELECT * FROM SCREEN_PARTICIPANT WHERE Email = '{$q['Email']}'"));
display_results(my_trusted_mysql_query("SELECT * FROM S_ATTEND WHERE Email = '{$q['Email']}'"));
$query = "DELETE FROM SCREEN_PARTICIPANT WHERE Email='{$q['Email']}'";
my_trusted_mysql_query($query);
my_mysql_close();
$_POST['Fill'] = 'false';
}
} else {
echo "An unexpected selection has been made. <br />";
my_mysql_close();
die;
}
}
}
}
}
}
<?php
include "includes/functions.php";
my_mysql_connect();
echo "<br />Staff list: ";
$results_staff = my_trusted_mysql_query("SELECT * FROM STAFF");
display_results($results_staff);
echo "<br />Number of Staff: ";
$total_staff = count(my_trusted_mysql_query("SELECT * FROM STAFF"));
echo "{$total_staff}<br />";
echo "<br />Screening participant list: ";
display_results(my_trusted_mysql_query("SELECT * FROM SCREEN_PARTICIPANT"));
echo "<br />Number of screening participants: ";
$total_screening = count(my_trusted_mysql_query("SELECT * FROM SCREEN_PARTICIPANT"));
echo "{$total_screening}<br />";
echo "<br />Class participant list: ";
display_results(my_trusted_mysql_query("SELECT * FROM CLASS_PARTICIPANT"));
echo "<br />Number of class participants: ";
$total_class = count(my_trusted_mysql_query("SELECT * FROM CLASS_PARTICIPANT"));
echo "{$total_class}";
my_mysql_close();
?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2"><table align="left" border="1" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td height="38" background="/images/index_r17_c9.jpg" class="style21">
<div align="center">Patents and Copyrights owned by Maelstrom, Not for use by others</span><strong>.</strong><br>
</div></td>
//Connect to the database
my_mysql_connect();
//Delete all previous records in company table.
my_trusted_mysql_query("DELETE FROM COMPANY");
my_trusted_mysql_query("DELETE FROM EVENT");
my_trusted_mysql_query("DELETE FROM CLASS_PARTICIPANT");
my_trusted_mysql_query("DELETE FROM SCREEN_PARTICIPANT");
my_trusted_mysql_query("DELETE FROM STAFF");
my_trusted_mysql_query("DELETE FROM C_ATTEND");
my_trusted_mysql_query("DELETE FROM S_ATTEND");
//The array that stores each INSERT query as an element.
//Can run through them in a loop later, easy-peasy
$population = array("INSERT INTO COMPANY (Email, Name, Address, City, State, Zip)\r\nVALUES ('*****@*****.**', 'Maelstrom', '321 Money Ln', 'Rolla', 'MO', 64014)", "INSERT INTO COMPANY (Email, Name, Address, City, State, Zip)\r\nVALUES ('*****@*****.**', 'Mage_Killer', '456 Rock Face Rd', 'Middle-earth', 'TX', 22215)", "INSERT INTO COMPANY (Email, Name, Address, City, State, Zip)\r\nVALUES ('*****@*****.**', 'br?', 'Dirt Road', 'Brazil', 'BR', 11111)", "INSERT INTO COMPANY (Email, Name, Address, City, State, Zip)\r\nVALUES ('*****@*****.**', 'Efsie', 'Rich Pl', 'Gojira', 'JP', 01235)", "INSERT INTO STAFF (Fname, Lname, Email, Address, City, State, Zip, Comments, Password)\r\nVALUES ( 'James', 'Bond', '*****@*****.**', '1803 awesome Rd', 'Rolla', 'MO', 65401, NULL, 12345)", "INSERT INTO STAFF (Fname, Lname, Email, Address, City, State, Zip, Comments, Password)\r\nVALUES ( 'Frank', 'Sims', '*****@*****.**', 'Ice cap', 'North Pole', 'NP', 71374, NULL, 123123)", "INSERT INTO SCREEN_PARTICIPANT (Email, Fname, Lname, Address, City, State, Zip, Comments, Time)\r\nVALUES ('*****@*****.**', 'Pope', 'Joe', '123 Holy Rd', 'Vatican', 'Vatican', 77777, NULL, 7 )", "INSERT INTO CLASS_PARTICIPANT (Email, Fname, Lname, Address, City, State, Zip, Comments, BCBSNum, BCBSSuffix, Birth_Date)\r\nVALUES ('*****@*****.**', 'Peter', 'Parker', '20 Ingram Street', 'Queens', 'NY', 11428, 'AKA spiderman', 7, 8, '4/3/1962' )", "INSERT INTO EVENT (EVENT_ID, Event_Name, Start_Date, End_Date, Start_Time, End_Time, Comments, E_Type, S_Type, Session_Length)\r\nVALUES (101,'Health Fair', 6, 9, 7, 8, NULL, 's', 'Fair', 15 )", "INSERT INTO EVENT (EVENT_ID, Event_Name, Start_Date, End_Date, Start_Time, End_Time, Comments, E_Type, S_Type, Session_Length)\r\nVALUES (102,'Quit Smoking', 6, 9, 7, 8, NULL, 'c', NULL, NULL )", "INSERT INTO C_ATTEND (Email, Event_ID)\r\nVALUES ('*****@*****.**', 102)", "INSERT INTO S_ATTEND (Email, Event_ID)\r\nVALUES ('*****@*****.**', 101)");
//Perform the queries, huzzah
foreach ($population as $query) {
echo "> " . $query . "<br />";
my_trusted_mysql_query($query);
}
//Confirm the insertions
display_results(my_trusted_mysql_query("SELECT * FROM COMPANY"));
display_results(my_trusted_mysql_query("SELECT * FROM EVENT"));
display_results(my_trusted_mysql_query("SELECT * FROM CLASS_PARTICIPANT"));
display_results(my_trusted_mysql_query("SELECT * FROM SCREEN_PARTICIPANT"));
display_results(my_trusted_mysql_query("SELECT * FROM STAFF"));
display_results(my_trusted_mysql_query("SELECT * FROM C_ATTEND"));
display_results(my_trusted_mysql_query("SELECT * FROM S_ATTEND"));
//Close connection to database
my_mysql_close();
?>
$player_choice = "Stone";
if ($rand_num == 1) {
$npc_score = $npc_score + 1;
//mysql_query("UPDATE phaos_characters SET stamina = '$stamina_reduce' WHERE username = '******'");
$npc_choice = "Scroll";
display_results($npc_score, $player_choice, $npc_choice, lost, $ad_array);
}
if ($rand_num == 2) {
//mysql_query("UPDATE phaos_characters SET stamina = '$stamina_reduce' WHERE username = '******'");
$npc_choice = "Dagger";
display_results($npc_score, $player_choice, $npc_choice, won, $ad_array);
}
if ($rand_num == 3) {
//mysql_query("UPDATE phaos_characters SET stamina = '$stamina_reduce' WHERE username = '******'");
$npc_choice = "Stone";
display_results($npc_score, $player_choice, $npc_choice, drew, $ad_array);
}
}
echo "</p>\n<p align='center'>" . $lang_added["ad_please-select"] . ": <a href='" . $_SERVER[PHP_SELF] . "?guess=1&npcscore={$npc_score}'>" . $lang_added["ad_scroll"] . "</a>, <a href='" . $_SERVER[PHP_SELF] . "?guess=2&npcscore={$npc_score}'>" . $lang_added["ad_dagger"] . "</a> or <a href='" . $_SERVER[PHP_SELF] . "?guess=3&npcscore={$npc_score}'>" . $lang_added["ad_stone"] . "</a>?\n<br>\n</p>";
echo "<br><div align=center><a href='inn.php'> " . $lang_clan["back"] . " </a></td></div>";
echo '</body>
</html>';
function display_results($npc_score, $player_choice, $npc_choice, $game_result, $ad_array)
{
global $character, $PHP_PHAOS_CHARID, $PHP_PHAOS_USER;
//Added by dragzone---
if ($player_choice == "Scroll") {
$player_choice = $ad_array["scroll"];
}
if ($player_choice == "Dagger") {
$player_choice = $ad_array["dagger"];
foreach ($pages as $key => $page) {
if (!is_object($page['before']) || !is_object($page['after'])) {
continue;
}
$count++;
$class = $count % 2 ? 'odd' : 'even';
$classkey = substr($key, 0, 8);
if ($mostcommononly) {
$page['before']->strip_to_most_common_only($organiseby);
$page['after']->strip_to_most_common_only($organiseby);
}
echo "<div class='pagecontainer {$class} page-{$classkey}'>";
echo "<h1 class='pagetitle'>" . $page['before']->name . "</h1>";
echo "<h2 class='pagesubtitle'><a href='" . $page['before']->url . "'>" . $page['before']->url . "</a></h2>";
echo "<div class='statistical'>";
list($output, $stats) = display_results($page['before'], $page['after']);
echo $stats;
echo $output;
$statsarray[] = $stats;
display_organised_results($organiseby, $page['before'], $page['after']);
echo "<div class='graphdiv'>";
foreach ($PROPERTIES as $PROPERTY) {
if (!property_exists($page['before'], $PROPERTY)) {
continue;
}
$graphfile = produce_page_graph($PROPERTY, $before, $page['before'], $after, $page['after'], $width, $height, array('x' => $mostcommononly));
echo "<a href='webapp/graph.php?before={$before}&after={$after}&property={$PROPERTY}&page={$key}' class='largegraph'>";
echo "<img src='./cache/" . $graphfile . "' alt='{$PROPERTY}' style='width:{$width}px;height:{$height}px;' />";
echo "</a>";
}
echo "</div>";
</td>
</tr>
</table></td>
<td align="left" width="100%" style="background-color: #FFFFFF" class="style26">
<center>Current screenings in the database:<br /><br /></center>
<?php
include "includes/functions.php";
my_mysql_connect();
display_results(my_trusted_mysql_query("SELECT Event_ID, Event_Name, Start_Date, End_Date, Start_Time, End_Time, Comments, S_Type, Session_Length FROM EVENT WHERE E_Type = 's'"));
$total_screening = count(my_trusted_mysql_query("SELECT * FROM EVENT WHERE E_Type = 's'"));
echo "<br />Total screenings: ";
echo "{$total_screening}";
echo "<br />Average number of people per screening: ";
//Displays the avrage number of people attending all screening
display_results(my_trusted_mysql_query("SELECT AVG(Screening_Participants) FROM ( SELECT Event_ID, count(Email) Screening_Participants FROM S_ATTEND GROUP BY Event_ID) AS cnt_table"));
my_mysql_close();
?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2"><table align="left" border="1" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td height="38" background="/images/index_r17_c9.jpg" class="style21">
<div align="center">Patents and Copyrights owned by Maelstrom, Not for use by others</span><strong>.</strong><br>
</div></td>
</tr>
</table>
</td>
if (isset($_POST['submit'])) {
//Copy $_POST data, sanitizing it to prevent SQL injection attacks.
$q = safe_inputs($_POST);
//Force event ID into a number
$Event_ID_num = (int) $q['Event_ID'];
my_mysql_connect();
//event ID can't be blank
if ($Event_ID_num == 0) {
echo "Invalid Event ID entered. Event ID cannot be blank and must be a number. <br />";
} else {
if (count(my_trusted_mysql_query("SELECT Event_ID FROM EVENT WHERE Event_ID = {$Event_ID_num}")) == 0) {
echo "The event with the ID " . $q['Event_ID'] . " does not exist in the database. " . "<br />To add this event's information, please go <a href='http://group13.x10hosting.com/event_manip.php'>[here]</a> and select insert.<br /><br />";
$_POST['Fill'] = 'true';
} else {
echo "Dates and times for event {$Event_ID_num}: <br />";
display_results(my_trusted_mysql_query("SELECT Event_ID, Event_Name, Start_Date, Start_Time, End_Date, End_Time FROM EVENT WHERE Event_ID={$Event_ID_num}"));
my_mysql_close();
$_POST['Fill'] = 'false';
}
}
}
?>
</div>
<div class="style35">
<ul>
<strong>View all times and dates associated with a specific class or screening:</strong><br />
<li>The event ID must already be in the database.</li>
</ul>
</div>
<!-- The HTML for receiving user input from text boxes and such -->
if (count(my_trusted_mysql_query("SELECT Email FROM STAFF WHERE Email = '{$q['Email']}'")) == 0) {
echo "The person with the e-mail " . $q['Email'] . " is not currently in the database as a staff member. " . "To add this person's information, please select insert.<br /><br />";
$_POST['Fill'] = 'true';
} else {
//Show the record that's about to be deleted.
echo "Records deleted:";
display_results(my_trusted_mysql_query("SELECT * FROM STAFF WHERE Email = '{$q['Email']}'"));
$query = "DELETE FROM STAFF WHERE Email='{$q['Email']}'";
my_trusted_mysql_query($query);
if (count(my_trusted_mysql_query("SELECT Email FROM TEACH WHERE Email = '{$q['Email']}'")) > 0) {
display_results(my_trusted_mysql_query("SELECT * FROM TEACH WHERE Email = '{$q['Email']}'"));
$query = "DELETE FROM TEACH WHERE Email='{$q['Email']}'";
my_trusted_mysql_query($query);
}
if (count(my_trusted_mysql_query("SELECT Email FROM ADMINISTER WHERE Email = '{$q['Email']}'")) > 0) {
display_results(my_trusted_mysql_query("SELECT * FROM ADMINISTER WHERE Email = '{$q['Email']}'"));
$query = "DELETE FROM ADMINISTER WHERE Email='{$q['Email']}'";
my_trusted_mysql_query($query);
}
my_mysql_close();
$_POST['Fill'] = 'false';
}
} else {
echo "An unexpected selection has been made. <br />";
my_mysql_close();
die;
}
}
}
}
}
//See if the page was called with POST data, meaning this page has been called before
if (isset($_POST['submit'])) {
//Copy $_POST data, sanitizing it to prevent SQL injection attacks.
$q = safe_inputs($_POST);
my_mysql_connect();
//Check various conditions to make sure input is valid.
if (!preg_match('/^[a-zA-Z0-9._-]+@[a-zA-Z0-9-]+\\.[a-zA-Z.]{2,5}$/', $_POST['Email'])) {
echo "Invalid E-mail entered. E-mail must be in the format \"name@server.com\"<br />";
}
//Company is not in the database.
if (count(my_trusted_mysql_query("SELECT Email FROM COMPANY WHERE Email = '{$q['Email']}'")) == 0) {
echo "The company with the e-mail " . $q['Email'] . " does not exist in the database. " . "To add this company's information, please select insert instead of update.<br /><br />";
$_POST['Fill'] = 'true';
} else {
echo "All events hosted by the company with e-mail " . $q['Email'] . ": <br />";
display_results(my_trusted_mysql_query("SELECT * FROM EVENT WHERE Event_ID IN (SELECT Event_ID FROM HOSTS WHERE Email='{$q['Email']}')"));
my_mysql_close();
$_POST['Fill'] = 'false';
}
}
?>
</div>
<div class="style35">
<ul>
<strong>View all classes or screenings hosted by a specific company:</strong><br />
<li>The company must already be in the database.</li>
</ul>
</div>
<!-- The HTML for receiving user input from text boxes and such -->
<!-- For proper HTML rendering, the php scripts must be left completely left-aligned! -->
// 2. Get player last name
// 3. Build and execute query
// 4. Display results
// Check for form submission:
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// Check for name
// more robust input checking than just using empty()
if (!(filter_has_var(INPUT_POST, 'last_name') && strlen(filter_input(INPUT_POST, 'last_name')) > 0)) {
echo "<p class='error'>Please enter player's last name</p>";
} else {
$lastname = mysqli_real_escape_string($dbc, trim($_POST['last_name']));
// Define the query:
$q = "SELECT ilkid as player_id, concat(lastname, ', ',firstname) as name,\n concat(firstname, '_', lastname) as fname,\n firstseason as fs, lastseason as ls, position as pos,\n college\n FROM players\n WHERE lastname = '{$lastname}'\n ORDER BY lastname ASC";
$r = @mysqli_query($dbc, $q);
// Count the number of returned rows:
$num = mysqli_num_rows($r);
if ($num > 0) {
// If it ran OK, display the records.
display_results($num, $r);
mysqli_free_result($r);
} else {
// If no records were returned.
echo "<p class='error'>No players with last name " . htmlentities($lastname) . " found.</p>";
}
}
}
mysqli_close($dbc);
?>
<?php
include 'includes/footer.html';
</tr>
</table></td>
<td align="left" width="100%" style="background-color: #FFFFFF" class="style26">
<center>Current companies in the database:<br /><br /></center>
<?php
include "includes/functions.php";
//Connect to the database
my_mysql_connect();
display_results(my_trusted_mysql_query("SELECT * FROM COMPANY"));
$total_company = count(my_trusted_mysql_query("SELECT * FROM COMPANY"));
echo "<br />Total Companies: ";
echo "{$total_company}";
my_mysql_close();
?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2"><table align="left" border="1" cellpadding="0" cellspacing="0" width="100%">
function module_poll()
{
$activepolls = display_results();
if (strlen($activepolls) > 160) {
echo '<div class="poll">';
}
if (isset($_SESSION['valid_user'])) {
if (!isset($_REQUEST['pollaction'])) {
$pollaction = "";
} else {
$pollaction = $_REQUEST['pollaction'];
}
if ($pollaction == "votecast") {
$pollid = $_REQUEST['pollid'];
$regvote = "INSERT INTO vote VALUES (" . $pollid . ", '" . $_SESSION['valid_user'] . "'," . $_REQUEST['chosenalt'] . ");";
$result = DB_insert($regvote);
if ($result) {
echo "Takk for din stemme. Resultatet under oppdateres neste gang du viser siden.";
} else {
echo "Databaseproblem - din stemme ble ikke registrert. Skriv gjerne en lynforumpost om nøyaktig hva som skjedde, her er en bug et sted.";
}
}
$current_time = date('Y-m-d H:i');
//echo $current_time;
$findpolls = "SELECT pollid, title FROM poll WHERE time_opened < '" . $current_time . "' AND time_closed > '" . $current_time . "';";
$pollresult = DB_get_table($findpolls);
//echo $findpolls;
$num_polls = DB_rows_affected($pollresult);
while ($rowpoll = DB_next_row($pollresult)) {
$pollid = $rowpoll['pollid'];
if (!has_voted($_SESSION['valid_user'], $pollid)) {
if (!isset($findalt)) {
echo '<table class="polltable">';
echo '<tr><td colspan=2 class="pollheader">Stem!</td></tr>';
}
echo '<tr><td colspan=2 class="polltitle">' . $rowpoll['title'] . '</td></tr>';
$findalt = "SELECT pollid, question,questionid FROM pollquestion WHERE pollid =" . $pollid . ";";
$result = DB_get_table($findalt);
$num_results = DB_rows_affected($result);
if ($num_results > 0) {
form_start_post();
form_hidden("pollid", $pollid);
form_hidden("pollaction", "votecast");
while ($row = DB_next_row($result)) {
echo '<tr><td class="pollquestion">' . $row['question'];
echo '</td><td><input type="radio" value="' . $row['questionid'] . '" name="chosenalt"></td></tr>';
}
echo '<tr><td colspan=2 class="pollinput">';
form_submit("s", "Stem");
echo '</td></tr>';
form_end();
}
}
}
if (isset($findalt)) {
echo '</table>';
}
}
// Vis resultater for alle aktive polls
if (strlen($activepolls) > 160) {
echo $activepolls . '</div>';
}
}
<?php
include "../_include/header.php";
include $_INCLUDES . "navbar.php";
include $_PHP . "search_function.php";
require_once $_INCLUDES . "footer.php";
?>
<div class="container">
<?php
display_results();
?>
</div>
<?php
require_once $_INCLUDES . "footer.php";
// 1. Get letter value
// based on letter value, display appropriate player list page
if (!isset($_GET['lt'])) {
$lt = 'A';
// default
} else {
$lt = $_GET['lt'];
}
// is_string($lt) ? print('<p>$lt is a string</p>') :
// print('<p>$lt is not a string</p>');
// echo "<p>letter is $lt</p>";
// 2. Based on letter value, build appropriate sql query
// Define the query:
$q = "SELECT ilkid as player_id, concat(lastname, ', ',firstname) as name,\n concat(firstname, '_', lastname) as fname,\n firstseason as fs, lastseason as ls, position as pos,\n college\n FROM players\n WHERE lastname LIKE '{$lt}%'\n ORDER BY lastname ASC";
$r = @mysqli_query($dbc, $q);
// Count the number of returned rows:
$num = mysqli_num_rows($r);
if ($num > 0) {
// If it ran OK, display the records.
display_results($num, $r, $lt);
mysqli_free_result($r);
} else {
// If no records were returned.
echo '<p class="error">No players found.</p>';
}
}
mysqli_close($dbc);
?>
<?php
include 'includes/footer.html';
<html>
<title>
Company Test
</title>
<body>
<!-- The php script for generating the table and handling database queries -->
<?php
include "includes/functions.php";
my_mysql_connect();
echo "<h1><CENTER>Class</CENTER></h1>";
//Displays the class with the most amount of people
display_results(my_trusted_mysql_query("SELECT Event_ID, min(people) FROM ( SELECT Event_ID, count(Email) people FROM C_ATTEND GROUP BY Event_ID) AS cnt_table"));
echo "<h1><CENTER>Session</CENTER></h1>";
//Displays the session with the most amount of people
display_results(my_trusted_mysql_query("SELECT Event_ID, min(people) FROM ( SELECT Event_ID, count(Email) people FROM S_ATTEND GROUP BY Event_ID) AS cnt_table"));
my_mysql_close();
?>
</body>
</html>
}
// Begin to process the page...
$iSearchString = $_POST['iSearchString'];
if (empty($_POST['iSearchType'])) {
if (empty($_GET['searchType'])) {
$iObjectType = "user";
} else {
$iObjectType = $_GET['searchType'];
}
} else {
$iObjectType = $_POST['iSearchType'];
}
?>
<h2>Search for objects</h2>
<?php
/*echo "\$_POST['iSearchString']=".$_POST['iSearchString']."\n<br />";
echo "\$_POST['iSearchType']=".$_POST['iSearchType']."\n<br />";
echo "\$_GET['searchType']=".$_GET['searchType']."\n<br />";
echo "\$iSearchString=$iSearchString\n<br />";
echo "\$iObjectType=$iObjectType\n<br />";*/
?>
<h3>Help</h3>
<p>Some help...</p>
<?php
display_search_form($iObjectType, $iSearchString);
if (!empty($_POST['iSearchString'])) {
echo " <h3>Results</h3>\n";
DB_connect($DB_host, $DB_login, $DB_pass);
DB_select($DB_db);
display_results($iSearchString, $iObjectType);
}
</tr>
</table></td>
<td align="left" width="100%" style="background-color: #FFFFFF" class="style26">
<center>Events currently in the database:<br /><br /></center>
<?php
include "includes/functions.php";
//Connect to the database
my_mysql_connect();
display_results(my_trusted_mysql_query("SELECT * FROM EVENT"));
$total_event = count(my_trusted_mysql_query("SELECT * FROM EVENT"));
echo "<br />Total Events: ";
echo "{$total_event}";
my_mysql_close();
?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2"><table align="left" border="1" cellpadding="0" cellspacing="0" width="100%">
