function get_arr_rowChoice($db, $idQ)
{
if (!isset($_SESSION['map_QC'])) {
$_SESSION['map_QC'] = array();
}
if (isset($_SESSION['map_QC'][$idQ])) {
return $_SESSION['map_QC'][$idQ];
} else {
$result = $db->query("select * from oes_Choice where Question = {$idQ}");
$map_QC = fetch_columns($result);
mysql_free_result($result);
return $_SESSION['map_QC'][$idQ] = $map_QC;
}
}
function getColumns($columns, $table)
{
$result = $this->query("select {$columns} from `{$table}` order by {$columns}");
$ret = fetch_columns($result);
mysql_free_result($result);
return $ret;
}
</HEAD>
<?php
$db = new Database(DB_HOST, DB_USER, DB_PASS);
$db->selectDatabase(DB_NAME);
$res = null;
if (isset($_POST['submit'])) {
$search = $_POST['search'];
$query = "SELECT oes_Question.ID, Text, Name FROM oes_Question join oes_Subject on oes_Subject.ID = oes_Question.Subject where Newer is null and Text like '%" . $search . "%'";
if (($subject = $_POST['subject']) > 0) {
$query .= " AND Subject = " . $subject;
}
$query .= ' limit 10';
try {
$result = $db->query($query);
$res = fetch_columns($result);
mysql_free_result($result);
} catch (Exception $e) {
?>
<center>Xảy ra lỗi trong khi tìm kiếm.</center>
<center>Xin hãy kiểm tra thông tin đã nhập.</center>
<center><button onClick='history.back()'>Trở lại</button></center>
<?php
echo $e->getMessage();
return -1;
}
}
?>
<BODY>
<div align=center>
