php search form?

[iphetamine]

I have created a database and a table, was able to use php and mysql display the information onto a webpage using query, fetch_array, and loops.

 

Now I want to have a field (or search box?) so the user can enter the name of the product and it's related details appear. Does this require php forms or something like that?

[trq]

Does this require php forms or something like that?

 

Forms are made using html. You might find the chapter on dealing with forms in the book linked to in my signiture usefull.

[phpSensei]

Enter the name of the product requires a form, form field, and submit button. Then you process the form by taking the details and inputting in a query.

 

http://www.htmlite.com/mysql011.php

 

edit: Yes forms are HTML not PHP.

[iphetamine]

So basically I need to have a .html file and a .php file. And the .html file is linked to the .php file?

I'll take a look at some of the stuff you guys mentioned, thanks.

[phpSensei]

Try this to get you started.

 

<form id="form1" name="form1" method="post" action="[b]getproduct.php[/b]">
  <label>
  <input name="product" type="text" id="product" />
  </label>
  <label>
  <input type="submit" name="Submit" value="Search Product" />
  </label>
</form>

 

 

The action is where you set the form too. all the values of the product field goes to the getproduct.php page, and use $_POST['product'] to get the value. Insert that into the query I posted earlier...

 

 

edit: Do some research on PHP search security too.