Re: [PHP-DB] Drop-down box in php
From: andy amol
I am using the following code, but it is not populating my script. If
you can help I would be grateful.
I am using mysql as database.
?
$sql = SELECT course_id FROM course;
$sql_result = mysql_query($sql)
or die(Couldn't execute query.);
while ($row = mysql_fetch_array($sql_result)) {
$type = $row[course_id];
$typedesc =$row[dept_id];
$option_block .= OPTION value=\$type\$typedesc/OPTION;
You're using [dept_id], but not selecting that column in your query.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
I use html forms with select field size 1 and the option values and/or what is supposed to appear in the box. This you populate by your DB query, maybe using an array and a loop (from 0 to ..). Torsten andy amol schrieb: hi, I would like to know how to create and populate drop down boxes in php. I want the value to be populated from database. What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrity. Also if you can help me with a date validation program I will be grateful. Thanks in advance. - Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
You mean select/select html dropdown-s?
print 'select name=sg';
$r = mysql_query(SELECT id, field1, fieldn FROM table WHERE fieldn = 'sg');
while($RESULT = mysql_fetch_array($)) {
print 'option value='.$RESULT['id'].''.$RESULT['fieldn']'./option';
}
print '/select';
Validating: just check the $_POST['sg'] value, against is_numeric(), then you can do a SELECT, to
check whether the id exists.
You can find some more examples, on php net manual pages
andrej
andy amol wrote:
hi,
I would like to know how to create and populate drop down boxes in php.
I want the value to be populated from database.
What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrity.
Also if you can help me with a date validation program I will be grateful.
Thanks in advance.
-
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
From: andy amol [EMAIL PROTECTED]
I would like to know how to create and populate drop down boxes in php.
I want the value to be populated from database.
What I am try to do is to provide the forign key value as combo box
option, so that I do not have to check for referential integrity.
You still have to check. Just because you provide a discreet number of
options in a select box doesn't mean that's really all the user can choose
from. There are many ways to manipulate the data.
That being said, just create a loop as you draw items from your database.
?php
echo 'select name=something size=1';
$sql = SELECT name FROM products WHERE ...;
$result = query($sql);
while($row = fetch_assoc($result))
{ echo option value=\{$row['name']}\{$row['name']}/option\n; }
echo /select;
I don't know what database you're using, so query() and fetch_assoc() are
generic.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Drop-down box in php
If it is a MySWL database, the following code works great
?
$sql = select choice, description from views;
$result = mysql_query($sql) or die(mysql_error());
$viewing = ;
$viewing .= select name=\view_code\\n;
while ($view_list = mysql_fetch_array($result))
{
$view_code = $view_list[choice];
$view_desc = stripslashes($view_list[description]);
$viewing .= option value=\$view_code\$view_desc/option\n;
}
$viewing .= /select;
?
Of course you'll have to change it to fit your needs, but I just have a
while loop that gets the information and then dumps each line it gets
out to a temp variable. On the pages that include this one is where the
displaying comes out.
HTH,
Robert
-Original Message-
From: andy amol [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 11:53 AM
To: David Robley; [EMAIL PROTECTED]
Subject: [PHP-DB] Drop-down box in php
hi,
I would like to know how to create and populate drop down boxes in
php. I want the value to be populated from database. What I am try to do
is to provide the forign key value as combo box option, so that I do not
have to check for referential integrity.
Also if you can help me with a date validation program I will be
grateful.
Thanks in advance.
-
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
hi,
I am using the following code, but it is not populating my script. If you can help
I would be grateful.
I am using mysql as database.
?
$sql = SELECT course_id FROM course;
$sql_result = mysql_query($sql)
or die(Couldn't execute query.);
while ($row = mysql_fetch_array($sql_result)) {
$type = $row[course_id];
$typedesc =$row[dept_id];
$option_block .= OPTION value=\$type\$typedesc/OPTION;
}
?
SELECT name=selecttype id=selecttype
? echo $option_block; ?
/SELECT
thanks.
John W. Holmes [EMAIL PROTECTED] wrote:
From: andy amol
I would like to know how to create and populate drop down boxes in php.
I want the value to be populated from database.
What I am try to do is to provide the forign key value as combo box
option, so that I do not have to check for referential integrity.
You still have to check. Just because you provide a discreet number of
options in a box doesn't mean that's really all the user can choosefrom. There are
many ways to manipulate the data.That being said, just create a loop as you draw items
from your database.echo '';
$sql = SELECT name FROM products WHERE ...;
$result = query($sql);
while($row = fetch_assoc($result))
{ echo {$row['name']}\n; }
echo ;
I don't know what database you're using, so query() and fetch_assoc() are
generic.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
