Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p><a href="http://php.net/manual/en/function.mysql-select-db.php" rel="nofollow">enter link description here</a>Use the code provided by jquery UI :</p> <pre><code>&lt;!doctype html&gt; &lt;html lang="en"&gt; &lt;head&gt; &lt;meta charset="utf-8" /&gt; &lt;title&gt;jQuery UI Accordion - Default functionality&lt;/title&gt; &lt;link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" /&gt; &lt;script src="http://code.jquery.com/jquery-1.9.1.js"&gt;&lt;/script&gt; &lt;script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"&gt;&lt;/script&gt; &lt;link rel="stylesheet" href="/resources/demos/style.css" /&gt; &lt;script&gt; $(function() { $( "#accordion" ).accordion(); }); &lt;/script&gt; &lt;/head&gt; &lt;body&gt; &lt;div id="accordion"&gt; &lt;h3&gt;Section 1&lt;/h3&gt; &lt;div&gt; &lt;p&gt; Mauris mauris ante, blandit et, ultrices a, suscipit eget, quam. Integer ut neque. Vivamus nisi metus, molestie vel, gravida in, condimentum sit amet, nunc. Nam a nibh. Donec suscipit eros. Nam mi. Proin viverra leo ut odio. Curabitur malesuada. Vestibulum a velit eu ante scelerisque vulputate. &lt;/p&gt; &lt;/div&gt; &lt;h3&gt;Section 2&lt;/h3&gt; &lt;div&gt; &lt;p&gt; Sed non urna. Donec et ante. Phasellus eu ligula. Vestibulum sit amet purus. Vivamus hendrerit, dolor at aliquet laoreet, mauris turpis porttitor velit, faucibus interdum tellus libero ac justo. Vivamus non quam. In suscipit faucibus urna. &lt;/p&gt; &lt;/div&gt; &lt;h3&gt;Section 3&lt;/h3&gt; &lt;div&gt; &lt;p&gt; Nam enim risus, molestie et, porta ac, aliquam ac, risus. Quisque lobortis. Phasellus pellentesque purus in massa. Aenean in pede. Phasellus ac libero ac tellus pellentesque semper. Sed ac felis. Sed commodo, magna quis lacinia ornare, quam ante aliquam nisi, eu iaculis leo purus venenatis dui. &lt;/p&gt; &lt;ul&gt; &lt;li&gt;List item one&lt;/li&gt; &lt;li&gt;List item two&lt;/li&gt; &lt;li&gt;List item three&lt;/li&gt; &lt;/ul&gt; &lt;/div&gt; &lt;h3&gt;Section 4&lt;/h3&gt; &lt;div&gt; &lt;p&gt; Cras dictum. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Aenean lacinia mauris vel est. &lt;/p&gt; &lt;p&gt; Suspendisse eu nisl. Nullam ut libero. Integer dignissim consequat lectus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. &lt;/p&gt; &lt;/div&gt; &lt;/div&gt; &lt;/body&gt; </code></pre> <p></p> <p>And replace your static html with your PHP calls, you can use something like this:</p> <pre><code>&lt;? $pdo = new PDO('mysql:host=localhost; dbname=db01', $username, $password); $pdo-&gt;exec("SET CHARACTER SET utf8"); $sql= "select name,age,height,weight from infoTable" $result = $pdo-&gt;query($sql); foreach($result as $row) { $accordion .= ' &lt;h3&gt;'.$row['Name'].'&lt;/h3&gt; &lt;div&gt; &lt;p&gt; my age is ' .$row['Age']. ' my height is' .$row['Height']. ' &lt;/p&gt;&lt;/div&gt;'; } ?&gt; </code></pre> <p>Just make sure you put in the right place. Also, as a suggestion please note that Original MySQL API is deprecated , from the docs:</p> <blockquote> <p>This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information.</p> </blockquote>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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