Databases
StackOverflow2013
Postsdbo
POjQuery & PHP - Update current table view with the next records automatically when record(s) in existing view are deleted
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjQuery & PHP - Update current table view with the next records automatically when record(s) in existing view are deleted
    primarykey
    data
    text
    <p><strong>PLATFORM:</strong></p> <p>PHP, mySQL &amp; jQuery</p> <p><strong>WHAT I HAVE:</strong></p> <p>I have a Database table. Within my application, I am able to fetch all the rows. When I am querying the database, I have set the records fetch limit as 30, but that can be changed via a dropdown list. So consider that I am fetching upto 30 rows of data in a single query and displaying them. I am populating this data in table (rows). I have checkbox next to every record and a Delete button. When the Delete button is clicked, all the rows that are checked, will get deleted.</p> <p><strong>WHAT I AM TRYING TO DO:</strong></p> <p>For every row that I delete, I am trying to update the current view with the next set of rows, till the fetch row limit is met. Confusing? Here's an example:</p> <p><strong>EXAMPLE:</strong></p> <p>Consider that I 1000 rows in my table &amp; I have set the records fetch limit as 30, which means that upto 30 records will be shown at one time. I can use pagination to navigate to the other records. Now in my view, I have 30 rows of data in the table. I selected 5 rows and deleted them via jQuery. Upon deletion, I am able to remove the deleted rows from view. So in this case, since I deleted 5 rows, I am able to remove them and now my view shows me only 25 rows (which is correct). Since there are 995 rows remaining still in my table and as I have a record fetch limit of 30, now I want this to work in such a way that I show the next 5 records automatically. I want the existing entries to move up and the new entries to populate at the bottom. </p> <p>In other words, as long as sufficient rows exist, I want to populate my view with the same number of records, as many were deleted. So if I delete 10 records, I want the next 10 records to be fetched and displayed automatically again making it a total count of 30 rows of data, that are displayed. If 20 records are deleted, then I want next 20 records to be fetched and displayed automatically( again making it a total count of 30 rows of data, that are displayed). I want to do this with an effect attached to it, so that i can visually note that new rows has appeared. Maybe a slideup or fadein+slideup effect can be applied? Hope I make sense.</p> <p><strong>WHAT I NEED:</strong></p> <p>I need the <strong>PHP &amp; jQuery code</strong> to be able to achieve the above effect/functionality. Thanks in advance.</p> <p>Here's a bit of my <strong>jQuery code</strong> (if that helps):</p> <pre><code>$('#button_delete').click(function() { $.ajax({ type: 'POST', cache: false, url: 'test.php', data: $('#form1').serialize(), dataType: 'json', success: function(data) { if(data.success === 1) { $.each(data.id, function (index, value) { $('#'+value).remove(); }); jQuery.each(data.new_rows_data, function(i, val) { jQuery.each(val, function(i, new_val) { $('#table').append('&lt;tr id='+new_val+'&gt;'+ '&lt;td&gt;&lt;/td&gt;'+ '&lt;td&gt;&lt;/td&gt;'+ '&lt;td&gt;'+new_val+'&lt;/td&gt;'+ '&lt;/tr&gt;'); }); }); } } }) return false; }); </code></pre> <p><strong>PHP code:</strong></p> <pre><code>&lt;?php $from = 0; $limit = 30; $result = mysql_query( "SELECT * FROM mytable ORDER BY m_id ASC LIMIT $from, $limit" ); ?&gt; &lt;table&gt; &lt;tr&gt; &lt;td&gt;ID&lt;/td&gt; &lt;td&gt;Content&lt;/td&gt; &lt;/tr&gt; &lt;?php while( $rows = mysql_fetch_array($result) ) { ?&gt; &lt;tr id=&lt;?php echo $rows['m_id']; ?&gt;&gt; &lt;td&gt;&lt;?php echo $rows['m_id']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $rows['content']; ?&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php } ?&gt; &lt;/table&gt; </code></pre> <p><strong>test.php</strong></p> <pre><code>//test.php &lt;?php $id = $_POST['id']; if( is_array( $id ) ) { $arr_size = sizeof( $id ); foreach ( $id as $value ) { $sql = "DELETE FROM mytable WHERE id = ".(int)$value." LIMIT 1"; $result = mysql_query($sql); } if( $result ) { $success = 1; $message = 'Deleted'; } else { $success = 0; $message = 'Unable to DELETE FROM DB.'; } } $last_id = 500; for($i=1; $i &lt;= $arr_size; $i++) { $new_value = ($last_id + $i); $new_rows[] .= $new_value; $res = mysql_query("SELECT id, message, date FROM mytable WHERE id = ".(int)$new_value." "); //LIMIT 1 $row = mysql_fetch_array($res); $new_rows_data['row']['id'] .= $row['id']; $new_rows_data['row']['message'] .= $row['message']; $new_rows_data['row']['date'] .= $row['date']; } print json_encode(array('success' =&gt; $success, 'message' =&gt; $message, 'id' =&gt; $id, 'new_rows' =&gt; $new_rows, 'new_rows_data' =&gt; $new_rows_data)); ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDevner
    1. USDevner
    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. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

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