Need to add image to a databse

qim · December 1, 2015, 6:14am

Thanks to spaceshiptrooper I now have a Seach facilty that displays results in a table with 6 cells. I need an extra cell, an image, that depends on one of the fields in the database; $Chain.

How can I add an image to the database?

The database will have some 5000 records but only needs around 20 images (one for each $Chain )

?>

    <tr>
        <td> <?php echo $chain; ?></td>
        <td> <?php echo $country; ?></td>
        <td> <?php echo $city; ?></td>
        <td> <?php echo $top; ?></td>
        <td> <?php echo $medium; ?></td>
        <td> <?php echo $low; ?></td>
    </tr>
<?php

John_Betong · December 1, 2015, 7:39am

I prefer to have links to images:

define('PATH_TO_IMAGES', $_SERVER['DOCUMENT_ROOT'] .'afiles/images/'); // notice trailing slash

// database 
table->chain = "chain-001.jpg"; // just image name

echo '<img src="' .PATH_TO_IMAGES .$chain .'" alt="' .$city .'" />';

qim · December 1, 2015, 7:43am

Hi

Thank you John, but databases and the php that goes with it are still a mystery to me!

Do I understand that I need to put something in the MySQL databse: another field?

and where do I put the line echo '<img src="' .PATH_TO_IMAGES .$chain .'" alt="' .$city .'" />';

$sql = "SELECT Chain, Country, City, Top, Medium, Low FROM Chains WHERE Country LIKE ? OR City LIKE ?"; // Your query string
$prepare = $mysqli->prepare($sql); // Prepare your query string
$prepare->bind_param('ss', $searchq, $searchq); // Bind the placeholders to your search variables
// s = string | i = integer | d = double | b = blob
$prepare->execute(); // Execute the prepared statement
$prepare->store_result(); // Store the results for later checking

// Use num_rows to check if the results return a 0 or 1. 0 meaning false and 1 meaning true
if($prepare->num_rows) {

$prepare->bind_result($chain, $country, $city, $top, $medium, $low); // Append variables to the columns you specified

// Throw them all in a while loop
while($prepare->fetch()) {

John_Betong · December 1, 2015, 8:03am

@qim

OK forget my previous post, I think this will be easier.

If there are only 20 images involved then add a function:

// define once 
define('PATH_TO_IMAGES', '/path_to-images/');

//=========================
function getImage($chain=NULL)
{
   $result = 'img_chain-default.jpg';

   switch ($chain) { 
     case 'chain-001' : $result = 'chain-001.jpg';
     break;
     case 'chain-002' : $result = 'chain-002.jpg';
     break;
     case 'chain-003' : $result = 'chain-003.jpg';
     break;
     case 'chain-004' : $result = 'chain-004.jpg';
     break;
   
     case 'chain-XXX' : $result = 'chain-XXX.jpg';
     break;
   }//endswitch

   return PATH_TO_IMAGES .$result;
}

$sql = "
      SELECT Chain, Country, City, Top, Medium, Low, Image 
      FROM   Chains 
      WHERE  Country LIKE ? OR City LIKE ?
      "; // Your query string
   ...
   ...
   ...

   $img = getImage($chain);  
   $img = '<img src="'  .$img  .'" alt="' .$city .'" />';
?>
    <tr>
        <td> <?php echo $img; ?></td>
        <td> <?php echo $chain; ?></td>
        <td> <?php echo $country; ?></td>
        <td> <?php echo $city; ?></td>
        <td> <?php echo $top; ?></td>
        <td> <?php echo $medium; ?></td>
        <td> <?php echo $low; ?></td>
    </tr>

Mittineague · December 1, 2015, 8:07am

If it were me, I think I would create a table named something like “chain_images” with “chain_name” and “img_path” fields (name whatever suits you best)

The query would be a bit more complex but I think it would be more efficient and easier to maintain

qim · December 1, 2015, 8:10am

Hi, Thank you both.
I’m trying to understand John’s code and make the necessary changes in the page.

Once, I get that working I will come back to Mittineague and lose a few more hairs because right now I am at a loss with both solutions.

Give me a few minutes, please.

qim · December 1, 2015, 8:21am

Hi John

is this where the code is supposed to go?

I gueess not because it is not working. Try http://pintotours.net/TEMP/SPACE/test10.html and enter “Brussels” in the Search box

 <div id="main">

<h2> You searched for hotels in ......</h2>
<p> The following chains guarantee the lowest rates on the Internet</p>

<div class="space"><p>5*                           4*                          3*</p></div>

<table>

<?php
// Your database preferences
// We are using constants instead of variables for this
// You can use either or
define('HOST', 'localhost'); // Database host
define('pintotou_*****', 'root'); // Database username
define('*******', 'root'); // Database password
define('pintotou_search', ''); // Database
define('PATH_TO_IMAGES', '/path_to-images/');

$mysqli = new mysqli('localhost', 'pintotou_******', '******', 'pintotou_search'); // Connect to the database using MySQLi_* OOP and constants
if($mysqli->connect_errno) {

// Do not die or display any MySQL errors in this area.
die(‘Unable to connect to the mysql server’);

}

$searchq = filter_var("%{$_POST['keyword']}%", FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH); // Sanitize the string
//=========================
function getImage($chain=NULL)
{
   $result = 'img_chain-default.jpg';

   switch ($chain) {

case ‘chain-001’ : $result = ‘chain-AccorTest.jpg’;
break;
case ‘chain-002’ : $result = ‘chain-002.jpg’;
break;
case ‘chain-003’ : $result = ‘chain-003.jpg’;
break;
case ‘chain-004’ : $result = ‘chain-004.jpg’;
break;

case ‘chain-XXX’ : $result = ‘chain-XXX.jpg’;
break;
}//endswitch

   return PATH_TO_IMAGES .$result;
}
$sql = "SELECT Chain, Country, City, Top, Medium, Low, Image FROM Chains WHERE Country LIKE ? OR City LIKE ?"; // Your query string
$prepare = $mysqli->prepare($sql); // Prepare your query string
$prepare->bind_param('ss', $searchq, $searchq); // Bind the placeholders to your search variables
// s = string | i = integer | d = double | b = blob
$prepare->execute(); // Execute the prepared statement
$prepare->store_result(); // Store the results for later checking

// Use num_rows to check if the results return a 0 or 1. 0 meaning false and 1 meaning true
if($prepare->num_rows) {

$prepare->bind_result($chain, $country, $city, $top, $medium, $low); // Append variables to the columns you specified

// Throw them all in a while loop
while($prepare->fetch()) {

// Technically you don't need to use HEREDOCS because if you end the PHP tag and restart it
// You can have your full HTML in your PHP file
// This isn't ideal though, you should separate your HTML from PHP, but since you are still a beginner
// This doesn't really mean anything.
// I'd say put these results in a new PHP file and require it
$img = getImage($chain);  
   $img = '<img src="'  .$img  .'" alt="' .$city .'" />';
?>

    <tr>
        <td> <?php echo $img; ?></td>
        <td> <?php echo $chain; ?></td>
        <td> <?php echo $country; ?></td>
        <td> <?php echo $city; ?></td>
        <td> <?php echo $top; ?></td>
        <td> <?php echo $medium; ?></td>
        <td> <?php echo $low; ?></td>
    </tr>
<?php

}

} else {
?>
    <tr>
        <td colspan="6">There were no search results!</td>
    </tr>
<?php

}


?>
</table>

qim · December 1, 2015, 8:25am

I copied the file across to Notepad++ and line 135 is

$prepare->bind_param('ss', $searchq, $searchq); // Bind the placeholders to your search variables

Wouldn’t something like this after the results work?

<td>If $Chain == Accor Load Accor.jpg</td>

Is it possible to upload the php file, rather than paste the contents?

qim · December 1, 2015, 8:32am

Hi

I’ve copies the Results3.php across to http://pintotours.net/TEMP/SPACE/Results2.html so that you can have a look at the full code.

John_Betong · December 1, 2015, 9:02am

The start and finish of your PHP scripts are incorrect and showing the PHP source.

qim · December 1, 2015, 9:37am

Hi John

I was without Internet for some 20 minutes…

I cannot get your page to work.

I changed it back to .php and made the necessary changes (I think…)

I cannot understand your comment about start and finish of php

Now at the top of the php I have

    <table>

<?php
// Your database preferences
// We are using constants instead of variables for this
// You can use either or
define('HOST', 'localhost'); // Database host
define('pintotou_****', 'root'); // Database username
define('****', 'root'); // Database password
define('pintotou_search', ''); // Database

$mysqli = new mysqli('localhost', 'pintotou_****', '*****', 'pintotou_search'); // Connect to the database using MySQLi_* OOP and constants
if($mysqli->


connect_errno) {

// Do not die or display any MySQL errors in this area.
die(‘Unable to connect to the mysql server’);

}

$searchq = filter_var("%{$_POST['keyword']}%", FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH); // Sanitize the string

Try it with http://pintotours.net/TEMP/SPACE/test10.html and enter “Brussels”

qim · December 1, 2015, 9:55am

Sorry…

I don’t understand what you added and what you changed. My changes are in a mess and no wonder it does not work.

I think the main problem is that you commentedd out most of the original code and that’s thrown me.

maybe the easiest way is to go back to the original file and changes things one at a time.

In the table I have to add

<td> <?php echo $img; ?></td>

$img comes from

$img = getImage($chain);
$img = ‘’;

That in turn connects to getImage($chain); a function

function getImage($chain=NULL)
{
$result = ‘img_chain-default.jpg’;

switch ($chain) {
case ‘chain-001’ : $result = ‘chain-AccorTest.jpg’;
break;
case ‘chain-002’ : $result = ‘chain-002.jpg’;
break;
case ‘chain-003’ : $result = ‘chain-003.jpg’;
break;
case ‘chain-004’ : $result = ‘chain-004.jpg’;
break;
 case 'chain-XXX' : $result = 'chain-XXX.jpg';
 break;
}//endswitch

but then I don’t understand where chain-001, chain-002 etc comes from.

EDIT

OK. This is the name of the several Chains, say, I substitute case-001 for Accor, case-002 for Hilton, etc

maybe I did’t explain well.

This is about hotel chains. You have Accor, Hilton, Sheraton, etc

The current code after a search displays $Chain, $City, etc and I need to put a logo of the chain as the first cell of the table.

EDITED BELOW: wrong before

The way I think without talking of code is that i need some thing that does " if $Chain== ‘Accor’ load Accor img in cell1; if $Chain== ‘Hilton’ load Hilton img in cell1; if $Chain== Sheraton’ load Sheraton img in cell1

That I thought could be done inside the <td></td>

The current file works well and was given to me by spaceshiptrooper, only yesterday. It would not be nice to change it entirely without his knowledge, What I need, if it is at all possible, is to add to it.

from what I deduct I only need to know where to place the 2 bits of code in the page: the function and the

$img = getImage($chain);
$img = ‘’;

The rest seems obvious.

qim · December 1, 2015, 10:30am

Hi just to answer previous post

I copied the file with an html extension so that you could see the php code

qim · December 1, 2015, 11:17am

In your code above you have

$sql = "

SELECT Chain, Country, City, Top, Medium, Low, Image
FROM Chains
WHERE Country LIKE ? OR City LIKE ?
"; // Your query string

That assumes a field in the database for ‘image’ which does not exist.

Do you mean that I should create one? And what do I put in it?

John_Betong · December 1, 2015, 12:15pm

Try this demo

Try inputting either Accor, Hilton or Sheraton and notice the results.

Your source code has been simplified and you may notice the file source code is shown below

Note: FILE is a PHP file name constant.

Note where I have remmed the database script. When you test for $_POST variable and if it exists then search the database and substitute the default values.

Have fun

qim · December 1, 2015, 12:27pm

Hi John

many thanks but I’m lost as usual

The View code shows some html and then what appears to be minified code

I unminified it but got only a few lianes out of all this

<div style="width:88%; margin:2em auto; background-color:#fff; border:solid 1px red; padding:1em;">
  <code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />error_reporting</span><span style="color: #007700">(</span><span style="color: #0000BB">E_ALL</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Show&nbsp;all&nbsp;error&nbsp;messages<br /></span><span style="color: #0000BB">ini_set</span><span style="color: #007700">(</span><span style="color: #DD0000">'display_errors'</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">true</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">//&nbsp;Your&nbsp;database&nbsp;preferences<br />//&nbsp;We&nbsp;are&nbsp;using&nbsp;constants&nbsp;instead&nbsp;of&nbsp;variables&nbsp;for&nbsp;this<br />//&nbsp;You&nbsp;can&nbsp;use&nbsp;either&nbsp;or<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'HOST'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'localhost'</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Database&nbsp;host<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'pintotou_*****'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'root'</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Database&nbsp;username<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'*******'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'root'</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Database&nbsp;password<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'pintotou_search'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">''</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Database<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'PATH_TO_IMAGES'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">''</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;/path_to-images/<br /><br />//=========================<br /></span><span style="color: #007700">function&nbsp;</span><span style="color: #0000BB">getImage</span><span style="color: #007700">(</span><span style="color: #0000BB">$chain</span><span style="color: #007700">=</span><span style="color: #0000BB">NULL</span><span style="color: #007700">)<br />{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Hotel-default.jpg'</span><span style="color: #007700">;<br /><br />&nbsp;&nbsp;&nbsp;switch&nbsp;(</span><span style="color: #0000BB">$chain</span><span style="color: #007700">)&nbsp;{&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;</span><span style="color: #DD0000">'Accor'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">:&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Accor.jpg'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;</span><span style="color: #DD0000">'Hilton'&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">:&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Hilton.jpg'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;</span><span style="color: #DD0000">'Sheraton'&nbsp;</span><span style="color: #007700">:&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Sheraton.jpg'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;</span><span style="color: #DD0000">'Hotel-X'&nbsp;&nbsp;</span><span style="color: #007700">:&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Hotel-X.jpg'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<br />&nbsp;&nbsp;&nbsp;}</span><span style="color: #FF8000">//endswitch<br /><br />&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">return&nbsp;</span><span style="color: #0000BB">PATH_TO_IMAGES&nbsp;</span><span style="color: #007700">.</span><span style="color: #0000BB">$result</span><span style="color: #007700">;<br />}<br /><br /></span><span style="color: #FF8000">/*<br />$searchq&nbsp;=&nbsp;filter_var("%{$_POST['keyword']}%",&nbsp;FILTER_SANITIZE_STRING,&nbsp;FILTER_FLAG_STRIP_HIGH);&nbsp;//&nbsp;Sanitize&nbsp;the&nbsp;string<br />$sql&nbsp;=&nbsp;"SELECT&nbsp;Chain,&nbsp;Country,&nbsp;City,&nbsp;Top,&nbsp;Medium,&nbsp;Low,&nbsp;Image&nbsp;FROM&nbsp;Chains&nbsp;WHERE&nbsp;Country&nbsp;LIKE&nbsp;?&nbsp;OR&nbsp;City&nbsp;LIKE&nbsp;?";&nbsp;//&nbsp;Your&nbsp;query&nbsp;string<br />$prepare&nbsp;=&nbsp;$mysqli-&gt;prepare($sql);&nbsp;//&nbsp;Prepare&nbsp;your&nbsp;query&nbsp;string<br />$prepare-&gt;bind_param('ss',&nbsp;$searchq,&nbsp;$searchq);&nbsp;//&nbsp;Bind&nbsp;the&nbsp;placeholders&nbsp;to&nbsp;your&nbsp;search&nbsp;variables<br />//&nbsp;s&nbsp;=&nbsp;string&nbsp;|&nbsp;i&nbsp;=&nbsp;integer&nbsp;|&nbsp;d&nbsp;=&nbsp;double&nbsp;|&nbsp;b&nbsp;=&nbsp;blob<br />$prepare-&gt;execute();&nbsp;//&nbsp;Execute&nbsp;the&nbsp;prepared&nbsp;statement<br />$prepare-&gt;store_result();&nbsp;//&nbsp;Store&nbsp;the&nbsp;results&nbsp;for&nbsp;later&nbsp;checking<br /><br />//&nbsp;Use&nbsp;num_rows&nbsp;to&nbsp;check&nbsp;if&nbsp;the&nbsp;results&nbsp;return&nbsp;a&nbsp;0&nbsp;or&nbsp;1.&nbsp;0&nbsp;meaning&nbsp;false&nbsp;and&nbsp;1&nbsp;meaning&nbsp;true<br />if($prepare-&gt;num_rows)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;$prepare-&gt;bind_result($chain,&nbsp;$country,&nbsp;$city,&nbsp;$top,&nbsp;$medium,&nbsp;$low);&nbsp;//&nbsp;Append&nbsp;variables&nbsp;to&nbsp;the&nbsp;columns&nbsp;you&nbsp;specified<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Throw&nbsp;them&nbsp;all&nbsp;in&nbsp;a&nbsp;while&nbsp;loop<br />&nbsp;&nbsp;&nbsp;&nbsp;while($prepare-&gt;fetch())&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Technically&nbsp;you&nbsp;don't&nbsp;need&nbsp;to&nbsp;use&nbsp;HEREDOCS&nbsp;because&nbsp;if&nbsp;you&nbsp;end&nbsp;the&nbsp;PHP&nbsp;tag&nbsp;and&nbsp;restart&nbsp;it<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;You&nbsp;can&nbsp;have&nbsp;your&nbsp;full&nbsp;HTML&nbsp;in&nbsp;your&nbsp;PHP&nbsp;file<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;This&nbsp;isn't&nbsp;ideal&nbsp;though,&nbsp;you&nbsp;should&nbsp;separate&nbsp;your&nbsp;HTML&nbsp;from&nbsp;PHP,&nbsp;but&nbsp;since&nbsp;you&nbsp;are&nbsp;still&nbsp;a&nbsp;beginner<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;This&nbsp;doesn't&nbsp;really&nbsp;mean&nbsp;anything.<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;I'd&nbsp;say&nbsp;put&nbsp;these&nbsp;results&nbsp;in&nbsp;a&nbsp;new&nbsp;PHP&nbsp;file&nbsp;and&nbsp;require&nbsp;it<br />&nbsp;&nbsp;&nbsp;$img&nbsp;=&nbsp;getImage($chain);&nbsp;&nbsp;Accor<br />&nbsp;&nbsp;&nbsp;$img&nbsp;=&nbsp;'&lt;img&nbsp;src="'&nbsp;&nbsp;.$img&nbsp;&nbsp;.'"&nbsp;alt="'&nbsp;.$city&nbsp;.'"&nbsp;/&gt;';<br />}<br />*/<br /><br />//&nbsp;KLUDGE:&nbsp;TO&nbsp;MAKE&nbsp;IT&nbsp;WORK&nbsp;<br />//&nbsp;THSES&nbsp;DEFAULTS&nbsp;SHOULD&nbsp;COME&nbsp;FROM&nbsp;DATABASE<br /></span><span style="color: #0000BB">$chain&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$chain'</span><span style="color: #007700">;&nbsp;<br /></span><span style="color: #0000BB">$country&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$country'</span><span style="color: #007700">;&nbsp;<br /></span><span style="color: #0000BB">$city&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$city'</span><span style="color: #007700">;&nbsp;<br /></span><span style="color: #0000BB">$top&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$top'</span><span style="color: #007700">;&nbsp;<br /></span><span style="color: #0000BB">$medium&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$medium'</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$low&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$low'</span><span style="color: #007700">;&nbsp;<br /><br /></span><span style="color: #0000BB">$img&nbsp;</span><span style="color: #007700">=&nbsp;isset(&nbsp;</span><span style="color: #0000BB">$_POST</span><span style="color: #007700">[</span><span style="color: #DD0000">'keyword'</span><span style="color: #007700">]&nbsp;)&nbsp;?&nbsp;</span><span style="color: #0000BB">$_POST</span><span style="color: #007700">[</span><span style="color: #DD0000">'keyword'</span><span style="color: #007700">]&nbsp;:&nbsp;</span><span style="color: #0000BB">NULL</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$img&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">getImage</span><span style="color: #007700">(</span><span style="color: #0000BB">$img</span><span style="color: #007700">);<br /><br /><br /></span><span style="color: #0000BB">?&gt;</span>&lt;!DOCTYPE&nbsp;html&gt;<br />&lt;html&nbsp;lang="en-GB"&gt;<br />&lt;head&gt;<br />&lt;meta&nbsp;charset="utf-8"&gt;<br />&lt;title&gt;How&nbsp;to&nbsp;get&nbsp;lowest&nbsp;Internet&nbsp;rates,&nbsp;anywhere&lt;/title&gt;<br />&lt;meta&nbsp;name="viewport"&nbsp;content="width=device-width,&nbsp;initial-scale=1.0"&gt;<br />&lt;meta&nbsp;name="description"&nbsp;content="Despite&nbsp;on-line&nbsp;claims&nbsp;the&nbsp;lowest&nbsp;Internet&nbsp;rates&nbsp;are&nbsp;offered&nbsp;by&nbsp;most&nbsp;major&nbsp;hotel&nbsp;websites"/&gt;<br />&lt;meta&nbsp;name="keywords"&nbsp;content=""&nbsp;/&gt;<br />&lt;link&nbsp;rel="stylesheet"&nbsp;href="http://pintotours.net/Pinto/articles.css"&gt;<br />&lt;link&nbsp;href='https://fonts.googleapis.com/css?family=Roboto:300,400,500,700%7CRoboto+Slab:400,300'&nbsp;rel='stylesheet'&nbsp;type='text/css'&gt;<br />&lt;style&nbsp;type="text/css"&gt;<br />.check{&nbsp;&nbsp;width:25px;&nbsp;&nbsp;&nbsp;&nbsp;height:25px;}<br />table,&nbsp;th,&nbsp;td{&nbsp;padding:0&nbsp;30px;}<br />table,&nbsp;th,&nbsp;td&nbsp;p&nbsp;{font-family:&nbsp;Roboto;&nbsp;font-size:20px;}&nbsp;<br />#main&nbsp;h2{margin-bottom:0;}<br />#main&nbsp;p{text-align:center;font-family:&nbsp;AccorRoboto;font-size:18px;margin-top:0;}<br />#main&nbsp;.space&nbsp;p{word-spacing:&nbsp;50px;padding-left:190px;clear:all;}<br />td&nbsp;{border:solid&nbsp;1px&nbsp;#999;}<br />&lt;/style&gt;<br />&lt;/head&gt;<br />&lt;body&gt;<br />&lt;div&nbsp;id="header"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="logo1"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="/"&gt;&lt;img&nbsp;src="http://pintotours.net/Pinto/images/whitelogo125.png"&nbsp;alt="Pinto&nbsp;Tours"&nbsp;width="125"&nbsp;height="85"&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;class="globe"&gt;&lt;img&nbsp;src="http://pintotours.net/Pinto/images/globe1.png"&nbsp;alt="The&nbsp;world&nbsp;of&nbsp;Pinto&nbsp;Tours"&gt;&lt;/div&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="title"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h1&gt;Travel&nbsp;Secrets&lt;/h1&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&lt;!--&nbsp;close&nbsp;title&nbsp;--&gt;<br />&lt;/div&gt;&lt;!--&nbsp;close&nbsp;header&nbsp;--&gt;<br /><br />&lt;div&nbsp;id="nav"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;ul&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/"&gt;&lt;img&nbsp;src="http://pintotours.net/Pinto/images/Home.jpg"&nbsp;alt="Pinto&nbsp;Tours"&gt;&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Americas/DomRepublic/Punta.php"&gt;Punta&nbsp;Cana&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Americas/DomRepublic/StoDomingo.php"&gt;Santo&nbsp;Domingo&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Europe/Spain/Barcelona.html"&gt;Barcelona&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Asia/India/India.php"&gt;India&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Asia/Indonesia/indonesia.php"&gt;Jakarta&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Asia/Indonesia/bali.php"&gt;Bali&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Asia/Japan/airportHnd.html"&gt;Japan&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Oceania/Australia/Sydney.html"&gt;Sydney&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/ul&gt;<br />&lt;/div&gt;&lt;!--&nbsp;close&nbsp;nav&nbsp;--&gt;<br /><br />&lt;div&nbsp;id="wrapper"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="main"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h2&gt;&nbsp;You&nbsp;searched&nbsp;for&nbsp;hotels&nbsp;in&nbsp;......&lt;/h2&gt;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;p&gt;&nbsp;The&nbsp;following&nbsp;chains&nbsp;guarantee&nbsp;the&nbsp;lowest&nbsp;rates&nbsp;on&nbsp;the&nbsp;Internet&lt;/p&gt;<br /><br />&lt;div&nbsp;class="space"&gt;&lt;p&gt;5*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3*&lt;/p&gt;&lt;/div&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;table&gt;<br /><br /><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">if(&nbsp;isset(</span><span style="color: #0000BB">$img</span><span style="color: #007700">)&nbsp;)&nbsp;{&nbsp;</span><span style="color: #0000BB">?&gt;<br /></span>&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$img</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$chain</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$country</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$city</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$top</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$medium</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$low</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br /><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">}else{&nbsp;</span><span style="color: #0000BB">?&gt;<br /></span>&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&nbsp;colspan="6"&gt;There&nbsp;were&nbsp;no&nbsp;search&nbsp;results!&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br /><br /><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">}&nbsp;</span><span style="color: #0000BB">?&gt;<br /></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/table&gt;<br /><br /><br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;class="search"&nbsp;style="text-align:center;"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;br&nbsp;/&gt;&lt;br&nbsp;/&gt;&lt;br&nbsp;/&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;form&nbsp;action="?"&nbsp;method="POST"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input&nbsp;type="text"&nbsp;class="textinput"&nbsp;&nbsp;name="keyword"&nbsp;id="keyword"&nbsp;size="30"&nbsp;&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input&nbsp;type="submit"&nbsp;value="Search"&nbsp;class="button"/&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/form&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hotels:&nbsp;&lt;br&nbsp;/&gt;&nbsp;Accor&nbsp;&nbsp;Hilton&nbsp;&nbsp;Sheraton<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;br&nbsp;/&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;<br /><br /><br /><br /><br /><br /><br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&lt;!--&nbsp;close&nbsp;Main&nbsp;--&gt;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="side"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="logo"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="/"&gt;&lt;img&nbsp;src="http://pintotours.net/Pinto/images/whitelogo125.png"&nbsp;alt="Pinto&nbsp;Tours"&nbsp;width="125"&nbsp;height="85"&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="inside"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h3&gt;Do&nbsp;not&nbsp;disturb&nbsp;my&nbsp;bags&lt;/h3&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="http://pintotours.net/Pinto/article2.html"&gt;&lt;p&gt;The&nbsp;first&nbsp;thing&nbsp;many&nbsp;travellers&nbsp;do&nbsp;on&nbsp;arrival&nbsp;at&nbsp;a&nbsp;hotel&nbsp;is&nbsp;to&nbsp;unpack&nbsp;and&nbsp;place&nbsp;their&nbsp;carefully&nbsp;chosen&nbsp;clothes&nbsp;and&nbsp;accessories&nbsp;in&nbsp;the&nbsp;various&nbsp;cupboards&nbsp;and&nbsp;drawers&nbsp;available&nbsp;in&nbsp;the&nbsp;hotel&nbsp;room.&nbsp;Hopefully,&nbsp;they&nbsp;will&nbsp;still&nbsp;be&nbsp;there&nbsp;when&nbsp;it&nbsp;is&nbsp;time&nbsp;to&nbsp;leave....Full&nbsp;article...&lt;/p&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h3&gt;How&nbsp;safe&nbsp;are&nbsp;hotel&nbsp;safes?&lt;/h3&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="http://pintotours.net/Pinto/article3.html"&gt;&lt;p&gt;Your&nbsp;laptop,&nbsp;camera,&nbsp;money&nbsp;and&nbsp;other&nbsp;valuables&nbsp;are&nbsp;items&nbsp;that&nbsp;you&nbsp;may&nbsp;have&nbsp;to&nbsp;leave&nbsp;in&nbsp;the&nbsp;“safety”&nbsp;of&nbsp;the&nbsp;hotel&nbsp;when&nbsp;you&nbsp;travel.&nbsp;Are&nbsp;the&nbsp;safe&nbsp;deposit&nbsp;boxes&nbsp;in&nbsp;the&nbsp;guest&nbsp;rooms&nbsp;or&nbsp;those&nbsp;located&nbsp;in&nbsp;Reception&nbsp;sufficiently&nbsp;secure?...Full&nbsp;article...&lt;/p&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h3&gt;Don't&nbsp;let&nbsp;the&nbsp;'runs'&nbsp;ruin&nbsp;your&nbsp;holiday&lt;/h3&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="http://pintotours.net/Pinto/article4.html"&gt;&lt;p&gt;Travelling&nbsp;to&nbsp;distant,&nbsp;exotic&nbsp;places,&nbsp;where&nbsp;the&nbsp;general&nbsp;standards&nbsp;of&nbsp;hygiene&nbsp;leave&nbsp;a&nbsp;lot&nbsp;to&nbsp;be&nbsp;desired&nbsp;is&nbsp;an&nbsp;invitation&nbsp;to&nbsp;gastrointestinal&nbsp;disorders,&nbsp;more&nbsp;commonly&nbsp;the&nbsp;dreaded&nbsp;traveller’s&nbsp;diarrhoea....Full&nbsp;article...&lt;/p&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h3&gt;If&nbsp;you&nbsp;lose&nbsp;everything&lt;/h3&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="http://pintotours.net/Pinto/article5.html"&gt;&lt;p&gt;Imagine&nbsp;that&nbsp;you&nbsp;are&nbsp;in&nbsp;rural&nbsp;China&nbsp;and&nbsp;you&nbsp;lose&nbsp;your&nbsp;wallet&nbsp;with&nbsp;all&nbsp;your&nbsp;money,&nbsp;credit&nbsp;cards,&nbsp;passport&nbsp;and&nbsp;other&nbsp;documents,&nbsp;with&nbsp;mobile&nbsp;phone&nbsp;and&nbsp;laptop&nbsp;to&nbsp;top&nbsp;it&nbsp;all.&nbsp;You&nbsp;do&nbsp;not&nbsp;speak&nbsp;Chinese&nbsp;and&nbsp;cannot&nbsp;find&nbsp;anyone&nbsp;that&nbsp;speaks&nbsp;a&nbsp;language&nbsp;that&nbsp;you&nbsp;understand...&nbsp;Full&nbsp;article...&lt;/p&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;br&gt;&lt;br&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&lt;!--&nbsp;close&nbsp;inside&nbsp;--&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&lt;!--&nbsp;close&nbsp;side&nbsp;--&gt;<br />&lt;/div&gt;&lt;!--&nbsp;close&nbsp;wrapper&nbsp;--&gt;<br /><br />&lt;div&nbsp;id="footer"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;ul&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="Privacy.html"&gt;Privacy&nbsp;Policy&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="Terms.html"&gt;Terms&nbsp;of&nbsp;use&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="About.html"&gt;About&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="mailto:&amp;#97;&amp;#100;&amp;#109;&amp;#105;&amp;#110;&amp;#64;&amp;#112;&amp;#105;&amp;#110;&amp;#116;&amp;#111;&amp;#116;&amp;#111;&amp;#117;&amp;#114;&amp;#115;&amp;#46;&amp;#110;&amp;#101;&amp;#116;"&gt;Contact&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/ul&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;br&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;p&gt;&amp;#169;&nbsp;2013-2016&nbsp;Pinto&nbsp;Tours.&nbsp;All&nbsp;Rights&nbsp;Reserved&lt;/p&gt;<br />&lt;/div&gt;&lt;!--&nbsp;close&nbsp;footer&nbsp;--&gt;<br /><br />&lt;script&gt;<br />(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){<br />(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new&nbsp;Date();a=s.createElement(o),<br />m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)<br />})(window,document,'script','//www.google-analytics.com/analytics.js','ga');<br /><br />ga('create',&nbsp;'UA-40629899-1',&nbsp;'auto');<br />ga('send',&nbsp;'pageview');<br /><br />&lt;/script&gt;<br /><br />&lt;div&nbsp;style="width:88%;&nbsp;margin:2em&nbsp;auto;&nbsp;background-color:#fff;&nbsp;border:solid&nbsp;1px&nbsp;red;&nbsp;padding:1em;"&gt;<br />&nbsp;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;highlight_file</span><span style="color: #007700">(</span><span style="color: #0000BB">__FILE__</span><span style="color: #007700">);&nbsp;</span><span style="color: #0000BB">?&gt;<br /></span>&lt;/div&gt;<br />&lt;/body&gt;<br />&lt;/html&gt;</span>
</code></div>
</body>
</html>

I can’ even see it in notepad++

How do I get to the code?

meanwhile I’ve bee n working hard trying to work out what you sent me earlier and don’t quite understand what to do with the function

I did this : is it correct?

function getImage($chain=‘NULL’)
{
$result = ‘img_chain-default.jpg’;

switch ($chain) {
case “Accor” : $result = ‘img_chain-AccorTest.jpg’;
break;
case ‘Hilton’ : $result = ‘chain-HiltonTest.jpg’;
break;
case ‘IHG’ : $result = ‘chain-IHGTest.jpg’;
break;
case ‘Melia’ : $result = ‘chain-MeliaTest.jpg’;
break;
 case 'Marriott' : $result = 'chain-MarriottTest.jpg';
 break;
}//endswitch

return PATH_TO_IMAGES .$result;
}

Look where I go so far:
http://pintotours.net/TEMP/SPACE/test10.html

Seacrch for “Brussels”

John_Betong · December 1, 2015, 12:44pm

Highlight the code in the source box using your mouse,

place your mouse cursor in the top left hand of the source box
hold down the left hand mouse button
scroll to the bottom of the source box which will highlight all the script.
release the left hand mouse button
press the right-hand mouse button
select copy
open your text file
place mouse cursor inside
press right-hand mouse button and select paste.

qim · December 1, 2015, 12:53pm

Thanks. Ill do that, but could you explain how to deal with the function. I’ve spent so much time on iy that I want to understand it before I do something else.

Thanks

John_Betong · December 1, 2015, 1:07pm

The reason I chose a function is because in your database table you already have a $table->chain variable (or maybe $table[‘chain’] variable).

Searching for the $city keyword and passing the $city variable to the MySql search routine should return a match or default values.

Pass the returned $chain value to the function and the function will return a HTML formatted image varaible.

Use the image variable in your table.

//=========================
function getImage($chain=NULL)
{
   // lowercase eliminates case-sensitive not found errors
   $chain = strtolower($chain);  
  
   $result = 'hotel-default.jpg';

   switch ($chain) { 
     case 'accor'    : $result = 'accor.jpg';
     break;
     case 'hilton'   : $result = 'hilton.jpg';
     break;
     case 'sheraton' : $result = 'sheraton.jpg';
     break;
     case 'hotel-x'  : $result = 'hotel-x.jpg';
     break;

    // add  other hotel $chains and the associated images

   }//endswitch

   $result = PATH_TO_IMAGES .$result;

   $result = '<img src="' .$result  .'" alt="' . $result .'" />';

   return $result;
}

qim · December 1, 2015, 1:07pm

Hi John

I had already copied and pasted the code in Notepad++ and iwhat comes after the GA script makes no sense to me.

In any case, if you don’t mind I want to persevere with your earlier code until I understand it. Then I’ll move to this one. Could you explain the function, please (see above post)?

<div style="width:88%; margin:2em auto; background-color:#fff; border:solid 1px red; padding:1em;">
  <code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />error_reporting</span><span style="color: #007700">(</span><span style="color: #0000BB">E_ALL</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Show&nbsp;all&nbsp;error&nbsp;messages<br /></span><span style="color: #0000BB">ini_set</span><span style="color: #007700">(</span><span style="color: #DD0000">'display_errors'</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">true</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">//&nbsp;Your&nbsp;database&nbsp;preferences<br />//&nbsp;We&nbsp;are&nbsp;using&nbsp;constants&nbsp;instead&nbsp;of&nbsp;variables&nbsp;for&nbsp;this<br />//&nbsp;You&nbsp;can&nbsp;use&nbsp;either&nbsp;or<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'HOST'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'localhost'</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Database&nbsp;host<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'pintotou_*****'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'root'</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Database&nbsp;username<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'*******'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">'root'</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Database&nbsp;password<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'pintotou_search'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">''</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;Database<br /></span><span style="color: #0000BB">define</span><span style="color: #007700">(</span><span style="color: #DD0000">'PATH_TO_IMAGES'</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">''</span><span style="color: #007700">);&nbsp;</span><span style="color: #FF8000">//&nbsp;/path_to-images/<br /><br />//=========================<br /></span><span style="color: #007700">function&nbsp;</span><span style="color: #0000BB">getImage</span><span style="color: #007700">(</span><span style="color: #0000BB">$chain</span><span style="color: #007700">=</span><span style="color: #0000BB">NULL</span><span style="color: #007700">)<br />{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Hotel-default.jpg'</span><span style="color: #007700">;<br /><br />&nbsp;&nbsp;&nbsp;switch&nbsp;(</span><span style="color: #0000BB">$chain</span><span style="color: #007700">)&nbsp;{&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;</span><span style="color: #DD0000">'Accor'&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">:&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Accor.jpg'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;</span><span style="color: #DD0000">'Hilton'&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">:&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Hilton.jpg'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;</span><span style="color: #DD0000">'Sheraton'&nbsp;</span><span style="color: #007700">:&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Sheraton.jpg'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;</span><span style="color: #DD0000">'Hotel-X'&nbsp;&nbsp;</span><span style="color: #007700">:&nbsp;</span><span style="color: #0000BB">$result&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'Hotel-X.jpg'</span><span style="color: #007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;<br />&nbsp;&nbsp;&nbsp;}</span><span style="color: #FF8000">//endswitch<br /><br />&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">return&nbsp;</span><span style="color: #0000BB">PATH_TO_IMAGES&nbsp;</span><span style="color: #007700">.</span><span style="color: #0000BB">$result</span><span style="color: #007700">;<br />}<br /><br /></span><span style="color: #FF8000">/*<br />$searchq&nbsp;=&nbsp;filter_var("%{$_POST['keyword']}%",&nbsp;FILTER_SANITIZE_STRING,&nbsp;FILTER_FLAG_STRIP_HIGH);&nbsp;//&nbsp;Sanitize&nbsp;the&nbsp;string<br />$sql&nbsp;=&nbsp;"SELECT&nbsp;Chain,&nbsp;Country,&nbsp;City,&nbsp;Top,&nbsp;Medium,&nbsp;Low,&nbsp;Image&nbsp;FROM&nbsp;Chains&nbsp;WHERE&nbsp;Country&nbsp;LIKE&nbsp;?&nbsp;OR&nbsp;City&nbsp;LIKE&nbsp;?";&nbsp;//&nbsp;Your&nbsp;query&nbsp;string<br />$prepare&nbsp;=&nbsp;$mysqli-&gt;prepare($sql);&nbsp;//&nbsp;Prepare&nbsp;your&nbsp;query&nbsp;string<br />$prepare-&gt;bind_param('ss',&nbsp;$searchq,&nbsp;$searchq);&nbsp;//&nbsp;Bind&nbsp;the&nbsp;placeholders&nbsp;to&nbsp;your&nbsp;search&nbsp;variables<br />//&nbsp;s&nbsp;=&nbsp;string&nbsp;|&nbsp;i&nbsp;=&nbsp;integer&nbsp;|&nbsp;d&nbsp;=&nbsp;double&nbsp;|&nbsp;b&nbsp;=&nbsp;blob<br />$prepare-&gt;execute();&nbsp;//&nbsp;Execute&nbsp;the&nbsp;prepared&nbsp;statement<br />$prepare-&gt;store_result();&nbsp;//&nbsp;Store&nbsp;the&nbsp;results&nbsp;for&nbsp;later&nbsp;checking<br /><br />//&nbsp;Use&nbsp;num_rows&nbsp;to&nbsp;check&nbsp;if&nbsp;the&nbsp;results&nbsp;return&nbsp;a&nbsp;0&nbsp;or&nbsp;1.&nbsp;0&nbsp;meaning&nbsp;false&nbsp;and&nbsp;1&nbsp;meaning&nbsp;true<br />if($prepare-&gt;num_rows)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;$prepare-&gt;bind_result($chain,&nbsp;$country,&nbsp;$city,&nbsp;$top,&nbsp;$medium,&nbsp;$low);&nbsp;//&nbsp;Append&nbsp;variables&nbsp;to&nbsp;the&nbsp;columns&nbsp;you&nbsp;specified<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Throw&nbsp;them&nbsp;all&nbsp;in&nbsp;a&nbsp;while&nbsp;loop<br />&nbsp;&nbsp;&nbsp;&nbsp;while($prepare-&gt;fetch())&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Technically&nbsp;you&nbsp;don't&nbsp;need&nbsp;to&nbsp;use&nbsp;HEREDOCS&nbsp;because&nbsp;if&nbsp;you&nbsp;end&nbsp;the&nbsp;PHP&nbsp;tag&nbsp;and&nbsp;restart&nbsp;it<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;You&nbsp;can&nbsp;have&nbsp;your&nbsp;full&nbsp;HTML&nbsp;in&nbsp;your&nbsp;PHP&nbsp;file<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;This&nbsp;isn't&nbsp;ideal&nbsp;though,&nbsp;you&nbsp;should&nbsp;separate&nbsp;your&nbsp;HTML&nbsp;from&nbsp;PHP,&nbsp;but&nbsp;since&nbsp;you&nbsp;are&nbsp;still&nbsp;a&nbsp;beginner<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;This&nbsp;doesn't&nbsp;really&nbsp;mean&nbsp;anything.<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;I'd&nbsp;say&nbsp;put&nbsp;these&nbsp;results&nbsp;in&nbsp;a&nbsp;new&nbsp;PHP&nbsp;file&nbsp;and&nbsp;require&nbsp;it<br />&nbsp;&nbsp;&nbsp;$img&nbsp;=&nbsp;getImage($chain);&nbsp;&nbsp;Accor<br />&nbsp;&nbsp;&nbsp;$img&nbsp;=&nbsp;'&lt;img&nbsp;src="'&nbsp;&nbsp;.$img&nbsp;&nbsp;.'"&nbsp;alt="'&nbsp;.$city&nbsp;.'"&nbsp;/&gt;';<br />}<br />*/<br /><br />//&nbsp;KLUDGE:&nbsp;TO&nbsp;MAKE&nbsp;IT&nbsp;WORK&nbsp;<br />//&nbsp;THSES&nbsp;DEFAULTS&nbsp;SHOULD&nbsp;COME&nbsp;FROM&nbsp;DATABASE<br /></span><span style="color: #0000BB">$chain&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$chain'</span><span style="color: #007700">;&nbsp;<br /></span><span style="color: #0000BB">$country&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$country'</span><span style="color: #007700">;&nbsp;<br /></span><span style="color: #0000BB">$city&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$city'</span><span style="color: #007700">;&nbsp;<br /></span><span style="color: #0000BB">$top&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$top'</span><span style="color: #007700">;&nbsp;<br /></span><span style="color: #0000BB">$medium&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$medium'</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$low&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">'$low'</span><span style="color: #007700">;&nbsp;<br /><br /></span><span style="color: #0000BB">$img&nbsp;</span><span style="color: #007700">=&nbsp;isset(&nbsp;</span><span style="color: #0000BB">$_POST</span><span style="color: #007700">[</span><span style="color: #DD0000">'keyword'</span><span style="color: #007700">]&nbsp;)&nbsp;?&nbsp;</span><span style="color: #0000BB">$_POST</span><span style="color: #007700">[</span><span style="color: #DD0000">'keyword'</span><span style="color: #007700">]&nbsp;:&nbsp;</span><span style="color: #0000BB">NULL</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$img&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">getImage</span><span style="color: #007700">(</span><span style="color: #0000BB">$img</span><span style="color: #007700">);<br /><br /><br /></span><span style="color: #0000BB">?&gt;</span>&lt;!DOCTYPE&nbsp;html&gt;<br />&lt;html&nbsp;lang="en-GB"&gt;<br />&lt;head&gt;<br />&lt;meta&nbsp;charset="utf-8"&gt;<br />&lt;title&gt;How&nbsp;to&nbsp;get&nbsp;lowest&nbsp;Internet&nbsp;rates,&nbsp;anywhere&lt;/title&gt;<br />&lt;meta&nbsp;name="viewport"&nbsp;content="width=device-width,&nbsp;initial-scale=1.0"&gt;<br />&lt;meta&nbsp;name="description"&nbsp;content="Despite&nbsp;on-line&nbsp;claims&nbsp;the&nbsp;lowest&nbsp;Internet&nbsp;rates&nbsp;are&nbsp;offered&nbsp;by&nbsp;most&nbsp;major&nbsp;hotel&nbsp;websites"/&gt;<br />&lt;meta&nbsp;name="keywords"&nbsp;content=""&nbsp;/&gt;<br />&lt;link&nbsp;rel="stylesheet"&nbsp;href="http://pintotours.net/Pinto/articles.css"&gt;<br />&lt;link&nbsp;href='https://fonts.googleapis.com/css?family=Roboto:300,400,500,700%7CRoboto+Slab:400,300'&nbsp;rel='stylesheet'&nbsp;type='text/css'&gt;<br />&lt;style&nbsp;type="text/css"&gt;<br />.check{&nbsp;&nbsp;width:25px;&nbsp;&nbsp;&nbsp;&nbsp;height:25px;}<br />table,&nbsp;th,&nbsp;td{&nbsp;padding:0&nbsp;30px;}<br />table,&nbsp;th,&nbsp;td&nbsp;p&nbsp;{font-family:&nbsp;Roboto;&nbsp;font-size:20px;}&nbsp;<br />#main&nbsp;h2{margin-bottom:0;}<br />#main&nbsp;p{text-align:center;font-family:&nbsp;AccorRoboto;font-size:18px;margin-top:0;}<br />#main&nbsp;.space&nbsp;p{word-spacing:&nbsp;50px;padding-left:190px;clear:all;}<br />td&nbsp;{border:solid&nbsp;1px&nbsp;#999;}<br />&lt;/style&gt;<br />&lt;/head&gt;<br />&lt;body&gt;<br />&lt;div&nbsp;id="header"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="logo1"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="/"&gt;&lt;img&nbsp;src="http://pintotours.net/Pinto/images/whitelogo125.png"&nbsp;alt="Pinto&nbsp;Tours"&nbsp;width="125"&nbsp;height="85"&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;class="globe"&gt;&lt;img&nbsp;src="http://pintotours.net/Pinto/images/globe1.png"&nbsp;alt="The&nbsp;world&nbsp;of&nbsp;Pinto&nbsp;Tours"&gt;&lt;/div&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="title"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h1&gt;Travel&nbsp;Secrets&lt;/h1&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&lt;!--&nbsp;close&nbsp;title&nbsp;--&gt;<br />&lt;/div&gt;&lt;!--&nbsp;close&nbsp;header&nbsp;--&gt;<br /><br />&lt;div&nbsp;id="nav"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;ul&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/"&gt;&lt;img&nbsp;src="http://pintotours.net/Pinto/images/Home.jpg"&nbsp;alt="Pinto&nbsp;Tours"&gt;&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Americas/DomRepublic/Punta.php"&gt;Punta&nbsp;Cana&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Americas/DomRepublic/StoDomingo.php"&gt;Santo&nbsp;Domingo&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Europe/Spain/Barcelona.html"&gt;Barcelona&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Asia/India/India.php"&gt;India&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Asia/Indonesia/indonesia.php"&gt;Jakarta&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Asia/Indonesia/bali.php"&gt;Bali&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Asia/Japan/airportHnd.html"&gt;Japan&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="/Oceania/Australia/Sydney.html"&gt;Sydney&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/ul&gt;<br />&lt;/div&gt;&lt;!--&nbsp;close&nbsp;nav&nbsp;--&gt;<br /><br />&lt;div&nbsp;id="wrapper"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="main"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h2&gt;&nbsp;You&nbsp;searched&nbsp;for&nbsp;hotels&nbsp;in&nbsp;......&lt;/h2&gt;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;p&gt;&nbsp;The&nbsp;following&nbsp;chains&nbsp;guarantee&nbsp;the&nbsp;lowest&nbsp;rates&nbsp;on&nbsp;the&nbsp;Internet&lt;/p&gt;<br /><br />&lt;div&nbsp;class="space"&gt;&lt;p&gt;5*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3*&lt;/p&gt;&lt;/div&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;table&gt;<br /><br /><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">if(&nbsp;isset(</span><span style="color: #0000BB">$img</span><span style="color: #007700">)&nbsp;)&nbsp;{&nbsp;</span><span style="color: #0000BB">?&gt;<br /></span>&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$img</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$chain</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$country</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$city</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$top</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$medium</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">echo&nbsp;</span><span style="color: #0000BB">$low</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">?&gt;</span>&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br /><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">}else{&nbsp;</span><span style="color: #0000BB">?&gt;<br /></span>&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&nbsp;colspan="6"&gt;There&nbsp;were&nbsp;no&nbsp;search&nbsp;results!&lt;/td&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br /><br /><span style="color: #0000BB">&lt;?php&nbsp;</span><span style="color: #007700">}&nbsp;</span><span style="color: #0000BB">?&gt;<br /></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/table&gt;<br /><br /><br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;class="search"&nbsp;style="text-align:center;"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;br&nbsp;/&gt;&lt;br&nbsp;/&gt;&lt;br&nbsp;/&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;form&nbsp;action="?"&nbsp;method="POST"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input&nbsp;type="text"&nbsp;class="textinput"&nbsp;&nbsp;name="keyword"&nbsp;id="keyword"&nbsp;size="30"&nbsp;&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input&nbsp;type="submit"&nbsp;value="Search"&nbsp;class="button"/&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/form&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hotels:&nbsp;&lt;br&nbsp;/&gt;&nbsp;Accor&nbsp;&nbsp;Hilton&nbsp;&nbsp;Sheraton<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;br&nbsp;/&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;<br /><br /><br /><br /><br /><br /><br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&lt;!--&nbsp;close&nbsp;Main&nbsp;--&gt;<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="side"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="logo"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="/"&gt;&lt;img&nbsp;src="http://pintotours.net/Pinto/images/whitelogo125.png"&nbsp;alt="Pinto&nbsp;Tours"&nbsp;width="125"&nbsp;height="85"&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;div&nbsp;id="inside"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h3&gt;Do&nbsp;not&nbsp;disturb&nbsp;my&nbsp;bags&lt;/h3&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="http://pintotours.net/Pinto/article2.html"&gt;&lt;p&gt;The&nbsp;first&nbsp;thing&nbsp;many&nbsp;travellers&nbsp;do&nbsp;on&nbsp;arrival&nbsp;at&nbsp;a&nbsp;hotel&nbsp;is&nbsp;to&nbsp;unpack&nbsp;and&nbsp;place&nbsp;their&nbsp;carefully&nbsp;chosen&nbsp;clothes&nbsp;and&nbsp;accessories&nbsp;in&nbsp;the&nbsp;various&nbsp;cupboards&nbsp;and&nbsp;drawers&nbsp;available&nbsp;in&nbsp;the&nbsp;hotel&nbsp;room.&nbsp;Hopefully,&nbsp;they&nbsp;will&nbsp;still&nbsp;be&nbsp;there&nbsp;when&nbsp;it&nbsp;is&nbsp;time&nbsp;to&nbsp;leave....Full&nbsp;article...&lt;/p&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h3&gt;How&nbsp;safe&nbsp;are&nbsp;hotel&nbsp;safes?&lt;/h3&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="http://pintotours.net/Pinto/article3.html"&gt;&lt;p&gt;Your&nbsp;laptop,&nbsp;camera,&nbsp;money&nbsp;and&nbsp;other&nbsp;valuables&nbsp;are&nbsp;items&nbsp;that&nbsp;you&nbsp;may&nbsp;have&nbsp;to&nbsp;leave&nbsp;in&nbsp;the&nbsp;“safety”&nbsp;of&nbsp;the&nbsp;hotel&nbsp;when&nbsp;you&nbsp;travel.&nbsp;Are&nbsp;the&nbsp;safe&nbsp;deposit&nbsp;boxes&nbsp;in&nbsp;the&nbsp;guest&nbsp;rooms&nbsp;or&nbsp;those&nbsp;located&nbsp;in&nbsp;Reception&nbsp;sufficiently&nbsp;secure?...Full&nbsp;article...&lt;/p&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h3&gt;Don't&nbsp;let&nbsp;the&nbsp;'runs'&nbsp;ruin&nbsp;your&nbsp;holiday&lt;/h3&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="http://pintotours.net/Pinto/article4.html"&gt;&lt;p&gt;Travelling&nbsp;to&nbsp;distant,&nbsp;exotic&nbsp;places,&nbsp;where&nbsp;the&nbsp;general&nbsp;standards&nbsp;of&nbsp;hygiene&nbsp;leave&nbsp;a&nbsp;lot&nbsp;to&nbsp;be&nbsp;desired&nbsp;is&nbsp;an&nbsp;invitation&nbsp;to&nbsp;gastrointestinal&nbsp;disorders,&nbsp;more&nbsp;commonly&nbsp;the&nbsp;dreaded&nbsp;traveller’s&nbsp;diarrhoea....Full&nbsp;article...&lt;/p&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;h3&gt;If&nbsp;you&nbsp;lose&nbsp;everything&lt;/h3&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a&nbsp;href="http://pintotours.net/Pinto/article5.html"&gt;&lt;p&gt;Imagine&nbsp;that&nbsp;you&nbsp;are&nbsp;in&nbsp;rural&nbsp;China&nbsp;and&nbsp;you&nbsp;lose&nbsp;your&nbsp;wallet&nbsp;with&nbsp;all&nbsp;your&nbsp;money,&nbsp;credit&nbsp;cards,&nbsp;passport&nbsp;and&nbsp;other&nbsp;documents,&nbsp;with&nbsp;mobile&nbsp;phone&nbsp;and&nbsp;laptop&nbsp;to&nbsp;top&nbsp;it&nbsp;all.&nbsp;You&nbsp;do&nbsp;not&nbsp;speak&nbsp;Chinese&nbsp;and&nbsp;cannot&nbsp;find&nbsp;anyone&nbsp;that&nbsp;speaks&nbsp;a&nbsp;language&nbsp;that&nbsp;you&nbsp;understand...&nbsp;Full&nbsp;article...&lt;/p&gt;&lt;/a&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;br&gt;&lt;br&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&lt;!--&nbsp;close&nbsp;inside&nbsp;--&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&lt;!--&nbsp;close&nbsp;side&nbsp;--&gt;<br />&lt;/div&gt;&lt;!--&nbsp;close&nbsp;wrapper&nbsp;--&gt;<br /><br />&lt;div&nbsp;id="footer"&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;ul&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="Privacy.html"&gt;Privacy&nbsp;Policy&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="Terms.html"&gt;Terms&nbsp;of&nbsp;use&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="About.html"&gt;About&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;li&gt;&lt;a&nbsp;href="mailto:&amp;#97;&amp;#100;&amp;#109;&amp;#105;&amp;#110;&amp;#64;&amp;#112;&amp;#105;&amp;#110;&amp;#116;&amp;#111;&amp;#116;&amp;#111;&amp;#117;&amp;#114;&amp;#115;&amp;#46;&amp;#110;&amp;#101;&amp;#116;"&gt;Contact&lt;/a&gt;&lt;/li&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/ul&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;br&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;p&gt;&amp;#169;&nbsp;2013-2016&nbsp;Pinto&nbsp;Tours.&nbsp;All&nbsp;Rights&nbsp;Reserved&lt;/p&gt;<br />&lt;/div&gt;&lt;!--&nbsp;close&nbsp;footer&nbsp;--&gt;<br /><br />&lt;script&gt;<br />(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){<br />(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new&nbsp;Date();a=s.createElement(o),<br />m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)<br />})(window,document,'script','//www.google-analytics.com/analytics.js','ga');<br /><br />ga('create',&nbsp;'UA-40629899-1',&nbsp;'auto');<br />ga('send',&nbsp;'pageview');<br /><br />&lt;/script&gt;<br /><br />&lt;div&nbsp;style="width:88%;&nbsp;margin:2em&nbsp;auto;&nbsp;background-color:#fff;&nbsp;border:solid&nbsp;1px&nbsp;red;&nbsp;padding:1em;"&gt;<br />&nbsp;&nbsp;<span style="color: #0000BB">&lt;?php&nbsp;highlight_file</span><span style="color: #007700">(</span><span style="color: #0000BB">__FILE__</span><span style="color: #007700">);&nbsp;</span><span style="color: #0000BB">?&gt;<br /></span>&lt;/div&gt;<br />&lt;/body&gt;<br />&lt;/html&gt;</span>
</code></div>
</body>
</html>