{source}
<!– You can place html anywhere within the source tags –>
<script language=”javascript” type=”text/javascript”>
// You can place JavaScript like this
</script>
<?php
// You can place PHP like this
$db = “dicha20_astrolog”; //set this to the name of your database
$host = “localhost”; //set this to the name of your host
$user = “dicha20_astrolog”; //set this to your db user name
$pass = “6658709123”; //set this to your db password
$connect = mysql_connect(“$host”, “$user”, “$pass”); //make db connection
mysql_connect($host, $user, $pass);
mysql_select_db($db);
mysql_query(‘set character set greek’,$connect);
mysql_query(“SET NAMES ‘utf8′”,$connect);
//unset($host,$user,$pass,$db);
$searchStr = $_GET[‘search’];
$searchStr = urldecode($searchStr);
//$html = htmlspecialchars($utf8_string, ENT_COMPAT, ‘UTF-8’);
$searchStr = mysql_real_escape_string($_GET[‘search’]);
$query = “SELECT * FROM astro_dreams WHERE categories_keywords LIKE ‘%{$_GET[‘searchStr’]}%'”;;
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
$categories_name=$row[“categories_name”];
$categories_description =$row[“categories_description”];
$categories_image_type =$row[“JPG”];
$categories_image=$row[“categories_image”];
$image_path = $row[“./dreamreader./pictures//”];
$show_image = $row[“categories_image”];
$imlink =$row[“$image_path”];
$id = $row[“id”];
//display the row
echo ” <font color=’#000066′><strong>”.$categories_name.”</font></strong><div align=’justify’>”.
$categories_description.”</div><br> “;
}
mysql_close();
?>
{/source}