Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>THis isn't complicated at all using ajax &amp; jquery!</p> <p>A quick dirty way is to do this</p> <pre><code>&lt;div id="firstName"&gt;&lt;/div&gt; &lt;script type='text/javascript'&gt; $('#lastNames').change(function() { $('#firstName').load('getfirstname.php?lastname=' + $(this).val()); }); &lt;/script&gt; </code></pre> <p>and for getfirstname.php page</p> <pre><code>$lastName = mysql_real_escape_string($_GET['lastname']); $sql="SELECT DISTINCT Name FROM firstName WHERE LastName ='$lastName'"; //using distinct to make sure there are no duplicates $result=mysql_query($sql); $options="&lt;select id='firstNames' style='margin-right:40px;'&gt;"; $options.="&lt;option value='blank'&gt;-- first name --&lt;/option&gt;" ; while ($row=mysql_fetch_array($result)) { $name=$row["Name"]; $options.="&lt;option value='$name'&gt;$name&lt;/option&gt;"; } $options.= "&lt;/SELECT&gt;"; echo $options; </code></pre> <p>Here is a very simple page that shows how to execute php code using ajax and jquery. </p> <pre><code>&lt;? if(!isset($_GET['value'])):?&gt; &lt;script src="jquery-1.7.1.js"&gt;&lt;/script&gt; &lt;select id="select" &gt; &lt;option value="1"&gt;1&lt;/option&gt; &lt;option value="2"&gt;2&lt;/option&gt; &lt;option value="3"&gt;3&lt;/options&gt; &lt;/select&gt; &lt;div id="phpoutput"&gt;&lt;/div&gt; &lt;script&gt; $('#select').change(function() { $('#phpoutput').load('?value=' + $(this).val()); }); &lt;/script&gt; &lt;?else: $val = $_GET['value']; echo "$val sent to server. $val*3 = " . $val *3; ?&gt; &lt;?endif;?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POediting html using javascript that calls php function that gets information from sql database.. complicated...
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKris
    1. USKris
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POediting html using javascript that calls php function that gets information from sql database.. complicated...
      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. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COit doesn't work, is there any other way? it doesn't seem to load anything on change...
      singulars
      1. PO
      1. USBaruch
    2. CO@Baruch I have updated my answer and added a block of code that shows you an extremely basic ajax. This should give you an idea on how it works, and you can use this to implement what yo uneed
      singulars
      1. PO
      1. USKris
    3. COThanks, ill try it later on when i get home, seems like it should work
      singulars
      1. PO
      1. USBaruch
 

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