Meboreen Mary: Created page with "{| border=1 |'''Time''' |'''Narration''' |- |00:02 | Khublei. Ha kane ka bynta banyngkong jong kane ka jinghikai ngi lah shna ia ka table hapoh ka '''database'''"phpacademy" j..."

2017-10-05T17:06:40Z

Created page with "{| border=1 |'''Time''' |'''Narration''' |- |00:02 | Khublei. Ha kane ka bynta banyngkong jong kane ka jinghikai ngi lah shna ia ka table hapoh ka '''database'''"phpacademy" j..."

New page

{| border=1
|'''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''' lane'''php'''.
|-
|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 (<p>) 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.

|}

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

Meboreen Mary: Created page with "{| border=1 |'''Time''' |'''Narration''' |- |00:02 | Khublei. Ha kane ka bynta banyngkong jong kane ka jinghikai ngi lah shna ia ka table hapoh ka '''database'''"phpacademy" j..."