querying database from web based form

[ajdesigns]

Could someone please explain the post & get commands. I have compiled a html form that I want to use to allow my customers to enter an order no into.I then want the form to Query my database and return the order details ie: despatched ,assembled etc back to my customers is this possible if so how.
please help
AD

 

[sleipnir214]

I don't understand. PHP does not have post and get commands.

Do you mean that you want clarification between GET and POST methods in HTML forms and how those differences are reflected in PHP?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sc7090]

If you use GET method you have to look for the key=>val inside $_GET[] var. For example you wrote:

<input type=&quot;text&quot; name=&quot;num&quot; />

you will have to look for $_GET['num']

If you use a POST method you will have to look for $_POST['num']

You choose to use GET or POST when you define the form:

<form action=&quot;order.php&quot; method=&quot;post&quot;>

or

<form action=&quot;order.php&quot; method=&quot;get&quot;>

with the GET method you'll see in the address bar a thing like this:

http://www.mysite/order.php?num=<val>

where <val> is what you typed in the text input

but this is HTML not PHP...

 

[LTeeple]

Hi,
Like the above users said, POST and GET are not PHP commands. But, I'll bite. To expand on what they've said, you must do something like this:
(assuming <input type=&quot;text&quot; name=&quot;num&quot;> and proper validation, etc)

For:

<form method=&quot;POST&quot;>
on your processing page:

$partnum=$_POST['num'];
Your SQL statement will be
SELECT * FROM TABLE WHERE NUMBER = $partnum;

For:
<form method=&quot;GET&quot;>
on your processing page:

$partnum=$_GET['num'];
Your SQL statement will be
SELECT * FROM TABLE WHERE NUMBER = $partnum;



Cheers!
Laura