File manager - Edit - /home/autoph/public_html/connectv1/app/misc/get_dealer3.php
Back
<?php include_once("../../cfg/db.php"); $type = $db->escape($_POST['type']); if($type == 1){ if(isset($_POST['company'])){ $company_value = $_POST['company']; $dealer_list = ""; $query = " SELECT sd.id, sd.code, sd.name FROM `source_company_dealer` scd INNER JOIN source_dealer sd ON scd.dealer_id = sd.id WHERE scd.company_id = '$company_value' AND sd.id != 0 GROUP BY id ORDER by sd.name ASC"; $dealer = $db -> return_result($query); //echo $query; return; $dealer_list = $dealer_list."<option value='0'>ALL</option>"; foreach($dealer as $data){ $dealer_list = $dealer_list."<option value='{$data['id']}'>".$data['code']."</option>"; } echo $dealer_list; } } else if($type == 2){ if(isset($_POST['company'])){ $company_value = $_POST['company']; $dealer_list = ""; $query = " SELECT sd.id, sd.code, sd.name FROM `source_company_dealer` scd INNER JOIN source_dealer sd ON scd.dealer_id = sd.id WHERE scd.company_id = '$company_value' AND sd.id != 0 GROUP BY id ORDER by sd.name ASC"; $dealer = $db -> return_result($query); //echo $query; return; $dealer_list = $dealer_list."<option value=''>ALL</option>"; foreach($dealer as $data){ $dealer_list = $dealer_list."<option value='{$data['id']}'>".$data['code']."</option>"; } echo $dealer_list; } } else if($type == 3){ if(isset($_POST['company'])){ $company_value = $_POST['company']; $dealer_list = ""; $query = " SELECT sd.id, sd.code, sd.name FROM `source_company_dealer` scd INNER JOIN source_dealer sd ON scd.dealer_id = sd.id WHERE scd.company_id = '$company_value' AND sd.id != 0 GROUP BY id ORDER by sd.name ASC"; $dealer = $db -> return_result($query); //echo $query; return; // $dealer_list = $dealer_list."<option value=''>ALL</option>"; foreach($dealer as $data){ $dealer_list = $dealer_list."<option value='{$data['id']}'>".$data['code']."</option>"; } echo $dealer_list; } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings