PHP-and-MySQL/C4/User-Registration-Part-3/Khasi

Time	Narration
00:00	Ngi pdiangsngewbha ia phi sha ka bynta balai jong ka jinghikai User Registration
00:04	Ha kane ka bynta , ngin ia check na ka bynta ka jingdon jong baroh kito kiba ngi lah iakren ha ka bynta ba lah dep.
00:10	To ngin recap wut wut ia kaba lah dep leh ha ka bynta balah dep.
00:14	Ngi lah dep striped ia ki tags na ka "fullname" bad"username" jong ngi.
00:19	Ngi lah dep stripped bad encrypt ia ka "password" jong ngi.
00:23	Kynmaw kane ka sequence na ka bynta ki functions khnang ba ngin ym ia strip ia u value jong ngi ba lah dep encrypt.
00:30	Hangne, ngin ia sdang ia ka registration process jong ngi.
00:34	Ngan check na ka bynta ka jingdon jong kine baroh.
00:38	Shwa ban leh ia kata, ngan set ia ka "$date".
00:43	Mynta, kane ka pyndonkam ia ka date() function.
00:47	Hapoh, ngi don "Y" na ka bynta year, "m" na ka bynta month bad "d" na ka bynta date.
00:55	Udei u "Y" dak heh na ka bynta u 4-digit year. Lada phi pyndonkam ia u "y" dak rit, un dei u 2-digit year.
01:02	Te, ha ka database jong nga , ha kane ka por, nga don nyngkong ia u year jong nga, nangta u month jong nga bad ka day bad kine lah pyniakhlad da ki hyphens.
01:15	Phi lah ban iohi ia kane haba ngi pyndap ia ka database jong ngi hangne bad pyndap ia u value hapoh "users".
01:22	Ngi lah ban iohi ba ka "date" ka don ha ka format ba thikna, lada ngi pyndonkam ia kane ka jait function hangne.
01:29	Ynda nga nion today , phi lah ban iohi hangne ba ngi don ia u year ha ka 4-digit format bad u month jong ngi hangne bad ka day jong ngi hangne, ba la pyniakhlad da ki hyphens.
01:40	Ka lah adjust ha katei ka structure ha ka database jong nga.
01:45	Te, lada if '$submit' te ngi donkam ban check na ka bynta ka jingdon.
01:51	Ngan pyndap ia ka comment hangne, "check for existence".
01:55	Mynta, kane ka suk bha.
01:58	Baroh kaba ngi kwah ban leh kadei, ngi hap ban ong "if" statement bad ka block jong u code hadien katei.
02:05	Ka condition kan dei 'if $fullname, $username, $password and $repeat password exist', ngi don ia ka jingpynshisha hangne.... ngin ia ong if $username bud da ka AND, te double ampersand symbol.
02:24	Nangta ngin ia ong "$password" bad nangta ngin ong ......
02:28	Oh! Nga lah klet ia ka "$fullname" hangne, te ngan pyndap ia ka hangtei.
02:33	Pyniakhlad ia kine da u double ampersand sign.
02:38	Kaba khatduh kadei "$repeat password"; te type ia kata.
02:42	Ngin sa donkam ia kine baroh.
02:46	Lym kumta, ngin ong echo "Please fill in" bad ha ki dak rben, "all", "fields!".
02:57	Ngin ia buh ia ka paragraph break hadien katei.
03:01	Kumjuh , to ngan buh ia ka paragraph break hashwa jong ka form khnang ba ngin nym donkam ban pyndap ia ka sha man ka error message ba ngi ai.
03:10	Te, tang katto.To ngin shu pyrshang ia ka.
03:13	Ngan phai biang sha ka "Register" page jong nga.
03:17	Ngi ioh ia ka hangne. To ngan nion ha register.
03:20	Sngewbha pyndap ia baroh ki fields!".
03:22	To ngin type katto katne ki fields hangne.
03:25	To ngin jied kawei na ki passwords jong ngi.
03:27	Ngin ym iai ban ia ka password jong ngi.
03:30	Register. Oh ! ban biang ia ka password.
03:42	'$repeat password'.
03:45	Ka daw ba kane kam treikam ha kane ka por kadei, u "md5" value jong ubym don eiei u iaryngkat bad u "md5" string jong ka text.
03:56	Ka string ba lah dep encrypt jong ka text.
04:00	Te, nga sngewthuh kaei ba ngi donkam ban leh kadei, sei ia ka "md5" function hangne.
04:06	Pynthikna ba phi weng noh ia ki brackets bakut. Ngan wan hangne hapoh bad check na ka bynta baroh ki data jong ngi.
04:14	Te, to ngan phai biang bad pyrshang ia kane sa shisien.
04:17	Kynmaw ba ka khlem treikam mynshwa haba ngi khlem jied ia ka "Repeat password".
04:23	Te, lada nga khlem jied ia ka repeat lane ka password ngi ioh ia ka error jong ngi.
04:30	Lada nga jied biang ia u value jong ngi lait noh ia ka "Repeat password", ngi dang ioh hi ia kane ka error.
04:37	Katei kadei ka jingeh. Kaba ngi dei ban ong kadei –lada baroh ki don te ngi lah ban pynkylla ia ka password jong ngi bad repeat password.
04:46	Te ngan shu ong "$password" ka iaryngkat bad ka "md5" jong ka "$password".
04:53	Kane kan encrypt ia u original variable value bad buh ia ka password code bathymmai ha ujuh u variable.
05:00	Ngi donkam ruh ban ong "$repeat password" ka iaryngkat bad ka "md5" bad ka "$repeat password".
05:08	Hangne . comment ia kane kum "encrypt password". Ngi lah dep encrypt ia ka password jong ngi.
05:15	Mynta ngin iaid shakhmat bad pyndap ia baroh ki data ha ka database jong ngi.
05:21	Ngan leh ia kane. Namar ba ngi don ia ka data jong ngi kaba leit sha ka registration jong ngi, ngin ia set ia ka maximum limit na ka bynta man kawei ka data ba lah input.
05:39	Mynta ngi ong 25 characters na ka bynta ka fullname, username, password bad repeat password. Te u maximum value udei 25.
05:50	Te, ngan ong- lada ka string length jong ka '$username' ka heh lane kham heh ban ia 25..... OR
06:05	string length jong ka '$fullname' ka kham heh ban ia 25.
06:15	To ngin ia peit ia kine kawei pa kawei bad ong – lada ka length jong ka username lane fullname ka jrong palat.
06:24	To ngan buh ia kane ha ka rukom badei.
06:27	Lada man uwei na kine ki values u kham heh ban ia 25 lane kham heh ban ia 25,
06:34	Ngin ia echo ia kine ki values.
06:40	Da kaba ong "username" lane... em...
06:48	To ngan ong "Max limit for username or fullname are 25 characters".
06:55	Lym kumta ngan iaid shakhmat ban check ia ka jingjrong jong ka password jong nga.
07:01	Mynta nga lah dep rai ban leh ia kane - "check password length" namar nga kwah ia ka jingcheck ba thikna na ka bynta kane.
07:12	Lada ka string length jong ka password jong nga ka kham heh ban ia 25 ... lane.. ka string length...
07:30	Em.. um... to ngin iaid lait na kane, iaid lait na ka else.
07:36	Ka check ba nyngkong ba nga kwah ban leh kadei ban peit lada ki passwords ki iadei.
07:41	To ngan ong "if password equals equals (==)to repeat password" nangta bteng ia ka block jong u code kaba heh.
07:53	Lym kumta echo sha u user "Your passwords do not match".
08:00	Biang?
08:03	Te, phi lah ban type hangne bad ngi lah ban iai check ia ka character length jong phi.
08:09	Mynta, ban check ia ka character length jong ka "username" bad ka "fullname".
08:14	Te, "check character length of username and fullname".
08:18	Bad kata kan dei kumba ngi lah ong hashwa, if "username is greater than 25",
08:25	Lane lada ka string length ba la pyndonkam ha kane ka function ka kham heh ban ia 25...
08:31	OR ka string length jong ka fullname ka kham heh ban ia 25, te ngi echo "Length of username or fullname is too long!".
08:43	Te, tang ban shu pynlong suk ia ka bad nangta ngin ia ong
08:51	"check password length".
08:57	Hangne, ngan pynthikna lane ong if... mynta kynmaw ba ki passwords jong ngi ki iadei.
09:04	Te ngi donkam ban check tang ia kane ha kawei na ki password variables.
09:09	Hangne ngan ong, lada ka string length jong ka password ka kham heh ban ia 25 lane ka string length jong ka password ka duna ban ia 6 characters....
09:23	.... te ngin echoia ka error kaba ong "Password must be between 6 and 25 characters".
09:35	Kane lah thikna kan sa treikam.
09:37	Ngin sa bteng ia kane ka jingbatai ha ka jinghikai babud.
09:41	Shwa kata, to ngan pynkut ia kane da ka else statement.
09:46	Te, lym kumta ngin ong "register the user".
09:51	U code ban register ia u user un leit hangne.
09:56	Ha ka jinghikai kaba bud, ngin test ia kane bad ngin pule kumno ban register ia u user bad ngin buh ia u code hangne ha katei ka jinghikai.
10:06	Kane kadei na ka bynta ban check ia ka minimum lane maximum limit ha ka password jong ngi bad kane ka block jong u code hangne kan dei ka "register the user" ka bynta jong u code jong ngi ba phylla bha.
10:17	Te sa iasnoh bad nga ha ka bynta babud. Nga i Meboreen na Shillong nga dubbed na ka bynta ka Spoken Tutorial Project.

Contributors and Content Editors

Meboreen Mary