Search jQuery

jQuery Forum

Screen name:
mackie2

mackie2's Profile

1 Posts

16 Responses

0 Followers

Activity Trend

Last 30 days

Loading Chart...

Show:

Expanded view
List view

jqm li delete with ajax/php/mysql
[24Replies]
- 01-Jul-2012 08:00 AM
- Forum: jQuery Mobile
Hi all,
I have a listview populated with list items from mysql.
I have data-icon delete in each list view.
I can remove single list items with remove and refresh but when I try to use ajax to delete from mysql and refresh my listview, all I get is an undefined index: id in my delete.php page.
Here is some of my code:
1. <li id = <?php echo "$row[0]"?> data-icon="delete"><a href="delete.php" data-ajax="false">
2. <?php echo "$row[1]"?>
3. <?php echo "$newmine[0]"?>
4. <?php echo "$newmine[1]"?>
5. <?php echo "$newmine[2]"?>
6. <?php echo "$newmine[3]"?>
7. <?php echo "$newmine[4]"?>
8. <?php echo "$newmine[5]"?>
9. <?php echo "$newmine[6]"?>
10. </a>
11. </li>
That part shows the list items as a link with an X to the right. Here is what my ajax part looks like:
1. <script type= "text/javascript>
2. $('#showtickets').on (pageinit', function(event) { //showtickets is page id
3. //$('li.a').on('click', function() {
4. $('li').find('a').on('click', function() { // find anchors with a list list item parent
5. var li = $(this).parent();
6. //var id = $(this).attr('id');
7. var id = li.attr('id');
8. $.ajax ( {
9. type: "post",
10. url: "delete.php,
11. data: 'id='+ id,
12. success: function() {
13. $(this).remove(); // These next couple of lines on their own delete a clicked list item but of
14. // course only onscreen
15. $('st').listview (refresh); //st is unordered list id
16. }
17. });
18. return false;
19. });
20. });
Finally delete.php:
1. $id=$_POST['id'];
2. require ("my connection script here");
3. $query ="DELETE FROM picks WHERE pid = '" . $id . "'";
4. $result = mysqli_query($mylnk, $query);
I need a liitle guidance as my head is about to explode from spending days re-loading pages after reading yet another article without success.
Thanks

«Prev
Next »

Response title

Attachments

jQuery Forum

Activity Trend