connect_error) { die("Connection failed: " . $conn->connect_error); } if(isset($_POST['submit'])) { $date1 = date("Y-m-d H:i:s"); $Notwoking = date("Y-m-d H:i:s"); $ttype = isset($_POST['ttype'])? $_POST['ttype'] : 0; $userId = $_POST['userId']; $vehicle_no = $_POST['vehicle_no']; $date_of_install = ''; $company = $_POST['company']; $time= date('Y-m-d H:i:s',strtotime($_POST['time1'])); ; $totime = date('Y-m-d H:i:s'); $reasan = $_POST['SIssues']; $pname=$_POST['pname']; $userName=$_POST['userName']; $atime_status = 'Between'; $cnumber=$_POST['cnumber']; $comment=$_POST['TxtComment']; $location=$_POST['location']; //$Zone_area = $_POST['Zone_area']; $service_reinstall=$_POST['service_reinstall']; $required=$_POST['required']; //$IP_Box=$_POST['IP_Box']; // $Zone_data = "SELECT id,`name` FROM re_city_spr_1 WHERE `name`='".$_POST['Zone_area']."'"; // $result1 = $conn->query($Zone_data); // while($row1 = $result1->fetch_assoc()) { // $Zone_area = $row1['id']; // } $Zone_area1 = 0;//$Zone_area!=''? $Zone_area: 0; $sql = "INSERT INTO `internalsoftware`.`services` (`req_date`,`request_by`,`name`,`user_id`,`company_name`,`veh_reg`,`date_of_installation`,`Notwoking`,`location`,`atime`,`atimeto`,`Zone_area`,`service_reinstall`,`cnumber`,`comment`,`reason`,`required`,`pname`,`service_status`) VALUES ('".$date1."','manual' ,'".$userName."', '".$userId."', '".$company."', '".$vehicle_no."','','".$Notwoking."', '".$location."', '".$time."','".$totime."','".$Zone_area1."','".$service_reinstall."', '".$cnumber."', '".$comment."','".$reasan."','".$required."','".$pname."','1')"; // exit; if ($conn->query($sql) === TRUE) { if ($ttype ==1) { echo (""); }else{ // echo "else";exit; $sql2 = "UPDATE `internalsoftware`.`client_notworking_vehicle` SET `is_service` = '1' WHERE `user_id` ='".$userId."' AND `veh_no` ='".$vehicle_no."'"; if ($conn->query($sql2) === TRUE) { echo (""); } } } else { // echo "fibnal else"; exit; echo (""); } } $UserId = (!empty($_REQUEST['u']))?$_REQUEST['u']:""; //get all user Details $serverName = "203.115.101.62"; $serverUser = "for124"; $serverPass = "123456"; $serverDb = "matrix"; $connForUser = new mysqli($serverName, $serverUser, $serverPass, $serverDb); if ($connForUser->connect_error) { die("Connection failed: " . $connForUser->connect_error); } $userDetails= $connForUser->query("select * from users where id=".$UserId." Limit 1"); $getDetails= array(); if ($userDetails->num_rows > 0) { while($row = $userDetails->fetch_assoc()) { array_push($getDetails, $row); } foreach($getDetails as $getDetail); } ?>