php - IDs in MySQL, standard IDs or alphanumerics? -

-

i'm thinking of this, if make web site specific university's students should make id standard ids on mysql (integer, auto increment) or should give ids how email address is, if student's email address e12234@university.edu his/her id e12234 (on web site). ok, performance?

edit: also, there such email addresses: n13345@university.edu (exchange student) jennajameson@university.edu (this professor)

i recommend separate, independent value id (integer, auto increment). id values should never change, never updated. people change emails time, corporations reissue same email address new users sometimes.


Comments

Post a Comment

Popular posts from this blog

C#: Application without a window or taskbar item (background app) that can still use Console.WriteLine() -

-
i'm trying create application adheres following: no taskbar no console or form window can utilize console.writeline() . (i.e. if executes app command prompt write console.) the problem if create windows form (or wpf) application can have there no taskbar, console or window show up, console.writeline() nothing. if create console app, writes console, can't figure out how hide (and if did hide it, write command prompt window?)... how do this? just create standard console application. callers responsibility hide window caused program (from how run c# console application console hidden ): system.diagnostics.processstartinfo start = new system.diagnostics.processstartinfo(); start.filename = dir + @"\myprocesstostart.exe"; start.windowstyle = system.diagnostics.processwindowstyle.hidden;
Read more

c# - Making TableLayoutPanel Act Like An HTML Table (Cells That Resize Automatically Around Text) -

-
i'm trying build tablelayoutpanel on winform , want behave plain old html table. one requirement table needs built programmatically. have far: foreach (var rowlinq in resultlinq) { richtextbox rt = new richtextbox(); rt.borderstyle = borderstyle.none; rt.text = rowlinq.result.resultname; rt.dock = dockstyle.fill; tablelayoutpanel.rowcount++; tablelayoutpanel.rowstyles.add(new rowstyle(system.windows.forms.sizetype.autosize)); tablelayoutpanel.controls.add(rt1, 0, tablelayoutpanel5.rowcount - 1); } so builds row each row in linq result. works pretty except 1 thing: height doesn't adjust @ , fixed. need height grow , shrink depending on height of text inside each cell. i need 1 big time, stack-o set autosize property true.
Read more