-----Original Message-----
From: Burhan Khalid [mailto:[EMAIL PROTECTED] Sent: Saturday, November 01, 2003 3:50 AM
To: Jake McHenry; [EMAIL PROTECTED]
Subject: Re: [PHP] Array maybe? Or many SQL insert queries
Jake McHenry wrote:
Hi everyone, here's what I'm doing.
As of right now, I don't have anything implemented, but
here's what I
need to do.
I have a web page, with a drop down list of hotels, an
input box for
the users frequent hotel number, and a add button. At the bottom
of
the page is a update and continue button to move the user
to the next
page with more options.
What my boss wants is, when someone puts in a number, and
clicks add,
he wants it to take that number and put it below the box,
all on the
fly. I know I could do this through repeated sql insert
querys, but I
was wondering if I could just put them into an array, then
update the
database with one query after the user clicks the update
and continue
button at the bottom, to get them to the next page?
This sounds like something javascript can fix. If you can be a bit more precise "below the box" doesn't mean much. What box? Is it a big green box? Blue box? Box of boxes?
If you want "on the fly" then its javascript. For php to work, you'd
have to send a request to the server, which would kill your "on the fly" part.I don't know why I said on the fly.. Lol..
The box I'm referring to is the input field box. I just need what's submitted via the input field and add button to show up in a list below the input box, to show the account numbers that were entered. I can either insert them into the database each time the add button is clicked, or my preference if possible, put them in an array of some kind then submit them all at once. To get a picture of what I want...:
Site Logo ______________ |______________| ADD
Submit and Continue Submit and Exit
That's basically what this page looks like. What I need is when the person inputs the account number in the input box, and clicks add, it needs to refresh the page with the added number below that box, then again for each number they enter.
You can attach a javascript function to the onclick event of the Add button that populates your drop down. Of course, this assumes that you have a predefined array of all possible values (in javascript) that the user can enter.
However, if your user can arbitrarily enter values, and all you need to do is "add" them to the drop down list, then some simple javascript DOM is all you need. Then when the user clicks on the Submit and Continue button, use php to read the dropdown array (appending [] to the name attribute's value will help -- like this <select name="foo[]"> then $_POST['foo'][0] would hold the value of your selected index).
If you are not a big fan of javascript + DOM (this is, after all, a PHP list) -- you can use PHP to dynamically populate the dropdown by appending the value of the entered box to the array. Something along the lines of (untested):
$textbx = isset($_POST['textbx']) ? $_POST['textbx'] : NULL;
$menu = array();
if ($textbx != NULL)
{
$menu['somevalue'] = $textbx;
} else { echo "<select name=\"chooser[]\"><option value=\"NULL\" selected=\"selected\">Please enter a value</option></select>";
}
/* we now assume that the array was populated */
echo "<select name=\"chooser[]\">\n";
echo "<option value=\"NULL\" selected=\"selected\">Value Entered Below</option>\n";
while(list($k,$v) = each($menu))
{
echo "<option value=\"".$k."\">".$v."</option>\n";
}
echo "</select>";
Hope this helps.
-- Burhan Khalid phplist[at]meidomus[dot]com http://www.meidomus.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
