Jump to content

Adding a further behaviour to a page

bladechob

By bladechob
in PHP Coding Help

 Share

Recommended Posts

bladechob Member

bladechob

Posted
Posted

Hi, I've got a page where it seraches a database and returns hotel info. On the page returned it also has a behaviour that highlights whether a particular venue has been 'blacklisted'. I need to add a further behaviour that indicates whether a particular venue is commissionable or not - if not it should highlight that venue as being non-commissionable. I've tried various means of inserting the additional 'warning' but the page just crashes out. Where am I going wrong with  this? Base page code below. In a nutshell I've set up the sql - written from another page so that to simple radio buttons indicate noncomm or not:

 

<?
error_reporting(0);
session_start();

//if(!isset($_SESSION["userid"])){
//header("Location:index.htm");
//echo "logon failed"; 
//exit;
//}
if(!empty($_GET['session'])){
unset($_SESSION['sql']);
}

//echo $sql;

?>
<html>
<!-- Creation date: 14/08/2003 -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title></title>
<meta name="description" content="">
<meta name="keywords" content="">
<meta name="author" content="Lathyrus Ltd">
<meta name="generator" content="AceHTML 5 Pro">
<link rel="StyleSheet" type="text/css" href="style.css">
<script language="JavaScript">
function blackListAlert(){
alert('You have selected a blacklisted hotel. This may be because the client has insisted on this venue. If you have selected this hotel in error, or the client is happy to use a different venue, please choose a different one immediately. You can do this by clicking the "Change Hotel" link in the venue details section on the left of the screen."');
}
</script><style type="text/css">
<!--
body {
background-color: #ccffcc;
}
-->
</style></head>
<body  leftmargin="0" marginwidth="0" topmargin="0" marginheight="0">
<table summary="" border="0" width="100%" height="100%" bgcolor="white">
  <tr>
    <td valign="top">
<?
require_once("cfg.php");
require_once($CFG->include_dir . "/config.php");
require_once($CFG->include_dir . "/weblib.php");
require_once($CFG->include_dir . "/dblib.php");
if (!isset($search) && !isset($_SESSION['sql'])){ ?>
<form action="<?PHP $_SERVER['PHP_SELF'];?>" method="POST">
<table border="0" cellpadding=0 bgcolor="#ccffcc" class="hotel" summary="">
  <tr>
    <td>Hotel Number</td>
    <td><input type="text" name="searchhotelid" size="20" maxlength="256"></td><!-- *** -->
  </tr>
  <tr>
    <td>Hotel name</td>
    <td><input type="text" name="searchname" size="50" maxlength="256"></td><!-- *** -->
  </tr>
  <tr>
    <td>Preferred by </td>
    <td><input type="text" name="searchpreferred" size="50" maxlength="256"></td><!-- *** -->
  </tr>
  <tr>
    <td>Hotel Town</td>
    <td><input type="text" name="searchtown" size="50" maxlength="256"></td><!-- *** -->
  </tr>
    <tr>
    <td>County</td>
    <td><input type="text" name="searchcounty" size="50" maxlength="256"></td><!-- *** -->
  </tr>
  <tr>
    <td>Country</td>
    <td><input type="text" name="searchcountry" size="50" maxlength="256"></td><!-- *** -->
  </tr>
      <tr>
    <td>Postcode</td>
    <td><input type="text" name="searchpost" size="50" maxlength="256"></td><!-- *** -->
  </tr>
    <tr>
    <td>Region</td>
    <td><select name="searchregion">
<option></option>
<?
dbconnect(); 
$queryu = "select list from lists where name='region' ";
$resultu=mysql_query($queryu,$conn);
$list=mysql_result($resultu,0,0);
$list = preg_replace("/(\015\012)|(\015)|(\012)/","@",$list); 
$list_array=explode ("@", $list);
$count=count($list_array);
for ($loopi=0;$loopi<$count;++$loopi){
$this=$list_array[$loopi];?>
<option <? if ($this==$hotel_region){echo ' selected';}?>> <? echo $list_array[$loopi];?></option>
<? }?>
</select></td><!--dd-->
  </tr>
      <tr>
    <td>Rating</td>
    <td><select name="searchrating">
<option></option>
<?
dbconnect(); 
$queryu = "select list from lists where name='cimrating' ";
$resultu=mysql_query($queryu,$conn);
$list=mysql_result($resultu,0,0);
$list = preg_replace("/(\015\012)|(\015)|(\012)/","@",$list); 
$list_array=explode ("@", $list);
$count=count($list_array);
for ($loopi=0;$loopi<$count;++$loopi){
$this=$list_array[$loopi];?>
<option <? if ($this==$hotel_rating){echo ' selected';}?>> <? echo $list_array[$loopi];?></option>
<? }?>
</select></td><!--dd-->
  </tr>
      <tr>
    <td>Type</td>
    <td><select name="searchtype">
<option></option>
<?
dbconnect(); 
$queryu = "select list from lists where name='venuetype' ";
$resultu=mysql_query($queryu,$conn);
$list=mysql_result($resultu,0,0);
$list = preg_replace("/(\015\012)|(\015)|(\012)/","@",$list); 
$list_array=explode ("@", $list);
$count=count($list_array);
for ($loopi=0;$loopi<$count;++$loopi){
$this=$list_array[$loopi];?>
<option <? if ($this==$hotel_type){echo ' selected';}?>> <? echo $list_array[$loopi];?></option>
<? }?>
</select></td><!-- *** -->
  </tr>
      <tr>
    <td>Rooms</td>
    <td><input type="text" name="searchrooms" size="20" maxlength="256"></td><!-- *** -->
  </tr>
    <tr>
    <td>Hotel Group</td>
    <td><input type="text" name="searchgroup" size="50" maxlength="256"></td><!-- *** -->
  </tr>
    <tr>
      <td> </td>
        <td> </td>
              <tr>
    <td>Room style capacity</td>
    <td>
<table summary="" border="0">
  <tr>
    <td>Banquet </td>
    <td> <input type="text" name="searchba" size="5" maxlength="5" ></td>
    <td>Boardroom</td>
    <td><input type="text" name="searchbo" size="5" maxlength="5" ></td>
  </tr>
  <tr>
    <td>Classroom</td>
    <td><input type="text" name="searchc" size="5" maxlength="5" ></td>
    <td>Theatre </td>
    <td><input type="text" name="searcht" size="5" maxlength="5" ></td>
  </tr>
  <tr>
    <td>U Shaped</td>
    <td><input type="text" name="searchu" size="5" maxlength="5" ></td>
    <td>Maximum</td>
    <td><input type="text" name="searchm" size="5" maxlength="256" ></td>
  </tr>
</table></td>
  </tr>
    <tr>
    <td>
<? if (isset($clientid)){echo '<input type=hidden name=clientid value='.$clientid.'>';}?>
<input type="hidden" name="search" value="1">
<input type="hidden" name="source" value="<? echo $source?>">
					<input name="submit" type="submit" class=button value="Search"></td>
  </tr>
</table>
</form>



<? }
else{ //if(isset($search)){unset($_SESSION['sql']);}
if ($searchname!=''){
$sql1=' and venue_main.name like \'%'.trim($searchname).'%\'';
}
if (!empty($_REQUEST['searchtown'])){
$sql2=' and venue_main.town like \'%'.$searchtown.'%\'';
}
if ($searchgroup!=''){
$sql3=' and venue_main.groupname like \'%'.$searchgroup.'%\'';
}
if ($searchhotelid!=''){
$sql4=' and venue_main.hotelid=\'%'.$searchhotelid.'%\' ';
}
if ($searchpost!=''){
$sql5=' and venue_main.postcode like \'%'.$searchpost.'%\'';
}
if ($searchrooms!=''){
$sql6=' and venue_main.rooms> \'%'.$searchrooms.'%\' ';
}
if ($searchcounty!=''){
$sql7=' and venue_main.county like \'%'.$searchcounty.'%\' ';
}
if ($searchcountry!=''){
$sql7a=' and venue_main.country like \'%'.$searchcountry.'%\' ';
}
if ($searchregion!=''){
$sql8=' and venue_main.region like \'%'.$searchregion.'%\' ';
}
if ($searchrating!=''){
$sql9=' and venue_main.rating like \'%'.$searchrating.'%\' ';
}
if ($searchtype!=''){
$sql10=' and venue_main.type like \'%'.$searchtype.'%\' ';
}
if (!empty($searcht) || !empty($searchm)){
if(!empty($searcht)){
$sfilter=$searcht;
}else{
$sfilter=$searchm;
}
$sqls=', venue_rooms';
$sql11='  and venue_main.hotelid=venue_rooms.hotelid and  venue_rooms.theatre >= \''.$sfilter.'\' ';
}
if ($searchpreferred!=''){
$sql12=' and venue_main.preferred like \'%'.trim($searchpreferred).'%\'';
}
if (!isset ($sql)){
$sql=$sql1.$sql2.$sql3.$sql4.$sql5.$sql6.$sql7.$sql7a.$sql8.$sql9.$sql10.$sql11.$sql12;


$_SESSION['sql']=$sql;
}
if(isset($_SESSION['sql'])){$sql=$_SESSION['sql'];}
$sql=stripslashes($sql);
?>
<table summary="" border="0" class=hotel>
  <tr>
    <td colspan="2"></td>
    <td align="right" colspan="3"><a href="<? echo "search_hotel.php?session=kill&source=$source"; ?>"><b>New Search</b></a></td><!-- *** -->
  </tr>
<tr><td colspan=7> Order by -<br> </td></tr>
<form action="<?PHP $_SERVER['PHP_SELF'];?>" method="POST">
<input type="hidden" name="search" value="1">
<input type="hidden" name="source" value="<? echo $source?>">
<input type="hidden" name="sql" value="<? echo $sql?>">
  <tr>
    <td ><input  name='Hotel/Venue' type="submit" value="Hotel/Venue" ></td>
    <td ><input  name='Preferred' type="submit" value="Preferred" ></td>
    <td><input  name='Town'  type="submit" value="Town"></td>
    <td><input  name='Group'  type="submit" value="Group" ></td>
    <td><input  name='Rooms'  type="submit" value="Rooms" ></td>
    <td><input  name='Rate'  type="submit" value="Rate" ></td>
    <td></td>
  </tr>  
</form>
<tr><td colspan=7><hr></td></tr>
<?
//echo $_POST['Hotel/Venue'];
//echo $order;
if (!isset ($order)){$order='order by venue_main.town ';}
if ($_POST['Hotel/Venue']=="Hotel/Venue"){$order='order by '.name;}
if ($_POST['Preferred']=="Preferred"){$order='order by '.preferred;}
if ($_POST['Town']=="Town"){$order='order by '.town;}
if ($_POST['Group']=="Group"){$order='order by '.groupname;}
if ($_POST['Rooms']=="Rooms"){$order='order by '.rooms;}
if ($_POST['Rate']=="Rate"){$order='order by rate desc';}

if(isset($_SESSION['sql'])){$sql=$_SESSION['sql'];}
//if(isset($_SESSION['order'])){$order=$_SESSION['order'];}

dbconnect(); 
$query = "select
venue_main.hotelid, 
venue_main.name,
  venue_main.town, 
  venue_main.groupname,
   venue_main.rooms,
   venue_main.preferred,
      venue_main.blacklisted 
    from venue_main $sqls
where 1 
  
$sql group by venue_main.hotelid $order";


if(!$result=mysql_query($query,$conn))echo mysql_error();
while ($r= mysql_fetch_array($result)) {
$hotelid=$r["hotelid"];

$_SESSION['query']=$query;

$bgcol='#FFFFFF';
$isBlacklisted=false;
if($r['blacklisted']=='Y'){
$bgcol='#999999';
$isBlacklisted=true;
}

?>

   <tr <? if($isBlacklisted){echo "title=\"This hotel is blacklisted. Please only choose it if the client insists on it and you cannot persuade them to use another.\""; } ?>>
    <td width=88 bgcolor="<? echo $bgcol; ?>"> <a href="cimnetint.php?content=<? echo $source?><? if (isset($clientid)){echo '&clientid='.$clientid;}?>&newhotelid=<? echo $r["hotelid"]?>" target=_parent <? if($isBlacklisted){echo "onClick=\"blackListAlert()\"";} ?>><? echo $r["name"]?></a></td>
    <td width=90 bgcolor="<? echo $bgcol; ?>"><? echo $r["preferred"]?></a></td>
    <td width=120 bgcolor="<? echo $bgcol; ?>"><? echo $r["town"]?></td>
    <td bgcolor="<? echo $bgcol; ?>"><? echo $r["groupname"]?></td>
    <td align=right bgcolor="<? echo $bgcol; ?>"><? if ($r["rooms"]!='0'){echo $r["rooms"];}?></td>
<?php $rq="SELECT rate from venue_rates where ratename like 'Rack%' and hotelid='".$r['hotelid']."' ";
	$rqs=mysql_query($rq,$conn);
	$rateval=mysql_result($rqs,0,0);  ?>
    <td bgcolor="<? echo $bgcol; ?>"><? echo $rateval; ?> </td>
    <td bgcolor="<? echo $bgcol; ?>"></td>
  </tr>
  
<? }}?>
</table>

</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/55937-adding-a-further-behaviour-to-a-page/
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.