เว็บบอร์ด PHP เว็บส่งเสริมการเรียนรู้ Hosting CRM ERP Server Programming ถาม-ตอบปัญหา

โค้ด: เลือกทั้งหมด

$s1 = explode('-',$search);
$a = $s1[0];
$b = $s1[1];



$min   = request_var('min', $a);
$max   = request_var('max', $b);
$start   = request_var('start', 0);
$limit   = request_var('limit', (int)5);


$data = 'SELECT * FROM '.OFFING_TABLE.' as o,'.USERS_TABLE. ' as u 
    where u.user_id = o.name and o.sa_total between abs("'.$min.'") and  abs("'.$max.'") order by o.search_id DESC'; 
$row = "SELECT COUNT(*) AS sumrow FROM ".OFFING_TABLE.' as o,'.USERS_TABLE. ' as u 
    where u.user_id = o.name and o.sa_total between abs("'.$min.'") and abs("'.$max.'")'; 


$result = $db->sql_query($row);

$total_data = (int) $db->sql_fetchfield('sumrow');
$result = $db->sql_query_limit($data, $limit, $start);

while($show = $db->sql_fetchrow($result)){
 $x = ($show[pic] == 0) ? true : false;
     $date1 = $user->format_date($show['date']);
 

   $template->assign_block_vars('somerow1', array(
      'VAR1' => "$show[username]",
      'VAR2' => "$show[sa_m]",
       'VAR3' => "$show[sa_f]",
       'VAR4' => "$show[age_m]",
       'VAR5' => "$show[age_f]",
       'VAR6' => "$show[status_l]",
       'VAR7' => "$show[status_c]",
       'VAR8' => "$show[status_ma]",
       'VAR9' => "$show[status_f]",
       'VAR10' => "$show[status_ceo]",
       'VAR11' => "$show[time]",
       'VAR12' => "$show[money]",
       'VAR13' => "$show[ip]",
       'VAR14' => "$show[search_id]",
       'VAR15'  =>  "$x",
       'VAR16'  =>  "$show[user_id]",
        'VAR17' => "$date1",
       
      
   ));
}


$pagination_url = append_sid($phpbb_root_path . 'calculate_dowry.' . $phpEx."?search=".$search,'');




$template->assign_vars(array(
      'PAGINATION'        => generate_pagination($pagination_url, $total_data, $limit, $start),
      'PAGE_NUMBER'       => on_page($total_data, $limit, $start), 
));
  

โค้ด: เลือกทั้งหมด

<table class="tablebg" width="100%" cellspacing="1" >

    <tr class="row2" align="center" style="color:#FFA34F; white-space: nowrap;padding: 7px 5px;font-weight: bold;background-color: #006699;background-image: url('./images/cellpic3.gif');font-size: 1.1em;">
            <td >{L_NAME}:</td>
            <td>{L_SA_M}:</td>
            <td>{L_SA_F}:</td>
            <td>{L_AGE_M}:</td>
            <td>{L_AGE_F}:</td>
            <td>{L_STATUS_L}:</td>
            <td>{L_STATUS_C}:</td>
            <td>{L_STATUS_MA}:</td>
            <td>{L_STATUS_F}:</td>
            <td>{L_STATUS_CEO}:</td>
            <td>{L_TIME}:</td>
            <td>{L_MONEY}:</td>
            <td>{L_IP}:</td>
            <td>{L_DATE}</td>
            <td>{L_PIC}</td>
		</tr>
		
	 <!-- BEGIN somerow1 -->
        <tr class="row2"  style="white-space: nowrap;" align="center">
             <td><span class="rank-img"><a href="memberlist.php?mode=viewprofile&u={somerow1.VAR16}">{somerow1.VAR1}</td>
             <td>{somerow1.VAR2}</td>
             <td>{somerow1.VAR3}</td>
             <td>{somerow1.VAR4}</td>
             <td>{somerow1.VAR5}</td>
             <td>{somerow1.VAR6}</td>
             <td>{somerow1.VAR7}</td>
             <td>{somerow1.VAR8}</td>
             <td>{somerow1.VAR9}</td>
             <td>{somerow1.VAR10}</td>
             <td>{somerow1.VAR11}</td>
             <td>{somerow1.VAR12}</td>
             <td>{somerow1.VAR13}</td>
             <td>{somerow1.VAR17}</td>
             <!-- IF somerow1.VAR15 -->
             <td><a href="calculate_dowry_showpicture.php?id={somerow1.VAR14}">{L_NOPIC}</td>
             <!-- ELSE -->
             <td><a href="calculate_dowry_showpicture.php?id={somerow1.VAR14}">{L_PIC}</td>
             <!-- ENDIF -->
     
     
         </tr>
         <!-- END somerow1 -->
         
		

	</table>