assign('toolbar', Utility::toolbar_bootstrap($interface_menu, false, $interface_icon));
$xoTheme->addStylesheet('modules/tad_idioms/css/module.css');
require_once XOOPS_ROOT_PATH . '/footer.php';
/*-----------function區--------------*/
//列出所有tad_idioms資料
function list_tad_idioms($show_sn = '')
{
global $xoopsDB, $xoopsTpl;
$andkeyword = '';
if (isset($_POST['keyword'])) {
$keyword = $xoopsDB->escape($_POST['keyword']);
$andkeyword = " where `title` like '%{$keyword}%' or `mean` like '%{$keyword}%'";
}
$sql = 'select * from ' . $xoopsDB->prefix('tad_idioms') . " $andkeyword";
//Utility::getPageBar($原sql語法, 每頁顯示幾筆資料, 最多顯示幾個頁數選項);
$PageBar = Utility::getPageBar($sql, 20, 10);
$bar = $PageBar['bar'];
$sql = $PageBar['sql'];
$total = $PageBar['total'];
$result = $xoopsDB->query($sql) or Utility::web_error($sql, __FILE__, __LINE__);
$all_content = [];
$i = 0;
while (false !== ($all = $xoopsDB->fetchArray($result))) {
//以下會產生這些變數： $sn , $title , $juin , $mean , $show_times , $search_times , $cate
foreach ($all as $k => $v) {
$$k = $v;
}
$ji = explode(' ', $juin);
$main = '';
$sound = [_MD_TADIDIOMS_2, _MD_TADIDIOMS_3, _MD_TADIDIOMS_4, _MD_TADIDIOMS_5];
foreach ($ji as $n => $juin) {
$sud = substr($juin, -2);
if (in_array($sud, $sound)) {
$juin = substr($juin, 0, -2);
$lh = strlen($juin) > 6 ? 80 : 120;
} else {
$sud = ' ';
$lh = strlen($juin) > 6 ? 80 : 120;
}
$m = $n * 3;
$txt = substr($title, $m, 3);
$main .= "
| $txt |
$juin |
$sud |
";
}
$newsn = sprintf('%1$03d', $sn);
$all_content[$i]['current'] = $sn == $show_sn ? 1 : 0;
$all_content[$i]['name'] = $sn;
$all_content[$i]['sn'] = $newsn;
$all_content[$i]['main'] = $main;
$all_content[$i]['mean'] = $mean;
$all_content[$i]['title'] = $title;
++$i;
}
$xoopsTpl->assign('bar', $bar);
$xoopsTpl->assign('all_content', $all_content);
}