php - I just can eliminate the last row from the database using checkboxes -


i have 1 html table rows value specific database table.

i created html table column eliminate specific row database, inside column exists checkbox check , eliminate multiple table rows database.

but i'm having problems, can delete last row, example: lets imagine check second row, , click @ submit button , nothing happens.

but if check last inserted row, , click submit, deletes row database.

i can delete last row, can't delete multiple rows checking specific number of checkboxes.

i did this:

example

i'm using mvc structure:

view:

<form method='post'> <?php echo "<td><input style='width: 50px;' class='delete' value='delete'  type='submit' name='del[]' /></td>";     foreach($editjoarray $key){         echo "     <table>     <tr>       <td> ".$key['id']."</td>        <td><input type='checkbox' name='delete[]' value=".$key['id']." /></td>     </tr>     </table>     </form>";      }

model:

function fname(){  if(isset($_post['del']) && !empty($_post['delete'])) { {     $checkbox = $_post['delete'];     $countcheck = count($_post['delete']);  for($i=0;$i<$countcheck;$i++) { $del_id = $checkbox[$i];  echo $del_id;   $sql = "delete mytable id=$del_id";    $exe = mysql_query($sql) or die(mysql_error()); } } }      printfunction(); }

you closing form tag inside loop there 1 delete checkbox (as post values). need move closing tag of form </form> outside loop checkboxes lies in same form.

<form method='post'> <?php foreach($editjoarray $key){        /*    delete checkboxes    input fields    */  } ?> </form>

Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more