function process_subject_areas() { global $userrole; if ($userrole === "admin") { print '<b>Subject Areas</b><br /><br />'; if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $sa = db_subject_areas(); edit_subject_area($sa); } else { if ($_POST['Add'] === 'add') { add_subject_area(); } else { if ($_POST['Save'] === 'save') { save_subject_area(); } else { if ($_POST['Remove'] === 'remove') { $sa = db_subject_areas(); remove_record($sa); } else { if ($_POST['Remove'] === 'yes') { yes_remove_subject_area(); } } } } } } $sadata = db_subject_areas(); show_table(array('ID', 'Subject area CODE', 'Subject area NAME'), $sadata); print '<br /><br />For a list of areas, see: <a href="http://egracons.eu/sites/default/files/APPLICATION_OF_ISCED_CODES_IN_EGRACONS_TOOL_2015%2004%2008_1.pdf" target="_blank">ISCED CODES</a><br />'; } else { return; } }
function process_universities() { global $userrole; if ($userrole === "admin") { print '<b>Universities</b><br /><br />'; if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $uni = db_universities_without_countries(); edit_university($uni); } else { if ($_POST['Add'] === 'add') { add_university(); } else { if ($_POST['Save'] === 'save') { save_university(); } else { if ($_POST['Remove'] === 'remove') { $uni = db_universities_with_countries(); remove_record($uni); } else { if ($_POST['Remove'] === 'yes') { yes_remove_university(); } } } } } } $unidata = db_universities_with_countries(); show_table(array('ID', 'University name (country)', 'Erasmus code'), $unidata); } else { return; } }
function process_study_programs() { global $userrole; if ($userrole === "admin") { print '<b>Study Programs</b><br /><br />'; if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $sp = db_study_programs(); edit_study_program($sp); } else { if ($_POST['Add'] === 'add') { add_study_program(); } else { if ($_POST['Save'] === 'save') { save_study_program(); } else { if ($_POST['Remove'] === 'remove') { $sp = db_study_programs(); remove_record($sp); } else { if ($_POST['Remove'] === 'yes') { yes_remove_study_program(); } } } } } } $spdata = db_study_programs(); show_table(array('ID', 'Study program CODE', 'Study program NAME'), $spdata); } else { return; } }
function process_fmfi_courses() { global $userrole; if ($userrole === "admin") { print '<b>FMFI Courses</b><br /><br />'; if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $fc = db_fmfi_courses(); edit_fmfi_course($fc); } else { if ($_POST['Add'] === 'add') { add_fmfi_course(); } else { if ($_POST['Save'] === 'save') { save_fmfi_course(); } else { if ($_POST['Remove'] === 'remove') { $fc = db_fmfi_courses(); remove_record($fc); } else { if ($_POST['Remove'] === 'yes') { yes_remove_fmfi_courses(); } } } } } } $fcdata = db_fmfi_courses(); show_table(array('ID', 'Course CODE', 'Course NAME', 'Credits'), $fcdata); } else { return; } }
function process_credits() { print '<b>Travel courses</b><br /><br />'; $tcdata = NULL; if (isset($_GET['act'])) { if (strcmp($_POST['Edit'], 'edit') === 0) { $tcdata = db_travel_courses(); edit_travel_course($tcdata); } else { if (strcmp($_POST['Add'], 'add') === 0) { add_travel_course(); } else { if (strcmp($_POST['Save'], 'save') === 0) { save_travel_course(); } else { if (strcmp($_POST['Remove'], 'remove') === 0) { $tcdata = db_travel_courses(); remove_record($tcdata); } else { if (strcmp($_POST['Remove'], 'yes') === 0) { yes_remove_travel_courses(); } } } } } } if ($tcdata == NULL) { $tcdata = db_travel_courses(); } $tcf = format_travel_courses($tcdata); show_table(array('ID', 'Associated travel', 'Foreign course code', 'Foreign course name', 'Credits', 'Grade', 'Course type', 'FMFI course'), $tcf); }
function process_students() { global $userrole; if ($userrole === "admin") { print '<b>Students</b><br /><br />'; if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $st = db_students(); edit_student($st); } else { if ($_POST['Add'] === 'add') { add_student(); } else { if ($_POST['Save'] === 'save') { save_student(); } else { if ($_POST['Remove'] === 'remove') { $st = db_students(); remove_record($st); } else { if ($_POST['AddOption'] === 'add') { add_study_program_to_student_and_edit_student(); } else { if ($_POST['Remove'] === 'yes') { yes_remove(); } else { if ($_POST['Remove'] === 'no') { no_remove(); } else { foreach ($_POST as $var => $val) { if (strncmp($var, 'deletelist', 10) === 0) { delete_sp_and_edit_student($var); break; } } } } } } } } } } $stdata = db_students(); $stfd = format_student_data($stdata); show_table(array('ID', 'First name', 'Middle names', 'Last name', 'Born', 'StudentID', 'Gender', 'Citizenship', 'E-mail', 'Study programs', 'Year 1st participated'), $stfd); } else { return; } }
function process_agreements() { print '<b>Bilateral Agreements</b><br /><br />'; if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $agg = db_retrieve_agreements_data(); edit_agreement($agg); } else { if ($_POST['Add'] === 'add') { add_agreement(); } else { if ($_POST['Save'] === 'save') { save_agreement(); } else { if ($_POST['Remove'] === 'remove') { $agg = db_retrieve_agreements_data(); remove_record($agg); } else { if ($_POST['Remove'] === 'yes') { yes_remove_agreement(); } else { if (isset($_POST['upload10'])) { upload_file_and_edit_agreement(); } else { if ($_POST['DeleteFile'] === 'yes') { yes_delete_file_and_edit_agreement(); } else { if ($_POST['DeleteFile'] === 'no') { no_delete_file_and_edit_agreement(); } else { foreach ($_POST as $var => $val) { if (strncmp($var, 'deletefile', 10) === 0) { delete_file_and_edit_agreement($var); break; } } } } } } } } } } } $columns = array('ID', 'University (country, code)', 'Valid FROM (YYYY/YYYY)', 'Valid TO (YYYY/YYYY)', 'Coordinator', 'Subject Area', 'Accepted levels', '# of students', 'Files'); $agg = db_retrieve_agreements_data(); $fagg = format_agreements_data($agg); show_table($columns, $fagg); }
function process_foreign_credits() { global $userrole; if ($userrole === "admin") { print '<b>Travel foreign courses</b><br /><br />'; $filter_exchange = retrieve_filter_exchange(); show_exchange_filter($filter_exchange); $tcdata = NULL; if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE); edit_travel_course($tcdata); } else { if ($_POST['Add'] === 'add') { add_travel_course($filter_exchange); } else { if ($_POST['Save'] === 'save') { save_travel_course($filter_exchange); } else { if ($_POST['Remove'] === 'remove') { $tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE); remove_record($tcdata); } else { if ($_POST['Remove'] === 'yes') { yes_remove_travel_courses(); } } } } } } logmsg("retr"); if ($tcdata == NULL) { $tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE); } logmsg("ieve"); $tcf = format_travel_foreign_courses($tcdata); show_table(array('ID', 'Foreign course code', 'Foreign course name', 'Credits', 'Grade', 'Course type'), $tcf); } else { return; } }
if(!empty($dl)){ if(REFCHECK){ $c_okurl=count($okurl); $is_okurl=false; for($i=0; $i<$c_okurl; $i++){ if(isset($_SERVER['HTTP_REFERER']) && ($is_okurl = strstr($_SERVER['HTTP_REFERER'],$okurl[$i]) !== FALSE)) break; if(!$is_okurl && $i==$c_okurl-1) die("指定URL以外からはDLできません"); } } count_dl($dl); exit; } switch($job){ case 'detail': if($detail) show_detail($detail); break; case 'admin': if($admin_submit) $admin = md5($admin_submit); validation($admin); if($act) manage($act,$id,$new); if($submit=="Add Entry") add_data($new_loc,$new_id,$description,$new_ref); show_track(); break; default: if(time()-filemtime(LOGFILE) > 3600) @copy(LOGFILE,LOGFILE.".bak"); show_table($top,$option); } ?>
function process_travels() { global $userrole; if ($userrole === "admin") { print '<b>Travels</b><br /><br />'; list($filter_a, $filter_d1, $filter_d2) = configure_travel_filters(); show_travel_filters($filter_a, $filter_d1, $filter_d2); if (isset($_GET['act'])) { if ($_POST['Edit'] === 'edit') { $ts = db_travels($filter_a, $filter_d1, $filter_d2); edit_travel($ts); } else { if ($_POST['Add'] === 'add') { add_travel(); } else { if ($_POST['Print'] === 'print') { $ts = db_travels($filter_a, $filter_d1, $filter_d2); print_link_travel($ts); } else { if ($_POST['Save'] === 'save') { save_travel(); } else { if (isset($_POST['upload13'])) { upload_file_and_edit_travel(); } else { if ($_POST['Remove'] === 'remove') { $ts = db_travels($filter_a, $filter_d1, $filter_d2); remove_record($ts); } else { if ($_POST['Remove'] === 'yes') { yes_remove_travels(); } else { if ($_POST['DeleteFile'] === 'yes') { yes_delete_file_and_edit_travel(); } else { if ($_POST['DeleteFile'] === 'no') { no_delete_file_and_edit_travel(); } else { if ($_POST['AddOption'] === 'add') { add_course_to_travel_and_edit_travel(); } else { if ($_POST['Remove'] === 'yes') { yes_remove_travels(); } else { foreach ($_POST as $var => $val) { if (strncmp($var, 'deletefile', 10) === 0) { delete_file_and_edit_travel($var); break; } } } } } } } } } } } } } } $tsdata = db_travels($filter_a, $filter_d1, $filter_d2); $fts = format_travel_data($tsdata); show_table(array('ID', 'Level', 'Agreement', 'Semester', 'Date FROM (Y-m-d)', 'Date TO (Y-m-d)', 'Student', 'Study program', 'Language:', 'Has', 'Expected', 'Soc.stip.', 'Handicap', 'Files', 'Courses', 'Notes', 'Cancelled'), $fts, TRUE, TRUE); } else { return; } echo "\n <script>\n \$('table>tbody>tr>td:nth-child(15)>article').each(\n function(index){\n \$(this).readmore({\n collapsedHeight: 45, \n moreLink: '<a href=\"#\">More</a>',\n lessLink: '<a href=\"#\">Less</a>'\n })\n })\n </script>"; //oshitoshit }
<?php /* Chen Qiu, CSE 154 Section AB, Homework 5, 10/29/2014 This page searches for all the films with the actor the user is searching sorted by year descending, breaking ties by movie title ascending. */ $first = $_GET["firstname"]; $last = $_GET["lastname"]; include "common.php"; $db = new PDO("mysql:dbname=imdb;host=localhost;", "chenq9", "9XcmbstwvP"); $id_rows = search($first, $last, $db); if ($id_rows->rowCount() > 0) { $id = $id_rows->fetch()["id"]; $rows = $db->query("SELECT name, year FROM movies JOIN roles ON movie_id = id WHERE actor_id = {$id} ORDER BY year DESC, name ASC"); $caption = "All Films"; show_table($rows, $first, $last, $caption); } else { // Actor Not Found. ?> <p>Actor <?php echo "{$first} {$last}"; ?> not found.</P> <?php } forms(); footer();
$form .= show_parameter ($interface["name"],$interface["optional"],$interface["def"],$$var); } } for ($i=0;$i<count($def);$i++) { $interface = $def[$i]; if ($interface["type"] == "TABLE") // if internal table { $form .= "<tr bgcolor=#D0D0D0><td colspan=2><b>TABLE ".$interface["name"]."</b></td></tr>\n"; $var="RFC_TABLE_".$interface["name"]; if ( !isset ($$var) ) $$var=""; $vararray = unserialize (urldecode($$var)); // get saved array of values from RFC_TABLE_* $var="RFC_".$interface["name"]; if ($action=="Append ".$interface["name"]) // if Append button pressed, add new line to internal table (array) $vararray[]=$$var; $form .= show_table ($interface["name"],$interface["def"],$vararray); } } $form .= "<tr><td colspan=2><input type=submit name=action value=\"Call $function\">\n"; $form .="<input type=submit name=action value=\"Generate PHP\"></td></tr>\n"; $form .= "</table></form>\n"; print_window ("Function module $function",$form,"<a href=\"javascript:history.back()\">Back</a> <a href=\"saprfc_test.php?p=newlogin\">New login</a> <a href=\"saprfc_test.php?p=select\">Select other function</a>"); print_footer(); } } if ( $p == "call" ) // set input parameters and tables, call function module, show results { for ($i=0;$i<count($def);$i++) { $interface = $def[$i];
<div class="row clearfix"> <!-- форма для добавления товара в базу --> <div class="head_cont">Редактирование товара в базе данных</div> <form method="post"> <label> <p>ID товара в базе</p> <input name = "id_elem" type = "text" value = "" /> </label> <?php include_once "_db_item_form_fields.php"; ?> <div class="wr_subm"> <input type="submit" value="Изменить" /> </div> </form> <div class="wr_result_mess"> <?php show_result_edit($connection); ?> </div> <div> <?php show_table($connection); ?> </div> </div> </div> </div> </div> </main>
function process_logs() { global $userrole; if ($userrole === "admin") { print '<b>Logs</b><br /><br />'; $logdata = db_retrieve_logs(); show_table(array('date', 'ip', 'user', 'table', 'record', 'operation', 'description', 'new value'), $logdata, FALSE); } else { return; } }
<?php session_start(); $user = @$_SESSION['myemail']; if ($user != "admin") { header("location: ./../index.php"); die; } require './../config.php'; require './../src/security.php'; $action = @$_POST['action']; if ($action == 'show_table') { show_table(); } if ($action == 'delete_row') { delete_row(); } if ($action == 'new_row') { new_row(); } if (preg_match('/change/', $action)) { change($action); } function show_table() { $data = $GLOBALS['DB']->query("SELECT * FROM user"); echo json_encode($data); } function delete_row() { $id = (int) @$_POST['id'];
echo $class; ?> "><?php echo $class; ?> </td> <td><?php echo $shogi->log[count($shogi->log) - 1]; ?> </td> </tr> <?php } } ?> <caption style="position:relative;"> <?php echo show_table($shogi); ?> <br /> </caption> </table> <tt>* In all instances, Pass means the code worked properly, not that the ove was proper.</tt><br /> <a onclick="document.getElementById('boardarray').style.display = 'block';return false;" href="">Display Board</a> <pre style="display:none;" id="boardarray"><?php print_r($shogi->board); // */ ?> </pre> </body></html>
?> <table class="table table-hover"> <thead> <tr> <th>标题</th> <th>需求类型</th> <th>内容</th> <th>状态</th> <th>提交人</th> <th>日期</th> </tr> <tbody> <?php if ($total_num <= $each_page_num) { for ($i = 0; $i < $total_num; $i++) { show_table($content_array[$i]); } } ?> </tbody> </thead> </table> <?php if ($total_num > $each_page_num) { echo "<div id=\"page_num\">"; echo "<nav>"; echo "<ul class=\"pagination pagination-lg\">"; echo "<li>"; echo "<a href=\"#\" aria-label=\"Previous\">"; echo "<span aria-hidden=\"true\">«</span>";
$result = $db->Execute($sql); if ($result == false) { die("failed"); } show_table('OAI', $result); // DIGIR $sql = 'SELECT * FROM services INNER JOIN status ON services.id = status.service_id WHERE (kind=\'DIGIR\') AND (tested > NOW() - INTERVAL ' . $interval . ' SECOND) ORDER BY name'; $result = $db->Execute($sql); if ($result == false) { die("failed"); } show_table('DiGIR providers', $result); } echo "</tbody>" . "\n"; echo "</table>" . "\n"; echo '<hr/>' . "\n"; if (1) { echo '<h3>Key to symbols and colours</h3>'; echo "<table cellpadding=\"3\" cellspacing=\"0\">"; echo '<tbody style="font-family:verdana,Arial,sans-serif;font-size:12px">'; echo '<tr>'; echo '<td><img src="../images/accept.png" alt="accept"/></td>'; echo '<td>200</td>'; echo '<td>Everything seems to be OK</td>'; echo '</tr>'; echo '<tr style="background-color:rgb(255,187,187)">'; echo '<td><img src="../images/delete.png" alt="error"/></td>';
print $error_message . "<p>"; } print var_export($user_info, true); $vod_user_info = array(); $ret = $mysql_vod->QueryUserInfo($appid, $vod_user_info, $error_message); if ($ret != 0) { die($error_message); } //print var_export($vod_user_info, true)."<p>"; show_table($vod_user_info); $vod_user_payment_lilst = array(); $ret = $mysql_vod->QueryUserPayment($appid, $vod_user_payment_lilst, $error_message); if ($ret != 0) { die($error_message); } show_table($vod_user_payment_lilst); //print var_export($vod_user_payment_lilst, true)."<p>"; /* $link = mysqli_connect('127.0.0.1','root','root', 'test'); if (!$link) { die('Could not connect to MySQL: ' . mysql_error()); } mysqli_query($link, 'set names gbk'); $result_rows = mysqli_query($link, 'select * from user'); $html = "<table border='1' width='200'><tr><td>id</td><td>name</td><td>sex</td><td>age</td><td>salary</td><td>address</td><td>QQ</td><td>email</td><td>create_time</td><td>update_time</td></tr>"; while($row = mysqli_fetch_assoc($result_rows)){ $html = $html."<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['sex']}</td><td>{$row['age']}</td><td>{$row['salary']}</td><td>{$row['address']}</td><td>{$row['qq']}</td><td>{$row['email']}</td><td>{$row['create_time']}</td><td>{$row['update_time']}</td></tr>"; } $html.'</table>';
if ($code != "") { $content = sys_exec(str_replace("\n", "&", trim($code))); } $title = "SYS Console: " . getcwd() . " @ " . $_SERVER["SERVER_NAME"] . " [" . $_SERVER["SERVER_SOFTWARE"] . "]"; if ($content != "") { $content = "<pre>" . q($content) . "</pre>"; } } else { $content = ""; $title = "SQL Console: " . SETUP_DB_USER . " @ " . SETUP_DB_NAME . " [" . SETUP_DB_TYPE . " " . sgsml_parser::sql_version() . "] "; if ($code != "") { if (($data = sql_fetch($code, false)) === false) { $content .= sql_error(); } else { if (is_array($data) and count($data) > 0) { $content .= show_table($data, isset($_REQUEST["full_texts"]), isset($_REQUEST["vertical"])); } else { if (SETUP_DB_TYPE == "mysqli" and $num = mysqli_affected_rows(sys::$db)) { $content .= t("{t}%s rows affected{/t}", $num); } else { $content .= t("{t}Empty{/t}"); } } } } $tpl->auto_complete = true; } } if ($code != "") { $content .= "<br/> " . t("{t}%s secs{/t}", number_format(microtime(true) - $start, 4)); $content .= ", " . t("{t}%s M memory usage{/t}", number_format(memory_get_peak_usage(true) / 1048576, 2));
break; case 3: $t = 'Package'; break; case 4: $t = 'IP'; break; case 5: $t = 'Comment'; break; default: goto endlabel; } $r_value = DB::real_escape_string(str_replace('*', '%', str_replace('?', '_', $_GET['contents']))); $list_query = DB::fetch_all("SELECT * FROM `" . DCRM_CON_PREFIX . "UDID` WHERE `" . $t . "` LIKE '%" . $r_value . "%' ORDER BY `ID` DESC LIMIT " . (string) $page_a . ",10"); $page_c = show_table($list_query); $q_info = DB::query("SELECT count(*) FROM `" . DCRM_CON_PREFIX . "UDID` WHERE `" . $t . "` LIKE '%" . $r_value . "%'"); $info = DB::fetch_row($q_info); $totalnum = (int) $info[0]; $params = array('total_rows' => $totalnum, 'method' => 'html', 'parameter' => 'center.php?action=search&contents=' . $_GET['contents'] . '&type=' . $_GET['type'] . '&page=%page', 'now_page' => $page, 'list_rows' => 10); $page = new Core_Lib_Page($params); echo '<div class="page">' . $page->show(2) . '</div>'; } elseif (!empty($_GET['action']) and $_GET['action'] == "edit") { // 添加与编辑UDID if (!isset($_GET['add'])) { // 获取编辑信息 if (isset($_GET['id']) && is_numeric($_GET['id'])) { $request_id = (int) $_GET['id']; if ($request_id < 1) { _e('Illegal request!'); goto endlabel;
echo "Вы не ввели Ваше имя<br> "; # show_zakaz($zakaz,1); show_zakaz($zakaz, $page, $youname, $youmail, $youtel, $youmsg); } } if (!isset($submit)) { show_table($page, $rid, $zakaz, $filt); } if (isset($submit) && $submit == " OK ") { $ff = $filt; $filt = to_filter($mfilt, $vfilt, $ff); show_table($page, $rid, $zakaz, $filt); } if (isset($submit) && $submit == " Очистить ") { $filt = clean_filter($filt); show_table($page, $rid, $zakaz, $filt); } ?> </td> </tr> </table> </td> </tr> <tr> <td colspan="5"> <img src="img/line2.jpg" border="0" height="50" width="800"> </td> </tr> <tr>