PHP-and-MySQL/C3/MySQL-Part-8/Khasi

Time	Narration
00:00	Ngi pdiangsngewbha ia phi sa shisien! Ha ka jinghikai ba hashwa jong ngi, ngi lah dep pynmih ia kaei kaba ngin pynkylla bad kumno ngin pynkylla ia ka.
00:09	Ngi lah dep iaid lyngba katei.
00:11	Te, mynta ngan test ia ka code jong nga.
00:13	Lada ngi peit ha ka database jong ngi , ngi don katto katne ki records hangne.
00:17	Ngan delete ia ka record jong David hangne namar ba kadei na kawei pat ka jinghikai.
00:23	Hadien ka jing delete, ngi don ia ki records jong Alex, Kyle, Emily bad Dale.
00:29	Hangne ngan pyndonkam ia ka record jong Kyle kum ka nuksa bad pynkylla ia ka sha uwei u value.
00:34	Ngin refresh ia ka page jong ngi bad pynthikna ba ka lah dep update.
00:38	Ngan jied "Kyle" bad ngan pynkylla ia kane sha "Karen" bad ngan nion ha Change bad hangne baroh ki lah jah lut.
00:46	Mynta ngin wan phai biang sha ka table jong ngi bad nion ha Browse ban refresh ia ka.
00:50	Ngin scroll shapoh bad shem ba khlem don jingkylla eiei.
00:58	Nga tharai, nga lah leh bakla. Ka jingbakla jong nga kadei ba kadei ka name mynshwa bad mynta ngan pynkylla ia kane sha value.
01:06	Kane ka donkam ban set sha value ha ka jaka jong name.
01:09	value u don ia u value.... jong uei uei hangne ba lah dep jied; te u value udei "$id".
01:15	Haba ngi submit ia ka form jong ngi kan sa wan lyngba bad u value un sa don hangne hapoh ka "id".
01:25	Te, nga lah lap bad pynbeit ia ka jingeh bad mynta ngan phai biang bad refresh.
01:30	Hangne, sa shisien ngan pynkylla "Kyle" sha "Karen". Da kaba nion ha Change phi iohi ba ka khlem jia eiei.
01:37	Wat haba nga pyndap ia ka database jong nga, ngi lah ban iohi ba ngi lah don Alex,Kyle, Emily bad Dale.
01:42	Namar ba ngi lah pynkylla "Kyle" sha "Karen",ka "id" jong ngi ka pyni ia ki jingkylla bapaw.
01:47	Tangba haba ngi nion ha Browse bad scroll shapoh, ngi lah ban iohi ba mynta "Kyle" lah dep bujli da "Karen".
01:54	Namarkata, phi lah ruh ban update ia ki values da kaba pyndonkam ia ki forms.
01:57	Ka suk bha, katba phi dang don ia ka jingtip ba thikna jong php software Kumno ban manipulate ia kiei kiei Kumno ban check ia kiei kiei Kumno ban pyndonkam ia ki if statements Ban pass ia ki variables Kham kyrpang ka jing post ia ki variables bad kiwei kiwei.
02:15	Phin sa nang ban pule ia kane katba phi dang pule ia ki bynta ba donkam jong kine ki jinghikai.
02:20	Katba ia mynta, ha kane ka jinghikai, phi lah pule ban pynrung bad update bad kumta ter ter.
02:28	Kaba khatduh ba ngan pyni ia phi kadei kumno ban delete.
02:34	Ban pyni ia phi kumno ban delete, ngan khang ia kane ka page bad weng ia kane ka box bad edit ia ka.
02:46	Ngan bujli ia ka "Change" da ka "Delete".
02:49	Hangne ngan delete ia ki records ha kaba ngi don ia kawei ka kyrteng ba la pyni.
02:55	Ban leh ia kane, ngan pyndap "$lastname" hangne.
03:01	To mynta ngin nym resend ia katei bad to ngin leit phai biang sha ka "mysql.php".
03:08	Hangne, ngi don mynta ia ka "Alex Garrett", "Karen Headen" kiba la dep pynkylla lane pynpher na ka nuksa ba khatduh jong nga.
03:17	Ngin nion "Karen Headen" bad ngin nion ha "Delete". Kane kan sa delete ia ka record.
03:24	Tangba ka khlem pat shah delete ha kane ka khyllipmat.
03:27	To ngin pynthikna nyngkong ba baroh ki records jong ngi ki biang.
03:31	Kumba phi lah ban iohi hangne, ngi don ia baroh ki records jong ngi bad ngan jied ban delete ia kawei ka record.
03:37	To ngin ong delete "Emily Headen"; te ngan jied ia ka record jong Emily Headen kaba dei ban delete.
03:45	Mynta ngi donkam ban submit ia kane sha ka page ba thymmai ba kyrteng "mysql underscore delete.php".
03:52	Na ka bynta kane, ngin shna ia ka page bathymmai, save ia ka kum "mysql underscore delete.php".
03:59	Ngin leh thik kumjuh kumba ngi lah dep leh mynshwa.
04:03	Ngin sa ia require ia ka "connect" jong ngi, te ngi donkam ban connect sha ka database.
04:10	Oh Map ia nga! To ngin pynphai biang ia katei sha ka require "connect.php" bad sa shisien shim ia ki variables.
04:22	Te, to ngin type$todelete hangne bad katei kan iaryngkat sa shisien u "$_POST" variable hangne.
04:29	Ngi ia post ia kane ka form sha kane ka page bad to ngin pynkylla katto katne ki values hangne.
04:34	To ngin ong "todelete".
04:37	Te, ngi lah pynkylla ia ka select name sha "todelete".
04:41	Mynta, lada phi phai biang ha kane ka form hangne, ngan pyni ia phi ia u code sa shisien.
04:47	Hangne ngi lah ban iohi ba ngi don ia ki name values bad u id value jong ngi hangne na ka bynta man kawei ka case jong ka record.
04:54	Lada ngi refresh, ka kyrteng jong ka form jong ngi kadei "todelete" bad ngi ia shim ia katei sha ka account na ka bynta man uwei u value.
05:01	Lada lah dep jied ia ka record jong ka Emily ngin delete ia ka record ha kaba ka id ka iaryngkat bad 3.
05:08	To ngin phai biang sha u code jong ngi bad hangne ngi don ia u POST variable jong ngi.
05:14	Mynta ngan echo bad ai ia phi ia kawei ka nuksa jong kumno ba ia ka lah processed.
05:20	Ngi don "Emily Headen" hangne . Ngi don 3 hangtei kaba mut ba ngi lah ban pyndonkam ia kane ban delete ia ka id 3 ha ka database lane ka table.
05:30	Hangne , sa shisien ngin shna ia u variable bathymmai bad ngan khot ia u "mysql underscore query()".
05:41	Hangne hapoh, ngin pyndonkam ia baroh kawei ka set bathymmai jong ki commands
05:45	Ngin type ha "DELETE FROM" bad khlem pep, ngin specify ia ka table jong ngi.
05:52	To ngin type "people" bad "WHERE id equals "$todelete".
05:57	U"$todelete" variable uba dei u "id" jong u briew ba ngi lah jied na kane ka list.
06:03	Mynta , to ngin test ia kane. To ngin ong "Emily Headen".
06:08	To ngin check ha ka database lada ka record jong Emily Headen ka dang don.
06:13	To ngin refresh ban peit lada ka record ka dang don.
06:17	Haba nga nion ha "Emily Headen" bad nion ha Delete, ka khlem jia eiei.
06:22	Ngi khlem pat echo tangba haba ngi nion ha Browse ban refresh, ngi lah ban iohi ba ka record jong Emily lah dep delete na ka database.
06:30	Te ha kane ka bynta jong ki jinghikai, nga lah dep pyni ia phi ia ka serve command kaba donkam kum Kumno ban pynrung ia ka data Kumno ban read ia ka data Kumno ban modify Kumno ban delete ia ka data Kumno ban pynrung ha ki html forms.
06:43	Lada nga lah klet eiei, sngewbha pyntip ia nga bad ngan pyndap ia ka kum ki bynta jong kine ki jinghikai.
06:50	Pynthikna ba phi subscribe na ka bynta ki updates na ka channel jong nga.
06:53	Kyrmen ba phi sngewtynnad ia kine ki jinghikai.Khublei Shibun na ka bynta ka jingpeit jong phi.
06:55	Nga i Meboreen na Shillong nga dubbed na ka bynta ka Spoken Tutorial Project.

Contributors and Content Editors

Meboreen Mary