|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| PHP PHP for some can be one of the hardest website programming codes, so do you need help on your PHP script, if it is php4, php5 or lower this is the place for you for any PHP help. |
 |
| | LinkBack | Thread Tools | Display Modes |
07-01-2007, 5:09 PM
| #1 | ||
 |
Hi-- I have the following script, which is supposed to take a set of keywords form a POST and retrieve any records found from a mysql database which contain those keywords. I am getting the following error when this is run: Parse error : parse error, unexpected $ in /usr/www/users/grndlvl/searchresults.php on line 201 The line referred to here is a bit odd. I do have that many lines because the script is part of an html page, however, that line in the page only says <html> and is the end of the page. Here is the script: <?php $keywords = addslashes($_POST['keywords']); if( empty($keywords) ) { echo "Sorry. You must enter at least one Keyword to start your Search."; } else { //connect to host $dbServer = "host"; $dbDatabase = "db"; $dbUser = "user"; $dbPass = "password"; $sConn = mysql_connect($dbServer, $dbUser, $dbPass); if (!$sConn) echo 'Unable to connect to database server because ',mysql_error(); else { $dConn = mysql_select_db($dbDatabase, $sConn); if (!$dConn) echo 'Unable to connect to database because ',mysql_error(); else { //find which records have any of the keywords sent by the POST $vars = explode (" " ,trim ($keywords )); for( $i =0;$i <count ($vars ); $i ++) { $pre = ( $i == 0) ? "WHERE" : "OR" ; $k .= " $pre `keywords` LIKE '%" .$vars [$i ]. "%'" ; } $query = mysql_query ("SELECT * FROM articles $k" ); $result = mysql_query($query); if (!$result) echo "Couldn't get request because ",mysql_error(); else { if ($row = mysql_fetch_array($result)) { echo "<b>Answer: </b>",$row[4]; } else echo "<b>Sorry, we couldn't find an answer to your Question. Please contact Sales at: <a href=\"sales@mysite.com\">sales@mysite.com</a></b>" ; } } } ?> | ||
     |
| Advertisements |
|
07-01-2007, 5:09 PM
| #2 | ||
| |
in article XC9%a.1839$dW.71751893@newssvr13.news.prodigy.com, Tom Thackrey at tomnr@creative-light.com wrote on 8/15/03 11:28 AM: > > On 15-Aug-2003, Jeffrey Ellis <support@groundlevel.net> wrote: > >> I have the following script, which is supposed to take a set of keywords >> form a POST and retrieve any records found from a mysql database which >> contain those keywords. I am getting the following error when this is run: >> >> Parse error : parse error, unexpected $ in >> /usr/www/users/grndlvl/searchresults.php on line 201 >> >> The line referred to here is a bit odd. I do have that many lines because >> the script is part of an html page, however, that line in the page only >> says > > If you're not going to include the complete file, please indicate which line > is 201. > > The problem is your braces are mismatched. The else (or for() depending on > your POV) below has an opening brace but no closing brace > > else { > //find which records have any of the keywords sent by the POST > $vars = explode (" " ,trim ($keywords )); > for( $i =0;$i <count ($vars ); $i ++) { > $pre = ( $i == 0) ? "WHERE" : "OR" ; > $k .= " $pre `keywords` LIKE '%" .$vars [$i ]. "%'" ; > } // <<<<<<<<<<<<<< add a closing brace here. > } > > A few hints on syntax errors: > 0) The error message describes what caught the problem not what caused it. A > missing ; on line 23 rarely says "missing ; on line 23" it usually says > "unexpected T_VAL on line 24" or some such gibberish. Just because a car > smashes into a tree doesn't mean the tree caused the accident. > 1) Syntax errors are almost always caused by a missing ; or a string without > a closing " / ' or unmatched () {} or [] > 2) Next come strings with an unescaped character like 'tom's house' and > missing operators like $a = "error: " mysql_error(); > > If you don't see the problem by inspection, remove the line that reports the > error or even the block of lines containing the error. If the error goes > away, you know the problem is probably in the code you removed, if not it's > probably in some statement before the removed code. If you still can't find > the error, try feng shui-- take as many lines out as you can and still get > the error. When you have the smallest possible set of code that produces the > error, post it here and you'll get a quick answer. Hi, Tom-- Thanks again for your help and training...I will try that. One of the reasons I was hesitant to take any brackets out or pout them in is I'm not sure how to indent them...does the indentation of the brackets actually matter to the code? All My Best, Jeffrey | ||
| |
|
07-01-2007, 5:09 PM
| #3 | ||
| |
in article XC9%a.1839$dW.71751893@newssvr13.news.prodigy.com, Tom Thackrey at tomnr@creative-light.com wrote on 8/15/03 11:28 AM: > > On 15-Aug-2003, Jeffrey Ellis <support@groundlevel.net> wrote: > >> I have the following script, which is supposed to take a set of keywords >> form a POST and retrieve any records found from a mysql database which >> contain those keywords. I am getting the following error when this is run: >> >> Parse error : parse error, unexpected $ in >> /usr/www/users/grndlvl/searchresults.php on line 201 >> >> The line referred to here is a bit odd. I do have that many lines because >> the script is part of an html page, however, that line in the page only >> says > > If you're not going to include the complete file, please indicate which line > is 201. > > The problem is your braces are mismatched. The else (or for() depending on > your POV) below has an opening brace but no closing brace > > else { > //find which records have any of the keywords sent by the POST > $vars = explode (" " ,trim ($keywords )); > for( $i =0;$i <count ($vars ); $i ++) { > $pre = ( $i == 0) ? "WHERE" : "OR" ; > $k .= " $pre `keywords` LIKE '%" .$vars [$i ]. "%'" ; > } // <<<<<<<<<<<<<< add a closing brace here. > } > > A few hints on syntax errors: > 0) The error message describes what caught the problem not what caused it. A > missing ; on line 23 rarely says "missing ; on line 23" it usually says > "unexpected T_VAL on line 24" or some such gibberish. Just because a car > smashes into a tree doesn't mean the tree caused the accident. > 1) Syntax errors are almost always caused by a missing ; or a string without > a closing " / ' or unmatched () {} or [] > 2) Next come strings with an unescaped character like 'tom's house' and > missing operators like $a = "error: " mysql_error(); > > If you don't see the problem by inspection, remove the line that reports the > error or even the block of lines containing the error. If the error goes > away, you know the problem is probably in the code you removed, if not it's > probably in some statement before the removed code. If you still can't find > the error, try feng shui-- take as many lines out as you can and still get > the error. When you have the smallest possible set of code that produces the > error, post it here and you'll get a quick answer. Hi, Tom-- I inserted the Bracket and now there are no errors  However, I am now getting the following as a results: Couldn't get request because You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #2' at line 1 I thought Resource ID problems had to do with not using mysql_fetch_array or such, and my script does have that...? Here's the relevant section: $vars = explode (" " ,trim ($keywords )); for( $i =0;$i <count ($vars ); $i ++) { $pre = ( $i == 0) ? "WHERE" : "OR" ; $k .= " $pre `keywords` LIKE '%" .$vars [$i ]. "%'" ; } } $query = mysql_query ("SELECT * FROM articles $k" ); $result = mysql_query($query); if (!$result) echo "Couldn't get request because ",mysql_error(); else { if ($row = mysql_fetch_array($result)) { echo "<b>Answer: </b>",$row[4]; } else echo "<b>Sorry, we couldn't find an answer to your Question. Please contact Sales at: <a href=\"sales@mysite.com\">sales@mysite.com</a></b>" ; } } } ?> Thanks again! All My Best, Jeffrey | ||
| |
|
07-01-2007, 5:09 PM
| #4 | ||
| |
Jeffrey Ellis wrote: > in article XC9%a.1839$dW.71751893@newssvr13.news.prodigy.com, Tom Thackrey > at tomnr@creative-light.com wrote on 8/15/03 11:28 AM: > > >>On 15-Aug-2003, Jeffrey Ellis <support@groundlevel.net> wrote: >> >> >>>I have the following script, which is supposed to take a set of keywords >>>form a POST and retrieve any records found from a mysql database which >>>contain those keywords. I am getting the following error when this is run: >>> >>>Parse error : parse error, unexpected $ in >>>/usr/www/users/grndlvl/searchresults.php on line 201 >>> >>>The line referred to here is a bit odd. I do have that many lines because >>>the script is part of an html page, however, that line in the page only >>>says >> >>If you're not going to include the complete file, please indicate which line >>is 201. >> >>The problem is your braces are mismatched. The else (or for() depending on >>your POV) below has an opening brace but no closing brace >> >> else { >> //find which records have any of the keywords sent by the POST >> $vars = explode (" " ,trim ($keywords )); >> for( $i =0;$i <count ($vars ); $i ++) { >> $pre = ( $i == 0) ? "WHERE" : "OR" ; >> $k .= " $pre `keywords` LIKE '%" .$vars [$i ]. "%'" ; >> } // <<<<<<<<<<<<<< add a closing brace here. >>} >> >>A few hints on syntax errors: >>0) The error message describes what caught the problem not what caused it. A >>missing ; on line 23 rarely says "missing ; on line 23" it usually says >>"unexpected T_VAL on line 24" or some such gibberish. Just because a car >>smashes into a tree doesn't mean the tree caused the accident. >>1) Syntax errors are almost always caused by a missing ; or a string without >>a closing " / ' or unmatched () {} or [] >>2) Next come strings with an unescaped character like 'tom's house' and >>missing operators like $a = "error: " mysql_error(); >> >>If you don't see the problem by inspection, remove the line that reports the >>error or even the block of lines containing the error. If the error goes >>away, you know the problem is probably in the code you removed, if not it's >>probably in some statement before the removed code. If you still can't find >>the error, try feng shui-- take as many lines out as you can and still get >>the error. When you have the smallest possible set of code that produces the >>error, post it here and you'll get a quick answer. > > > Hi, Tom-- > > I inserted the Bracket and now there are no errors > > However, I am now getting the following as a results: > > Couldn't get request because You have an error in your SQL syntax. Check > the manual that corresponds to your MySQL server version for the right > syntax to use near 'Resource id #2' at line 1 After this line: $query = mysql_query ("SELECT * FROM articles $k" ); add this: echo "sql : $query"; and post what it prints out. The problem is (as it says) in your SQL syntax, so lets take a look at it. In response to your earlier question, the indentation of the code makes no difference, however you'll find it much easier to understand if you indent properly. The code you've posted doesn't look too bad, but its difficult to tell exactly as it tends to get a bit mashed up when posting code. MK. > I thought Resource ID problems had to do with not using mysql_fetch_array or > such, and my script does have that...? > > Here's the relevant section: > > $vars = explode (" " ,trim ($keywords )); > for( $i =0;$i <count ($vars ); $i ++) { > $pre = ( $i == 0) ? "WHERE" : "OR" ; > $k .= " $pre `keywords` LIKE '%" .$vars [$i ]. "%'" ; > } > } > $query = mysql_query ("SELECT * FROM articles $k" ); > $result = mysql_query($query); > if (!$result) > echo "Couldn't get request because ",mysql_error(); > else { > if ($row = mysql_fetch_array($result)) { > echo "<b>Answer: </b>",$row[4]; > } > else > echo "<b>Sorry, we couldn't find an answer to your Question. > Please contact Sales at: > <a > href=\"sales@mysite.com\">sales@mysite.com</a></b>" ; > } > } > } > ?> > > Thanks again! > > All My Best, > Jeffrey > > > > -- MeerKat | ||
| |
|
07-01-2007, 5:09 PM
| #5 | ||
| |
in article XC9%a.1839$dW.71751893@newssvr13.news.prodigy.com, Tom Thackrey at tomnr@creative-light.com wrote on 8/15/03 11:28 AM: Reply deleted. > > A few hints on syntax errors: > 0) The error message describes what caught the problem not what caused it. A > missing ; on line 23 rarely says "missing ; on line 23" it usually says > "unexpected T_VAL on line 24" or some such gibberish. Just because a car > smashes into a tree doesn't mean the tree caused the accident. > 1) Syntax errors are almost always caused by a missing ; or a string without > a closing " / ' or unmatched () {} or [] > 2) Next come strings with an unescaped character like 'tom's house' and > missing operators like $a = "error: " mysql_error(); > > If you don't see the problem by inspection, remove the line that reports the > error or even the block of lines containing the error. If the error goes > away, you know the problem is probably in the code you removed, if not it's > probably in some statement before the removed code. If you still can't find > the error, try feng shui-- take as many lines out as you can and still get > the error. When you have the smallest possible set of code that produces the > error, post it here and you'll get a quick answer. Hi, Tom-- I tried doing some work on the page. I want to get all the records I get back to echo into a table. So I have added the following below...(I'll only show one example of each...) It looks like I am also getting the following error: Warning : mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/www/users/grndlvl/searchresults.php on line 165 Line 165 is the while line: <?php while($row = mysql_fetch_array($result)) { ?> <tr> <td width="34%" bgcolor="#FFDCA8" height="21"> <p style="margin-left: 10; margin-right: 10"> <font face="Verdana" size="1"> <?php echo $row["til_id"]; ?> </font> </td> The rest of the statements are the same except for which row I display. All My Best, Jeffrey | ||
| |
|
07-01-2007, 5:10 PM
| #6 | ||
| |
On 15-Aug-2003, Jeffrey Ellis <support@groundlevel.net> wrote: > t looks like I am also getting the following error: > > Warning : mysql_fetch_array(): supplied argument is not a valid MySQL > result resource in /usr/www/users/grndlvl/searchresults.php on line 165 > > Line 165 is the while line: > > > <?php > > while($row = mysql_fetch_array($result)) That message means that $result is not valid probably because your mysql_query() failed for some reason. if you code something like: $result = mysql_query($sql,$lnk); if (!$result) echo "Query ($sql) failed because ",mysql_error(); where $lnk is your mysql connection and $sql is your query string. You will get a lot more information. -- Tom Thackrey www.creative-light.com | ||
| |
|
07-01-2007, 5:10 PM
| #7 | ||
| |
in article cIc%a.1410$pD5.73@newssvr25.news.prodigy.com, Tom Thackrey at tomnr@creative-light.com wrote on 8/15/03 2:58 PM: > > On 15-Aug-2003, Jeffrey Ellis <support@groundlevel.net> wrote: > >> t looks like I am also getting the following error: >> >> Warning : mysql_fetch_array(): supplied argument is not a valid MySQL >> result resource in /usr/www/users/grndlvl/searchresults.php on line 165 >> >> Line 165 is the while line: >> >> >> <?php >> >> while($row = mysql_fetch_array($result)) > > That message means that $result is not valid probably because your > mysql_query() failed for some reason. > > if you code something like: > $result = mysql_query($sql,$lnk); > if (!$result) > echo "Query ($sql) failed because ",mysql_error(); > > where $lnk is your mysql connection and $sql is your query string. You will > get a lot more information. Hi-- I put in both the suggested error detection lines as follows...Tom, I apologize if I didn't use the variables correctly. I wasn't sure exactly how. $vars = explode (" " ,trim ($keywords )); for( $i =0;$i <count ($vars ); $i ++) { $pre = ( $i == 0) ? "WHERE" : "OR" ; $k .= " $pre `keywords` LIKE '%" .$vars [$i ]. "%'" ; } } $query = mysql_query ("SELECT * FROM articles $k" ); echo "sql : $query"; $result = mysql_query($query); $result = mysql_query($sql,$lnk); if (!$result) echo "Query ($sql) failed because ",mysql_error(); if (!$result) echo "Couldn't get request because ",mysql_error(); else { if ($row = mysql_fetch_array($result)) { echo "<b>Answer: </b>",$row[4]; } The errors coming back are: sql : Resource id #2 Warning : mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/www/users/grndlvl/searchresults.php on line 100 Query () failed because You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #2' at line 1 Couldn't get request because You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #2' at line 1 Warning : mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/www/users/grndlvl/searchresults.php on line 169 Line 1 is: <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> Line 100 is: $result = mysql_query($sql,$lnk); Line 169 is: while($row = mysql_fetch_array($result)) Which is a part of this, a section supposed to build a table of the results when the script retrieves them: <td width="33%" bgcolor="#3D80E9" height="21"> <p style="margin-left: 10"><b><font face="Verdana" size="2" color="#FFFFFF"> Link: </font></b></td> </tr> <?php while($row = mysql_fetch_array($result)) { ?> <tr> <td width="34%" bgcolor="#FFDCA8" height="21"> <p style="margin-left: 10; margin-right: 10"> <font face="Verdana" size="1"> <?php echo $row["til_id"]; ?> </font> </td> All My Best, Jeffrey | ||
| |
|
07-01-2007, 5:10 PM
| #8 | ||
| |
On 16-Aug-2003, Jeffrey Ellis <support@groundlevel.net> wrote: > In any case, what is happening now is that I am getting the following > error: > > Parse error : parse error, unexpected $ in > /usr/www/users/grndlvl/searchresults.php on line 359 > > Line 359 is: </html> (Which is just the end of the page). (snip) Look for unbalanced <? ?>, { }, ( ), or [ ] Print your code. Take a highlighter and start with the inner most pairs of brackets. Work your way out to the rest. When you get done you should be able to spot the missing or extra bracket. I've asked you repeatedly to post all the relevant code not just the line of the error. I don't know why this is such a difficult concept for you. I do know it's getting frustrating for me to try and figure out what's going on without being able to see all the relevant information. I feel like you are using the 'Huckleberry Finn' method of programming and I think it's time for you to hire a consultant to teach you what you need to know. -- Tom Thackrey www.creative-light.com | ||
| |
|
07-01-2007, 5:10 PM
| #9 | ||
| |
in article wYs%a.784$i5.371@newssvr29.news.prodigy.com, Tom Thackrey at tomnr@creative-light.com wrote on 8/16/03 9:28 AM: > > > On 16-Aug-2003, Jeffrey Ellis <support@groundlevel.net> wrote: > >> In any case, what is happening now is that I am getting the following >> error: >> >> Parse error : parse error, unexpected $ in >> /usr/www/users/grndlvl/searchresults.php on line 359 >> >> Line 359 is: </html> (Which is just the end of the page). > (snip) > > Look for unbalanced <? ?>, { }, ( ), or [ ] > > Print your code. Take a highlighter and start with the inner most pairs of > brackets. Work your way out to the rest. When you get done you should be > able to spot the missing or extra bracket. > > I've asked you repeatedly to post all the relevant code not just the line of > the error. I don't know why this is such a difficult concept for you. I do > know it's getting frustrating for me to try and figure out what's going on > without being able to see all the relevant information. I feel like you are > using the 'Huckleberry Finn' method of programming and I think it's time for > you to hire a consultant to teach you what you need to know. > > Hi, Tom-- I do apologize...I thought I *was* posting all the relevant code...I will try to do better next time.. I will thoroughly check through all the code as you've said...I have been reading all the online tutorials to try get through this...I'm sorry for being a bother... All My Best, Jeffrey | ||
| |
|
07-01-2007, 5:10 PM
| #10 | ||
| |
in article wYs%a.784$i5.371@newssvr29.news.prodigy.com, Tom Thackrey at tomnr@creative-light.com wrote on 8/16/03 9:28 AM: > > > On 16-Aug-2003, Jeffrey Ellis <support@groundlevel.net> wrote: > >> In any case, what is happening now is that I am getting the following >> error: >> >> Parse error : parse error, unexpected $ in >> /usr/www/users/grndlvl/searchresults.php on line 359 >> >> Line 359 is: </html> (Which is just the end of the page). > (snip) > > Look for unbalanced <? ?>, { }, ( ), or [ ] > > Print your code. Take a highlighter and start with the inner most pairs of > brackets. Work your way out to the rest. When you get done you should be > able to spot the missing or extra bracket. > > I've asked you repeatedly to post all the relevant code not just the line of > the error. I don't know why this is such a difficult concept for you. I do > know it's getting frustrating for me to try and figure out what's going on > without being able to see all the relevant information. I feel like you are > using the 'Huckleberry Finn' method of programming and I think it's time for > you to hire a consultant to teach you what you need to know. > > Please accept my great thanks for all your help...of course, doing what you suggested, printing out the script and highlighting each open bracket and brace, I found that I was missing 4 closed brackets. When I added these the script worked beautifully.. I'm sure there may be another question or two as I try to fine tune the script...I hope you wont mind if I ask and that you might be kind enough to answer...but in any case, I still greatly appreciate the help you have given me already! All My Best, Jeffrey | ||
| |
| Featured Websites | ||||
|
|
| Tags: keyword, search |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Free Search Engine Listing - Unlimited Keyword Targeting | Christian Steele | Affiliate Programs | 0 | 06-12-2007 7:50 PM |
| Keyword research tools. | Chilipeppers | Search Engine Optimization | 1 | 07-17-2006 5:12 AM |
| Featured Websites | ||||
|
Keyword Search 
PacMan
Linear Mode
