Beispiel #1
0
             }
             $html .= '<td><label><input type="checkbox" value="' . $row1['sys_id'] . '"/>&nbsp;' . $row1['description'] . '</label></td>';
             $j++;
             if ($j === 3) {
                 $html .= '</tr>';
                 $j = 0;
             }
         }
         if ($blank_cell < 3) {
             for ($i = 1; $i <= $blank_cell; $i++) {
                 $html .= '<td>&nbsp;</td>';
             }
             $html .= '</tr>';
         }
     }
     MainConfig::closeDB();
     echo $html;
     //
 } else {
     if ($_POST['table'] == 'tbl_web_homepg') {
         $query = "SELECT\r\n        web_homepg.wh_id,\r\n        web_homepg.wh_image,\r\n        web_homepg.wh_head1\r\n        FROM\r\n        web_homepg WHERE\r\n        web_homepg.wh_section = '{$_POST['section']}'";
         $system->prepareSelectQueryForJSON($query);
     } else {
         if ($_POST['table'] == 'vehicle_spec_table') {
             $query = "SELECT\r\n        vh_tech_spec.spec_title,\r\n        vh_tech_spec.spec_id,\r\n        vh_tech_spec.eng_cc,\r\n        vh_tech_spec.eng_rpm,\r\n        vh_tech_spec.perf_max_speed,\r\n        vh_tech_spec.trans_type,\r\n        vh_tech_spec.fuel_cons_highway,\r\n        vh_tech_spec.bd_curb_weight,\r\n        vh_tech_spec.cap_fuel_tank\r\n        FROM\r\n        vh_tech_spec\r\n        WHERE\r\n        vh_tech_spec.mod_id = '{$_POST['model_id']}'";
             $system->prepareSelectQueryForJSON($query);
         } else {
             if ($_POST['table'] == 'sendWeb_selectedVh') {
                 $query = "SELECT\r\n        vehicle.vh_code,\r\n        maker_model.mod_name,\r\n        vehicle.package,\r\n        vehicle.vh_year,\r\n        vehicle.vh_color,\r\n        vehicle.vh_id,\r\n        maker_model.mod_id\r\n        FROM\r\n        vehicle\r\n        INNER JOIN maker_model ON vehicle.vh_maker_model = maker_model.mod_id\r\n        WHERE\r\n        vehicle.vh_id IN ({$_POST['idlist']})";
                 $system->prepareSelectQueryForJSON($query);
             } else {
Beispiel #2
0
 function getCountByQuery($query)
 {
     $count = 0;
     MainConfig::connectDB();
     $queryResult = mysql_query($query);
     $count = mysql_num_rows($queryResult);
     MainConfig::closeDB();
     return $count;
 }