<?php //redirect to release WIPs URL if r parameter is set if (!empty($_GET['r'])) { header('Location: http' . (empty($_SERVER['HTTPS']) || $_SERVER['HTTPS'] == 'off' ? '' : 's') . '://' . $_SERVER['SERVER_NAME'] . dirname($_SERVER['REQUEST_URI']) . '/wips.php?r=' . $_GET['r']); } ?> <!DOCTYPE html> <html> <head> <title>Work in Progress Archive</title> <link rel="stylesheet" type="text/css" href="../styles.css"/> <link rel="stylesheet" type="text/css" href="tablestyles.css"/> </head> <body> <table> <thead> <tr><th>Name (Click to Download)</th><th>For Release</th><th>Description</th></tr> </thead> <tbody> <?php include 'wiplist.php'; generate_list(); ?> </tbody> </table> </body> </html>
echo $row3['eventStartDate']; echo "</font></td>"; echo "<td><font face = 'Arial, Helvetica, sans-serif'>"; echo $row3['eventEndDate']; echo "</font></td>"; echo "<td><font face = 'Arial, Helvetica, sans-serif'>"; echo $row3['eventStartTime']; echo "</font></td>"; echo "<td><font face = 'Arial, Helvetica, sans-serif'>"; echo $row3['eventEndTime']; echo "</font></td>"; echo "<td><font face = 'Arial, Helvetica, sans-serif'>"; echo $row3['eventDesc']; echo "</font></td>"; echo "</tr>"; $y = $y - 1; } echo "</table>"; echo "<br/>"; echo "<a href='eventslocation.php' class='button black'>GO BACK</a>"; } else { echo "<h2 class='center'>Search Events</h2>"; echo "<form name='queryroom' id ='queryname' method='POST' action='" . $PHP_SELF . "'>"; $query = "select buildingName from Building"; $x = "buildingName"; $st = generate_list($query, $x); echo "\n<table >\n<tr><td> Building: </td>\n<td> " . $st . " </td></tr>\n</table>"; echo "<table style='text-align:center'>\n<tr><td> Select Start Date: </td>\n<td><div id='divroomName'> <script>DateInput('date_start', true, 'YYYY-MM-DD')</script> </div></td>\n</tr>\n<tr><td> Select End Date: </td>\n<td><div id='divroomName'> <script>DateInput('date_end', true, 'YYYY-MM-DD')</script> </div></td>\n</tr>\n<tr><td></td><td><br/>\n<input type='submit' name='submit' id='submit' value='QueryEvents'/>\n</td></tr></table>\n</form>"; echo "<button><a href='search.php'>BACK TO SEARCH</a></button>"; } include 'footer.php';
<form id="form_clear" action="index.php" onsubmit="return clearTable();" method="post" > <input type="submit" name="clear" value="Clear Purchase List" /> </form> <div id="database"> <h4>Current purchase list:</h4> <?php /* update table Purchase_List according to the user input */ /* Generate a purchase list randomly */ if (isset($_POST['count']) && isset($_POST['percentage'])) { $count = $_POST['count']; //The number of rows $percentage = $_POST['percentage']; //The percentage of match: generate_list($count, $percentage, $connection); /* Create a purchase by user */ } else { if (isset($_POST['ip']) && isset($_POST['delivery_country'])) { $ip = $_POST['ip']; //Your IP address $delivery_country = $_POST['delivery_country']; //Your delivery country /* Insert the pruchase to the table Purchase_List */ $query = "INSERT INTO Purchase_List(IP, Country_Name) "; $query .= "VALUES ('" . $ip . "', '" . $delivery_country . "') "; mysqlQuery($connection, $query); /* If the user want to empty the table Purchase_List */ } else { if (isset($_POST['clear'])) { $query = "TRUNCATE TABLE Purchase_List";
" <?php post_class('lc-article lc-people-list'); ?> > <div class='ninecol' id='contentarea'> <div class='top-content'> <article class='wireframe row'> <header class='entry-header'> <h1><?php the_title(); ?> </h1> </header> <div class='entry-content article-text'> <?php echo generate_list($people_list, MODE_FULL_LIST); ?> </div> <?php get_template_part('snippet-socialmedia-share'); ?> </article> </div><!-- .top-content --> </div><!-- #contentarea --> </div><!-- #post-<?php the_ID(); ?> --> <?php get_template_part('nav'); ?>
<form action="addRequest.php" autocomplete="on" method="POST"> <table class='center'> <tr><td> Name:</td><td><input type="text" name="creator" id="P1"><br> </tr> <tr><td> Email: </td><td><input type="email" name="creatorEmail" id="P2" autocomplete="off"><br></tr> <tr><td> Phone No: </td><td><input type="text" name="creatorPhone" id="P3" maxlength=10><br></tr> <tr><td> Are you requesting for someone else?</td><td><input type="checkbox" id="switchAlias"/></tr> <tr class="CP"><td> Details of concerned person:</td></tr> <tr class="CP"><td> Name:</td><td><input type="text" name="concernedPName" id="CP1"><br></tr> <tr class="CP"><td> Email: </td><td><input type="email" name="concernedPEmail" id="CP2" autocomplete="off"><br></tr> <tr class="CP"><td> Phone No:</td> <td><input type="text" name="concernedPPhone" id="CP3" maxlength=10><br></tr> <tr><td> <span style="font-weight: bold;">Details of Event:</span></td><td></tr> <!-- <tr><td> Title:</td><td><input type="text" name="eventTitle" id="ti1"><br></tr>--> <?php echo "<tr><td>Event Title:</td><td>"; $query = "select * from eventTitle"; echo generate_list($query, "eventTitle"); echo "</td>"; ?> <tr><td> Select Building: </td><td> <?php if ($_GET['buildingname']) { echo generateBuildingList1("buildingName", $_GET['buildingname']); } else { echo generateBuildingList("buildingName"); } ?> </td></tr> <?php echo "<tr><td> Select Room:</td><td>"; if ($_GET['buildingname']) { echo generateRoomList1("room", $_GET['roomName']);
</table> </form> <form name='deleteroom' method='POST' action ='s_addroom2.php' id="deleteRoom" > <h2 align='center'>Delete Room</h2> <table align='center'><tr><td>Select Room: </td> <td><?php echo $list2; ?> </td></tr> <tr><td></td><td><input type='submit' name='deleteroom' value='Delete'/i></td></tr> </table></form> <?php $query = "select buildingName from Building;"; $r = 'bname'; $list1 = generate_list($query, $r); ?> <form name='insert' action='s_addbuild2.php' method='post' id="addBuilding"> <h2 align='center'>Add Building</h2> <table align='center'> <tr><td> Enter the new Building's Name : </td><td><input type='text' id='enter' name = 'Bname' /> <script type="text/javascript"> var f2 = new LiveValidation('enter'); f2.add( Validate.Presence ); </script> </td> </tr> <tr><td></td><td><input type='submit' name='add' value='Add'/></td> </tr></table> </form><br/><br/><br/>
<?php $TRACE_ENABLED = is_user_logged_in(); $TRACE_PREFIX = 'nav.php -- '; $current_post_id = $post->ID; $people_list = get_post_meta($post->ID, 'people_list', true); if ($people_list) { ?> <nav id="whoswho-side-toc"> <?php echo generate_list($people_list, 'summary'); ?> </nav> <?php }
<?php include "essential.php"; require_once "header.php"; ?> <h2>Edit Room</h2> <?php $id = $_GET['SNO']; //echo $id; $query1 = "select * from Room where roomId=" . $id . ";"; $q = "select buildingName from Building"; $x = "buildingName"; $st = generate_list($q, $x); $result1 = execute($query1); while ($row = mysql_fetch_row($result1)) { ?> <form action="s_addroom3.php" method="post"> <table> <tr> <td> RoomId:</td> <td><input type='text' name='roomID' readonly value=<?php echo $id; ?> ></td> </tr> <tr> <td> Room Name</td> <td> <input type='text' name='roomName' id='room' value=<?php echo $row[1]; ?>
<?php include "lib/autoload.php"; if (file_exists("schema.php")) { include "schema.php"; if (isset($config) && isset($schema)) { echo "<p>Base de datos <b>{$config['db']}</b></p>"; echo "<ul>"; generate_conection($config); generate_sql($config, $schema); foreach ($schema as $tablename => $tabledata) { generate_form($tablename, $tabledata); generate_form_edit($tablename, $tabledata); generate_adder($tablename, $tabledata); generate_editer($tablename, $tabledata); generate_list($tablename, $tabledata); generate_deleter($tablename, $tabledata); } echo "<li>Finalizado</li>"; echo "</ul>"; } }
<?php include "essential.php"; require_once "header.php"; echo "<script type='text/javascript' src='js/calendarDateInput.js'> </script>"; if (!$_POST['submit']) { echo "\n<h2 class='center'> Search Events </h2>\n\n<form name='queryroom' id ='queryname' method='POST' action='" . $PHP_SELF . "'>"; echo "<table class='center'>\n<tr><td style='text-align:right'>Search(Event Type) : </td><td>"; echo generate_list("select * from eventTitle", 'keyword'); echo "</td></tr>\n</table>\n<br/>\n<table style='text-align:center'>\n<tr><td> Select Start Date: </td>\n<td><div id='divroomName'> <script>DateInput('date_start', true, 'YYYY-MM-DD')</script> </div></td>\n</tr>\n<tr><td> Select End Date: </td>\n<td><div id='divroomName'> <script>DateInput('date_end', true, 'YYYY-MM-DD')</script> </div></td>\n</tr>\n<tr><td></td><td><br/>\n<input type='submit' name='submit' id='submit' value='QueryEvents'/>\n</td></tr></table>\n</form>"; echo "<button><a href='search.php'>BACK TO SEARCH</a></button>"; } else { $date_s = strtotime($_POST['date_start']); $date_e = strtotime($_POST['date_end']); if ($date_s > $date_e) { header("Location:error.php?msg=ERROR: Your Date and time limits are wrong!"); } $buildid = 1; $roomid = 1; $x = $_POST['date_start']; $y = $_POST['date_end']; $hardhik = $_POST['keyword']; //echo $hardhik; //$query2 = "select Building.buildingName,Requests.eventDesc,eventStartTime,eventEndTime,room,eventStartDate,eventEndDate from Requests,Room,Building where appStatus = 'Accepted' AND Requests.room = Room.roomName AND Building.buildId = Room.buildingName AND Requests.eventDesc LIKE '%".$hardhik."%' AND ((eventStartDate <= DATE '".$x."' AND eventEndDate >= DATE '".$y."') OR (eventStartDate >= DATE '".$x."' AND eventEndDate >= DATE '".$y."' AND eventStartDate <= DATE '".$y."') OR (eventStartDate >= DATE '".$x."' AND eventEndDate <= DATE '".$y."') OR (eventStartDate <= DATE '".$x."' AND eventEndDate <= DATE '".$y."' AND eventEndDate >= DATE '".$x."'));"; $query2 = "select Building.buildingName,Requests.eventDesc,eventStartTime,eventEndTime,room,eventStartDate,eventEndDate from Requests,Room,Building where appStatus = 'Accepted' AND Requests.room = Room.roomName AND Building.buildId = Room.buildingName AND Requests.eventTitle = '" . $hardhik . "' AND ((eventStartDate <= DATE '" . $x . "' AND eventEndDate >= DATE '" . $y . "') OR (eventStartDate >= DATE '" . $x . "' AND eventEndDate >= DATE '" . $y . "' AND eventStartDate <= DATE '" . $y . "') OR (eventStartDate >= DATE '" . $x . "' AND eventEndDate <= DATE '" . $y . "') OR (eventStartDate <= DATE '" . $x . "' AND eventEndDate <= DATE '" . $y . "' AND eventEndDate >= DATE '" . $x . "'));"; //$query2 = "select Building.buildingName,Instances.eventDesc,eventStartTime,eventEndTime,room,eventStartDate,eventEndDate from Instances,Room,Building where Instances.room = Room.roomName AND Building.buildId = Room.buildingName AND Instances.eventTitle = '".$hardhik."' AND ((eventStartDate <= DATE '".$x."' AND eventEndDate >= DATE '".$y."') OR (eventStartDate >= DATE '".$x."' AND eventEndDate >= DATE '".$y."' AND eventStartDate <= DATE '".$y."') OR (eventStartDate >= DATE '".$x."' AND eventEndDate <= DATE '".$y."') OR (eventStartDate <= DATE '".$x."' AND eventEndDate <= DATE '".$y."' AND eventEndDate >= DATE '".$x."'));"; $result9 = execute($query2); $y = mysql_num_rows($result9); //echo $query2; if ($y != 0) { echo "<table id='box-table-a'>\n<thead>\n<tr>\n<th scope='col'>Building Name</th>\n<th scope='col'>Room</th>\n<th scope='col'>Start Date</th>\n<th scope='col'>End Date</th>\n<th scope='col'>Start Time</th>\n<th scope='col'>End Time</th>\n<th scope='col'>Description</th>\n</tr>\n</thead>";