mysql - PHP Best Practice to Update one record and delete another record -

-

i have 2 tables ( voucher , voucherbalance ). intention first check whether if voucher exist(assuming voucher exists), it'll deleted table , update record in table.

following approach im doing.

$vouchercode=$_request['vouchercode']; $userid=$_request['userid'];  $vouchervalue = $link->query("select vouchervalue voucher vouchercode='$vouchercode';"); $link->query("delete voucher vouchercode='$vouchercode';"); $result = $link->query("update uservoucherbalance set voucherbalance=voucherbalance+'$intvouchervalue' userid='$userid';");

i ask there better approaches ? best practice ?


Comments

Post a Comment

Popular posts from this blog

javascript - IndexedDB error: Uncaught DataCloneError: Failed to execute 'put' on 'IDBObjectStore': An object could not be cloned -

-
i using google maps api along html 5 geolocation api display position marker on map. once marker displayed have simple on marker double click function saves new marker current position using indexeddb. goes until object stored, recieve message " uncaught datacloneerror: failed execute 'put' on 'idbobjectstore': object not cloned. " in console. code follows: function initialize() { var mapproperties = { // set maps properties center:new google.maps.latlng(55.8580,-4.2590), zoom:8, maptypeid:google.maps.maptypeid.roadmap }; var map=new google.maps.map(document.getelementbyid("map-overview"),mapproperties); //display map in map-overview div function nogeolocation(e) { //a function handle users not have geolocation if (e) { var content = 'error: unfortunately geolocation service failed.'; } else { ...
Read more

amazon web services - When using Cognito credentials with AWS in a browser (javascript), keep getting "missing credentials" error -

-
Image
i'm attempting upload file s3 bucket of mine web browser using aws' javascript sdk. code looks this: aws.config.credentials = new aws.cognitoidentitycredentials({ accountid: 'dfhgdh', identitypoolid: 'fdagsd', rolearn: 'fdafds' }); var bucket = new aws.s3({params: {bucket: 'test-bucket'}}); var pdfupload = document.getelementbyid('pdf-uploads').files[0]; var params = {key: pdfupload.name, contenttype: pdfupload.type, body: pdfupload}; bucket.putobject(params, function (error, data) { if (error) { console.log(error); } else { console.log(data); } }); however, whenever reaches putobject command, keep getting error aws: "error: missing credentials in config {message: "missing credentials in config", code: "credentialserror"..." i'm sure i'm missing simple , stupid here, can't figure out life of me. (i different error when try hardcode bogus secret...
Read more

c# - How to set the datatextfield value instead of the value on a drop down list? -

-
i have list of countries, returns id , name. have string. drop down sets value id, @ point don't have id's. want able set selectedvalue text field. there way this? or there way compare string against list work out id? string country = "australia"; ddlcountry.datasource = listofcountries; ddlcountry.datatextfield = "value"; ddlcountry.datavaluefield = "key"; ddlcountry.databind(); ddlcounty.selectedvalue = ??? thanks ddlcountry.items.findbytext(country).selected = true
Read more