File: //home/cafsindia/allyindian_com/backend/app/package_model.php
<?php
include('./dbconnect.php');
class package_model{
public function __construct() {
$dbconnect = new dbconnect;
$db = $dbconnect->connect();
}
public function package_info(){
$result = array();
$qry_info = mysql_query("SELECT package_id, package_title FROM `sblttweb_package` where status = 1");
while($qry_rslt = mysql_fetch_array($qry_info)){
$package_id = $qry_rslt['package_id'];
$package_title = $qry_rslt['package_title'];
$result[] = array("package_id"=>$package_id,"package_title"=>$package_title);
}
return $result;
}
public function package_date($package_id){
$result = array();
$qry_info = mysql_query("SELECT dep_date FROM `sblttweb_package` where package_id = '$package_id' and status = 1");
$rslt_count = mysql_num_rows($qry_info);
if((int)$rslt_count === 1){
$qry_rslt = mysql_fetch_array($qry_info);
$dep_date = $qry_rslt['dep_date'];
$result[] = array("dep_date"=>$dep_date,);
}
return $result;
}
}
?>