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

Time	Narration
00:02	Khublei. Ha kane ka bynta banyngkong jong kane ka jinghikai ngi lah shna ia ka table hapoh ka database"phpacademy" jong ngi bad ngi lah shna ia ki fields jong ngi bad ki data ba iahap ban iahap bad ka... data types bad kiwei kiwei.
00:15	Mynta ngin pynrung katto katne ki dummy data hapoh ka database jong ngi da kaba leh ia kane.
00:20	Ngan nym nion ia une u Insert button hangne namar da kaba nion ia une u button hangne, ngi ioh da kaba suk ban pyndonkam ia ka interface ha kaba ngi lah ban type ia ka firstname, lastname, dob (date of birth) da kaba pyndonkam ia ka calender function hangne.
00:34	Phi lah ban iohi ba kata ka dang shu popped up.
00:36	Bad ruh ngi lah ban pyndap ia ka gender jong ngi hangne.
00:40	Bad kane kadei ka jinghikai mysql php, ngan pyni ia phi kumno ban pynrung ia ki data da kaba pyndonkam mysql lanephp.
00:49	Mynta kaba nyngkong eh ngi donkam ban connect sha ka database jong ngi.
00:52	Hapoh "mysql dot php" file, ngin pyndonkam ia ka include() function ban kynthup lang ia ka file jong ngi "connect dot php".
01:01	Mynta, lada kane kam don ha kajuh ka directory, phi tip ba phi lah ban ong "sub directory and then connect".
01:07	Sngewbha batai bniah ia kane.
01:10	Lada phim kwah ba ka page kan execute.... lada phim kwah ia ka "Rest of the page" ban execute hangne, phi lah ban pyndonkam ia ka require() function.
01:18	Ka require() function ka pynduh noh ia ka page lada kane khlem lap nangne shakhmat.
01:24	Ka include() kan kynthup lang bad ka bad nangta kan sa bteng ban echo lane bteng ban run ia ka page basah.
01:31	Lada phi pyndonkam ia ka "require" function, ha ka jingshisha kan "kill" lada ia kane ym lah ban kynthup lang.
01:38	Te, kaei kaba ngan ong kadei require "connect dot php" tang ban ong ba lada phim lah ban connect sha ka database, ka page kaba sah kam don jingmut.
01:47	Ngin ioh shibun kiei kiei kibym donkam ha ka page.
01:51	Kabiang..... Te lada require "connect dot php" bad hapoh ka "connect dot php" ngi donkam ban sdang ia ki "php mysql" functions.
02:00	Nyngkong eh phi dei ban tip – ngin sdang da u variable jong ngi ba kyrteng "$connect" bad une un sa pyndonkam ia ka function "mysql_connect()".
02:08	Kata kadei ka function banyngkong ba phi hap ban pule.
02:10	Kadei ka function kaba donkam bha kaba ailad ia phi ban connect sha ka database "mysql" jong phi.
02:15	Kane ka shim 3 tylli ki parameters.
02:19	Kaba nyngkong eh hangne kadei ka webserver da lade hi – ka address jong ka webserver.
02:23	Ngan pyndonkam ia ka computer jong nga ha kane ka khyllipmat ryngkat bad ka local webserver bad ka localhost jong nga.
02:28	Ia kane lah ban thoh kum 127.0.0.1 lada phi kwah, kum ka nongmih bujli na ka bynta ka local host.
02:36	Shimet hi nga kwah ban type "localhost"
02:39	Tangba ngan pyndonkam ia ka standard username bad password ba lah ai sha nga.
02:43	Kane kadei ka "root".
02:45	Ka password jong nga kam don namar ba ngam don ia ka password.
02:48	Ngi lah dep pynmih ia ka connection tangba kaei kaba jia lada ia kane ka connection khlem initialized bha.
02:54	Kaba ngi lah ban leh hadien kane kadei, thoh lane " die" bad hapoh ki brackets ngi lah ban batai ia ka error message , kum ka nuksa "Connection failed".
03:05	Te ngin shu shim ia mynta ba kane ka connection ka treikam.
03:10	Ngan echo ia ka bynta jong u code kaba ong "Connected".
03:19	Biang. Mynta lada kane ka connect bha ka script kaba sah kan run bad echo "connected" lym kumta kan shu ai ia phi ia kane ka text bad kan nym run ia ka page kaba sah.
03:30	Te kaba ngan leh kadei, ngam plie ia ka backup hangne.
03:34	Refresh bad phi lah ban iohi "connect dot php" bad "mysql dot php" bad ngan nion ha "mysql dot php".
03:44	Ka daw ba ngam nion ha "connect' kadei namar ba hapoh "mysql" ngi donkam "connect dot php"
03:50	Te , katba kine baroh ar lah save, ngi lah ban shu run ia ka "mysql dot php".
03:58	Ngi lah connect bad ka long kaba jop.
03:59	Mynta ,lada nga hap ban ong, pynkylla ia kane sha kawei pat kum "I dont exist" te ngi ioh ia ka connection error namar ba kata ka kyrteng jong ka host kam don,..... la kumno kumno ha kane ka computer.
04:11	Nga lah ban refresh bad .... ka shim por bha..... te, ngi lah don hangtei.
04:17	Phi iohi ba ngi lah don ia ka "mysql" error hangne bad ngi don ia ka "Connection failed" text hangne , kaba ngi lah batai hashwa.
04:27	Biang, Te ngi lah don ia ka mysql server host bym ithuh.
04:32	Lada lano lano phi ioh ia kane ka error phi tip ha kaei phi dei ban peit.
04:36	Kane kadei ka host ba nga la batai bad phi lah ban iohi ha kano ka line kadon bad baroh ki debugging message code jong ngi.
04:44	Te , to ngin shu shim ba nga...ummmm... ha ka jingshisha kaba nga lah ban leh nyngkong kadei ban pyni ia phi kawei kaba iarap bha "or die()", phi lah ruh ban batai ia kawei ka function hangne.
04:55	Kane kadei kaba ar kaba phi dei ban pule.
04:58	Kadei ka "mysql_error" – shu buh brackets kumtei – bad haba phi refresh ia ka page jong ngi da kaba buh ia ka "I don't exist".
05:06	Ngi lah ban refresh bad ka shim ia ka por lajong.
05:09	Te, ngi lah don hangtei.
05:11	Kaei kaba ngi lah leh kadei ngi lah echo ia kajuh ka error message ba ka php ka la ai ia ngi .
05:19	Wat la katta, lada phi..... ummmm. Kumno ngan ong – lada ka error reporting la turned off na ka bynta u user jong phi, kane kan ai ia phi kaei kaba phi kwah.
05:28	Mynta ngim echo ia kane sha u user.
05:32	To ngin ong ngi leit hangne hajrong bad ong "error reporting()".
05:35	Sngewbha peit ia ka jinghikai error reporting ba nga shna , lada phim pat iohi.
05:40	Lada phi lah iohi..... ummmm.... set ia kane sha '0'.
05:43	Kane kan turn off ia baroh ki error reporting.
05:46	Te kaei kaba jia kadei kane ka error hangne yn sa kyntait tangba ka error ba thikna yn sa ai sha u user.
05:54	To ngin refresh hangne.... sa shisien kane ka shim por.... te nga pan map.....
06:00	Hangne phi don. Ngi lah ban shu ong ba ngi don ia ka error ba thikna hangtei, biang?
06:06	Da kaba shim ba ngi lah dep connect da kaba pyndonkam ia kane ka function bad lada khlem pat dep, te ngi la ai ia kane ka error message. Kaba bud kaba dei ban leh kadei ban jied ia ka database.
06:16	Ban leh ia kane, ngin pyndonkam ia ka "mysql_select-db()" function.
06:22	Kane ka shim thik kawei ka parameter bad kata kadei ka kyrteng jong ka database jong phi.
06:26	Te, ngi nion ha "phpMyAdmin" sa shisien , ngi lah ban iohi ba ka kyrteng jong ka database jong ngi kadei "phpacademy".
06:34	Te, lada nga shu type "phpacademy", kane kadei ban treikam.
06:39	Sa shisien ngi lah ban pyndonkam ia kane lane ka" die()" feature.
06:42	Da kaba pyndonkam ia ka die function jong ngi, ngi lah ban batai ia ka mysql_error lada kam don lane eiei kum katei.
06:51	Te, to ngin refresh ia kane. Ha ka jingshisha ngan pynkylla biang ia kane sha ka "localhost" namar ba nga lah poi biang hangne bad nangta to ngin refresh.
07:03	Te katei kadei "connected!" bad lada ia kane khlem lap, ngi ai ia ka mysql_error.
07:12	To ngin pyrshang ia kata - "I don't exist" bad refresh bad"Unknown database 'idon'texist'".
07:20	Kane ka treikam bha.
07:23	Ka long kaba iarap bha ban don ia kine ki errors bad nangta ngi lah ban ioh ia ki users ban report kylla lada kim don.
07:29	Te kadei ka "phpacademy" hangtei.
07:31	Nga shim ba baroh ki biang bad to ngin refresh.
07:34	Pynkylla ia kane sha ka "phpacademy" bad save ia katei.
07:38	Refresh bad ngi lah connect bad ka long kaba jop.
07:41	Kaba ngan leh kadei ban buh ia ka log jong kane bad ong ba nga lah connect bad ka long kaba jop.
07:46	Ngan pynkut ia ka paragraph ( ) jong ngi hadien kane ban bteng bad u code ba sah jong ngi.
07:53	Kaba bud kadei ban thoh katto katne ki data sha ka database jong ngi kaba ngin sa leh ha ka jinghikai ba bud.
08:00	Ngin sa iashem biang shen hi. Nga i Meboreen na Shillong nga dubbed na ka bynta ka Spoken Tutorial Project.

Contributors and Content Editors

Meboreen Mary