About 22,885 results: "mysql_query"
Page 2 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On





  1.     protected function tearDown() {
  2.     	$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_hsp_summary`"));
  3.     	$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_employee`"));
  4.     	$this->assertTrue(mysql_query("UPDATE `hs_hr_config` SET `value` = '0' WHERE `key` = 'hsp_current_plan'"));
  5.     }
  6. 
                        
  7. 		$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_pay_period`"));
  8. 		$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_hsp_summary`"));
  9. 
                        
  10. 		// Here 'check dates' don't mach with pay periods. They have been added to get three past check dates from current day.
  11. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_pay_period VALUES(1, '".date('Y')."-01-01', '".date('Y')."-01-31', '".date('Y')."-01-31', '".date('Y-m-d', time()-3600*24*3)."', '".date('Y')."-01-20')"));
  12. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_pay_period VALUES(2, '".date('Y')."-02-01', '".date('Y')."-02-29', '".date('Y')."-02-29', '".date('Y-m-d', time()-3600*24*2)."', '".date('Y')."-02-20')"));
  13. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_pay_period VALUES(3, '".date('Y')."-03-01', '".date('Y')."-03-31', '".date('Y')."-03-31', '".date('Y-m-d', time()-3600*24*1)."', '".date('Y')."-03-20')"));
  14. 
                        
  15. 		// Summary Insert
  16. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_hsp_summary VALUES(1, 1, 1, '".date('Y')."', 1, 1500, 50, 50, 0, 0)"), mysql_error());
  17. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_hsp_summary VALUES(2, 2, 1, '".date('Y')."', 1, 2500, 75, 75, 0, 0)"), mysql_error());






  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");









Back to Top