Question

144

How to update a mysql database without reloading page

rated 0 times [ 151] [ 7] / answers: 1 / hits: 22117 / 14 Years ago, thu, september 2, 2010, 12:00:00

thanks for looking.
I have a very long list of items, users click on an image (a plus sign) to add the item to their personal list. At the moment when they click the + it loads a add-item.php?itemid=* which processes the below code then redirects them to their own list, I did have it redirecting back to the global list but then it was unclear to the user if the item was added to their list. how would I go about making it all update the database without going anywhere, im thinking javascript but have never written any. Any help would be brilliant!! :)

<?php 

ini_set('display_errors', 'On');

error_reporting(E_ALL);



 $bucketlist=MYSQL_QUERY( SELECT * FROM membersbuckets where userid = $userid AND bucketid = $bucketid)

 or die(mysql_error());  



          $bucketlist=mysql_fetch_array( $bucketlist ) ;



            if($bucketlist < 1) {



            mysql_query(INSERT INTO membersbuckets (memberbucketid, userid, bucketid, complete)

            VALUES ('', '$userid', '$bucketid', '0'));

            echo Adding item to your bucketlist...;

            echo <meta http-equiv='Refresh' content='2; URL=mybucketlist.php'/>;

            }

            else {

            echo This item is already on your list, redirecting you to your list;

            echo <meta http-equiv='Refresh' content='2; URL=mybucketlist.php'/>;

            }

?>

Thank you in advance! :)

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

tayaw

Add To Favorites

Follow

Total Points: 749

Total Questions: 88

Total Answers: 86

Location: Djibouti

Member since Sun, Feb 27, 2022

2 Years ago

tayaw questions

1 How to enable cache for getServerSideProps?

Thu, Mar 3, 22, 00:00, 2 Years ago

1 navigator.clipboard.readText() is not working in Firefox

Fri, May 7, 21, 00:00, 3 Years ago

1 Vuetify form .$refs validate is not a function

Wed, Oct 7, 20, 00:00, 4 Years ago

1 Using absolute position to place image above another image using Tailwind CSS

Sun, Sep 6, 20, 00:00, 4 Years ago

1 How to make div tag clickable with Link from react-router-dom?

Wed, Jun 17, 20, 00:00, 4 Years ago

View All

answered 14 Years ago yosefleod · Accepted Answer

You need AJAX, as everyone has said.

Since you have never written any javascript, here is a guide for you.

Instead of your

<a href=add-item.php?itemid='.$itemId.' > Add Item </a>

Write

<a onclick=addItemToUsersList('.$itemId.') > Add </a>

For AJAX, use jquery as Angelo has suggested. Download it and add the following

<script type=text/javascript src=http://path/to/jquery-latest.min.js></script>

<script type=text/javasript>

function addItemToUsersList(itemId)

{

  $.ajax({

    'url': 'path/to/add-item.php', 

    'type': 'GET',

    'dataType': 'json', 

    'data': {itemid: itemId}, 

    'success': function(data) 

    {

      if(data.status)

      {

        if(data.added)

        {

          $(span#success+itemId).attr(innerHTML,Item added to your personal list);

        }

        else

        {

          $(span#success+itemId).attr(innerHTML,This item is already on your list);

        }

      }

    },

    'beforeSend': function() 

    {

      $(span#success+itemId).attr(innerHTML,Adding item to your bucketlist...);

    },

    'error': function(data) 

    {

      // this is what happens if the request fails.

      $(span#success+itemId).attr(innerHTML,An error occureed);

    }

  });

}

</script>

And then finally, in your path/to/add-item.php file write the code to add the items. The parameter itemId will be available here as $_GET['itemId']. Just return proper status values using json_encode.

if($bucketlist < 1) 

{

  mysql_query(INSERT INTO membersbuckets (memberbucketid, userid, bucketid, complete) VALUES ('', '$userid', '$_GET['itemId]', '0'));

  return json_encode(array(status => true, added => true));

}

else

{

  return json_encode(array(status => true, added => false));

}