468,306 Members | 1,200 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,306 developers. It's quick & easy.

How should i done this in PHP?

Hi,

I am a newbie and recently just delved into the scripting world of
PHP. Currently I am doing
a webform that consists many fields. I have three combobox with state
selection which
will retrieve the items from a database table called state. The
dumbest and direct way would
be creating a connection and querying the data each time, which means
three connections
connected just to querying same piece of information. I am wondering
if it is possible to
refactor them into using one connection to query the states, and
assign the value to each
combobox. Then i will need not to query thrice. Any idea?

Jun 17 '07 #1
3 1667
so*********@gmail.com wrote:
Hi,

I am a newbie and recently just delved into the scripting world of
PHP. Currently I am doing
a webform that consists many fields. I have three combobox with state
selection which
will retrieve the items from a database table called state. The
dumbest and direct way would
be creating a connection and querying the data each time, which means
three connections
connected just to querying same piece of information. I am wondering
if it is possible to
refactor them into using one connection to query the states, and
assign the value to each
combobox. Then i will need not to query thrice. Any idea?
Well, first of all, PHP wouldn't create connections for this - PHP is
strictly server side. But you can use PHP to generate the <option>
tags for your select boxes when you're building your page.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jun 17 '07 #2
..oO(so*********@gmail.com)
I am a newbie and recently just delved into the scripting world of
PHP. Currently I am doing
a webform that consists many fields. I have three combobox with state
selection which
will retrieve the items from a database table called state. The
dumbest and direct way would
be creating a connection and querying the data each time, which means
three connections
connected just to querying same piece of information.
It would be just one connection and three queries. Not really a problem,
but of course you can do it just once and store the result in an array.
Then use that to create your combo boxes.

Micha
Jun 17 '07 #3
On Sun, 17 Jun 2007 06:28:25 -0700, in comp.lang.php
so*********@gmail.com
<11**********************@a26g2000pre.googlegroups .comwrote:
>| Hi,
|
| I am a newbie and recently just delved into the scripting world of
| PHP. Currently I am doing
| a webform that consists many fields. I have three combobox with state
| selection which
| will retrieve the items from a database table called state. The
| dumbest and direct way would
| be creating a connection and querying the data each time, which means
| three connections
| connected just to querying same piece of information. I am wondering
| if it is possible to
| refactor them into using one connection to query the states, and
| assign the value to each
| combobox. Then i will need not to query thrice. Any idea?
You are probably using
q1 = SELECT ID,Field1 FROM table
q2 = SELECT ID,Field2 FROM table
q3 = SEELCT ID,Field3 FROM table

You can join these into a single query
q = SELCT ID, Field1,Field2,Field3 FROM table

then build your comboboxs using only the required field(s).
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Jun 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by jaialai technology | last post: by
5 posts views Thread by Morten Overgaard | last post: by
11 posts views Thread by Sharon | last post: by
3 posts views Thread by Miguel Dias Moura | last post: by
12 posts views Thread by Ark | last post: by
2 posts views Thread by maya | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.