how to create a unique id in jquery?

Question

0.00/5 (No votes)

See more:

i need to generate a unique customer id of the form c_123,c_124 and so on..

this value should be inserted in a textbox on clicking a button..
the id value should be stored in database using phpmysql to.

the table name is 'self_ticket_rising' and coulmn name is 'cust_id'

button id='click'
textbox id='cust_ids'

Posted 27-Aug-15 20:01pm

Member 11941750

Add a Solution

Comments

Herman<T>.Instance 28-Aug-15 4:44am

What have you tried?

Member 11941750 28-Aug-15 6:20am

i have no clue where to start. .

what i think of is that

i need to fetch last customer_id that is already present in the table and increment the value by one and check if the value is already present in database.if it is not present in the table of the corresponding database ,then store it .

thing is all this process should happen when a generate id button is clicked and the corresponding value should be popped in textbox

but then i dnt know how to code using phpmysql. . and fectch it back using json in javascript

Mohibur Rashid 28-Aug-15 4:45am

What is your attempt or thought?
Where is your problem?
Generating the ID or setting the id to the box? or what?

Member 11941750 28-Aug-15 6:13am

all i need is to generete a new id when i click a 'generate new id' button and then store newly generated id to the database

Member 11941750 28-Aug-15 6:20am

i have no clue where to start. .

what i think of is that

i need to fetch last customer_id that is already present in the table and increment the value by one and check if the value is already present in database.if it is not present in the table of the corresponding database ,then store it .

thing is all this process should happen when a generate id button is clicked and the corresponding value should be popped in textbox

but then i dnt know how to code using phpmysql. . and fectch it back using json in javascript

Peter Leow 28-Aug-15 6:54am

You are making unnecessary round trips for wrong approach. In a multi-user environment, your so called "last" customer_id is likely to be possessed by more than one user at any one time. Instead use an auto-increment primary key column which will guarantee that the value is unique.

Member 11941750 28-Aug-15 7:00am

i agree.but my cust_id should be of the form ex:"c_123" of this form
how do i auto increment to post ths sort of value

Peter Leow 28-Aug-15 7:21am

See improved solution 1.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Accepted Answer · 2015-08-27T23:29:00

Add an auto-increment primary key, say id, to the table, then create the customer_id column as a Generated Column[^] the value of which derives from concatenating[^] the 'c_' with the primary key value.
+++++++++[Edit]+++++++++
Ok, try this.
1. Create a new table, say 'dummy', with only one auto-increment primary key column called id.
2. Every time you need a new customer id upon clicking a button, insert a null value to this table like this:

insert into dummy set id=null

or

insert into dummy values (null)

3. step 2 will generate a new unique id, retrieve this id using PHP mysqli_insert_id() Function[^] and concatenate it with other prefix, say 'c_', to get a unique customer id.
In this way, you are certain that no two users get the same customer id.