<?php
include '../../Arabic.php';
$Arabic = new I18N_Arabic('Query');
echo $Arabic->allForms('فلسطينيون');
$dbuser = '******';
$dbpwd = '';
$dbname = 'test';
try {
$dbh = new PDO('mysql:host=localhost;dbname=' . $dbname, $dbuser, $dbpwd);
// Set the error reporting attribute
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->exec("SET NAMES 'utf8'");
if ($_GET['keyword'] != '') {
$keyword = @$_GET['keyword'];
$keyword = str_replace('\\"', '"', $keyword);
$Arabic->setStrFields('headline');
$Arabic->setMode($_GET['mode']);
$strCondition = $Arabic->getWhereCondition($keyword);
$strOrderBy = $Arabic->getOrderBy($keyword);
} else {
$strCondition = '1';
}
$StrSQL = "SELECT `headline` FROM `aljazeera` WHERE {$strCondition} ORDER BY {$strOrderBy}";
$i = 0;
foreach ($dbh->query($StrSQL) as $row) {
$headline = $row['headline'];
$i++;
if ($i % 2 == 0) {
$bg = "#f0f0f0";
} else {
$bg = "#ffffff";
