Category: General

03 Aug 2016 04:08

Joined:	13/08/2015
Level:	Silver
Points:	102

Points:	2

How To Generate and Save Auto Increment UserId with Prefix using Php Mysql

Hi Developers,

I need to generate unique auto increment user id with Prefix in Php
and also save it to the database.
]My required Output is like EMP001,EMP002,EMP001.......................... to EMP00n n numbers
This is the first step in my project
i don't know php is well.

so please help me to generate unique id using php code and also save it into the database.

Thanks with
Paul.S

#767454

03 Aug 2016 04:16

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	2

If the prefix "EMP" is constant, you can simple concatenate "EMP" with auto generate user id.
I am not familiar with PHP. Is it very complex in PHP?.

If you are nor familiar with PHP do not directly jump into the project. First read some good tutorials then start your project.

By Nathan
Direction is important than speed

#767455

03 Aug 2016 04:21

Joined:	13/08/2015
Level:	Silver
Points:	102

Points:	1

Ok nathan thanks for your quick reply

Paul.S

#767485

07 Aug 2016 22:59

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	4

Hi,

You can do this in 2 ways, one is AutoIncrement the field while creating table itself and another one is increment the field value while insert the record.

1)


CREATE TABLE [dbo].[Employee](
  [ID] [int] IDENTITY(1,1) NOT NULL,
  [EmpNo]  AS ([PreFix]+ RIGHT('0000000' + CAST(Id AS VARCHAR(7)), 7)) PERSISTED,
  CONSTRAINT [PK_AutoInc] PRIMARY KEY ([ID] ASC)
)

2)


DECLARE @EmpNo VARCHAR(25);
SELECT @EmpNo = @PreFix + RIGHT('0000000' + CAST(@Id AS VARCHAR(7)), 7)
--use the above EmpNo while insert it into database

Hope this will helpful to you...

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

How To Generate and Save Auto Increment UserId with Prefix using Php Mysql

About dotnetspider.com

Quick Links

General

Services