Databases
StackOverflow2013
Postsdbo
POSearching MySQL with PHP
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSearching MySQL with PHP
    primarykey
    data
    text
    <p>I am doing a project where I want a person to enter the name of any artist/band into a text box where it will seach my mysql database for the event information and display the results/content on another page. The code below is within my index.php where it should get the information from search.php (below also). I've looked all over and I'm not sure why it's not working and I can't figure out what to do. Help would be great! (I really need to pass this class!) :)</p> <p>(index.php)</p> <pre><code>&lt;form name="search" action="search.php" method="get"&gt; &lt;div align="center"&gt;&lt;input type="text" name="q" /&gt; &lt;p&gt;&lt;input type="submit" name="Submit" value="Search" /&gt;&lt;/p&gt; &lt;/form&gt; </code></pre> <p>(search.php)</p> <pre><code>&lt;?php //Get the search variable from URL $var=@&amp;_GET['q']; $trimmed=trim($var); //trim whitespace from the stored variable //rows to return $limit=10; //check for an empty string and display a message. if($trimmed=="") { echo"&lt;p&gt;Please enter a name.&lt;/p&gt;"; exit; } //check for a search parameter if(!isset($var)) { echo"&lt;p&gt;We don't seem to have a search parameter!&lt;/p&gt;"; exit; } //connect to database mysql_connect("localhost","root","password"); //specify database mysql_select_db("itour") or die("Unable to select database"); //Build SQL Query $query = "select * from events where artist_name like \"%trimmed%\" order by date"; $numresults=mysql_query($query); $numrows=mysql_num_rows(numresults); //If no results, offer a google search as an alternative if ($numrows==0) { echo"&lt;h3&gt;Results&lt;/h3&gt;"; echo"&lt;p&gt;Sorry, your search: &amp;quot;" .$trimmed . "&amp;quot; returned zero results&lt;/p&gt;"; //google echo"&lt;p&gt;&lt;a href=\"http://www.google.com/search?q=".$trimmed . "\" target=\"_blank\" title=\"Look up ".$trimmed ." on Google\"&gt; Click here&lt;/a&gt; to try the search on google&lt;/p&gt;"; } //next determine if s has been passed to script, if not use 0 if(empty($s)) { $s=0; } //get results $query .=" limit $s,$limit"; $result = mysql_query($query) or die("Couldn't execute query"); //display what was searched for echo"&lt;p&gt;You searched for: &amp;quot;" .$var . "&amp;quot;&lt;/p&gt;"; //begin to show results set echo "Results"; $count = 1 + $s; //able to display the results returned while ($row=mysql_fetch_array($result)) { $title = $row["artist_name"]; echo"$count.)&amp;nbsp;$title"; $count++; } $currPage = (($s/$limit) + 1; echo"&lt;br /&gt;"; //links to other results if ($s&gt;=1){ //bypass PREV link if s is 0 $prevs=($s-$limit); print"&amp;nbsp;&lt;a href=\"$PHP_SELF?s=$prevs&amp;q=$var\"&gt;&amp;lt;&amp;lt; Prev 10&lt;/a&gt;&amp;nbsp;&amp;nbsp;"; } //calculate number of pages needing links $pages = intval($numrows/$limit); //$pages now contains int of pages needed unless there is a remainder from diviison if($numrows%$limit){ //has remainder so add one page $pages++; } //check to see if last page if (!((($s+$limit)/$limit)==$pages) &amp;&amp; $pages!=1){ //not last page so give NEXT link $news = $s+$limit; echo "&amp;nbsp;&lt;a href=\"$PHP_SELF?s=$news&amp;q=$var\"&gt;Next 10 &amp;gt;&amp;gt;&lt;/a&gt;"; } $a = $s +($limit); if($a &gt; $numrows){$a = $numrows;} $b = $s + 1; echo "&lt;p&gt;Showing results $b to $a of $numrows&lt;/p&gt;"; ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USArian Faurtosh
    1. USHolly
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    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. POSearching MySQL with PHP
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSearching MySQL with PHP
      1. USmeleyal
      1. VTFavorite
    3. VO
      singulars
      1. POSearching MySQL with PHP
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COfor some reason this didn't show up... (index.php) <form name="search" action="search.php" method="get"> <div align="center"><input type="text" name="q" /> <p><input type="submit" name="Submit" value="Search" /></p></div> </form>
      singulars
      1. POSearching MySQL with PHP
      1. USHolly
    2. COPlease edit this so that the code looks like code: use the little 1010 button above your edit box and indent 4 spaces.
      singulars
      1. POSearching MySQL with PHP
      1. USPTBNL
    3. COConnecting to database as root, huge SQL injection vulnerability, delicious.
      singulars
      1. POSearching MySQL with PHP
      1. USChad Birch
 

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