Best Approach to Generate Unique Order Number with concurent inserts in Sales Application - Mysql/PHP -

-

we have sales application generating unique order number adding increment in previous value. since using unique combination based on orderid , store id, can not use auto increment. sometime getting duplicate order ids if request submitted multiple client devices.

can please advise better way handle order id generation based on order id , store id? using php scripting language.

this have of now.

// table structure  salesorders (order_id, store_id)  $generatenextorderid = "select max(order_id) + 1 salesorders store_id = 1";

any suggestions?


Comments

Post a Comment

Popular posts from this blog

javascript - Feed FileReader from server side files -

-
i´m starting customize/improve old audio editor project. can import audio tracks canvas via drag&drop computer. thing use audio tracks stored in server clicking on list of available tracks... instead of use <input type="file"> tags. how can read server side files filereader?ajax perhaps? in advance. this code file reader: player.prototype.loadfile = function(file, el) { //console.log(file); var reader = new filereader, filetypes = ['audio/mpeg', 'audio/mp3', 'audio/wave', 'audio/wav'], = this; if (filetypes.indexof(file.type) < 0) { throw('unsupported file format!'); } reader.onloadend = function(e) { if (e.target.readystate == filereader.done) { // done == 2 $('.progress').children().width('100%'); var onsuccess = function(audiobuffer) { $(el).trigger('audiee:fileloaded', [audiobuffer, file]); ...
Read more

c++ - What's the differece between of link to a dynamic file and as a input object? -

-
i use g++ link project (an executable mono_kitti) , project dependent on thirdparty library pangolin. when link action -lpangolin option: g++ -l../../lib -lorb_slam2 -lpangolin mono_kitti.o -o mono_kitti it returns: mono_kitti.o:(.data+0x0): undefined reference `vtable pangolin::handler' mono_kitti.o:(.data+0x8): undefined reference `vtable pangolin::handlerscroll' mono_kitti.o: in function `pangolin::handler::~handler()': mono_kitti.cc:(.text._zn8pangolin7handlerd2ev[_zn8pangolin7handlerd5ev]+0x13): undefined reference `vtable pangolin::handler' mono_kitti.o: in function `pangolin::handlerscroll::~handlerscroll()': mono_kitti.cc:(.text._zn8pangolin13handlerscrolld2ev[_zn8pangolin13handlerscrolld5ev]+0x13): undefined reference `vtable pangolin::handlerscroll' collect2: error: ld returned 1 exit status but when use command: g++ -l../../lib -lorb_slam2 mono_kitti.o /usr/local/lib/libpangolin.so -o mono_kitti it succeeded. but failed again when tr...
Read more

How to pass json object using PHP in Wepay API -

-
i have integrated wepay payment gateway . have facing problem pass json object wepay . shows incorrect json format. please @ below code. $forca_a = array( 'debit_opt_in'=>true ); $forca = json_encode($forca_a,json_force_object); $wepay_create_array = array( 'name' =>"xxxx", 'description' => "xxxxxxxxx xxxx", 'callback_uri' => "xxxxxxx", 'country' => "ca", 'currencies' => array('cad'), 'country_options' => $forca, 'rbits'=> array( array( 'receive_time'=>strtotime("now"), 'type' =>'website_uri', 'source' => 'partner_database', 'properties'=> array('uri'=>xxxxx) ) ) ); if won't pass country_options , seems working if pass parameter, giv...
Read more