Page 1 of 1

PHP Code Help

Posted: Fri Apr 30, 2010 9:26 am
by bidbud
Hi I have the following code that returns only 1 type of room from a database (ie Twin), does anyone know how to adjust it to return all the room types available
(ie Double, Family, Twin) ?

Code: Select all

<?php
# Copyright 2009 e21Software.com Ltd. All Rights Reserved.
# The contents of this file may be modified but not sold, copied
# or reverse engineered. The contents may not be used on any
# website(s) or internet services other than those agreed in
# writing by authorised representatives of e21Software.com Ltd.
#$t3a=microtime_float();
if(!isset($fld['agtPwd'])){$fld=array();}
if(!isset($fld['Language'])){$fld['Language']=substr($Languages,0,3);}
$Query='';
foreach($_REQUEST as $key=>$data){
 $ky=strtolower($key);
 if($ky == 'id'){$key='Id';}
 if($ky == 'l'){$key='Language';}
 if($ky == 'b'){$key='Basis';}
 if($ky == 'iu'){$key='InfoUnitNo';}
 if($ky == 'ui'){$key='UnitID';}
 if($ky == 'pn'){$key='PlaceNo';}
 if($ky == 'dn'){$key='DevNo';}
 if($ky == 'an'){$key='AccNo';}
 if($ky == 'cr'){$key='Currency';}
 if($ky == 'agt'){$key='AgencyCode';}
 if($ky == 'ad'){$key='ArrivalDate';}
 if($ky == 'nt'){$key='NumberNights';}
 if($ky == 'a'){$key='Adults';}
 if($ky == 'c'){$key='Children';}
 if($ky == 's'){$key='Sort';}
# if($ky == 'ftr'){$key='PlaceCategories';}
 if(!isset($_COOKIE[$key])){$fld[$key]=$data;}
}
foreach($fld as $key=>$data){if(strpos('Options,searchForm,Results,XQ,Type,Fields,Sort,',$key) === false){$Query.="$key=$data&";}}
if(isset($fld['agtPwd'])){$fld['head']='N';}else{$fld['head']='Y';}
if(!isset($fld['ArrivalDate'])){$Query.='Options=NOP&';}
if(isset($fld['PoolHeat'])){$fld['ftr'].='~PHeatS~PHeatE~HeatPool';}
if(isset($fld['AirCon'])){$fld['ftr'].='~AirCon~AirCn~AirConM~AirConL';}
if(isset($fld['ftr'])){$Query.="Categories=$fld[ftr]&";}
if(!isset($fld['allocOnly'])){$fld['allocOnly']='';}
if(!isset($fld['AgencyCode'])){$fld['AgencyCode']='';}
if(!isset($fld['Sort'])){$fld['Sort']='4';}
if(isset($fld['Nights'])){$fld['NumberNights']=$fld['Nights'];}
$Language=$fld['Language'];
if($fld['searchForm'] == ''){$fld['searchForm']=str_replace('/','',$fld['ArrivalDate'])."?$fld[NumberNights]?$fld[PlaceNo]?$fld[DevNo]?$fld[Adults]?$fld[Children]?$fld[Infants]?$fld[Babies]?$fld[Currency]?$fld[AgencyCode]?$fld[OfferCode]?$fld[Basis]?$fld[Country]?$fld[Region]?$fld[SubRegion]?";}
if(!isset($fld['XQ'])&&isset($fld['Results'])){$fld['XQ']=$fld['Results'];}
if(isset($fld['XQ'])){list($Results,$fld['searchForm'])=explode('__form',$fld['XQ']);$fld['head']='N';$Results=URLdecode($Results);}
$dtls=array();$sfrm=array();
list($sfrm['ad'],$sfrm['nt'],$sfrm['pn'],$sfrm['dn'],$sfrm['a'],$sfrm['c'],$sfrm['i'],$sfrm['b'],$sfrm['cur'],$sfrm['agt'],$sfrm['offer'],$sfrm['basis'],$sfrm['ctry'],$sfrm['rg'],$sfrm['sg'])=explode('?',$fld['searchForm']); # This is used to store the search criteria #
if(!isset($fld['ArrivalDate']) && isset($sfrm['ad'])){$fld['ArrivalDate']=substr($sfrm['ad'],0,2).'/'.substr($sfrm['ad'],2,2).'/'.substr($sfrm['ad'],4,4);}
if(!isset($fld['agtPwd'])){
 include('Std.php');
 e21Site();
 e21Languages();
}
if(!isset($fld['XQ'])){
 $htm='http://'.$_SERVER['SERVER_NAME'];
 $Query = "Site=$Site&".$Query."&B2X=C, ,&Html=$htm/search-3.html";
 if(isset($fld['agtCode'])){$Query.='&Agent=AGT'.($fld['agtCur'] != ''?'c':'');}
 if($fld['Type'] == 'S'){$Query.='&ForSale=Y';}
 URLencode($Query);
#print " $Query \n";
 $Results=e21Curl($Query,'http://www.'.str_replace('www.','',$accommRes).'/cgi/api_accommres_search.pl');
#print " $Results \n\n";
}
#$t3d=microtime_float();
#$Features=e21Features();
e21dbOpen();

$Title=$Lng['AvndPr'];
$k1=$Lng['Development'];
$words=array();$dtl=array();
$Description='';$xPn='';$fld['XQ']='';
$dtl['Units']='';$dtl['PD']='';$dtl['Locations']='';
$dtl['txLoc']='';$dtl['Categories']='';$dtl['TourArea']='';$dtl['TourAreas']='';
$key=$Language.'|{meta name="keywords"';
#$t1a=microtime_float();
foreach (explode('?-?',$Results) as $rec){
 if(strpos($rec,'||') !== false){
  $dtls=explode('||',$rec);
  $dtl['Units'].="'".($dtls[31] == ''?($dtls[35] == ''?$dtls[34]:$dtls[35]):$dtls[31])."',";
  if($dtl['PD'] != "$dtls[4],$dtls[5]"){
   $dtl['PD']="$dtls[4],$dtls[5]";$dtl['Country']=$dtls[7];$dtl['txLoc']=($dtls[45]!=''?e21Text('',$dtls[45]):$dtls[1]);
   if(strpos($dtl['Locations'],$dtl['txLoc']) === false){$dtl['Locations'].=$dtl['txLoc'].',';}
  }
  if($dtls[29] != '' and strpos($dtl['Categories'],$dtls[29]) === false){$dtl['Categories'].=$dtls[29].',';}
 }
}
#$t1c=microtime_float();
$Description=substr($dtl['Categories'],0,-1).' '.$Lng['Accommodation'].' '.substr($dtl['Locations'],0,-1).' - '.substr($dtl['TourAreas'],0,-1).' '.$dtl['Country'];
$rec='. '.$Lng['BookStage0'].'.';$Description=substr($Description,0,200-strlen($rec)).$rec;
#print "<!-- Dsc=$Description -->\n<!-- Cat=$dtl[Categories] -->\n<!-- loc= $dtl[Locations] -->\n<!-- TA=$dtl[TourAreas] -->\n";
$rec='';unset($dtls);unset($dtl);
foreach($words as $key=>$data){$rec.=$key.',';}
unset($words);
#print "\n";
#e21Menus("search.php",1); # Print out any Menus defined in Std.php #
#e21Content('1','',$Country); # Print out parts of the content which can be manipulated according depending on layout required defined in Std.php #
if($fld['head'] == 'Y'){
 list($Hdr,$Ftr)=e21Content($Title,substr($rec,0,-1),$Description);
 print $Hdr;
 $Ftr=str_replace("name='searchForm'>","name='searchForm' value='$fld[searchForm]'>",$Ftr);
}
#$t2a=microtime_float();

# Start of showing the results, the form 'Xtras' is mandatory #
print "
<form action='' name='Xtras' target='booking_form' method='post'><input type='hidden' name='Fields'><input type='hidden' name='Id'><input type='hidden' name='searchForm' value='$frm[searchForm]'><input type='hidden' name='Language' value='$Language'></form>
 <table border=0 cellspacing=0 width='100%'>
 <tbody>\n";
 if($sfrm['ad'] != ''){print "  <tr><td class='sortBy' align='right'>$Lng[SortBy]&nbsp;<select id=tcSort name='Sort' onchange='sortSearch(this);'><option value='4'".($fld['Sort'] == '4'?' selected':'').">$Lng[Resort]</option><option value='1'".($fld['Sort'] == '1'?' selected=selected':'').">$Lng[Alphally]</option><option value='3'".($fld['Sort'] == '3'?' selected=selected':'').">$Lng[SortPLow]</option><option value='2'".($fld['Sort'] == '2'?' selected':'').">$Lng[SortPHigh]</option></select></td></tr>\n";}
print "  <tr>
   <td class='htag'>";
if($sfrm['ad'] != ''){
 if(substr($sfrm['ad'],2,1) == '0'){$data='Month'.substr($sfrm['ad'],3,1);}else{$data='Month'.substr($sfrm['ad'],2,2);}
 print "
    <div class='clr bkt dflt-1 px12'><div class='lqd'><div class='lqd-t'><span></span></div><div class='lqd-c'>
     <h4>$Lng[Accommodation]: ".substr($sfrm['ad'],0,2).' '.$Lng[$data].' '.substr($sfrm['ad'],4,4).", $sfrm[nt] $Lng[Nights], $sfrm[a] $Lng[Adults]".($sfrm['c'] > 0?" $sfrm[c] $Lng[Children]":'').($sfrm['i'] > 0?" $sfrm[i] $Lng[Infants]":'').($sfrm['basis'] != ''?", ".$Lng["$sfrm[basis]"]:'')."</h4>
    </div><div class='lqd-b'><span></span></div></div></div>\n";
}
print "</td>\n   </tr>\n   <tr>\n    <td>\n";
print "    <div class='clr bkt dflt-1 px12'><div class='lqd'><div class='lqd-t'><span></span></div><div class='lqd-c'>\n";
if(strpos($Results,'__search:0') !== false){print "<div id='Page-1'><table><tbody><tr><td><br><center><h3>$Lng[Sorry3]</h3><center><br></td></tr>";$Results='';}
$sLg=substr($Language,0,2);

# Here is the record layout of each result each element is seperated by || #
#Count=0,Place=1,Property=2,Accommodation=3,PlaceNo=4,DevNo=5,AccNo=6,Country=7
#PriceSym=8,Price=9,Currency=10,YProRef=11,xAccImage1=12,xAccImage2=13
#MaxGuests=14,Bathrooms=15,DevFeatures=16,xsBook=17,AccFeatures=18,GPF=19,
#NAS=20,NASRating=21,NASEye=22,EyeRating=23,NASHear=24,HearRating=25,PlusChildren=26
#GPF=27,NoRooms=28,Category=29,DevCountry=30,SingleUnit=31,YLocRef=32,YAccRef=33,
#UnitInfoNo=34,UnitID=35,PlaceCategories=36,DoubleBeds=37,SingleBeds=38,SofaBeds=39,
#Bedrooms=40,DevImage1=41,DevImage2=42,Sid=43,VTours=44,txLoc=45,txDev=46,txAcc=47
#AgencyCType=48,AgencyComm=49,AgencyRetained=50,CurrencyRate=51,B2X=52
$Page=1;$knt=0;$xPn='';
$rds=array();$srt=array();
foreach (explode('?-?',$Results) as $rec){
 if(strpos($rec,'||') !== false){
#print "<!-- $rec -->\n";
  $dtls=explode('||',$rec);$key='';
  if($fld['AgencyCode'] == '' || strpos($fld['UnitLists'],",$dtls[35],") === false){$key=($fld['allocOnly'] == ''?"z$dtls[0]":'');}else{$key="a$dtls[0]";}
  if($key != ''){
   $rds[$key]=$rec;$srt[$key]=$dtls[9];
   if($fld['Sort']){
    if($fld['Sort'] == '1'){$srt[$key]="$dtls[2]$dtls[3]$dtls[1]";}
    if($fld['Sort'] == '2'||$fld['Sort'] == '3'){$srt[$key]=(substr($key,0,1) == 'z'?"$dtls[9]":'0.00');}
    if($fld['Sort'] == '4'){$srt[$key]="$dtls[1]$dtls[2]$dtls[3]";}
   }
  }
 }
}
if($fld['Sort']){if($fld['Sort'] == '2'){arsort($srt);}else{asort($srt);}}
foreach($srt as $ID=>$rec){
 $rec=$rds[$ID];
 if(strpos($rec,'||') !== false){
# Split the record into elements - refer to the above to correspond what with each element #
#http://www.onlyvillas.com/searches.php?pn=9&dn=1028,1049,1050,1051,1052,1053
#print "<!-- ($ID) $rec -->\n";
  unset($dtls);$dtls=explode('||',$rec);
  $Accept=($dtls[52] == 'B'?'N':'Y');
  $Price="<span class='Currency'>&nbsp;$dtls[10]";$fld['sym']=preg_replace('/&nbsp;\S+/','',$dtls[8]);
  if($dtls[9] == '1.00'){if($dtls[19] != '-1'){$Price=number_format($dtls[19],2,'.',',').$Price.'*';}else{$Price='-.--'.$Price;}}else{$Price=number_format($dtls[9],2,'.',',').$Price;}
  if($Accept == 'Y'){
   $fld['XQ'].='?-?'.$rec.'?-?';
   $dtls['txLoc']=ucwords(strtolower(($dtls[45]==''?e21Text('LOC',$dtls[4]):e21Text('',$dtls[45]))));if($dtls['txLoc']==''){$dtls['txLoc']=$dtls[1];}
   $dtls['txDev']=ucwords(strtolower(($dtls[46]==''?e21Text('DEV',$dtls[5]):e21Text('',$dtls[46]))));if($dtls['txDev']==''){$dtls['txDev']=$dtls[2];}
   $dtls['txAcc']=ucwords(strtolower(($dtls[47]==''?e21Text('ACC',$dtls[3]):e21Text('',$dtls[47]))));
   if($knt == 0){
    if($Page > 1){print "   </tbody>\n  </table>\n </div>\n";}
    print " <div id='Page-$Page'";if($Page > 1){print " style='display:none;'>\n";}else{print ">\n";}
    print "
      <table border=0 cellspacing='0' cellpadding='0' width='98%'>
       <tbody>\n";
   }
#--- Location & Development Details ---#
   if("$dtls[4],$dtls[5]" != $xPn or $knt == 0){
#    print "    <tr><td class='bar-1' colspan=4>";
    $Thumb1='';$Thumb2='';
#    if($dtls[41] == '1'){$Thumb1=strtolower("http://$accommRes/onlinebookings/$Site/$dtls[1]$dtls[2]_image1.jpg");$Thumb1=str_replace(' ','',$Thumb1);}
#    if($dtls[42] == '2'){$Thumb2=strtolower("http://$accommRes/onlinebookings/$Site/$dtls[1]$dtls[2]_image2.jpg");$Thumb2=str_replace(' ','',$Thumb2);}
    if($dtls[11] == ''){
     if($fld['agtCode'] == ''){$dtls['lkDev']="details.php?id=l&l=$Language&pn=$dtls[4]&dn=$dtls[5]";}else{$dtls['lkDev']="#' onclick='return(showLPA(this,\"id=l&l=$Language&pn=$dtls[4]&dn=$dtls[5]\"));";}
#     print "$dtls[txLoc], $dtls[txDev]</td></tr><tr><td><br/></td></tr>\n";
#     print "<tr><td valign='top'>".($Thumb1 != ''?"<img alt='$dtls[txDev]' src='$Thumb1' width=125 border=0/>&nbsp;":'').($Thumb2 != ''?"<img alt='$dtls[txDev]' src='$Thumb2' width=125 border=0/>":'')."</td>\n";
    }else{
     if($fld['agtCode'] == ''){$dtls['lkLoc']="details.php?id=p&l=$Language&pn=$dtls[4]";}else{$dtls['lkLoc']="#' onclick='return(showLPA(this,\"id=p&l=$Language&pn=$dtls[4]\"));";}
#     print "<a class='psize12' title='$dtls[txLoc] $Lng[Details]($Lng[TouristInfo])' href='$dtls[lkLoc]'>$dtls[txLoc]</a>, $dtls[txDev]</td></tr><tr><td><br/></td></tr>\n";
#     print "    <tr><td valign='top' width=280>";
     if($fld['agtCode'] == ''){$dtls['lkDev']="details.php?id=l&l=$Language&pn=$dtls[4]&dn=$dtls[5]";}else{$dtls['lkDev']="#' onclick='return(showLPA(this,\"id=l&l=$Language&pn=$dtls[4]&dn=$dtls[5]\"));";}
#     print "<a title='$dtls[txDev] $Lng[Details]' href='$dtls[lkDev]'>".($Thumb1 != ''?"<img alt='$dtls[txDev] $Lng[Details]' src='$Thumb1' width=125 border=0/></a>&nbsp;":'</a>');
#     print "<a title='$dtls[txDev] $Lng[Details]' href='$dtls[lkDev]'>".($Thumb2 != ''?"<img alt='$dtls[txDev] $Lng[Details]' src='$Thumb2' width=125 border=0/>":'')."</a></td>\n";
    }
#    $sql="select Info from dev where(PlaceNo = '$dtls[4]')and(DevNo = '$dtls[5]');";
#--- Retreive Information regarding the Property - defined in Accommres ---#
#    $dbR=mysql_query($sql);
#    $row=mysql_fetch_array($dbR);
#    $fld['Lng']=$fld['Language'];if(strpos($row['Info'],"|$fld[Lng]|") === false){$fld['Lng']=substr($Languages,0,3);}
#    $Info=explode("|$fld[Lng]|",$row['Info']);$data=$Info[1];$data=str_replace('~','<br/>',$data);
#    print "     <td style='padding:10px;'>\n";
#    print "      <div class='pagetext' style='overflow:hidden;height:9em;'>$data</div>\n";
#    if($data != ''){print "      <div style='position:relative;top:-5px;text-align:right;padding-right:10px;'><a title='$dtls[txDev] $Lng[Details]' href='$dtls[lkDev]'><small><small><br>$Lng[MoreInfo] ...</small></small></a></div>\n";}
#    print "     </td>\n";
#    print "    </tr>\n";
    $xPn="$dtls[4],$dtls[5]";
   }
   $dtls['lkAcc']="id=d&l=$Language&cr=$dtls[10]";
   if($sfrm['ad'] != ''){$dtls['lkAcc'].="&ad=$fld[ArrivalDate]";}
   if($sfrm['nt'] != ''){$dtls['lkAcc'].="&nt=$sfrm[nt]";}
   if($sfrm['a'] != ''){$dtls['lkAcc'].="&a=$sfrm[a]";}
#   if($sfrm['Currency'] != ''){$dtls['lkAcc'].="&cr=$sfrm[Currency]";}
   if($dtls[35] != ''){$dtls['lkAcc'].="&ui=$dtls[35]";}
   if($dtls['Basis'] != ''){$dtls['lkAcc'].="&b=$dtls[Basis]";}
#    $data="details.php?Id=d&Language=$Language&ArrivalDate=$fld[ArrivalDate]&Nights=$fld[NumberNights]&Adults=$fld[Adults]&Currency=$fld[Currency]&UnitID=$dtls[35]&Basis=$dtls[Basis]";
   if($fld['AgencyCode'] != ''){$dtls['lkAcc'].="&AgencyCode=$fld[AgencyCode]&AgencyRef=$fld[AgencyRef]&Agent=AGT".($fld['agtCur'] != ''?'c':'');}
   if($dtls[34] != ''){if($dtls[34] != $dtls[35]){$dtls['lkAcc'].="&iu=$dtls[34]";}}else{$dtls['lkAcc'].="&pn=$dtls[4]&dn=$dtls[5]&an=$dtls[6]";}
   if($sfrm['c'] != ''){$dtls['lkAcc'].="&c=$sfrm[c]";}
   if($sfrm['Infants'] != ''){$dtls['lkAcc'].="&Infants=$sfrm[Infants]";}
   if($sfrm['Babies'] != ''){$dtls['lkAcc'].="&Babies=$sfrm[Babies]";}
   if($fld['agtCode'] == ''){$dtls['lkAcc']="details.php?$dtls[lkAcc]";}else{$dtls['lkAcc']="#' onclick='return(showLPA(this,\"$dtls[lkAcc]\"));";}
#--- Depending on Location&Development being commented out ---#
#   print "    <tr><td class='bar-2' colspan='4'>$dtls[txAcc]</td></tr>\n";
   print "    <tr><td class='bar-p' colspan='4'><a href='$dtls[lkLoc]'>$dtls[txLoc]</a>,&nbsp;<a href='$dtls[lkAcc]'>$dtls[txDev]&nbsp;-&nbsp;$dtls[txAcc]</a></td></tr>\n";
   print <<<HTM
    <tr>
     <td style='' colspan='4' style='padding:8px;'>
      <table border=0 cellspacing=0 cellpadding=0 width='100%'>
       <tbody>
        <tr><td colspan=4 style='padding-bottom:10px;'></td></tr>
        <tr>
         <td width=280 class='top'>
HTM;
#--- Define thumb images of the Accommodation ---#
   $Thumb1='';$Thumb2='';
   if($dtls[12] == '1'){$Thumb1=strtolower("http://$accommRes/onlinebookings/$Site/$dtls[1]$dtls[2]$dtls[3]_thumbimage_$dtls[34]$dtls[12].jpg");$Thumb1=str_replace(' ','',$Thumb1);}else{$Thumb1='';}
   if($dtls[13] == '2'){$Thumb2=strtolower("http://$accommRes/onlinebookings/$Site/$dtls[1]$dtls[2]$dtls[3]_thumbimage_$dtls[34]$dtls[13].jpg");$Thumb2=str_replace(' ','',$Thumb2);}else{$Thumb2='';}
   if($dtls[11] == ''){
    print ($Thumb1 != ''?"<img id='img-$dtls[0]a' alt='$dtls[txDev] - $dtls[txAcc]' src='$Thumb1' width=125 border=0 />&nbsp;":'').($Thumb2 != ''?"<img id='img-$dtls[0]b' alt='$dtls[txDev] - $dtls[Acc]' src='$Thumb2' width=125 border=0 />":'');
   }else{
#    print "<a class='psize12' title='$dtls[1] $Lng[Details]' href='details.php?Id=d&Fields=PlaceNo=$dtls[4],Place=$dtls[1],Country=$dtls[7]'><img id='img-$dtls[0]' alt='$dtls[3]' src='$Thumb' border=0 /></a>";
    print "<a class='psize12' title='$dtls[txDev] $Lng[Details]' href='$dtls[lkAcc]'>".($Thumb1 != ''?"<img id='img-$dtls[0]a' alt='$dtls[txDev] - $dtls[txAcc]' src='$Thumb1' width=125 border=0 />":'')."</a>&nbsp;";
    print "<a class='psize12' title='$dtls[txDev] $Lng[Details]' href='$dtls[lkAcc]'>".($Thumb2 != ''?"<img id='img-$dtls[0]b' alt='$dtls[txDev] - $dtls[txAcc]' src='$Thumb2' width=125 border=0 />":'')."</a>";
#    $dtls[17]=str_replace("';","&VTours=$fld[VTours]';",$dtls[17]);
#    print "<a class='psize12' title='$dtls[txLoc] $Lng[Details]' href='#' onclick=\"$dtls[17]AccommresBook(2);\">".($Thumb1 != ''?"<img id='img-$dtls[0]a' alt='$dtls[Acc]' src='$Thumb1' width=125 border=0 />":'')."</a>&nbsp;";
#    print "<a class='psize12' title='$dtls[txLoc] $Lng[Details]' href='#' onclick=\"$dtls[17]AccommresBook(2);\">".($Thumb2 != ''?"<img id='img-$dtls[0]b' alt='$dtls[Acc]' src='$Thumb2' width=125 border=0 />":'')."</a>";
 }
   print "</td>\n";
   print "         <td valign='top'>\n";
   print "          <table border=0 cellspacing=0 cellpadding=0 width='100%'>\n";
#              <tr><td align='right'><div><a id='resBookit' onclick="$dtls[17]AccommresBook(1);"><img alt='' src='images/$Language/disponibilidad.gif' border=0></a></div></td></tr>
   print "           <tr>\n";
   print "            <td class='pagetext' align='left' class='top'>$dtls[40]&nbsp;$Lng[Bedrooms]<br/>$dtls[15]&nbsp;$Lng[Bathrooms]<br/>$dtls[14]&nbsp;$Lng[MaxGuests]".($dtls[26] != ''?" + $dtls[26] $Lng[Children]<br/>":"<br/>");
   $data='';$fld['GACode']=$fld['AgencyCode'];
   if($dtls[37] != ''){$data= "$dtls[37]&nbsp;$Lng[DoubleBeds],";}
   if($dtls[38] != ''){$data.= "$dtls[38]&nbsp;$Lng[SingleBeds],";}
   if($dtls[39] != ''){$data.= "$dtls[39]&nbsp;$Lng[SofaBeds],";}
   print str_replace(',,','',"$data,")."<br/><br/>";
   if($dtls[12] !=''){print "<a class='more' title='$dtls[txDev] $Lng[Details]' href='$dtls[lkAcc]'><small>$Lng[MoreInfo]</small></a>";}
   print "</td>\n";
   print "            <td valign='bottom' align='right' style='margin-right:5px;'>\n";
# Show price and the book now button #
   if($fld['AgencyCode'] != '' && substr($ID,0,1) == 'a'){$dtls[8]='0.00';$dtls[17]=preg_replace('/AgencyCode=/i','AgencyCode=GRNTE ',$dtls[17]);$fld['GACode']="GRNTE $fld[AgencyCode]";}
   print "             <table class='booknowtext' border=0>\n";
   if($dtls[9] == '1.00'){
    if($dtls[27] == '0-'){$dtls[27]='';}
    if($dtls[27] != ''){
     list($fld['gpF'],$fld['gpT'])=explode('-',$dtls[27]);$fld['gpF']=preg_replace('/\D/g','',$fld['gpF']);$fld['gpT']=preg_replace('/\D/g','',$fld['gpT']);
     $fld['gpF']=number_format($fld['gpF']*$dtls[51]);$fld['gpT']=number_format($fld['gpT']*$dtls[51]);
     $dtls[27]="$Lng[GPr]<br><b>$fld[sym]&nbsp;$fld[gpF]</b> <small>$Lng[To]</small> <b>$fld[gpT]</b> <small>$dtls[10]</small>";
    }
   }
   print "              <tr><td align=right>".($dtls[9] != '1.00'?"<b>$Lng[Available]</b>":"$dtls[27]")."<br/></td></tr>\n";
   print "              <tr><td align=right><b>".($dtls[9] != '1.00'?"$dtls[8] $dtls[10]":'')."</b></td></tr>\n";
   if($dtls[9] != '1.00' && $dtls[49] != '' && $dtls[50] != 'A'){
#      $dtls['agtRate']=($dtls[19] - ($dtls[19] / ((100 + $dtls[49])/100))) * $dtls[50];
    $dtls['agtRate']=($dtls[19] * ($dtls[49]/100)) * $dtls[51];
#print "\n<tr><td> $dtls[agtRate]=($dtls[19] * ($dtls[49]/100)) * $dtls[50]</td></tr>";
    print "              <tr><td align=right><br/><span class='pi pt9'>$Lng[Commission]&nbsp;".number_format($dtls['agtRate'],2,'.',',')."</span></td></tr>\n";
   }
   if(isset($fld['agtPwd'])){
    $data='agentBookConfirm()';if($dtls[8] == '0.00'){$dtls[17]=preg_replace('/\&AgencyCode=/i',"&AgencyCode=GRNTE ",$dtls[17]);}
    if($fld['agtCur'] != ''){$dtls[17]=preg_replace('/\&AgencyCode=/i',"&Loc=$dtls[txLoc]&Dev=$dtls[txDev]&Acc=$dtls[txAcc]&Agent=AGTc&AgencyDeposit=$fld[agtDeposit]&AgencyCode=",$dtls[17]);}
    $dtls[17]=preg_replace('/document\.Xtras\.Fields\.value/',"e21Fld.Fields",$dtls[17]);
   }else{
    if(strpos($dtls[17],'&Extras=&') === false){
     $data='AccommresBook(1)';
    }else{
     $data='AccommresBook(5)';
     $dtls[17]="document.Xtras.Fields.value='SiteCode=$Site&ArrivalDate=$fld[ArrivalDate]&NumberNights=$fld[NumberNights]&PlaceNo=$dtls[4]&DevNo=$dtls[5]&AccNo=$dtls[6]&Currency=$fld[Currency]&Adults=$fld[Adults]&Children=$fld[Children]&Infants=$fld[Infants]&Babies=$fld[Babies]&InfoUnitNo=$dtls[34]&OfferCode=$fld[OfferCode]&AgencyCode=$fld[GACode]';";
    }
   }
   if($dtls[9] == '1.00'){$Lng['BookNow']=$Lng['Details'];$dtls[17]="OpenWindow('$dtls[lkAcc]','_parent')";$data='';}
   print <<<HTM
              <tr><td align='right'><div><button class="bTn-W more" name="book" onclick="$dtls[17]$data;">$Lng[BookNow]</button></div></td></tr>
             </table>
            </td>
           </tr>
          </table>
         </td>
        </tr>
       </tbody>
      </table>
     </td>
    </tr>

HTM;
  $knt++;//if($knt == 10){$knt=0;$Page++;}
  }
 }
}
if($Results != '' && $knt == 0){print "<div id='Page-1'><table><tbody><tr><td><br><center><h3>$Lng[Sorry3]</h3><center><br></td></tr>";}
print "   </tbody>
  </table>
     </div>
    </div><div class='lqd-b'><span></span></div></div></div>
   </div>
  </td>
 </tr>\n";
# Show page numbers unless results fit on one page #
if($knt == 0){$Page--;}
if($Page > 1){
 print "        <tr height='40'>\n         <td colspan=4 align='right' valign='bottom' class='pagePN psize10'>\n          <&nbsp;<a id='pg-p' href='#' onclick='showPage(\"-\",\"$Page\",this);'>$Lng[PrvPage]</a> ";
 for($i=1;$i<=$Page;$i++){print "<a id='pg-$i' href='#' onclick='showPage(\"$i\",\"$Page\",this);'>$i</a>".($i<$Page?',':'');}
 print " <a id='pg-n' href='#' onclick='showPage(\"+\",\"$Page\",this);'>$Lng[NxtPage]</a>&nbsp;>\n";
}
if($dbR){mysql_free_result($dbR);}
e21dbClose();
$fld['XQ']=URLencode($fld['XQ'])."__form$fld[searchForm]";
print "\n </tbody>\n</table>\n<script type='text/javascript'>\nLanguage='$Language';\ne21Fld['searchForm']='$fld[searchForm]';\ne21Fld['XQ']='$fld[XQ]';\n</script>\n";
if($fld['head'] == 'Y'){print $Ftr;}
#$t2b=microtime_float();
#print "<!-- Args: ".($t3b - $t3a)." -->\n";
#print "<!-- std:  ".($t3c - $t3b)." -->\n";
#print "<!-- srch: ".($t3d - $t3c)." -->\n";
#print "<!-- dbOp: ".($t1a - $t3d)." -->\n";
#print "<!-- Res:  ".($t1b - $t1a)." -->\n";
#print "<!-- sql:  ".($t1c - $t1b)." -->\n";
#print "<!-- hdr:  ".($t2a - $t1c)." -->\n";
#print "<!-- htm:  ".($t2b - $t2a)." -->\n";
#print "<!-- Total: ".($t2b - $t3a)." -->\n\n\n";
#print "<!-- $sql -->\n";

function microtime_float(){
 list($usec, $sec) = explode(" ",microtime());
 return ((float)$usec + (float)$sec);
}

?>

Re: PHP Code Help

Posted: Fri Apr 30, 2010 1:55 pm
by Christopher
That is a lot of code. Perhaps you could narrow it down a little to the section where the problem is.