RE: [PHP-DB] PHP/Mysql Script help.
| From: | Fulco of Scarborough | Date: | Thu, 05 Jun 2003 17:57:42 +0000 |
| Subject: | RE: [PHP-DB] PHP/Mysql Script help. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28359@lists.php.net to get a copy of this message | ||
Thanks for all you wonderful help. With a little tweaking, and a new
debugging program, I have been able to get the results I want. Now I'm
going to begin adding some security features. Again, thanks for you help.
Yours in Service,
Jason Britton
Scar's Legion
http://st.fulco.net
scar@st.fulco.net
Vincit imitationem veritas.
> -----Original Message-----
> From: Becoming Digital [mailto:subs@becomingdigital.com]
> Sent: Thursday, June 05, 2003 4:59 AM
> To: 'PHP-DB'
> Subject: Re: [PHP-DB] PHP/Mysql Script help.
>
> I debugged the code and there were a slew of errors. I've fixed all but
one,
> which I can't correct bcs I don't know the intention. Most of the errors
came
> from improper syntax, a problem which could have been avoided by using
> consistent code formatting. I chose to do that for you as well and have
> included the code below.
>
> As for the error I could not correct, it involves the final elseif()
statement.
> The way your code was written, you had two 'else' statements, which is an
> obvious violation. I corrected that by changing the first (before the
select
> statement) to an elseif(), but I do not know the condition. Once you
enter it,
> the code should work smoothly.
>
>
> <?php
>
> require("racesetup.php");
>
> $con = mysql_connect($host, $user, $pass) or die(mysql_error());
>
> mysql_select_db($db, $con) or die(mysql_error());
>
> // display individual record
> if ($id)
> {
> error_reporting(E_ALL);
>
> $result = mysql_query("SELECT * FROM nuke_race WHERE id=$id",$con) or
> die(mysql_error());
>
> $myrow = mysql_fetch_array($result) or die(mysql_error());
>
> printf ("<b>Race:</b> %s\n<br>", $myrow["race"]);
>
> echo "<br>";
>
> printf("<b>Description:</b> %s\n<br>",
> $myrow["racetxt"]);
>
> echo "<br>";
> echo "<br><h3><a
> href=\"javascript:history.go(-1)\">Back</a></h3>";
> }
>
> elseif ($_Post['letter'])
> {
> if ($_Post['letter'])
> {
> $result = mysql_query("SELECT * FROM nuke_race WHERE race LIKE
> $_Post['letter']%",$con) or die(mysql_error());
> if ($myrow = mysql_fetch_array($result))
> { // display list if there are records to display
> do {
> printf("<a
> href=\"%s?id=%s\">%s</a><br>\n", $PHP_SELF,
> $myrow["id"], $myrow["race"]);
> }
> while ($myrow = mysql_fetch_array($result));
> }
> }
> }
>
> //NO CONDITION LISTED!!
> elseif ()
> {
> echo "<form name=\"letter\" method=\"post\"
> action=\"races.php\">"
>
> . " <p>Pick a letter to begin your search</p>"
> . " <p> "
> . " <select name=\"select\">"
> . " <option value=\"a\">A</option>"
> . " <option value=\"b\">B</option>"
> . " <option value=\"c\">C</option>"
> . " <option value=\"d\">D</option>"
> . " <option value=\"e\">E</option>"
> . " <option value=\"f\">F</option>"
> . " <option value=\"g\">G</option>"
> . " <option value=\"h\">H</option>"
> . " <option value=\"i\">I</option>"
> . " <option value=\"j\">J</option>"
> . " <option value=\"k\">K</option>"
> . " <option value=\"L\">L</option>"
> . " <option value=\"m\">M</option>"
> . " <option value=\"n\">N</option>"
> . " <option value=\"o\">O</option>"
> . " <option value=\"p\">P</option>"
> . " <option value=\"q\">Q</option>"
> . " <option value=\"r\">R</option>"
> . " <option value=\"s\">S</option>"
> . " <option value=\"t\">T</option>"
> . " <option value=\"u\">U</option>"
> . " <option value=\"v\">V</option>"
> . " <option value=\"w\">W</option>"
> . " <option value=\"x\">X</option>"
> . " <option value=\"y\">Y</option>"
> . " <option value=\"z\">Z</option>"
> . " </select>"
> . " </p>"
> . " <p> "
> . " <input type=\"Submit\" name=\"submit\"
> value=\"Enter
> information\">"
> . " </p>"
> . "</form>"
> ."";
> }
>
> else
> // no records to display
> echo "Sorry, no records were found!";
>
> ?>
>
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> ----- Original Message -----
> From: "Fulco of Scarborough" <fulco@fulco.net>
> To: "'PHP-DB'" <php-db@lists.php.net>
> Sent: Thursday, 05 June, 2003 00:25
> Subject: Re: [PHP-DB] PHP/Mysql Script help.
>
>
> I have still been getting errors, so here goes again.
>
>
>
> I am attempting to design a script that presents the user with a form with
> 26 letters to choose from. When they pick a letter I want it to take them
> to a list of all the entries in my database that begin with the letter
they
> selected in link form. When they click on the term, I want it to pull up
> the info for that entry.
>
>
>
> I have made some changes and added some error checking:
>
>
>
> <?php
>
>
>
> require("racesetup.php");
>
> $con = mysql_connect($host, $user, $pass) or die(mysql_error());
>
>
>
> mysql_select_db($db, $con) or die(mysql_error());
>
>
>
> // display individual record
>
>
>
> if ($id) {
>
> error_reporting(E_ALL);
>
> $result = mysql_query("SELECT * FROM nuke_race WHERE id=$id",$con) or
> die(mysql_error());
>
>
>
> $myrow = mysql_fetch_array($result) or die(mysql_error());
>
>
>
> printf("<b>Race:</b> %s\n<br>", $myrow["race"]);
>
> echo "<br>";
>
> printf("<b>Description:</b> %s\n<br>",
> $myrow["racetxt"]);
>
> echo "<br>";
>
> echo "<br><h3><a
> href=\"javascript:history.go(-1)\">Back</a></h3>";
>
>
>
>
> } elseif ($_Post['letter']) {
>
> if ($_Post['letter']) {
>
> $result = mysql_query("SELECT * FROM nuke_race WHERE race LIKE
> $_Post['letter']%",$con) or die(mysql_error());
>
> if ($myrow = mysql_fetch_array($result)) {
>
>
>
> // display list if there are records to display
>
>
>
> do {
>
>
>
> printf("<a href=\"%s?id=%s\">%s</a><br>\n",
> $PHP_SELF,
$myrow["id"],
> $myrow["race"]);
>
>
>
> } while ($myrow = mysql_fetch_array($result));
>
>
>
> ";
>
> }
>
> else {
>
> echo"<form name=\"letter\" method=\"post\"
> action=\"races.php\">"
>
> . " <p>Pick a letter to begin your search</p>"
>
> . " <p> "
>
> . " <select name=\"select\">"
>
> . " <option value=\"a\">A</option>"
>
> . " <option value=\"b\">B</option>"
>
> . " <option value=\"c\">C</option>"
>
> . " <option value=\"d\">D</option>"
>
> . " <option value=\"e\">E</option>"
>
> . " <option value=\"f\">F</option>"
>
> . " <option value=\"g\">G</option>"
>
> . " <option value=\"h\">H</option>"
>
> . " <option value=\"i\">I</option>"
>
> . " <option value=\"j\">J</option>"
>
> . " <option value=\"k\">K</option>"
>
> . " <option value=\"L\">L</option>"
>
> . " <option value=\"m\">M</option>"
>
> . " <option value=\"n\">N</option>"
>
> . " <option value=\"o\">O</option>"
>
> . " <option value=\"p\">P</option>"
>
> . " <option value=\"q\">Q</option>"
>
> . " <option value=\"r\">R</option>"
>
> . " <option value=\"s\">S</option>"
>
> . " <option value=\"t\">T</option>"
>
> . " <option value=\"u\">U</option>"
>
> . " <option value=\"v\">V</option>"
>
> . " <option value=\"w\">W</option>"
>
> . " <option value=\"x\">X</option>"
>
> . " <option value=\"y\">Y</option>"
>
> . " <option value=\"z\">Z</option>"
>
> . " </select>"
>
> . " </p>"
>
> . " <p> "
>
> . " <input type=\"Submit\" name=\"submit\" value=\"Enter
> information\">"
>
> . " </p>"
>
> . "</form>"
>
> . "
>
> ."";
>
>
>
> }
>
> else {
>
> // no records to display
>
>
>
> echo "Sorry, no records were found!";
>
> }
>
>
>
> ?>
>
>
>
> I am still getting "Parse error: parse error, unexpected T_STRING in
> /home/wwwfulc/public_html/st/races.php on line 38"
>
>
>
> This is line 38
>
>
>
> echo"<form name=\"letter\" method=\"post\"
> action=\"races.php\">"
>
>
>
>
>
> Thanks for your help!
>
>
>
> Yours in Service,
>
> Jason Britton
>
> Scar's <http://st.fulco.net/> Legion
>
> scar@st.fulco.net
>
>
>
> Vincit imitationem veritas.
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>