PHP Guide_DB::Select_PW Examples

Example #1

File: special.php Project: GHubgenius/qbbj

                }
                $show .= "<tr align='center' class='trA' onmouseover=\"this.className='trB'\" onmouseout=\"this.className='trA'\"> \n\t\t\t\t\t<td width='5%'>{$rs[tid]}</td>\n\t\t\t\t\t<td width='84%' align='left'><a href='{$webdb['passport_url']}/viewthread.php?tid={$rs['tid']}' target=_blank>{$rs['subject']}</a></td>\n\t\t\t\t\t<td width='11%'>&nbsp;{$add}</td>\n\t\t\t\t  </tr>";
            }
        }
        $show = "<table width='100%' border='0' cellspacing='1' cellpadding='3'>\n              <tr align='center' bgcolor='#eeeeee'> \n                <td width='5%'>ID</td>\n                <td width='84%'>标 题</td>\n                <td width='11%' bgcolor='#eeeeee'>添加</td>\n\t\t\t\t  {$show}\n              </tr>\n\t\t\t  \n            </table>";
        $show = str_replace("\r", "", $show);
        $show = str_replace("\n", "", $show);
        $show = str_replace('"', '\\"', $show);
        echo "<SCRIPT LANGUAGE='JavaScript'>\n\t\t<!--\n\t\tparent.document.getElementById('show_myatc').innerHTML=\"{$show}\";\n\t\t//-->\n\t\t</SCRIPT>";
        $showpage = str_replace("\r", "", $showpage);
        $showpage = str_replace("\n", "", $showpage);
        $showpage = str_replace('"', "", $showpage);
        $showpage = str_replace("href=&page=", "target='spiframe' href=special.php?job=show_BBSiframe&id={$id}&fid={$fid}&type=myatc&ismy={$ismy}&keywords=" . urlencode($keywords) . "&page=", $showpage);
        echo "<SCRIPT LANGUAGE='JavaScript'>\n\t\t<!--\n\t\tparent.document.getElementById('show_myatc_page').innerHTML=\"{$showpage}\";\n\t\t//-->\n\t\t</SCRIPT>";
        //论坛栏目
        $sort_fid = $Guidedb->Select_PW("fid", $fid);
        $sort_fid = str_replace("\r", "", $sort_fid);
        $sort_fid = str_replace("\n", "", $sort_fid);
        $sort_fid = str_replace('"', "", $sort_fid);
        $ismy ? $color_me = 'red' : ($color_all = 'red');
        $sort_fid = str_replace("<select name='fid'", "[<A target='spiframe'  HREF='special.php?job=show_BBSiframe&id={$id}&type=myatc&fid={$fid}&ismy=1' style='color:{$color_me};'>我的贴子</A>] [<A target='spiframe'  HREF='special.php?job=show_BBSiframe&id={$id}&type=myatc&fid={$fid}' style='color:{$color_all};'>所有贴子</A>] <select onChange='fid_jumpMenu(this)'", $sort_fid);
        echo "<SCRIPT LANGUAGE='JavaScript'>\n\t\t<!--\n\t\tparent.document.getElementById('show_myatc_fid').innerHTML=\"{$sort_fid}\";\n\t\t//-->\n\t\t</SCRIPT>";
    }
}
function group_box($name = "postdb[group]", $ckdb = array(), $type = '')
{
    global $db, $pre;
    if ($type == 1) {
        $SQL = " WHERE gptype=1 AND gid NOT IN(2,3,4) ";
    }
    $query = $db->query("SELECT * FROM {$pre}group {$SQL} ORDER BY gid ASC");