Jump to content

AJAX mysql creating duplicate tables


envexlabs

Recommended Posts

Hey,

 

Here is ajax.js:

 

   var http_request = false;
   function makePOSTRequest(url, parameters) {
      http_request = false;
      if (window.XMLHttpRequest) { // Mozilla, Safari,...
         http_request = new XMLHttpRequest();
         if (http_request.overrideMimeType) {
         	// set type accordingly to anticipated content type
            //http_request.overrideMimeType('text/xml');
            http_request.overrideMimeType('text/html');
         }
      } else if (window.ActiveXObject) { // IE
         try {
            http_request = new ActiveXObject("Msxml2.XMLHTTP");
         } catch (e) {
            try {
               http_request = new ActiveXObject("Microsoft.XMLHTTP");
            } catch (e) {}
         }
      }
      if (!http_request) {
         alert('Cannot create XMLHTTP instance');
         return false;
      }
      
      http_request.onreadystatechange = alertContents;
      http_request.open('POST', url, true);
      http_request.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
      http_request.setRequestHeader("Content-length", parameters.length);
      http_request.setRequestHeader("Connection", "close");
      http_request.send(parameters);
      slide_product();
   }

   function alertContents() {
      if (http_request.readyState == 4) {
         if (http_request.status == 200) {
            //alert(http_request.responseText);
            result = http_request.responseText;
            document.getElementById('store_contents').innerHTML = result;            
         } else {
            alert('There was a problem with the request.');
         }
      }
   }
   
   function get(obj) {
      var poststr = "pname=" + encodeURI( document.getElementById("pname").value ) +
                    "&price=" + encodeURI( document.getElementById("price").value ) +
                    "&desc=" + encodeURI( document.getElementById("desc").value ) +
                    "&store_id=" + encodeURI( document.getElementById("store_id").value );
      makePOSTRequest('add_product.php', poststr);
   }

 

Here is add_product.php:

 

    $store_id = $_POST[store_id];
    $pname = $_POST[pname];
    $price = $_POST[price];
    $desc = $_POST[desc];
    
    $add_product_query = mysql_query("INSERT INTO `products` (`product_id`, `store_id`, `name`, `price`, `sale_price`, `pic`, `description`, `display`, `on_sale`) VALUES (NULL, '$store_id', '$pname', '$price', '0', 'store_tmb_test', '$desc', '1', '0')") or die(mysql_error());

 

For some reason it's creating duplicate table entries and i can't seem to figure out why.

 

Anyone?

Link to comment
https://forums.phpfreaks.com/topic/60264-ajax-mysql-creating-duplicate-tables/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.