php - Using ajax with mysql to validate before rendering -


i pretty new ajax might ask might simple of you.

i looking best way check user posting checkdata.php verily price in database.

i have long database works find need validation.

product

pid      name                  size     price   1        chocolate              12        30.00

i have form , in form posting pid name , size

in pdo statement doing this

select pid, price, name, size product pid=:pid , size=:size , name=:name

this works fine.

but want use ajax check user same whats in database , equal same price in database.

if not same should have alert message saying "don't mess code."

i have long table. sorry cant show code long

in table have name echo database

size dropdown list

and pid hidden input.

i have jquery

$(document).ready(function(){     $('#selected').hide();     $('#button').click(function(){         var pid = $('#pid').val();         var size = $('#size').val();         var qty = $('#qty').val();         var price = '\u00a3' + parseint($('#pricetag').text().replace(/^\d/, ''), 10) * qty;         var size = $('#size').val();         if (!/^[1-9]\d?$/.test(qty)){             alert('quantity should not below 1 or null');             return false; // don't continue         }          else {         $('#sprice').text(price);         $('#ssize').text(size);         $('#selected').slidedown();         }         $.ajax({             url: 'checkdata.php',             type: 'post',             data: { pid:pid, size:size, qty:qty},             success: function(data)             {              }         });     }); });  <?php session_start()  if(isset($_post['pid']) && isset($_post['size']) && isset($_post['qty']) && isset($_post['name'])){        $pid = $_post['pid'];     $size = $_post["size"];     $qty = $_post['qty'];     $name= $_post['name'];  . . .   somewhere in php tag have statement right price based on data getting posted    select pid, price, name, size product pid=:pid , size=:size , name=:name  ?>

summary how can use ajax check getting posted same on database before render page.

you shouldn't round-tripping prices through client anyways. it's 1 thing pull price , display user, should never accept price value user. fetch fresh copy database when comes time calculate costs.

if want "fix" price if item in shopping cart prolonged duration, , you're changing prices in database, keep price in user's session. that's purely server-side data structure, , can't meddled directly.

that'd let things "item price has changed since added cart. accept new updated price or remove cart?".


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more