php - Query using MAX -


i have multiple user accounts , each of them running incremental set of integer own transactions.

so, everytime user open transaction, query last max digit within transaction , plus 1.

but, found result returning maximum id user transaction. supposedly user has last id = 5402, , user z has last id = 19201. sometimes, user gets 19202 instead of 5403.

this query:

select max(cast(id unsigned)) max_id `transaction` `user_id` = 'a'

the transaction table like: id int pk user_id int ... etc

this web application , multiple users connect simultaneously , i'm using mysql database, , php programming language.

i'm using ci, here code use obtain max id

function get_max($table, $max_col, $col_id = null, $id = null) {     if (!empty($col_id) && !empty($id)) {         $this->db->where($col_id, $id);     }     $this->db->select("max(cast($max_col unsigned)) max_$max_col");     $query = $this->db->get($table);      if ($query->num_rows() > 0) {         return intval($query->row_array()["max_$max_col"]);     }     return 0; }

once obtained id, insert below:

$new_data['id'] = $this->model_share->get_max('transaction', 'id', 'user_id', $user_id) + 1; $new_data['user_id'] = $user_id;  $this->model_share->insert('transaction', $new_data); // save data

and detail of insert function

function insert($table, $data) {     $this->db->insert($table, $data);      $id = $this->db->insert_id();     if ($id <= 0)         return $this->db->affected_rows() > 0;     else return $id; }

codeigniter has query function max value column database table,$this->db->select_max()

$this->db->select_max('your_column'); $query = $this->db->get('table');

and database transaction add before when start query , end @ last query.

$this->db->trans_start(); $this->db->query('an sql query...'); $this->db->query('another query...'); $this->db->query('and yet query...'); $this->db->trans_complete();

note: database transaction useful when use when doing many database related query inserting , updating before it.

here reference link

edit:

you have syntax error in lines because of max_$max_col this.

//error line1  $this->db->select("max(cast($max_col unsigned)) max_$max_col");  //error line 2  return intval($query->row_array()["max_$max_col"]);

Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj...
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer ...
Read more

c# - Asp.net web api : redirect unauthorized requst to forbidden page -

im trying redirect unauthorized request forbidden page instead i'm getting forbidden page in response body , how can fix ? here's startup class : app.createperowincontext(storecontext.create); app.createperowincontext<applicationusermanager>(applicationusermanager.create); app.createperowincontext<applicationsigninmanager>(applicationsigninmanager.create); app.usecookieauthentication(new cookieauthenticationoptions { authenticationtype = defaultauthenticationtypes.applicationcookie, expiretimespan = timespan.fromdays(30), }); app.useexternalsignincookie(defaultauthenticationtypes.externalcookie); app.usetwofactorsignincookie(defaultauthenticationtypes.twofactorcookie, timespan.fromminutes(5)); app.usetwofactorrememberbrowsercookie(defaultauthenticationtypes.twofactorrememberbrowsercookie); the method im trying reach : [httpget] [authorize(roles = "admin")] public string getcurrentusername() { return userman...
Read more