Creating a search form in PHP to search a database

Question

I am currently trying to complete a project where the specifications are to use a search form to search through a packaging database  The database has lots of variables ranging from Sizes  names  types and meats  I need to create a search form where users can search using a number of different searches  such as searching for a lid tray that is 50 cm long     I have spent all day trying to create some PHP code that can search for info within a test database I created  I have had numerous amounts of errors ranging from mysql fetch array errors  boolean errors and now currently my latest error is that my table doesn t seem to exist  Although i can enter data into it  html and php pages where I can enter data   I don t know what is causing this and I have started again a few times now    Can anyone give me some idea or tips of what I am going to have to do currently  Here is just my small tests at the moment before I move onto the actual sites SQL database    Creation of database      lt body gt     lt  php       con   mysql connect  localhost    root              if    con               die  Could not connect      mysql error                  if  mysql query  CREATE DATABASE db test    con            echo  Database created                else         echo  Error creating database      mysql error              mysql select db  db test    con      sql    CREATE TABLE Liam         Code varchar  30     Description varchar  30     Category varchar  30     CutSize varchar  30            mysql query  sql   con        mysql close  con      gt       lt  body gt    HTML search form page     lt body gt          lt form action  form php  method  post  gt          Search   lt input type  text  name  term    gt  lt br   gt         lt input type  submit  name  submit  value  Submit    gt         lt  form gt    lt  body gt    The PHP code I am using to attempt to gather info from the database  I have rewritten this a few times  this code also displays the  table liam doesn t exist       lt body gt      lt  php   con   mysql connect   localhost    root         mysql select db   db test    con      if    con             die   Could not connect      mysql error                 sql   mysql query  SELECT   FROM Liam WHERE Description LIKE   term     or die          mysql error             while   row   mysql fetch array  sql        echo  Primary key      row  PRIMARYKEY        echo   lt br   gt  Code      row  Code        echo   lt br   gt  Description     row  Description        echo   lt br   gt  Category     row  Category        echo   lt br   gt  Cut Size     row  CutSize            mysql close  con       gt        lt  body gt    If anyone has any insight or can help me with this I would be very grateful  Thanks in advance

User · Accepted Answer

try this out let me know what happens   Form    lt form action  form php  method  post  gt   Search   lt input type  text  name  term    gt  lt br   gt    lt input type  submit  value  Submit    gt    lt  form gt     Form php    term   mysql real escape string   REQUEST  term           sql    SELECT   FROM liam WHERE Description LIKE      term        r query   mysql query  sql    while   row   mysql fetch array  r query     echo  Primary key      row  PRIMARYKEY     echo   lt br   gt  Code      row  Code     echo   lt br   gt  Description     row  Description     echo   lt br   gt  Category     row  Category     echo   lt br   gt  Cut Size     row  CutSize           Edit  Cleaned it up a little more   Final Cut  my test file     lt  php  db hostname    localhost    db username    demo    db password    demo    db database    demo       Database Connection String  con   mysql connect  db hostname  db username  db password   if    con        die  Could not connect      mysql error          mysql select db  db database   con     gt    lt  DOCTYPE html gt   lt html lang  en  gt       lt head gt           lt meta charset  utf-8    gt           lt title gt  lt  title gt       lt  head gt       lt body gt   lt form action    method  post  gt    Search   lt input type  text  name  term    gt  lt br   gt     lt input type  submit  value  Submit    gt     lt  form gt     lt  php if   empty   REQUEST  term         term   mysql real escape string   REQUEST  term            sql    SELECT   FROM liam WHERE Description LIKE      term         r query   mysql query  sql     while   row   mysql fetch array  r query      echo  Primary key      row  PRIMARYKEY      echo   lt br   gt  Code      row  Code      echo   lt br   gt  Description     row  Description      echo   lt br   gt  Category     row  Category      echo   lt br   gt  Cut Size     row  CutSize                gt       lt  body gt   lt  html gt

User · Answer

You re getting errors  table liam does not exist  because the table s name is Liam which is not the same as liam  MySQL table names are case sensitive

User · Answer

Are you sure  that specified database and table exists  Did you try to look at your database using any database client  For example command-line MySQL client bundled with MySQL server  Or if you a developer newbie  there are dozens of a GUI and web interface clients  HeidiSQL  MySQL Workbench  phpMyAdmin and many more   So first check  if your table creation script was successful and had created what it have to   BTW why do you have a script for creating the database structure  It s usualy a nonrecurring operation  so write the script to do this is unneeded  It s useful only in case of need of repeatedly creating and manipulating the database structure on the fly

[php] Creating a search form in PHP to search a database?

Examples related to php

Examples related to html

Examples related to mysql

Examples related to sql

Examples related to database