Databases
StackOverflow2013
Postsdbo
POCreating a search form in PHP to search a database?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating a search form in PHP to search a database?
    primarykey
    data
    text
    <p>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). </p> <p>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. </p> <p>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. </p> <p><em>Creation of database:</em> </p> <pre><code> &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; </code></pre> <p><em>HTML search form page:</em> </p> <pre><code>&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; </code></pre> <p><em>The PHP code I am using to attempt to gather info from the database</em> (I have rewritten this a few times, this code also displays the "table.liam doesn't exist")</p> <pre><code> &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; </code></pre> <p>If anyone has any insight or can help me with this I would be very grateful! Thanks in advance.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USpjmorse
    1. USLiamHorizon
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreating a search form in PHP to search a database?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POCreating a search form in PHP to search a database?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POCreating a search form in PHP to search a database?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COyou are not catching the term in php use $term = $_POST["term"]
      singulars
      1. POCreating a search form in PHP to search a database?
      1. USamitchhajer
    2. COThanks, but I am still getting table.liam doesn't exist errors :(
      singulars
      1. POCreating a search form in PHP to search a database?
      1. USLiamHorizon
    3. COOuch. I'm sympathetic to your predicament here, but you're going to have a hard time getting good answers on Stack Overflow with this question as it stands. The reason is that it's not really one question; it's a whole bunch of questions. For good, useful help of the kind Stack Overflow is best at providing, you need to break your problem down into discrete pieces (e.g. "Why am I getting table doesn't exist errors?") and ask those questions.
      singulars
      1. POCreating a search form in PHP to search a database?
      1. USpjmorse
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload