nest 3rd generation serial number

A product was developed yesterday and requires that a registration code serial number be generated by the general background of the website, which is then generated in the format of 573-225-374-118 and is unique in the database, next I will record all the information I found and I wrote myself. The principle is to generate mt... A product was developed yesterday and requires that a registration code/

Copy codeThe Code is as follows:/*** Serial number generator*/Function snMaker ($ pre = ''){$ Date = date ('ymmd ');$ Rand = rand );$ Time = mb_substr (time (), 5, 5, 'utf-8 ');$ SerialNumber = $ pre. $ date. $ time. $ rand;// Echo strlen ($ serialNumber). 'Return $ serialNumber;}Echo snMaker ();/*** Replace a part of a string with a specific character.* @ Param str or int $ str string to be processed* @ Pa

/// /// /// Public static class databasegenerator { /// /// /// Private Static int64 seed = int64.parse (datetime. utcnow. Subtract (New datetime (1970, 1, 1). totalmilliseconds. tostring ("0 ")); /// ////// /// Public static int64 getprimarykey (){Return interlocked. increment (ref seed );}} Recently, I want to use the serial number function. Most of the existing online id

Bank Transfer stored procedures Use [bankinfor] go set ANSI_NULLS on Go Set QUOTED_IDENTIFIER on Go ALTER PROCEDURE [dbo].[ Transfer] (@inAccount int, @outAccount int, @amount float) as declare @totalDeposit float; The Begin Select @totalDeposit =total from the account where accountnum= @outAccount; If @totalDeposit is null begin rollback; print ' Turn out the account does not exist or there is no deposit in the account ' return ; End If @totalDeposit Stream

Bank Transfer stored procedure use [Bankinfor]goset ansi_nulls ongoset quoted_identifier ongoalter PROCEDURE [dbo]. [Transfer] (@inAccount int, @outAccount int, @amount float) as declare @totalDeposit float; begin select @totalDeposit =total from account where [emailprotected]; if @totalDeposit is null nbsp;begin rollback; print ' transfer out of account does not exist or no deposit in account ' return; end if @totalDeposit Bank transfer stored procedures and

I'm glad to have two functions that are useful to you. The first one is used to generate the serial number. The second one is used to encrypt some strings. modify it a little bit, you can find the effect of some hidden characters such as itb ********* @ gmail.com that we often see when retrieving the password. The code is as follows: /** * Serial

Use the function to generate id-bit auto-increment sequence number rules for custom Oracleselectid, Q | to_char (sysdate, yymmdd) | substr (00000,0, 5-length (id )) | idfromsys_admintorderbyid; Use the function to generate id-bit auto-increment sequence number rules for custom Oracle select id, 'q' | to_char (sysdate, 'yymmdd') | substr ('123 ', 0,5-length (id) | id from sys_admin t order by id; Generate

Copy codeThe Code is as follows :/** * Serial number generator */ Function snMaker ($ pre = ''){ $ Date = date ('ymmd '); $ Rand = rand ); $ Time = mb_substr (time (), 5, 5, 'utf-8 '); $ SerialNumber = $ pre. $ date. $ time. $ rand; // Echo strlen ($ serialNumber). 'Return $ serialNumber; } Echo snMaker (); /** * Replace a part of a string with a specific character. * @ Param str or int $ str s

Copy Code code as follows: /** * Serial Number generator */ function Snmaker ($pre = ' ") { $date = Date (' Ymd '); $rand = rand (1000000,9999999); $time = Mb_substr (Time (), 5, 5, ' utf-8 '); $serialNumber = $pre. $date. $time. $rand; echo strlen ($serialNumber). ' return $serialNumber; } Echo Snmaker (); /** * Replace part of a string with a specific character * @param str or int $str s