Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Yeah, sure, that's pretty easy. </p> <p>Here's what I would do:</p> <p>On your first page:</p> <pre><code>&lt;form action="mypage.php?searching=true" method="POST"&gt; &lt;input type="text" name="searchcategory" value=""/&gt; &lt;input type="submit" value="Search"/&gt; &lt;/form&gt; </code></pre> <p>On mypage.php:</p> <pre><code>&lt;table&gt; &lt;?php $sql=$db-&gt;prepare('SELECT * FROM mytable WHERE category=:category'); $sql-&gt;execute(array(':category'=&gt;$_REQUEST[searchcategory])); while ($row=$sql-&gt;fetch()) { //Here is where you will loop through all the results for your search. If //you had for example for each product name, price, and category, //you might do the following echo "&lt;tr&gt;&lt;td&gt;$row[name]&lt;/td&gt;&lt;td&gt;$row[price]&lt;/td&gt;&lt;td&gt;$row[category]&lt;/td&gt;&lt;/tr&gt;"; } ?&gt; &lt;/table&gt; </code></pre> <p>NOTES:</p> <ul> <li><p>I use mySQL...I'm not sure how you would do it with something else, but I would guess you could adapt the code for another sort of database. </p></li> <li><p>I generally use the <a href="http://php.net/manual/en/book.pdo.php" rel="nofollow">PDO</a> (accessing through prepare and execute)...my teacher said it was more secure. You can change that part of the code to however you connect to your DB. The code I use to connect looks something like (goes before the code above on mypage.php):</p> <pre><code>try { $db = new PDO("mysql:host=localhost;dbname=mydatabasename","username","password"); } catch (Exception $e) { echo "PDO connection error: " . $e-&gt;getMessage(); exit(1); } </code></pre></li> <li><p>They don't actually have to be separate pages. If you had both pages php (the first one not straight HTML), you could just change the content based on whether a variable (maybe called searching) was set to true or false. </p></li> </ul> <p>Let me know if any of that is unclear, and I'd be happy to help you out. Good luck! :)</p>
    singulars
    1. This table or related slice is empty.
    1. POdatabase search function on an HTML page possible?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJK.
    1. USemilyk
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POdatabase search function on an HTML page possible?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs it better to do this way than to use mysql's search features(all the in boolean searching, natural language searching etc)
      singulars
      1. PO
      1. USMarshall Mathews
    2. COFrom what I understand from SQL, if you index the category, the search will be extremely efficient using the WHERE clause. I was talking to one of my computer science teachers yesterday about a database that could contain GB of data, but if I indexed the date and used the WHERE clause it would still be efficient to get only the ones in the last day. Same idea.
      singulars
      1. PO
      1. USemilyk
    3. COMan, two great answers - I could only pick one and to be honest, both worked like a charm - only reason I gave the edge to emilyk is because of the secure connection method. Tweaked the script to work like a charm and added in a suggestions drop down. Thank you to everyone who commented and helped...you were all great!
      singulars
      1. PO
      1. USsynergy989
 

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