Alternate HTML

toucan

I have the below code running and mostly due to my poor planning I was wrongly assuming that the query would return a record in most cases. However, I now want to develop it further so if a customer record is not returned it will not run the HTML at the end of the script instead a very different method.

I was after some ideas on the best way to do this. I have toyed with the idea of putting all the HTML into a string that is conditionally called. If i did that I presume I would have to add escape characters by all the quotes and remove " <? " etc?

Any ideas appreciated.

David

NogDog

Could you simply do a little if/else action?

$result = mysql_query($sql);
if(mysql_num_rows($result)) {
   // output the data from the query
}
else {
   // output alternate content if no results
}

toucan

Thanks Nogdog; foolishly I forgot to post the actual code that I'm refering to. I'll put it in this time.

As you'll see my html is completely separate from the bulk of the php. So how do I get it to conditionally run the html or alternate, or is the answer just to put ALL html into a massive string variable?

code!

<?php session_start(); 
include 'link.php' ;  // include the link


// get the input form data
if ($_POST) {
	foreach($_POST as $k => $v) {
	$v = trim($v);
	$$k = $v;
	}




//build the cleaning array

$nononchar = array(" ", "(", ")", "[", "]", "-", ".", ",", "#") ;

//clean the phone number
$telno = str_replace($nononchar, "", $telno);
	//clean the postcode
$postcode = str_replace($nononchar, "", $postcode);


$expire=time()+60*60*24*30;
setcookie("telno", $telno, $expire);



$select = "SELECT CustomerID, EmailAddress, ContactFirstName, ContactLastName FROM Clients WHERE PostalCode='$postcode' && PhoneNumber='$telno' "; //build the query

$result = mysqli_query($link,$select); //execute select query


// check to see if a result is returned
if (mysqli_num_rows($result) < 1) {
	echo "You don't seem to be in our database - Click here to enter your details";
} else {

$row = mysqli_fetch_array($result);
$CustomerID = $row['CustomerID'];
$ContactFirstName = $row['ContactFirstName'];
$ContactLastName = $row['ContactLastName'];
$EmailAddress = $row['EmailAddress'];


$InitialLastName = substr($ContactLastName,0,1) . "*******" ;

$FullName = "$ContactFirstName  $ContactLastName" ;

//store session data
$_SESSION['FullName'] = $FullName;
$_SESSION['Initial'] = $ContactFirstName . " " . $InitialLastName;
$_SESSION['EmailAddress'] = $EmailAddress;
$_SESSION['telno'] = $telno;
}

//Now lets get the pets
$petselect = "SELECT ProjectID, BoardersName, Boardertype FROM ClientsPets WHERE CustomerID='$CustomerID' ";
$petresult =  mysqli_query($link, $petselect); 




}

?>



<HTML>

<STYLE>
table
{ 
margin-left: auto;
margin-right: auto;
}

P 
{
font-family:"Verdana", Times, serif;
} 

TH
{
font-family:"Verdana", Times, serif;
}

TD
{
font-family:"Verdana", Times, serif;
}


</STYLE>

<body>

<div align="center"> 
<FORM METHOD="POST" ACTION="makebooking.php" name="bookingform">
<INPUT TYPE=HIDDEN NAME="CustomerID" Value="<? echo $CustomerID ?> ">
<TABLE BORDER="1">
<TH COLSPAN="3">Request A Booking</TH>
<TR>
<TH>Customer ID</TH> <TH>First Name</TH><TH>Last Name</TH>
</TR>
<TR>
<TD><? echo $CustomerID ?></TD> <TD><? echo $ContactFirstName ?> </TD> <TD> <? echo $InitialLastName ?> </TD>
</TR>
</TABLE>
<BR>
<HR>
<BR>

<TABLE>
<TR>
<TD>
<P> Click the pets you'd like to request booking for (use the 'control' button to select multiple pets): 
</TD>
<TD>
<SELECT multiple="yes" NAME="SelectPet[]">
<?
while ($rowtwo = mysqli_fetch_array($petresult)) {
	$ProjectID = $rowtwo['ProjectID'];
	$BoardersName = $rowtwo['BoardersName'];
	$Boardertype = $rowtwo['Boardertype'];

echo "<OPTION VALUE=$ProjectID>  $BoardersName  the   $Boardertype  </OPTION>";
 } ?>
</SELECT>
</TD>
</TR>
<TR>
</TR>

</TABLE>

<HR>
</BR>
<TABLE border="1">
<TR><TH COLSPAN="6" style="text-align:center">Booking Dates</TH>
</TR>
<TR>
<TH COLSPAN="3">Arrival</TH><TH COLSPAN="3">Checkout</TH>
</TR>
<TD>
<SELECT NAME="InDate">


<?
	//back to php for counting dates
$startcounter = 1;
$endcounter = 32;
while ($startcounter < $endcounter) {
echo "<OPTION VALUE= $startcounter > $startcounter </OPTION>";
$startcounter++;
}
?>
</SELECT> 
</TD>
<TD>
<SELECT NAME="InMonth">
<OPTION VALUE=01> January </OPTION>
<OPTION VALUE=02> February </OPTION>
<OPTION VALUE=03> March </OPTION>
<OPTION VALUE=04> April </OPTION>
<OPTION VALUE=05> May </OPTION>
<OPTION VALUE=06> June </OPTION>
<OPTION VALUE=07> July </OPTION>
<OPTION VALUE=08> August </OPTION>
<OPTION VALUE=09> September </OPTION>
<OPTION VALUE=10> October </OPTION>
<OPTION VALUE=11> November </OPTION>
<OPTION VALUE=12> December </OPTION>
</SELECT> 
</TD>
<TD>
<SELECT NAME="InYear">
<OPTION VALUE=2011> 2011 </OPTION>
<OPTION VALUE=2012> 2012 </OPTION>
</SELECT>
- 
</TD>

<TD>
-
<SELECT NAME="OutDate">


<?
	//back to php for counting dates
$startcounter = 1;
$endcounter = 32;
while ($startcounter < $endcounter) {
echo "<OPTION VALUE= $startcounter > $startcounter </OPTION>";
$startcounter++;
}
?>
</SELECT> 
</TD>
<TD>
<SELECT NAME="OutMonth">
<OPTION VALUE=01> January </OPTION>
<OPTION VALUE=02> February </OPTION>
<OPTION VALUE=03> March </OPTION>
<OPTION VALUE=04> April </OPTION>
<OPTION VALUE=05> May </OPTION>
<OPTION VALUE=06> June </OPTION>
<OPTION VALUE=07> July </OPTION>
<OPTION VALUE=08> August </OPTION>
<OPTION VALUE=09> September </OPTION>
<OPTION VALUE=10> October </OPTION>
<OPTION VALUE=11> November </OPTION>
<OPTION VALUE=12> December </OPTION>
</SELECT> 
</TD>
<TD>
<SELECT NAME="OutYear">
<OPTION VALUE=2011> 2011 </OPTION>
<OPTION VALUE=2012> 2012 </OPTION>
</SELECT>
</TD>
</TR>


</TABLE>

<TABLE>
<TR>
<TD COLSPAN="4">
Do you plan to collect your pet in the morning or afternoon? <br>
</TD>
<TD >
<input type="radio" name="pickup" value="AM" checked>Before MidDay<br>
<input type="radio" name="pickup" value="PM">After MidDay<br>


</TD>
</TR>
</TABLE>

<INPUT TYPE ="SUBMIT" VALUE="Request Booking" />
</FORM>
</DIV>
<HR>

</body>
</HTML>

Emma

Just stick the conditional HTML in a string. You will have to remove the <? php echo but
don't have to escape the double quotes though, either encase in single quote and concatenate the variables i.e.

$html = '<INPUT TYPE=HIDDEN NAME="CustomerID" Value="'. $CustomerID.'"> ';

or less effort, find and replace the double quote marks with singles that way there's no need for concatenation.

$html = "<INPUT TYPE=HIDDEN NAME='CustomerID' Value='$CustomerID'> ";

JVassie

NogDog;10970315 wrote:

Could you simply do a little if/else action?

$result = mysql_query($sql);
if(mysql_num_rows($result)) {
   // output the data from the query
}
else {
   // output alternate content if no results
}

Well surely what NogDog said would still work? Unless I have missed something?

$result = mysql_query($sql);
if(mysql_num_rows($result)) {
   // output the data from the query
   ?>
             (PASTE HTML HERE)
   <?php
}
else {
   // output alternate content if no results
   ?>
             (PASTE HTML HERE)
   <?php
}

Would work and mean you dont need to worry about placing HTML in a string variable

toucan

JVassie;10970618 wrote:
Well surely what NogDog said would still work? Unless I have missed something?
$result = mysql_query($sql);
if(mysql_num_rows($result)) {
   // output the data from the query
   ?>
             (PASTE HTML HERE)
   <?php
}
else {
   // output alternate content if no results
   ?>
             (PASTE HTML HERE)
   <?php
}
Would work and mean you dont need to worry about placing HTML in a string variable

Interesting point, now you show it like that then maybe yes. I didn't know if I could maintain the IF, if I dropped out of php like you have shown. I've spend a fair amount of time butchering the HTML into 3 strings, so yes I would quite like to know the answer.

On Emma's point, I don't understand the concatenation of the variables, . $xxxx . What does that do?

I thought you could only normally refer to a variable in a string if it were enclosed in double quotes?

bradgrafelman

toucan wrote:
On Emma's point, I don't understand the concatenation of the variables, . $xxxx . What does that do?

Well it... concatenates. Not much else to say about it - it just concatenates two strings together.

toucan wrote:
I thought you could only normally refer to a variable in a string if it were enclosed in double quotes?

That's variable interpolation inside of double-quote delimited strings, aye... but you can also just concatenate a bunch of strings together.

JVassie

toucan;10970670 wrote:
On Emma's point, I don't understand the concatenation of the variables, . $xxxx . What does that do?

An example for you:

$str1 = "a string";
$string = "This is " . $str1 . " containing concatenated strings";

Very very basic, but you can see you can combine any combination of literal strings (enclosed by double quotes) and variables containing other strings.

The period (.) is the operator you need to use, just like for addition you use +

Hope that helps
James