🔒 Closed Tulong techies

[--psy]

Sir paano po ba gawing unique yung mga idno's? Unique key combination which is composed of random numbers and/or letters usually separated by a dash just like activation keys. I mean yun bang kahit ilan pa ang nakaregister sa database hindi po agad mauubos. Need ko lang kasi sa SIS (Student Information System) ko pangpractice lang naman since di pa ako magaling sa programming. Thanks sa tutulong.

 

[Jmrie_]

Hintay ka lang bess

 

[Maviz]

Baka naman po naka connect po sa forum o anything sites kaya ganun

Hmmm. Ginawa namin to Last Year haha.

 

[--psy]

PHC-Decrypt yung alin paps?

 

[Jmrie_]

Baka naman po naka connect po sa forum o anything sites kaya ganun

Hmmm. Ginawa namin to Last Year haha.

Anu daww yun boss

 

[Maviz]

Yang mismong SIS ginawa nanamin yan last year.

 

[Jmrie_]

Yang mismong SIS ginawa nanamin yan last year.

Pwede mo ba siyang tulongan boss?

 

[--psy]

PHC-Decrypt paps baka pwedeng mong ishare sakin kung paano ko ba masosolve problem ko about idno's. Yoko din namang humingi ng source code kasi ayokong maging spoodfeed masyado. For self study ko na din kasi pag gawa neto so malaking tulong sakin to para madagdagan learnings ko about programming.

 

[Jmrie_]

Boss turuan mo po siya

 

[Maviz]

Pa pm sskin yung screenshot ng base at source code mo paps. Pm ah.

 

[Jmrie_]

Pa pm sskin yung screenshot ng base at source code mo paps. Pm ah.

Salamat boss help mo po siya

 

[Jmrie_]

--psy tutulongan kana

 

[Frostbane]

Nakita ko lang din to sa stackoverflow

INSERT INTO vehicles VALUES (blah); -- leaving out the number plate
SELECT @lid:=LAST_INSERT_ID();
UPDATE vehicles SET numberplate=concat(
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(lid)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(seed)*36+1, 1)
)
WHERE id=@lid;

 

[Jmrie_]

Nakita ko lang din to sa stackoverflow

INSERT INTO vehicles VALUES (blah); -- leaving out the number plate
SELECT @lid:=LAST_INSERT_ID();
UPDATE vehicles SET numberplate=concat(
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(lid)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(seed)*4294967296))*36+1, 1),
substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(seed)*36+1, 1)
)
WHERE id=@lid;

Salamat sa tulong mo

 

[Maviz]

Wait natin response niya idol

 

[Jmrie_]

Wait natin response niya idol

Sorry po boss wait mo lang

 

[Maviz]

Bat parang kulang yung offset niya. OK na pero parang kulang.

 

[Jmrie_]

Bat parang kulang yung offset niya. OK na pero parang kulang.

Kaganino? Po???

 

[Maviz]

Yung comment no idol bensho

 

[Jmrie_]

Yung comment no idol bensho

Sleep ka muna boss mukhang tulog na siya