fork download
copy 
  1. <?
  2. header('Content-Type: text/html; charset=utf-8');
  3.  
  4. // ini_set('display_errors',1);
  5. // error_reporting(E_ALL);
  6.  
  7. $regexp = '/[,.;\s ]+/';
  8. $country= $_GET[country];
  9. $city= $_GET[city];
  10.  
  11. $first= preg_split ($regexp, $_GET[country]);
  12. $second= preg_split ($regexp, $_GET[city]);
  13.  
  14. if ($first[1]== false){
  15. 	$first[0] = preg_replace ("/[^a-zа-я]/ui","/",$first[0]);
  16. 	unset($first[1]);
  17. }
  18. if ($second[1]== false){
  19. 	$second[0] = preg_replace ("/[^a-zа-я]/ui","/",$second[0]);
  20. 	unset($second[1]);
  21. }
  22.  
  23. mysql_set_charset('utf8');
  24. $link = mysql_connect(localhost, 'sletatru_fedort', '*hrkq6J3');
  25. mysql_select_db ('sletatru_fedort', $link);
  26.  
  27. if ($first[0] == "" ){
  28. 	$linkcountry[0] = '0';
  29. }else{
  30. foreach ($first as $count){
  31. 	$str_sql_query = "SELECT id FROM dbCountries WHERE name COLLATE UTF8_GENERAL_CI LIKE '$count' OR alias COLLATE UTF8_GENERAL_CI LIKE '$count' OR alias1 COLLATE UTF8_GENERAL_CI LIKE '$count%' OR alias2 COLLATE UTF8_GENERAL_CI LIKE '$count'";
  32. 	$countrysSql[] = mysql_query($str_sql_query, $link);
  33. }
  34. foreach ($countrysSql as $countryTable){ 
  35. while ($line = mysql_fetch_array($countryTable, MYSQL_NUM)) { 
  36. foreach ($line as $a){
  37. $linkcountry[] =$a;
  38. }
  39. } 
  40. }
  41. }
  42.  
  43. if ($second[0] == "" ){
  44. 	$linkcity[0] = '832';
  45. }else{
  46. foreach ($second as $cit){
  47. 	$str_sql_query = "SELECT id FROM dptCities WHERE name COLLATE UTF8_GENERAL_CI LIKE '$cit' OR synonymus COLLATE UTF8_GENERAL_CI LIKE '$cit' OR synonymus1 COLLATE UTF8_GENERAL_CI LIKE '$cit' OR synonymus2 COLLATE UTF8_GENERAL_CI LIKE '$cit' ";
  48. 	$citiesSql[] = mysql_query($str_sql_query, $link);
  49. }
  50. foreach ($citiesSql as $cityTable){
  51. while ($sline = mysql_fetch_array($cityTable, MYSQL_NUM)) {
  52. foreach ($sline as $s=>$a){
  53. $linkcity[] =$a;
  54. }
  55. } 
  56. }
  57. }
  58.  
  59. if ($linkcountry == NULL){
  60. 	$linkcountry[0]=0;
  61. }
  62. if ($linkcity == NULL){
  63. 	$linkcity[0]=832;
  64. }
  65. //Тут запиливаем взрослых и детей
  66.  
  67.  
  68. preg_match_all('/\d{1,3}/', $_GET[kids], $preg); 
  69. if (!empty($preg[0][1])){
  70. 	$kids = 2;
  71. }else{
  72. $kids = $preg[0][0];
  73. }
  74. if ($kids > 3){
  75. 	$kids = 0;
  76. }
  77.  
  78. preg_match_all('/\d{1,3}/', $_GET[adults], $preg); 
  79. if (!empty($preg[0][1])){
  80. 	$adults = 2;
  81. }else{
  82. $adults = $preg[0][0];
  83. }
  84. if ($adults == 0){
  85. 	$adults = 2;
  86. }else if ($adults > 4){
  87. 	$adults = 1;
  88. }
  89.  
  90. //Тут запилим количество ночей
  91. preg_match_all('/\d{1,3}/', $_GET[nights], $preg); 
  92. $nightsmin = $preg[0][0];
  93. $nightsmax = $preg[0][1];
  94.  
  95. if ($nightsmin==0){
  96. 	$nightsmin = 14 ;
  97. }else if ($nightsmax==0){
  98. 	$nightsmax = $nightsmin ;
  99. }else if ($nightsmax < $nightsmin){
  100. 	$y = $nightsmax;
  101. 	$nightsmax = $nightsmin;
  102. 	$nightsmin = $y;
  103. }	
  104. if (($_GET[from] == NULL)&&($_GET[to] != NULL)){
  105. 	$dateF = date_create($_GET[to]);
  106. 	$dateT = date_create($_GET[to]);
  107. 	date_modify($dateF, '-7 day');
  108. 	$dateto = date_format($dateT, 'd-m-Y');
  109. 	$datefrom = date_format($dateF, 'd-m-Y');
  110. 	echo $datefrom, '<br>';
  111. 	echo $dateto, '<br>';
  112. }
  113. 	if (($_GET[from] != NULL)&&($_GET[to] == NULL)){
  114. 	$dateF = date_create($_GET[from]);
  115. 	$dateT = date_create($_GET[from]);
  116. 	$dateT = date_modify($dateT, '+7 day');
  117. 	$dateto = date_format($dateT, 'd-m-Y');
  118. 	$datefrom = date_format($dateF, 'd-m-Y');	
  119. } 
  120. if (($_GET[from] != NULL)&&($_GET[to] != NULL)){
  121. 	$dateF = date_create($_GET[from]);
  122. 	$dateT = date_create($_GET[to]);
  123. 	$dateto = date_format($dateT, 'd-m-Y');
  124. 	$datefrom = date_format($dateF, 'd-m-Y');
  125. }
  126.  
  127. //Звезды и еда
  128. $s = preg_replace ("/\[|\]/ui","",$_GET[stars]);
  129. $m = preg_replace ("/\[|\]/ui","",$_GET[meal]);
  130. $st = explode(', ', $s);
  131. $me = explode(', ', $m);
  132.  
  133.  
  134. $foodAndStars = array(
  135.     '1*' => '401', //отныне одна звезда - это две звезды!
  136.     '2*' => '401',
  137.     '3*' => '402',
  138. 	'4*' => '403',
  139. 	'5*' => '404',
  140. 	'Apts' => '405',
  141. 	'Villas' => '406',
  142. 	'HV1' => '410',
  143. 	'HV2' => '411',
  144. 	'Любая' => '',
  145. 	'Любое' => '',
  146.     'UAI' => '116',
  147.     'AI' => '115',
  148.     'FB' => '112',
  149. 	'FB+' => '121',
  150. 	'HB' => '113',
  151. 	'HB+' => '122',
  152. 	'BB' => '114',
  153. 	'RO' => '117',
  154. );
  155. foreach ($st as $ars){
  156. $star[]= $foodAndStars[$ars];
  157. }
  158. $stars = implode(',' ,$star);
  159.  
  160. foreach ($me as $al){
  161. $mea[]= $foodAndStars[$al];
  162. }
  163. $meal = implode(',' ,$mea);
  164.  
  165. if (in_array('Любая', $st)) {
  166. 	$stars = '';
  167. }
  168.  
  169. if (in_array('Любое', $me)) {
  170. 	$meal = '';
  171. }
  172.  
  173. $numbers = count($linkcity) + count($linkcountry);
  174. if ($numbers == 2){
  175. 	header("Location: https://s...content-available-to-author-only...t.ru/?callback=search&country={$linkcountry[0]}&city={$linkcity[0]}&stars={$stars}&meal={$meal}&adults={$adults}&kids={$kids}&datefrom={$datefrom}&dateto={$dateto}&nightsmin={$nightsmin}&nightsmax={$nightsmax}");
  176. }else{
  177. foreach ($linkcity as $n=>$id){
  178. 	foreach ($linkcountry as $k=>$did){
  179. 		echo "<div style=\"padding:10; font-size:20\";>$second[$n] - $first[$k]<a href=https://s...content-available-to-author-only...t.ru/?callback=search&country={$did}&city={$id}&stars={$stars}&meal={$meal}&adults={$adults}&kids={$kids}&datefrom={$datefrom}&dateto={$dateto}&nightsmin={$nightsmin}&nightsmax={$nightsmax} target=_blank style=\"padding:10; font-size:20\";>Link</a></div>";
  180. 	}
  181. }
  182. }
  183. ?>
Success #stdin #stdout 0.01s 82880KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
<?
header('Content-Type: text/html; charset=utf-8');

// ini_set('display_errors',1);
// error_reporting(E_ALL);

$regexp = '/[,.;\s ]+/';
$country= $_GET[country];
$city= $_GET[city];

$first= preg_split ($regexp, $_GET[country]);
$second= preg_split ($regexp, $_GET[city]);

if ($first[1]== false){
	$first[0] = preg_replace ("/[^a-zа-я]/ui","/",$first[0]);
	unset($first[1]);
}
if ($second[1]== false){
	$second[0] = preg_replace ("/[^a-zа-я]/ui","/",$second[0]);
	unset($second[1]);
}

mysql_set_charset('utf8');
$link = mysql_connect(localhost, 'sletatru_fedort', '*hrkq6J3');
mysql_select_db ('sletatru_fedort', $link);

if ($first[0] == "" ){
	$linkcountry[0] = '0';
}else{
foreach ($first as $count){
	$str_sql_query = "SELECT id FROM dbCountries WHERE name COLLATE UTF8_GENERAL_CI LIKE '$count' OR alias COLLATE UTF8_GENERAL_CI LIKE '$count' OR alias1 COLLATE UTF8_GENERAL_CI LIKE '$count%' OR alias2 COLLATE UTF8_GENERAL_CI LIKE '$count'";
	$countrysSql[] = mysql_query($str_sql_query, $link);
}
foreach ($countrysSql as $countryTable){ 
while ($line = mysql_fetch_array($countryTable, MYSQL_NUM)) { 
foreach ($line as $a){
$linkcountry[] =$a;
}
} 
}
}

if ($second[0] == "" ){
	$linkcity[0] = '832';
}else{
foreach ($second as $cit){
	$str_sql_query = "SELECT id FROM dptCities WHERE name COLLATE UTF8_GENERAL_CI LIKE '$cit' OR synonymus COLLATE UTF8_GENERAL_CI LIKE '$cit' OR synonymus1 COLLATE UTF8_GENERAL_CI LIKE '$cit' OR synonymus2 COLLATE UTF8_GENERAL_CI LIKE '$cit' ";
	$citiesSql[] = mysql_query($str_sql_query, $link);
}
foreach ($citiesSql as $cityTable){
while ($sline = mysql_fetch_array($cityTable, MYSQL_NUM)) {
foreach ($sline as $s=>$a){
$linkcity[] =$a;
}
} 
}
}

if ($linkcountry == NULL){
	$linkcountry[0]=0;
}
if ($linkcity == NULL){
	$linkcity[0]=832;
}
//Тут запиливаем взрослых и детей


preg_match_all('/\d{1,3}/', $_GET[kids], $preg); 
if (!empty($preg[0][1])){
	$kids = 2;
}else{
$kids = $preg[0][0];
}
if ($kids > 3){
	$kids = 0;
}

preg_match_all('/\d{1,3}/', $_GET[adults], $preg); 
if (!empty($preg[0][1])){
	$adults = 2;
}else{
$adults = $preg[0][0];
}
if ($adults == 0){
	$adults = 2;
}else if ($adults > 4){
	$adults = 1;
}

//Тут запилим количество ночей
preg_match_all('/\d{1,3}/', $_GET[nights], $preg); 
$nightsmin = $preg[0][0];
$nightsmax = $preg[0][1];

if ($nightsmin==0){
	$nightsmin = 14 ;
}else if ($nightsmax==0){
	$nightsmax = $nightsmin ;
}else if ($nightsmax < $nightsmin){
	$y = $nightsmax;
	$nightsmax = $nightsmin;
	$nightsmin = $y;
}	
if (($_GET[from] == NULL)&&($_GET[to] != NULL)){
	$dateF = date_create($_GET[to]);
	$dateT = date_create($_GET[to]);
	date_modify($dateF, '-7 day');
	$dateto = date_format($dateT, 'd-m-Y');
	$datefrom = date_format($dateF, 'd-m-Y');
	echo $datefrom, '<br>';
	echo $dateto, '<br>';
}
	if (($_GET[from] != NULL)&&($_GET[to] == NULL)){
	$dateF = date_create($_GET[from]);
	$dateT = date_create($_GET[from]);
	$dateT = date_modify($dateT, '+7 day');
	$dateto = date_format($dateT, 'd-m-Y');
	$datefrom = date_format($dateF, 'd-m-Y');	
} 
if (($_GET[from] != NULL)&&($_GET[to] != NULL)){
	$dateF = date_create($_GET[from]);
	$dateT = date_create($_GET[to]);
	$dateto = date_format($dateT, 'd-m-Y');
	$datefrom = date_format($dateF, 'd-m-Y');
}

//Звезды и еда
$s = preg_replace ("/\[|\]/ui","",$_GET[stars]);
$m = preg_replace ("/\[|\]/ui","",$_GET[meal]);
$st = explode(', ', $s);
$me = explode(', ', $m);


$foodAndStars = array(
    '1*' => '401', //отныне одна звезда - это две звезды!
    '2*' => '401',
    '3*' => '402',
	'4*' => '403',
	'5*' => '404',
	'Apts' => '405',
	'Villas' => '406',
	'HV1' => '410',
	'HV2' => '411',
	'Любая' => '',
	'Любое' => '',
    'UAI' => '116',
    'AI' => '115',
    'FB' => '112',
	'FB+' => '121',
	'HB' => '113',
	'HB+' => '122',
	'BB' => '114',
	'RO' => '117',
);
foreach ($st as $ars){
$star[]= $foodAndStars[$ars];
}
$stars = implode(',' ,$star);

foreach ($me as $al){
$mea[]= $foodAndStars[$al];
}
$meal = implode(',' ,$mea);

if (in_array('Любая', $st)) {
	$stars = '';
}

if (in_array('Любое', $me)) {
	$meal = '';
}

$numbers = count($linkcity) + count($linkcountry);
if ($numbers == 2){
	header("Location: https://s...content-available-to-author-only...t.ru/?callback=search&country={$linkcountry[0]}&city={$linkcity[0]}&stars={$stars}&meal={$meal}&adults={$adults}&kids={$kids}&datefrom={$datefrom}&dateto={$dateto}&nightsmin={$nightsmin}&nightsmax={$nightsmax}");
}else{
foreach ($linkcity as $n=>$id){
	foreach ($linkcountry as $k=>$did){
		echo "<div style=\"padding:10; font-size:20\";>$second[$n] - $first[$k]<a href=https://s...content-available-to-author-only...t.ru/?callback=search&country={$did}&city={$id}&stars={$stars}&meal={$meal}&adults={$adults}&kids={$kids}&datefrom={$datefrom}&dateto={$dateto}&nightsmin={$nightsmin}&nightsmax={$nightsmax} target=_blank style=\"padding:10; font-size:20\";>Link</a></div>";
	}
}
}
?>
https://ideone.com/Lz5R9P
language:
PHP (php 7.3.5)
created:
6 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!