RE: [PHP-DB] PHP/Mysql Script help.
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
[EMAIL PROTECTED]
Vincit imitationem veritas.
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
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 (bRace:/b %s\nbr, $myrow[race]);
echo br;
printf(bDescription:/b %s\nbr, $myrow[racetxt]);
echo br;
echo brh3a 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/abr\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\
. pPick 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 [EMAIL PROTECTED]
To: 'PHP-DB' [EMAIL PROTECTED]
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(bRace:/b %s\nbr, $myrow[race]);
echo br;
printf
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 (bRace:/b %s\nbr, $myrow[race]);
echo br;
printf(bDescription:/b %s\nbr, $myrow[racetxt]);
echo br;
echo brh3a 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/abr\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\
. pPick 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 [EMAIL PROTECTED]
To: 'PHP-DB' [EMAIL PROTECTED]
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(bRace:/b %s\nbr, $myrow[race]);
echo br;
printf(bDescription:/b %s\nbr, $myrow[racetxt]);
echo br;
echo brh3a 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/abr\n, $PHP_SELF, $myrow[id],
$myrow[race]);
} while ($myrow = mysql_fetch_array($result));
;
}
else {
echoform name=\letter\ method=\post\ action=\races.php\
. pPick a letter to begin your search/p
. p
Re: [PHP-DB] PHP/Mysql Script help.
hi!
wow - cool code! it is very well structured i think (i like it ;-)! i just
would change 2 little details (thats only what i'd do):
if($id) is not enough for me - first of all i want that it can only be
transportet by GET. secondly i do not want people trying to hack my
mysql-server with some ugly url-hacking. so i test if it is a numeric input.
third it is possible that people may bookmark some ids to access them
directly so i would include a test if the requested id exists or not:
if(isset($_GET['id']) is_numeric($_GET['id'])
{
$qry = 'SELECT `id` FROM `nuke_race` WHERE `id`='.$id;
$res = mysql_query($qry, $con);
if(mysql_num_rows($res)==0)
echo 'Sorry, this entry has been deleted or was never
created!'.\n;
else
// show entry
}
next - but this is really a small thing - i'd not make a long list of
options i'd create a for-loop like this:
echo 'select name=select size=1'.\n;
for($i = 65; $i = 90; $i++)
echo 'option
value='.strtolower(chr($i)).''.chr($i).'/option'.\n;
echo '/select'.\n;
oh! i just saw that you use POST anyways. ;) also a possibility (but this
avoids the entries from being bookmarked).
keep phping!
.ma
Fulco of Scarborough [EMAIL PROTECTED] [EMAIL PROTECTED] 0:04 Uhr:
Greeting everyone, my name is Jason and I am sorry for bugging you since you
probably get a ton of these emails, but I was hoping you all might be able
to help me. 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 am only wanting to get some tips or a sample somewhere you may know of to
get me going in the right direction.
Here is my current code so far:
?php
require(racesetup.php);
$con = mysql_connect($host, $user, $pass);
mysql_select_db($db, $con);
// display individual record
if ($id) {
$result = mysql_query(SELECT * FROM nuke_race WHERE id=$id,$con);
$myrow = mysql_fetch_array($result);
printf(bRace:/b %s\nbr, $myrow[race]);
echo br;
printf(bDescription:/b %s\nbr, $myrow[racetxt]);
echo br;
echo brh3a href=\javascript:history.go(-1)\Back/a/h3;
} else {
echo form name=letter method=\post\
action=\http://st.fulco.net/races.php\;
pPick 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=\letter\ value=\Enter information\
/p
/form
;
} else {
$result = mysql_query(SELECT * FROM nuke_race WHERE race LIKE
'$letter%',$con);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
printf(a href=\%s?id=%s\%s/abr\n, $PHP_SELF, $myrow[id],
$myrow[race]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no records to display
echo Sorry, no records were found!;
}
}
?
Thanks for your help in advance.
Yours in Service,
Jason Britton
Scar's http://st.fulco.net/ Legion
http://st.fulco.net http://st.fulco.net/
[EMAIL PROTECTED]
Vincit imitationem veritas.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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(bRace:/b %s\nbr, $myrow[race]);
echo br;
printf(bDescription:/b %s\nbr, $myrow[racetxt]);
echo br;
echo brh3a 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/abr\n, $PHP_SELF, $myrow[id],
$myrow[race]);
} while ($myrow = mysql_fetch_array($result));
;
}
else {
echoform name=\letter\ method=\post\ action=\races.php\
. pPick 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
echoform name=\letter\ method=\post\ action=\races.php\
Thanks for your help!
Yours in Service,
Jason Britton
Scar's http://st.fulco.net/ Legion
[EMAIL PROTECTED]
Vincit imitationem veritas.
Re: [PHP-DB] PHP/Mysql Script help.
On Thursday 05 June 2003 12:25, Fulco of Scarborough wrote:
I have still been getting errors, so here goes again.
[snip]
I am still getting Parse error: parse error, unexpected T_STRING in
/home/wwwfulc/public_html/st/races.php on line 38
Parse error means that you have written incorrectly formatted code that php
doesn't even attempt to run. Check that each open , ', [, (, { has a
corresponding closing counterpart and each of your php statements (~lines)
are terminated with a semi-colon (;).
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
Love means having to say you're sorry every five minutes.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
