i am using MS access database and front page and i want to make connect between them by using php
i am using phpTried apache web server
i want to make search in my data bsee
forexample my database contain shopping and hotels and resturand for each country i wand to search abot shoppin in specific city by drop down menue
i write my code but it gives me error i dont know why
i need help quickly please this is my code:
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html lang="Ar" dir="rtl">
<head>
<title>Search</title>
<style type = "text/css">
span { text-decoration: underline }
</style>
</head>
<body background='background/c3.jpg'">
<?php
define(Sr_project, "swah");
function DBconnect()
{
//connect to ODBC
if(!($database = odbc_connect(Sr_project,"","")))
die("áã íÊã ÇáÑÈØ ÈÞÇÚÏÉ ÇáÈíÇäÇÊ");
return $database;
}
function DBclose($database)
{
odbc_close($database);
}
function GetEmployeeContacts($ID,$all)
{
$database = DBconnect();
if ($ID != "")
$c1 = "Dept_ID = '$ID'";
else
$c1 = "";
//if ($Name != "")
// $c2 = "fullname like '$Name'";
// if ($c1 != "" && $c2 != "")
// $c1 = " where ".$c1." and ".$c2;
// elseif ($c1 != "" && $c2 == "")
$c1 = " where ".$c1;
// elseif ($c1 == "" && $c2 != "")
// $c1 = " where ".$c2;
//else
//$c1 = "";
if ($all == "all")
$query = "select market_name,address from shopping";
else
$query = "select market_name,address from shopping".$c1."order by market_name";
$result = odbc_exec($database, $query);
$Contacts = array("market"=>array(), "add"=>array());
//,"Dept"=>array(), "JobTitle"=>array(),
// "Phone"=>array(), "e_Mail"=>array());
for ($c = 0; odbc_fetch_row($result);$c++)
{
$Contacts["market"][$c] = odbc_result($result, "market_name");
$Contacts["add"][$c] = odbc_result($result, "address");
//$Contacts["Dept"][$c] = odbc_result($result, "Dept");
//$Contacts["JobTitle"][$c] = odbc_result($result, "JobTitle");
//$Contacts["Phone"][$c] = odbc_result($result, "work_phone");
//$Contacts["e_Mail"][$c] = odbc_result($result, "e_mail");
}
DBclose($database);
return $Contacts;
};
function PrintSearchForm($Adept,$check)
{
$database = DBconnect();
$query = "select cityID, city from city";
$result = odbc_exec($database, $query);
$Depts = array("codes"=>array(), "names"=>array());
$i = 0;
for (;odbc_fetch_row($result)😉
{
$code = odbc_result($result,"cityID");
$name = odbc_result($result,"city");
$Depts["codes"][$i] = $code;
$Depts["names"][$i] = $name;
$i++;
}
//print("<p><center><font face='Verdana, sans-serif' color='navy'><h2>Find Employee(s)</h2></font></center></p>");
print('<form name="search" method="post" action="Lebanon_search.php?n=2">');
// print('<font color="#993300"><b><font size="2" face="Arial, Helvetica, sans-serif">ÇáÇÓã </font></b></font>');
// print('<input type="text" name="Name" value="'.$Aname.'" size="25" maxlength="30">');
print('<br>');
print('<p><font color="#993300"><b><font size="2" face="Arial, Helvetica, sans-serif">ÇáãÏíäÉ </font></b></font>');
$num = count($Depts["codes"]);
print("<select name = 'city'>");
if($Adept == "")
print("<option selected='selected'></option>");
else
print("<option></option>");
for($i = 0;$i < $num;$i++)
{
if($Depts["codes"][$i] == $Adept)
print("<option value='".$Depts["codes"][$i]."' selected='selected'>".$Depts["names"][$i]."</option>");
else
print("<option value='".$Depts["codes"][$i]."'>".$Depts["names"][$i]."</option>");
}
print("</select>");
print('<p>');
if($check == "")
print('<input type="checkbox" name="ShowAll" value="all">');
else
print('<input type="checkbox" name="ShowAll" value="all" checked>');
print('<label>ÌãíÚ ÇáÏæá</label>');
print('</p>');
print('<p>');
print('<input type="submit" name="ÈÍË" value="ÈÍË">');
print('<input type="reset" name="ÇáÛÇÁ" value="ÇáÛÇÁ">');
print('</p>');
print('</form>');
}
function PrintResult($Dept, $ShowAll)
{
$Result = GetshoppingContacts($Dept, $ShowAll);
$count = count($Result["market_name"]);
echo "<b>ãÝÑÏÇÊ ÇáÈÍË:</b></br> <b>ÇáÇÓã = </b>'$Name' <b>ÇáÇÏÇÑÉ = </b>'$Dept'</br>";
echo "íæÌÏ $count ÓÌá ÊØÇÈÞ ãÝÑÏÇÊ ÇáÈÍË</br>";
if ($count < 1)
return;
print("<p><center><font face='Verdana, sans-serif' color='navy'><h3>äÊÇÆÌ ÇáÈÍË</h3></font></center></p>");
print("<table border='0' width = '80%' align = center>");
print("<thead>");
print("<tr bgcolor='#3f6952'>");
print("<th align='right'><font face='arial' color='ffffee'>ÇÓã ÇáÓæÞ</font></th>");
print("<th align='right'><font face='arial' color='ffffee'>ÇáÚäæÇä</font></th>");
// print("<th align='right'><font face='arial' color='ffffee'>åÇÊÝ ÇáÚãá</font></th>");
// print("<th align='right'><font face='arial' color='ffffee'>ÇáÈÑíÏ ÇáÇáßÊÑæäí</font></th>");
print("</tr>");
print("</thead>");
print("<tbody>");
for($i = 0;$i < $count;$i++)
{
print("<tr bgcolor='#eaeaea'>");
print("<td>".$Result["marlet_name"][$i]."</td>");
print("<td>".$Result["address"][$i]."</td>");
//print("<td>".$Result["Phone"][$i]."</td>");
//print("<td><a href='mailto:".$Result["e_Mail"][$i]."'>".$Result["e_Mail"][$i]."</td>");
print("</tr>");
$i++;
//print("<tr bgcolor='#ffffff'>");
//print("<td>".$Result["FullName"][$i]."</td>");
//print("<td>".$Result["Dept"][$i]."</td>");
//print("<td>".$Result["Phone"][$i]."</td>");
// print("<td><a href='mailto:".$Result["e_Mail"][$i]."'>".$Result["e_Mail"][$i]."</td>");
//print("</tr>");
}
print("</tbody>");
print("</table>");
}
//print("<p><center><font face='Verdana, sans-serif' color='navy'><h2>Ïáíá ÇáãæÙÝíä</h2></font></center></p>");
switch($n)
{
case 1: PrintSearchForm( $citylist, $ShowAll); break;
case 2: {PrintResult($citylist, $ShowAll);
printSearchForm( $citylist, $ShowAll); break;}
}
?>
</body>
</html>
in this line say that there is error
$query = "select market_name,address from shopping".$c1."order by market_name";
$result = odbc_exec($database, $query);
