PHP CLS_MYSQL Examples

Example #1

File: cls.workflow_task.php Project: hunglmtb/eb

 public function getIdTaskByWf($wfid)
 {
     $sql = "SELECT `id` FROM {$this->_tbl} WHERE `wf_id`={$wfid} ";
     $objmysql = new CLS_MYSQL();
     $objmysql->Query($sql);
     $ar = array();
     while ($r = $objmysql->Fetch_Assoc()) {
         $ar[] = $r['id'];
     }
     return $ar;
 }

Example #2

File: forgot_password.php Project: nuthankumarns/vts-source---services

 public function forgotPassword($email)
 {
     //var_dump($email);exit();
     $query = CLS_MYSQL::Query("SELECT user_name,user_mail FROM users WHERE user_mail='{$email}'");
     //echo "SELECT user_name,user_mail FROM users WHERE user_mail='$email'";
     //var_dump($query);exit();
     $count = CLS_MYSQL::GetResultNumber($query);
     if ($count == 0) {
         $data = "Email does not exist";
         $this->display($data);
     } else {
         $user_name = CLS_MYSQL::GetResultValue($query, 0, 'user_name');
         $string = $this->random_string();
         //var_dump($string);
         //var_dump($rand);
         //echo sha1($string);
         //echo "9011d6581a45b82e5f559063c4aa6d367e5c3ac5";
         //var_dump(sha1($string));exit();
         $this->resetPasscode($string, $email);
         //exit();
         $Email = new VTSMail();
         $Email->setName($user_name);
         //To name
         $Email->setMail($email);
         //To e-mail
         $Email->setSubject("Registration");
         //Subject
         $Email->setMessage("Password Reset Successful\n Your Passcode:{$string}");
         $Email->sendMail();
         $this->display('Password reset successful');
     }
 }

Example #3

File: gmt.php Project: nuthankumarns/vts-source---services

 public function getFullGmtData($split)
 {
     $query = CLS_MYSQL::Query("SELECT * FROM gmt_zones");
     $count = CLS_MYSQL::GetResultNumber($query);
     //echo"<pre>";
     //var_dump($query);
     for ($i = 0; $i < $count; $i++) {
         $data['Result']['Data'][$i]['gmt_id'] = CLS_MYSQL::GetResultValue($query, $i, 'id');
         $data['Result']['Data'][$i]['gmt'] = CLS_MYSQL::GetResultValue($query, $i, 'gmt');
         $data['Result']['Data'][$i]['secondsDiff'] = CLS_MYSQL::GetResultValue($query, $i, 'secondsDiff');
         //$data['Result']['Data'][$i]['Location']=CLS_MYSQL::GetResultValue($query,$i,'Location');
         //print_r($location);
         //$spl=preg_split('/(,(?: ))/', $location);
         $location = CLS_MYSQL::GetResultValue($query, $i, 'Location');
         /*if($split==1)
         		{
         		$data['Result']['Data'][$i]['Location']=preg_split('/(,(?: ))/', $location);
         		}
         		else
         		{
         		$data['Result']['Data'][$i]['Location']=$location;
         		}*/
         $data['Result']['Data'][$i]['Location'] = $split == 1 ? preg_split('/(,(?: ))/', $location) : $location;
         //print_r($spl);
         //exit();
     }
     $this->display($data);
 }

Example #4

File: cls.guser.php Project: hunglmtb/eb

 function listTableGmem($strwhere = "", $page, $parid, $level)
 {
     $star = ($page - 1) * MAX_ROWS;
     $leng = MAX_ROWS;
     $sql = "SELECT * FROM `tbl_gmember` WHERE `par_id`=\"{$parid}\" " . $strwhere . " LIMIT {$star},{$leng}";
     $objdata = new CLS_MYSQL();
     $objdata->Query($sql);
     $str_space = "";
     if ($level != 0) {
         for ($i = 1; $i < $level; $i++) {
             $str_space .= "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
         }
         $str_space .= "|--- ";
     }
     while ($rows = $objdata->Fetch_Assoc()) {
         $id = $rows['gmem_id'];
         $parid = $rows['par_id'];
         $name = $rows['name'];
         $intro = stripslashes(uncodeHTML($rows['intro']));
         echo "<tr name=\"trow\">";
         echo "<td width=\"30\" align=\"center\"><label>";
         echo "<input type=\"checkbox\" name=\"chk\" id=\"chk\" onclick=\"docheckonce('chk');\" value=\"{$id}\" />";
         echo "</label></td>";
         echo "<td width=\"50\" align=\"center\">{$parid}</td>";
         echo "<td nowrap=\"nowrap\">\n\t\t\t\t<a href=\"index.php?com=" . COMS . "&amp;task=edit&amp;id={$id}\">{$str_space}{$name}</a>\n\t\t\t</td>";
         echo "<td nowrap=\"nowrap\">{$intro} &nbsp;</td>";
         echo "<td width=\"50\" align=\"center\">";
         echo "<a href=\"index.php?com=" . COMS . "&amp;task=active&amp;id={$id}\">";
         showIconFun('publish', $rows["isactive"]);
         echo "</a>";
         echo "</td>";
         echo "<td width=\"50\" align=\"center\">";
         echo "<a href=\"index.php?com=" . COMS . "&amp;task=edit&amp;id={$id}\">";
         showIconFun('edit', '');
         echo "</a>";
         echo "</td>";
         echo "<td width=\"50\" align=\"center\">";
         echo "<a href=\"javascript:detele_field('index.php?com=" . COMS . "&amp;task=delete&amp;id={$id}')\">";
         showIconFun('delete', '');
         echo "</a>";
         echo "</td>";
         echo "</tr>";
         $this->listTableGmem($strwhere, $page, $id, $level + 1);
     }
 }

Example #5

File: faq.php Project: nuthankumarns/vts-source---services

 public function fetchFaq()
 {
     $query = CLS_MYSQL::Query("SELECT * FROM faq");
     $count = CLS_MYSQL::GetResultNumber($query);
     for ($i = 0; $i < $count; $i++) {
         $dataDB['Result']['Data'][$i]['Faq'] = CLS_MYSQL::GetResultValue($query, $i, 'faq');
     }
     $this->display($dataDB);
 }

Example #6

File: config.php Project: nuthankumarns/vts-source---services

 function __construct()
 {
     $this->DATABASE["server"] = "localhost";
     $this->DATABASE["port"] = "3306";
     $this->DATABASE["username"] = "******";
     $this->DATABASE["password"] = "******";
     $this->DATABASE["database"] = "vts";
     parent::CLS_MYSQL($this->DATABASE);
     parent::Connect();
 }

Example #7

File: apn.php Project: nuthankumarns/vts-source---services

 public function getFullApnData()
 {
     $query = CLS_MYSQL::Query("SELECT * FROM apn_settings");
     $count = CLS_MYSQL::GetResultNumber($query);
     //echo"<pre>";
     //var_dump($query);
     for ($i = 0; $i < $count; $i++) {
         $data['Result']['Data'][$i]['apn_id'] = CLS_MYSQL::GetResultValue($query, $i, 'id');
         $data['Result']['Data'][$i]['apn_settings'] = CLS_MYSQL::GetResultValue($query, $i, 'apn_settings');
         $data['Result']['Data'][$i]['network'] = CLS_MYSQL::GetResultValue($query, $i, 'network');
         $data['Result']['Data'][$i]['country'] = CLS_MYSQL::GetResultValue($query, $i, 'country');
     }
     $this->display($data);
 }

Example #8

File: get_vehicle.php Project: nuthankumarns/vts-source---services

 function vehicleDetails($user_id)
 {
     $query = CLS_MYSQL::Query("SELECT * FROM user_devices WHERE user_id='{$user_id}'");
     $count = CLS_MYSQL::GetResultNumber($query);
     if ($count == 0) {
         $dataDB['Result']['Data'][0]['Status'] = "no vehicle";
     } else {
         for ($i = 0; $i < $count; $i++) {
             $dataDB['Result']['Data'][$i]['uid'] = CLS_MYSQL::GetResultValue($query, $i, 'uid');
             $dataDB['Result']['Data'][$i]['alias'] = CLS_MYSQL::GetResultValue($query, $i, 'alias');
         }
     }
     $this->display($dataDB);
 }

Example #9

File: cls.users.php Project: hunglmtb/eb

 function getMemberByID($memid)
 {
     $sql = "SELECT * FROM `tbl_member` WHERE `mem_id`=\"{$memid}\" ";
     $objdata = new CLS_MYSQL();
     $objdata->Query($sql);
     if ($objdata->Num_rows() > 0) {
         $rows = $objdata->Fetch_Assoc();
         $this->pro['ID'] = $rows['mem_id'];
         $this->pro['UserName'] = $rows['username'];
         $this->pro['Password'] = $rows['password'];
         $this->pro['FirstName'] = $rows['firstname'];
         $this->pro['LastName'] = $rows['lastname'];
         $this->pro['Birthday'] = $rows['birthday'];
         $this->pro['Gender'] = $rows['gender'];
         $this->pro['Address'] = $rows['address'];
         $this->pro['Phone'] = $rows['phone'];
         $this->pro['Mobile'] = $rows['mobile'];
         $this->pro['Email'] = $rows['email'];
         $this->pro['Joindate'] = $rows['joindate'];
         $this->pro['LastLogin'] = $rows['lastlogin'];
         $this->pro['Gmember'] = $rows['gmem_id'];
         $this->pro['isActive'] = $rows['isactive'];
     }
 }

Example #10

File: login_api.php Project: nuthankumarns/vts-source---services

 function getDevices($id)
 {
     $query = CLS_MYSQL::Query("SELECT b. *\nFROM users AS a\nLEFT JOIN user_devices AS b ON a.user_id = b.user_id\nWHERE a.user_id = '{$id}'");
     $count = CLS_MYSQL::GetResultNumber($query);
     for ($i = 0; $i < $count; $i++) {
         $dataDB['Result']['Data'][$i]['user_device_id'] = CLS_MYSQL::GetResultValue($query, $i, 'id');
         $dataDB['Result']['Data'][$i]['mobile_num'] = CLS_MYSQL::GetResultValue($query, $i, 'mobile');
         //$dataDB['Result']['Data'][$i]['offset']=CLS_MYSQL::GetResultValue($query,$i,'offset');
         $dataDB['Result']['Data'][$i]['uid'] = CLS_MYSQL::GetResultValue($query, $i, 'uid');
         $dataDB['Result']['Data'][$i]['alias'] = CLS_MYSQL::GetResultValue($query, $i, 'alias');
     }
     //$dataDB['Result']['id']=session_id();
     $dataDB['Result']['user_id'] = $id;
     $dataDB['Result']['Status'] = "Successfully logged in";
     $this->display($dataDB);
 }

Example #11

File: latlong1 (copy).php Project: nuthankumarns/vts-source---services

 function logDetails($date1, $time1, $date2, $time2, $imei)
 {
     //$uid='12';
     $Timestamp1 = $this->makeTimestamp($date1, $time1);
     $Timestamp2 = $this->makeTimestamp($date2, $time2);
     $query = CLS_MYSQL::Query("SELECT * FROM track_data where activity BETWEEN '{$Timestamp1}' AND '{$Timestamp2}' AND imei='{$imei}'");
     $count = CLS_MYSQL::GetResultNumber($query);
     //echo $count;
     if ($count == 0) {
         $dataDB['Result']['Data'][0]['Status'] = "No data";
     } else {
         for ($i = 0; $i < $count; $i++) {
             //$dataDB['Result']['Data'][$i]['uid'] = CLS_MYSQL::GetResultValue($this->query,$i,'uid');
             $latitude[$i] = CLS_MYSQL::GetResultValue($query, $i, 'latitude');
             $longitude[$i] = CLS_MYSQL::GetResultValue($query, $i, 'longitude');
             // $dataDB['Result']['Data'][$i]['date_time'] = CLS_MYSQL::GetResultValue($query,$i,'date_time');
         }
     }
     //var_dump($latitude);
     $this->traceRoute($latitude, $longitude, $count);
 }

Example #12

File: gmt.class.php Project: nuthankumarns/vts-source---services

 /**
  * Defines the class variable required for conversion
  * Dont call this function. It is used internally
  */
 private function setZoneSecDiff()
 {
     if (empty($this->zoneId)) {
         $this->zoneSecDiff = 0;
         return;
     }
     $query = CLS_MYSQL::Query('SELECT secondsDiff FROM gmt_zones WHERE id = ' . $this->zoneId);
     //if(!$this->dbH)
     //$this->connectDB();
     //$recordSet 			= mysql_query($query, $this->dbH);
     $recordSet = CLS_MYSQL::GetResultNumber($query);
     if ($recordSet != 1) {
         die('Error : Invalid zone id');
     }
     //$this->zoneSecDiff	= mysql_result($recordSet, 0);
     $this->zoneSecDiff = CLS_MYSQL::GetResultValue($recordSet, 0, 'secondsDiff');
 }

Example #13

File: class_registration.php Project: nuthankumarns/vts-source---services

 /**
  * Register user in the database
  *
  * The user form data needed is: user_name, user_pass, user_confirm_pass, user_mail, user_confirm_mail
  */
 public function setUserRegistration()
 {
     if (!$this->databaseUsersTable) {
         $this->getMessage('Users table in the database is not specified. Please specify it before any other operation using the method setDatabaseUserTable();', '', '', 'true');
     }
     $user_name = $this->setEscape($_REQUEST['user_name']);
     $user_pass = $_REQUEST['user_pass'];
     $uid = $_REQUEST['uid'];
     $mobile = $_REQUEST['mobile'];
     $offset = $_REQUEST['offset'];
     $alias = $_REQUEST['alias'];
     //$user_confirm_pass=$_POST['user_confirm_pass'];
     $user_mail = $_REQUEST['user_mail'];
     // $user_confirm_mail=$_POST['user_confirm_mail'];
     $user_crypted_pass = $this->setCrypt($user_pass);
     $query = CLS_MYSQL::Query("SELECT a.*,b.* FROM" . " " . $this->databaseUsersTable . " AS a LEFT JOIN user_devices AS b on a.user_id=b.user_id WHERE a.user_name='{$user_name}'");
     // $result_user_mail=CLS_MYSQL::Query("SELECT * FROM"." ".$this->databaseUsersTable." "."WHERE user_mail='$user_mail'");
     $result_user_name = CLS_MYSQL::GetResultValue($query, 0, 'user_name');
     //$uid==CLS_MYSQL::GetResultValue($query,0,'uid');
     //var_dump($uid);
     if ($uid == CLS_MYSQL::GetResultValue($query, 0, 'uid')) {
         $this->display('device id already exist');
     } elseif (strlen($user_name) < 6 or strlen($user_name) > 16) {
         $this->display('Entered username length must be of 6 to 16 characters');
     } elseif (strlen($user_pass) < 6 or strlen($user_pass) > 16) {
         $this->display('Entered password length must be of 8 to 16 characters');
     } elseif (!preg_match("/^([a-zA-Z0-9_\\.\\-])+\\@(([a-zA-Z0-9\\-]{4,})+\\.)+([a-zA-Z0-9]{2,})+\$/", $user_mail)) {
         $this->display('Email address entered is not valid');
     } else {
         if (CLS_MYSQL::Execute("INSERT INTO" . " " . $this->databaseUsersTable . " " . "(user_name, user_pass, user_mail) VALUES ('{$user_name}', '{$user_crypted_pass}', '{$user_mail}')")) {
             $insert_id = mysql_insert_id();
         }
         CLS_MYSQL::Execute("INSERT INTO user_devices (user_id, mobile, offset, uid, alias) VALUES ('{$insert_id}','{$mobile}','{$offset}','{$uid}','{$alias}')");
         $Email = new VTSMail();
         $Email->setName($user_name);
         //To name
         $Email->setMail($user_mail);
         //To e-mail
         $Email->setSubject("Registration");
         //Subject
         $Email->setMessage("VTS Registration Successful \n username:{$user_name} \n password:{$user_pass}");
         $Email->sendMail();
         $this->display('Registration was successful');
     }
 }

Example #14

File: location.php Project: nuthankumarns/vts-source---services

 function geoFencing($device_id, $out_range, $range)
 {
     //$query=CLS_MYSQL::Query("SELECT range,out_range FROM user_devices WHERE uid='$uid'");
     //$range=CLS_MYSQL::GetResultValue($query,0,'range');
     //$out_range=CLS_MYSQL::GetResultValue($query,0,'out_range');
     //var_dump($out_range);
     if ($out_range != 0) {
         $query = CLS_MYSQL::Query("SELECT out_range\n\t\t\t\tFROM user_devices WHERE id = '{$device_id}'");
         $count = CLS_MYSQL::GetResultNumber($query);
         if ($count == 0) {
             $dataDB['Result']['Data'][0]['Status'] = "no data";
         } else {
             for ($i = 0; $i < $count; $i++) {
                 //$dataDB[$i]['lat_ref']=CLS_MYSQL::GetResultValue($query,0,'lat_ref');
                 //$dataDB[$i]['long_ref']=CLS_MYSQL::GetResultValue($query,0,'long_ref');
                 //$dataDB[$i]['lat_set']=CLS_MYSQL::GetResultValue($query,0,'lat_set');
                 //$dataDB[$i]['long_set']=CLS_MYSQL::GetResultValue($query,0,'long_set');
                 //$dataDB[$i]['preset_range']=CLS_MYSQL::GetResultValue($query,0,'range');
                 $dataDB['out_range'] = CLS_MYSQL::GetResultValue($query, 0, 'out_range');
             }
         }
         return $dataDB;
         //$this->display($dataDB);
     }
     //return '';
 }

Example #15

File: device.php Project: nuthankumarns/vts-source---services

 function InsertToken($app_id, $device_token)
 {
     $query = CLS_MYSQL::Execute("INSERT INTO apns (app_id,device_token) VALUES('{$app_id}','{$device_token}')");
     $dataDB['Result']['Data'][0]['Status'] = $query == true ? "Success" : "Failure";
     $this->display($dataDB);
 }

Example #16

File: location.php Project: nuthankumarns/vts-source---services

 function customMessage($uid, $message)
 {
     //$message=mysql_real_escape_string($message);
     $query = CLS_MYSQL::Execute("UPDATE user_devices SET message='{$message}',ack='1' WHERE uid='{$uid}'");
     $dataDB['Result']['Data'][0]['Status'] = $query == true ? "message tracked" : "message track failure";
     $this->display($dataDB);
 }

Example #17

File: latlong.php Project: nuthankumarns/vts-source---services

 function checkPoint($lat_ref, $long_ref, $imei, $range)
 {
     $query = CLS_MYSQL::Query("SELECT latitude,longitude FROM track_data WHERE imei='{$imei}' ORDER BY activity DESC LIMIT 1");
     $latitude = CLS_MYSQL::GetResultValue($query, 0, 'latitude');
     $longitude = CLS_MYSQL::GetResultValue($query, 0, 'longitude');
     $distance = $this->distance($latitude, $longitude, $lat_ref, $long_ref, 'M');
     echo $distance;
     echo $range;
     var_dump($imei);
     echo "UPDATE user_devices SET lat_ref='{$lat_ref}',long_ref='{$long_ref}',range='{$range}',out_range='',geo_status='1',read_status='1' WHERE uid='{$imei}'";
     //$query=CLS_MYSQL::Execute("UPDATE user_devices SET lat_ref='$lat_ref',long_ref='$long_ref',range='$range',out_range='',geo_status='1',read_status='1' WHERE uid='$imei'");
     $dataDB['Result']['Data'][0]['Status'] = $query == true ? "geo_fensing success" : "geo_fensing failure";
     if ($distance > $range) {
         $dataDB['Result']['Data'][0]['alert'] = "vehicle out of location";
         //echo "me";
     }
     $this->display($dataDB);
 }

Example #18

File: latlong.php Project: nuthankumarns/vts-source---services

 function localTime($device_id)
 {
     $query = CLS_MYSQL::Query("SELECT a.secondsDiff FROM gmt_zones AS a LEFT JOIN user_devices AS b ON a.id=b.offset WHERE b.id='{$device_id}'");
     //echo "SELECT a.*,b.* FROM gmt_zones AS a LEFT JOIN user_devices AS b ON a.id=b.offset WHERE b.id='$device_id'";
     $result = CLS_MYSQL::GetResultValue($query, 0, 'secondsDiff');
     return $result;
 }

Example #19

File: wfshow.php Project: hunglmtb/eb

$username = $current_username;
$wf_id = $_REQUEST["wf_id"];
//echo "xxxx $wf_id yyy";
?>
<html>
<head>
<title>Workflow Display</title>
<link rel="stylesheet" href="../common/css/style.css">
<script src="../common/js/jquery-1.9.1.js"></script>
<script src="../common/utils.js"></script>
<script src="../common/js/base64.js"></script>
<script src="js/wfshow.js?8"></script>
<?php 
$sql = "SELECT * FROM tm_workflow WHERE isrun='YES' AND id in(SELECT wf_id FROM tm_workflow_task WHERE isrun in (2,3) AND (user LIKE '%,{$username},%' OR user LIKE '{$username},%'))";
$mysql_task = new CLS_MYSQL();
$objmysql = new CLS_MYSQL();
$objmysql->Query($sql);
$wfs = "";
$c = 0;
while ($r = $objmysql->Fetch_Assoc()) {
    $data = $r['data'];
    if (!($wf_id > 0)) {
        $wf_id = $r['id'];
    }
    $selected = $r['id'] == $wf_id ? "selected" : "";
    $wfs .= "<option value='{$r['id']}' {$selected}>{$r['name']}</option>";
    $sql = "SELECT id FROM tm_workflow_task WHERE isrun=2 AND (user LIKE '%,{$username},%' OR user LIKE '{$username},%')";
    $mysql_task->Query($sql);
    $c++;
}
if ($c === 0) {

Example #20

File: class_registration.php Project: nuthankumarns/vts-source---services

 public function updateDetails()
 {
     if (!$this->databaseUsersTable) {
         $this->getMessage('contact nuthan', '', '', 'true');
     }
     $admin_mob = $_REQUEST['admin_mob'];
     $apn = $_REQUEST['apn'];
     $mobile = $_REQUEST['mobile'];
     $offset = $_REQUEST['offset'];
     $alias = $_REQUEST['alias'];
     $device_id = $_REQUEST['device_id'];
     $this->updateFields($mobile, $offset, $alias, $admin_mob, $apn, $device_id);
     $query = CLS_MYSQL::Execute("UPDATE user_devices SET admin_mob='{$admin_mob}',apn_settings='{$apn}',mobile='{$mobile}',offset='{$offset}',alias='{$alias}' WHERE id='{$device_id}'");
     //$count=CLS_MYSQL::GetResultNumber($query);
     $rows = CLS_MYSQL::AffectedRows($query);
     if ($rows == 1) {
         $Email = new VTSMail();
         $Email->setName($user_name);
         //To name
         $Email->setMail($user_mail);
         //To e-mail
         $Email->setSubject("VTS Updation");
         //Subject
         $Email->setMessage("VTS Updation for Device");
         $Email->sendMail();
         //var_dump($Email);
         $this->display('Updation was successful');
     } else {
         $this->display('Fields Remain same');
     }
 }

Example #21

File: location_try.php Project: nuthankumarns/vts-source---services

 function logDetails($date1, $time1, $date2, $time2, $uid)
 {
     $Timestamp1 = $this->makeTimestamp($date1, $time1);
     //echo $Timestamp1;echo "<br/>";
     $Timestamp2 = $this->makeTimestamp($date2, $time2);
     //echo $Timestamp2;echo "<br/>";
     $this->query = CLS_MYSQL::Query("SELECT gid,uid, latitude, longitude,FROM_UNIXTIME(UTC) AS date_time FROM gprs where UTC BETWEEN '{$Timestamp1}' AND '{$Timestamp2}' AND uid='12'");
     //08-07-2011&time1=06:01:07
     //echo mktime(06,01,07,07,08,2011);
     //echo date("Y-m-d H:i:s",1310130067);
     $a = "SELECT gid,uid, latitude, longitude,FROM_UNIXTIME(UTC) AS date_time FROM gprs where UTC BETWEEN '{$Timestamp1}' AND '{$Timestamp2}' AND uid='12'";
     //echo $a;
     $this->count = CLS_MYSQL::GetResultNumber($this->query);
     if ($this->count == 0) {
         $dataDB['Result']['Data'][0]['Status'] = "No data";
     } else {
         for ($i = 0; $i < $this->count; $i++) {
             // $dataDB['Result']['Data'][$i]['gid'] = CLS_MYSQL::GetResultValue($this->query,$i,'gid');
             // $dataDB['Result']['Data'][$i]['uid'] = CLS_MYSQL::GetResultValue($this->query,$i,'uid');
             $dataDB['Result']['Data'][$i]['latitude'] = CLS_MYSQL::GetResultValue($this->query, $i, 'latitude');
             $dataDB['Result']['Data'][$i]['longitude'] = CLS_MYSQL::GetResultValue($this->query, $i, 'longitude');
             $dataDB['Result']['Data'][$i]['date_time'] = CLS_MYSQL::GetResultValue($this->query, $i, 'date_time');
         }
     }
     $this->display($dataDB);
 }

Example #22

File: setup.php Project: nuthankumarns/Edulab-web-services

<?php

//SETUP.PHP
//YOUR MySQL CONNECTION DETAILS
$DATABASE["server"] = "localhost";
$DATABASE["port"] = "3306";
$DATABASE["username"] = "******";
$DATABASE["password"] = "******";
$DATABASE["database"] = "edulabcl_porsche";
//Including mysql.php , Remember to give the right path to this file
include "mysql.php";
// Initialaizing connection to database using CLS_MYSQL =20
$_DB = new CLS_MYSQL($DATABASE);
//Connecting to database
$_DB->Connect();

Example #23

File: reset_password.php Project: nuthankumarns/vts-source---services

 public function verifyPasscode($passcode, $user_id)
 {
     $query = CLS_MYSQL::Query("SELECT user_name FROM users WHERE user_active='{$passcode}' and user_id='{$user_id}'");
     $count = CLS_MYSQL::GetResultNumber($query);
     return $count;
 }