Hi Apologies if this question has been answered before and I can't find it.
I have searched and although finding similar issues, I haven't been able to
fix.
I have a file that creates a search for and then is supposed to post to
itself to retriev results. When I add the first function (the search form)
everything seems OK. The page renders, the select menus are populated from
my mySQL db.
When I add the second function (the results). I start getting an error that
refers to a line number in my initial function that was previously OK. I
gather the error has something to do with syntax, but I can't find it.
I'll show some examples and then detail the error.
My intial code that creates the search form and works is:
PHP:
------------------------------------------------------------------------
// Handles session initialization
include("open_session.php");
if(!isset($mainfile))
{
��include("mainfile.php");
}
// Global configuration data
include("config.php");
// Generates page header
include�("header.php");
function�sform()�{
include("config.php");
$box_title�=�"Search Form";
$box_stuff�=�"<table width=\"100%\"><tr><td align=\"left\">";
$box_stuff�.=�"<span class=\"finePrint\">Search hints can go
here</span></td></tr></table>";
$box_stuff�.=�"
<center><form action=\"./search_users.php\" method=\"post\">
<table><tr><td colspan=3 align=\"left\"><h4>Search for:</h4></td></tr>
<tr><td align=\"left\"><font size=\"-1\">Company</font></td><td
align=\"left\"><font size=\"-1\">Category</font></td><td
align=\"left\"><font size=\"-1\">City</font></td></tr>
<tr><td align=\"left\" valign=\"top\"><input name=\"company\"></td><td
align=\"left\" valign=\"top\">
<select name=\"cat\" size=\"7\" multiple>\n";
$cat_result�=�mysql_query("select cat, catkey, cattext, count(cat) AS
num_type FROM "�.�$table_prefix."users LEFT JOIN
"�.�$table_prefix."users_cat ON cat=catkey GROUP BY cattext ORDER BY
cattext");
$categories�=�mysql_fetch_array($cat_result);
if�($categories)�{
����while�($c2�=�mysql_fetch_array($cat_result))�{
����$num_type�=�$c2[num_type];
����$box_stuff�.=�"<option�name=\"cat\"�value=\"$c2[catkey]\">$c2[cattext]�(
$num_type)</option>";
����}
}
$box_stuff�.=�"
</select>
</td>
<td align=\"left\" valign=\"top\">
<select name=\"city\" size=\"7\" multiple>\n";
$city_result�=�mysql_query("select city, count(city) AS num_type FROM
"�.�$table_prefix."users GROUP BY city ORDER BY city");
$cities�=�mysql_fetch_array($city_result);
if�($cities)�{
����while�($c3�=�mysql_fetch_array($city_result))�{
����$num_type3�=�$c3[num_type];
����$box_stuff�.=�"<option�name=\"city\"�value=\"$c3[city]\">$c3[city]�($num
_type3)</option>";
����}
}
$box_stuff�.=�"</select></td></tr>\n";
$box_stuff�.=�"
<tr><td align=\"left\" colspan=3 align=\"center\"><input type=\"submit\"
value=\"Search\"> Note: searching for all can produce a large
page!</td></tr>
</table><input type=\"hidden\" name=\"op\" value=\"search\" />
</form></center>";
thememainbox($box_title,�$box_stuff);
include("footer.php");
}
switch($op)�{
����case�"search":
��������search();
��������break;
����default:
��������sform();
��������break;
��}
------------------------------------------------------------------------
Now, when I add anything for the function search() , even a simple message
printed to the page such as:
PHP:
------------------------------------------------------------------------
function�search()
{
����include('config.php');
����global�;
����$box_title�=�"Search Results";
����$box_stuff�.=�"Results here";
����thememainbox($box_title,�$box_stuff);
����include("footer.php");
}
------------------------------------------------------------------------
I get the error: Parse error: parse error, expecting `T_VARIABLE' or `'$''
in /Library/WebServer/Documents/phpwebsite/search_users.php on line 45
BTW... line 45 is part of the initial funtion that was working before:
PHP:
------------------------------------------------------------------------
$cat_result�=�mysql_query("select cat, catkey, cattext, count(cat) AS
num_type FROM "�.�$table_prefix."users LEFT JOIN
"�.�$table_prefix."users_cat ON cat=catkey GROUP BY cattext ORDER BY
cattext");
$categories�=�mysql_fetch_array($cat_result);
if�($categories)�{
����while�($c2�=�mysql_fetch_array($cat_result))�{
����$num_type�=�$c2[num_type];
����$box_stuff�.=�"<option�name=\"cat\"�value=\"$c2[catkey]\">$c2[cattext]�(
$num_type)</option>";
����}��//THIS IS LINE 45
}
------------------------------------------------------------------------
I feel that if I can get past this, I can likely get my actual search to
work. If you're curious, the following code is what I actually have in mind
for the search function. I just can't get far enough along to even test it.
I would surely appreciate any advice that anyone can extend.:
PHP:
------------------------------------------------------------------------
function�search()�{
include("config.php");
global�$company,�$cat,�$city,�$catkey,�$cattext,�Order;
$box_title�=�"Search Results";
if�($cat>0)�{
����$classreq="AND�catkey=$cat";
����}
��if�(!$Order)�{
����$Order="company";
����}
$query�=�"SELECT company, city, cat, catkey, cattext FROM
"�.�$table_prefix."users LEFT JOIN
"�.�$table_prefix."users_cat�ON�cat=catkey�WHERE�company�LIKE�'%$company%'�A
ND�city�LIKE�'%$city%'�AND�cat�LIKE�'%$cat%'�$classreq�ORDER�BY�$Order";
$result�=�mysql_query($query);
$box_stuff�=�"<center><br>";
$box_stuff�.=�"<table cellpadding=1 border=0 cellspacing=0 width=\"100%\">";
if�($result){
����if�($r�=�mysql_fetch_array($result)){
��������do�{
��������$box_stuff�.="
<tr�class=\"type5\"><td�align=\"left\">Company</td><td�align=\"left\">Catego
ry</td><td�align=\"left\">City</td></tr>
<tr�class=\"type5\"><td�align=\"left\">$r[company]</td><td�align=\"left\">$r
[cattext]</td><td�align=\"left\">$r[city]</td></tr>";
��������}�while�($r�=�mysql_fetch_array($result));
����}�else�{
��������$box_stuff�.=�"<b>Search Failed</b>";
����}
}
$box_stuff�.=�"</center>";
thememainbox($box_title,�$box_stuff);
include("footer.php");
}
------------------------------------------------------------------------
Thanks again,
Verdon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
