Databases
StackOverflow2013
Postsdbo
POphp search won't clear when javascript onclick is clicked
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POphp search won't clear when javascript onclick is clicked
    primarykey
    data
    text
    <p>So this is what I have - A javascript onclick event that will parse json from my MySQL database data and display it when someone clicks on a seat. </p> <pre><code> var jsonData = &lt;?php echo json_encode($array); ?&gt;; function displayInfoForDiv(i){ document.getElementById('fname').innerHTML = jsonData[i].first_name; document.getElementById('lname').innerHTML = jsonData[i].last_name; } </code></pre> <p>Output </p> <pre><code> &lt;?php while ($row = mysql_fetch_array($sql)){ ?&gt; &lt;p&gt;&lt;span id="fname"&gt;&lt;?php echo $row['first_name']; ?&gt;&lt;/span&gt;&lt;/p&gt; &lt;p&gt;&lt;span id="lname"&gt;&lt;?php echo $row['last_name']; ?&gt;&lt;/span&gt;&lt;/p&gt; &lt;?php } ?&gt; </code></pre> <p>The PHP is for my search box when you try to look up a name - I'm using this</p> <pre><code> $sql = mysql_query("select * from people where first_name like '%$term%' OR last_name LIKE '%$term2%'"); </code></pre> <p>So the problem I'm having is when I conduct a search for Matt, more then one result will show up. Say:</p> <p>Matt Hasselbeck<br /> Matt Hew</p> <p>But if I use the onclick event and click on joe's seat, it will display like this:</p> <p>Joe Frill<br /> Matt Hew</p> <p>So the problem is that the search results will remain when I trigger the onClick event but the first one will change. </p> <p>My question is, is there a way when I click on a seat to clear the search results and only display the one but when I conduct a search to display the similar names.</p> <p>I'm using the PHP and JS to call the same data because, the JS only has a range of floor, while the php is grabbing everything from the database. </p> <p>Hopefully this is clear and thank you for any input. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser1065905
    1. USuser1065905
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POphp search won't clear when javascript onclick is clicked
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPlease, don't use `mysql_*` functions to write new code. They are no longer maintained and the community has begun [deprecation process](http://goo.gl/KJveJ). See the *[red box](http://goo.gl/GPmFd)*? Instead you should learn about [prepared statements](http://goo.gl/vn8zQ) and use either [PDO](http://php.net/pdo) or [MySQLi](http://php.net/mysqli). If you can't decide which, [this article](http://goo.gl/3gqF9) will help you. If you pick PDO, [here is good tutorial](http://goo.gl/vFWnC). Also see [Why shouldn't I use `mysql_*` functions?](http://stackoverflow.com/q/12859942/871050)
      singulars
      1. POphp search won't clear when javascript onclick is clicked
      1. USMadara Uchiha
    2. COWhat happens if you search for `O'Neil`? I'm guessing you forgot to [escape your SQL properly](http://bobby-tables.com/php).
      singulars
      1. POphp search won't clear when javascript onclick is clicked
      1. UStadman
    3. COThanks for the corrections - fixing them now.
      singulars
      1. POphp search won't clear when javascript onclick is clicked
      1. USuser1065905
 

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