$ws_number = 1; // Установка, чтобы обработать только первый рабочий лист for ($ws_n = 0; $ws_n < $ws_number; $ws_n++) { $ws = $exc->worksheet['data'][$ws_n]; // Получение данных из рабочего листа if (!$exc->worksheet['unicode'][$ws_n]) { $db_table = $ws_name = $exc->worksheet['name'][$ws_n]; } else { $ws_name = uc2html($exc->worksheet['name'][$ws_n]); $db_table = convertUnicodeString($exc->worksheet['name'][$ws_n]); } echo "<div align=\"center\">Рабочий лист: <b>{$ws_name}</b></div><br>"; $max_row = $ws['max_row']; $max_col = $ws['max_col']; if ($max_row > 0 && $max_col > 0) { getTableData(&$ws, &$exc); } else { fatal("Пустой рабочий лист"); } } } if ($_POST['step'] == 2) { // вставка данных в mysql (шаг 2) echo "<br>"; extract($_POST); $db_table = ereg_replace("[^a-zA-Z0-9\$]", "", $db_table); $db_table = ereg_replace("^[0-9]+", "", $db_table); if (empty($db_table)) { $db_table = "Table1"; } // Проверка соединения с базой данных
function drawGraph($tableName) { require_once 'vendor/jpgraph/jpgraph/lib/JpGraph/src/jpgraph.php'; require_once 'vendor/jpgraph/jpgraph/lib/JpGraph/src/jpgraph_scatter.php'; require_once 'vendor/jpgraph/jpgraph/lib/JpGraph/src/jpgraph_line.php'; require_once 'vendor/jpgraph/jpgraph/lib/JpGraph/src/jpgraph_utils.inc.php'; $GDT = getTableData($tableName); $datax = $GDT['kp']; $datay = $GDT['kpe']; $x1 = array(0, 12); $y1 = array(6.58, 22.78); // $f = new FuncGenerator('cos($x)+1.5*cos(2*$x)'); // list($x1,$y1) = $f->E(0,10); $graph = new Graph(400, 400); $graph->SetScale("linlin"); $graph->img->SetMargin(60, 30, 30, 30); //$graph->img->SetPadding(10,10,10,10) $graph->SetShadow(); $graph->title->Set("Залежність між Кп та Кпе"); //$graph->title->SetFont(DejaVuSans); $graph->yaxis->title->Set('Кп'); $graph->xaxis->title->Set('Кпе'); $sp1 = new ScatterPlot($datay, $datax); $sp2 = new LinePlot($x1, $y1); $graph->Add($sp1); $graph->Add($sp2); $sp2->SetColor("#f00"); $sp2->SetWeight(2); $graph->Stroke(); }
unset($settings_data['promotes']); unset($settings_data['tblvers']); } // load or update settings foreach ($settings_data as $key => $value) { $smcFunc['db_insert']('replace', ' {db_prefix}portamx_settings', array('varname' => 'string', 'config' => 'string'), array($key, $value), array('varname')); } _dbinst_write($dbstr); } } } if (!empty($drop)) { // table exist ? if (!empty($exist)) { $updated[$tblname] = getTableData($tblname, $tblvers); } // drop table $smcFunc['db_drop_table']('{db_prefix}' . $tblname); $exist = false; _dbinst_write('.. Table not identical, dropped.' . $newline); } if (empty($exist)) { // create the table $created[] = $tblname; list($cols, $index, $params) = $tbldef; $smcFunc['db_create_table']('{db_prefix}' . $tblname, $cols, $index, $params, 'error'); _dbinst_write('.. Table successful created.' . $newline); if (!empty($updated[$tblname])) { foreach ($updated[$tblname] as $id => $value) { if ($tblname == 'portamx_blocks') {
} else { Errors::report("Invalid value for action varriable."); return; } } $al->tp->assign('rep', $rep); $al->tp->assign('err', $err); $al->tp->assign('title', 'List of articles'); $al->tp->assign('selMenu', 'article'); $catList = getTableData('categories', $al->db); if (is_string($catList)) { $al->tp->assign('rep', $catList); $catList = null; } if ($catList === false) { $catList = null; } $al->tp->assign('catList', $catList); $data = getTableData("articles", $al->db); if (is_string($data)) { $al->tp->assign('rep', $data); $data = null; } if ($data === false) { $data = null; } $al->tp->assign('data', $data); $body = $al->tp->fetch('admin_menu.tpl'); $body .= $al->tp->fetch("view_arttable.tpl"); $al->tp->assign('body', $body); $al->tp->display('admin.tpl');
} } if (isset($view)) { switch ($view) { case 'delete': if (deleteTable()) { $path = sprintf('location: ' . HTTP_PATH . 'public/views/%s.php', $_POST['page']); header($path); } break; case 'edit': $list = getItemData($page, $_POST['id']); break; case 'list': case 'add': $list = getTableData($page); break; } } //returns a list of all filled rows in the specific table function getTableData($page) { global $db; if (!($_SESSION['user']['user_id'] == 1)) { switch ($page) { case 'appointments': $sql = sprintf('SELECT tbl_%s.* FROM tbl_%s LEFT JOIN tbl_customers ON tbl_%s.customer_id = tbl_customers.customer_id WHERE tbl_customers.deleted_at IS NULL', $page, $page, $page); break;
function showTableDependings($tableName) { $dataTable = <<<EOT <table class="table"> <thead> <tr> <td>№</td> <td>Рівняння</td> <td>Умова розрахунку</td> <td>Граничний параметр</td> <td>Значення граничного параметру</td> <td>Коеф. кореляції</td> </tr> </thead> <tbody> EOT; $GTD = getTableData($tableName); $corelCoeficient = corellationCoeficient($GTD['kpe'], $GTD['kp']); $CAB = calculateAB($GTD['kpe'], $GTD['kp']); $A = $CAB['A']; $B = $CAB['B']; $corelCoeficientValue = number_format($corelCoeficient['value'], 2); $corelCoeficientID = number_format($corelCoeficient['id'], 2); $functionText = "Кп = " . number_format($A, 2) . " * Кп.еф + " . number_format($B, 2); $umovaRoz = $_GET['dependence-data-2']; $granychParam = number_format($A * $umovaRoz + $B, 2); // $x1 = array(0, 12); // $y1 = array(6.58, 22.78); $dataTable .= <<<EOT <tr> <td>1</td> <td>{$functionText}</td> <td>{$umovaRoz}</td> <td>Кп</td> <td>{$granychParam}</td> <td>{$corelCoeficientValue}</td> </tr> EOT; $dataTable .= <<<EOT </tbody> </table> EOT; echo $dataTable; }
$al->tp->assign('rep', "The category permission for id = " . $params[3] . " has been updated."); } else { Errors::report("Parameter 3: " . $params[2] . " is invalid for category toggle operation."); break; } } else { Errors::report("Second parameter of url: " . $params[1] . " is not valid."); break; } } } if (!$al->tp->template_exists($tpl)) { Errors::report("Template file: {$tpl} is missing."); break; } $data = getTableData($table, $al->db); if (is_string($data)) { $al->tp->assign('rep', $data); $data = null; } if ($data === false) { $data = null; } $al->tp->assign('data', $data); $body = $al->tp->fetch('admin_menu.tpl'); $body .= $al->tp->fetch($tpl); $al->tp->assign('body', $body); $al->tp->display('admin.tpl'); break; default: $al->tp->assign('title', 'Invalid request for page.');
if ($action == "edit") { $fields = array('catname', 'mtype', 'date_updated'); $values = array(addslashes(trim($cname)), $mtype, date("Y-m-d H:i:s")); $isUpdated = setRow('categories', $fields, $values, 'update', $al->db, $id); if ($isUpdated) { $rep .= "Category has been updated."; } else { $err .= "Your category was not updated. Please try again."; } } else { Errors::report("Invalid value for action varriable."); return; } } $al->tp->assign('rep', $rep); $al->tp->assign('err', $err); $al->tp->assign('title', 'List of category'); $al->tp->assign('selMenu', 'category'); $data = getTableData("categories", $al->db); if (is_string($data)) { $al->tp->assign('rep', $data); $data = null; } if ($data === false) { $data = null; } $al->tp->assign('data', $data); $body = $al->tp->fetch('admin_menu.tpl'); $body .= $al->tp->fetch("view_cattbl.tpl"); $al->tp->assign('body', $body); $al->tp->display('admin.tpl');
list($month, $day, $year) = explode("/", $_POST['birthdate']); $fields = array("email", "pass", "firstname", "lastname", "gender", "date_ofbirth", "utype", "ustatus", "date_updated"); $values = array(addslashes(trim($email)), addslashes(trim($password)), addslashes(trim($fname)), addslashes(trim($lname)), $sex, $year . "-" . $month . "-" . $day, $utype, $ustatus, date("Y-m-d G:i:s")); $isUpdated = setRow('users', $fields, $values, 'update', $al->db, $uid); if ($isUpdated) { $rep .= "User has been updated."; } else { $err .= "Your user was not updated. Please try again."; } } else { Errors::report("Invalid value for action varriable."); return; } } $al->tp->assign('rep', $rep); $al->tp->assign('err', $err); $al->tp->assign('title', 'List of users'); $al->tp->assign('selMenu', 'category'); $data = getTableData("users", $al->db); if (is_string($data)) { $al->tp->assign('rep', $data); $data = null; } if ($data === false) { $data = null; } $al->tp->assign('data', $data); $body = $al->tp->fetch('admin_menu.tpl'); $body .= $al->tp->fetch("view_usertbl.tpl"); $al->tp->assign('body', $body); $al->tp->display('admin.tpl');
include "../FORMS/usermodal.html"; } //saves the edited values that were submitted from user update modal if ($_POST['change'] === "edit") { $email = $_POST['email']; $fname = $_POST['firstname']; $lname = $_POST['lastname']; $userid = $_POST['primarykey']; $accountlocked = $_POST['accountlocked']; $loginattempts = $_POST['loginattempts']; $sqlupdate = "UPDATE {$table} SET FirstName='{$fname}', LastName = '{$lname}', Email = '{$email}', AccountLocked = {$accountlocked}, LoginAttempts = {$loginattempts} WHERE {$PK}= '{$userid}'"; query($conn, $sqlupdate); } //adds a comment to a request if ($_POST['change'] === 'editrequest') { $comment = $_POST['comment']; $requestid = $_POST['primarykey']; $sqlupdate = "UPDATE {$table} SET Comment = '{$comment}' WHERE {$PK}={$requestid}"; query($conn, $sqlupdate); } //simply generates the table for the admin page. Works for both the requests and users table if ($_POST['change'] === 'none') { $sqlData = "SELECT * FROM {$table}"; $sqlTitles = "SHOW COLUMNS FROM {$table}"; $rsData = getTableData($conn, $sqlData); $rsTitles = getTableData($conn, $sqlTitles); $arrayData = getResultSet($rsData); $arrayTitles = getResultSet($rsTitles); generateTable($table, $PK, $arrayTitles, $arrayData); } }
switch ($_GET['method']) { case 'get_table_names': getTableNames($conn); break; case 'get_table_columns': if (isset($_GET['table_name']) && $_GET['table_name'] != "") { getTableColumns($conn, $_GET['table_name']); } else { $post_data = array('message' => 'missing parameters', 'comment' => 'require param [table_name]'); $post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT); echo $post_data; } break; case 'get_table_data': if (isset($_GET['table_name']) && $_GET['table_name'] != "") { getTableData($conn, $_GET['table_name']); } else { $post_data = array('message' => 'missing parameters', 'comment' => 'require param [table_name]'); $post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT); echo $post_data; } break; case 'login': if (isset($_GET['user_name']) && $_GET['user_name'] != "" && isset($_GET['password']) && $_GET['password'] != "") { login($conn, $_GET['user_name'], $_GET['password']); } else { $post_data = array('message' => 'missing parameters', 'comment' => 'require param [user_name,password]'); $post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT); echo $post_data; } break;
<?php $URLS = [["https://tafetimetables.rmit.edu.au/btsTT/btstimetables.asp?desc=7&group=IT5C&sem=S2&yr=14", "IT5C"], ["https://tafetimetables.rmit.edu.au/btsTT/btstimetables.asp?desc=7&group=IT5B&sem=S2&yr=14", "IT5B"], ["https://tafetimetables.rmit.edu.au/btsTT/btstimetables.asp?desc=7&group=IT5A&sem=S2&yr=14", "IT5A"]]; foreach ($URLS as $URL) { echo "<h1>" . $URL[0] . "</h1>"; $table = getTable($URL[0]); $course = getTableData($table); dbStore($course, $URL[1]); } function getTable($URL) { $page = file_get_contents($URL); $key = "table_wrap'>"; $page = stristr($page, $key); $end = stripos($page, "</div>"); $page = substr($page, strlen($key), $end); return $page; } function getTableData($table) { $rows = explode("<tr", $table); $i = 0; foreach ($rows as $row) { $course_rough[$i] = explode("<td>", $row); $i++; } $count = count($course_rough); $n = 0; $line = array(); $course = array(); for ($i = 2; $i < $count; $i++) {