envexlabs Posted July 16, 2007 Share Posted July 16, 2007 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.