About 87 results: "mysql_query repo:fxrialab/tickets"
Page 1 of 5
Filter Results
Sources
Languages
Filter Results
Try Search On


tickets_controller.php in tickets https://bitbucket.org/fxrialab/tickets | 2446 lines | PHP
  1. 
                        
  2.             $result = mysql_query($sql);
  3.                 //delete cart
  4.                 mysql_query("DELETE FROM ticket_cart_details WHERE cart_id='".$row['id']."'") or die(mysql_error());
  5.                 mysql_query("DELETE FROM ticket_seat_booked WHERE cart_id='".$row['id']."'") or die(mysql_error());
  6.                 mysql_query("DELETE FROM ticket_carts WHERE id='".$row['id']."'") or die(mysql_error());
  7.             }
  8.             $userCountry = "select  user_details.c_id  , countries.country_name ,state.Name, user_details.state, user_details.city , CONCAT_WS(',',city_master.city_name,state.Name,countries.country_name) as CurrentLocation  from user_details LEFT JOIN  countries On  countries.id = user_details.c_id  LEFT JOIN state ON state.id = user_details.state LEFT JOIN city_master ON  user_details.city = city_master.city_id where user_details.user_id= ".$_SESSION['UserId']." ";
  9.             $userCountry_res = mysql_query($userCountry);
  10.                 $userCountry = "select  countries.id  , countries.country_name from countries Where countries.id = '6'";
  11.                 $userCountry_res = mysql_query($userCountry);
  12.         $userCountry = "select  IFNULL(countries.id,0) as countryId  ,  IFNULL(countries.country_name,'') as countryName  ,IFNULL(state.Name,'')as StateName, IFNULL(state.id,0) as StateId, IFNULL(city_master.city_id,0) as CityId , IFNULL(city_master.city_name,'')as CityName from countries LEFT JOIN state ON  state.c_id = countries.id  and state.id = ".$_REQUEST['province']." LEFT JOIN city_master ON  state_id = state.id and city_id = ".$_REQUEST['city']." where countries.id = ".$_REQUEST['country']."";
  13.         $userCountry_res = mysql_query($userCountry)or die(mysql_error());
  14.         $evtcat['0']="Select Category";
  15.         $select_ticket_cat = mysql_query("Select * from ticket_event_category");





users_controller.php in tickets https://bitbucket.org/fxrialab/tickets | 1513 lines | PHP
  1. /*						echo $ins_user_det = "insert into user_details(`user_id`, `first_name`,`last_name`,`dob`,`email`) values('".$userId."','".$this->data['User']['first_name']."','".$this->data['User']['last_name']."','".$this->data['User']['dob']."','".$this->data['User']['email']."')";exit();
  2. */						$res_det = mysql_query($updatUserDet);
  3. 					$sql = "update `users` set `user_status` = '1' where `id` ='".$value."'";
  4. 					$res = mysql_query($sql);
  5. 		$qry="update `users` set `user_status`='1' where `id`='".$_REQUEST['id']."'";
  6. 		$res=mysql_query($qry);
  7. 				
  8. 				$userSave = mysql_query("insert into users(id, username, password, user_group_master_id, user_status) values('', '".$this->data['User']['username']."', '".base64_encode($this->data['User']['password'])."', '".$this->data['User']['user_group_master_id']."', '".$this->data['User']['user_status']."')");
  9. 					$qry = "INSERT INTO `user_details` ( `id` , `user_id`, `first_name`, `last_name`, `email`, `dob`, `c_id` )VALUES ('',".$id.",'".$fname."','".$lname."','".$email."', '".$dob."', ".$_REQUEST['country'].")" ;
  10. 					if($res = mysql_query($qry))
  11. 				$usrqry = "insert into users(id, username, password, user_group_master_id, user_status) values('', '".$this->data['User']['username']."', '".base64_encode($this->data['User']['password'])."', ".$this->data['User']['user_group_master_id'].", '".$this->data['User']['user_status']."')";
  12. 				$userSave = mysql_query($usrqry);
  13. 					echo $qry = "INSERT INTO `user_details` ( `id` , `user_id`, `first_name`, `last_name`, `email`, `dob`, `c_id` )VALUES ('',".$id.",'".$fname."','".$lname."','".$email."', '".$dob."', ".$_REQUEST['country'].")" ;
  14. 					if($res = mysql_query($qry))
  15. 				//echo $sql = "delete from `users` where `id` = '".$value."'";exit();
  16. 				$res = mysql_query($sql);




pages_controller.php in tickets https://bitbucket.org/fxrialab/tickets | 1290 lines | PHP
  1.         $websiteQry = "SELECT layout,logoimage,backgroundimage,theme from photographer_website where user_id='".$photoId."'";
  2.         $websiteQry_res = mysql_query($websiteQry);
  3.             $websiteQry = "SELECT IFNULL(aboutus,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";
  4.             $websiteQry_res = mysql_query($websiteQry);
  5.         //$userName = 'aniphotoinav';
  6.         $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());
  7.             $websiteQry = "SELECT IFNULL(testimonial,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";
  8.             $websiteQry_res = mysql_query($websiteQry);
  9.         //$userName = 'aniphotoinav';
  10.         $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());
  11.             $websiteQry = "SELECT IFNULL(price,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";
  12.             $websiteQry_res = mysql_query($websiteQry);
  13.             $albumtit = "select * from user_albums where user_id='".$fetchUsers['userId']."' AND album_access='public'";
  14.             $res_albumtit = mysql_query($albumtit);
  15.                 $categorySql = "Select album_name  from user_albums where id='".base64_decode($albumid)."'";
  16.                 $categorySql_res = mysql_query($categorySql);









Back to Top