the line
global ;
should be
global $some_variable;
or delete it
Verdon Vaillancourt wrote:
>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
