Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Personally, if I knew I wouldn't ever really have more than 5 pages or so, I would forgo the Ajax thing altogether... Not that I don't like it... I just don't think its necessary in this case.</p> <pre><code>&lt;?php // Example Database result (say, 2 "pages" worth)... // We'll pretend the cells in your database match the textarea names... $results = array( [0] =&gt; array( 'textbox1'=&gt;'abc', 'textbox2'=&gt;'def', 'textbox3'=&gt;'ghi', 'textbox4'=&gt;'jkl', 'textbox5'=&gt;'mno', 'textbox6'=&gt;'pqr' 'textbox6'=&gt;'stu' 'textbox6'=&gt;'vwx' ), [1] =&gt; array( 'textbox1'=&gt;'cba', 'textbox2'=&gt;'fed', 'textbox3'=&gt;'ihg', 'textbox4'=&gt;'lkj', 'textbox5'=&gt;'onm', 'textbox6'=&gt;'rqp' 'textbox6'=&gt;'uts' 'textbox6'=&gt;'xwv' ) ) $json_results = json_encode($results); ?&gt; &lt;!-- Generate some jQuery and HTML --&gt; &lt;script language="javascript"&gt; var pages = eval('&lt;?=$json_results;?&gt;'); $(function() { $('.page_num').live('click',function() { var page = $(this).attr('rel'); if(pages[page] &amp;&amp; pages[page].length &gt; 0) { $.each(pages[page],function(key,value) { // assuming your key names are the same as the // names of your textareas $('textarea[name="'+key+'"]').value(value); }); } else { alert("Oops, that page doesn't exist for some reason..."); } }); }); &lt;/script&gt; &lt;?php foreach($results[0] as $key=&gt;$value): ?&gt; &lt;textarea name="&lt;?=$key?&gt;"&gt;&lt;?=$value;?&gt;&lt;/textarea&gt; &lt;?php endforeach; ?&gt; &lt;div id="page_nums"&gt; &lt;?php for($i=1;$i&lt;=sizeof($results)-1;$i++): ?&gt; &lt;a class="page_num" href="#" rel="&lt;?=$i;?&gt;"&gt;&lt;?=$i;?&gt;&lt;/a&gt; &lt;?php endfor; ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POpaging through database results using jquery
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USKyleFarris
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COHi Kyle. Thank you very much for your response. I'm sorry I haven't had a chance to thank you sooner but I got swamped. I will try this suggestion out and let you know how it works out.
      singulars
      1. PO
      1. USuser109162
    2. COHey Kyle, I am messing around with your example. Firstly, thanks for the code example. Since I have virtually no JQ experience what so ever, I'd like to make sure I'm understanding the code you've posted before I start investing a lot of time into it only to find out that it wouldn't do what I need it to. To me, the php array you have there.. Can you tell me exactly how this is supposed to work? I mean, I have a single html page with 8 textboxes. Each textbox has a different id. In your php array.. which is the id? The key or the value in the array?
      singulars
      1. PO
      1. USuser109162
    3. COWhat I need to do is to page through the different records. A single record fills all 8 textboxes. The user can then click the pageination link to go to the next record. The html textboxes shouldn't dynamically be added, only the data imported into the textboxes. Is this the way this code is supposed to work?
      singulars
      1. PO
      1. USuser109162
 

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