Script | Spoken-Tutorial - User contributions [en]

LaTeX/C2/Letter-Writing/Bhojpuri

2014-09-15T16:25:58Z

Gyan:

[[Media:Letter_Writing-Bhojpuri.pdf| Letter_Writing-Bhojpuri.pdf script]]

File:Letter Writing-Bhojpuri.pdf

2014-09-15T16:25:29Z

Gyan:

Scilab/C2/Conditional-Branching/Oriya

2014-09-15T16:11:03Z

Gyan: Created page with " Conditional-branching_Oriya.pdf script"

[[Media:Conditional-branching_Oriya.pdf| Conditional-branching_Oriya.pdf script]]

File:Conditional-branching Oriya.pdf

2014-09-15T16:09:29Z

Gyan:

Spoken-Tutorial-Technology/C2/Creation-of-a-spoken-tutorial-using-Camstudio/Bhojpuri

2014-09-15T16:05:23Z

Gyan: Created page with " Camstudio-Bhojpuri.pdf script"

[[Media:Camstudio-Bhojpuri.pdf| Camstudio-Bhojpuri.pdf script]]

LibreOffice-Suite-Writer/C2/Introduction-to-LibreOffice-Writer/Urdu

2014-09-15T16:04:53Z

Gyan:

[[Media:LO-Writer-C2-Introduction_to_LO_Writer-Urdu.pdf| LO-Writer-C2-Introduction_to_LO_Writer-Urdu.pdf script]]

LibreOffice-Suite-Writer/C2/Introduction-to-LibreOffice-Writer/Urdu

2014-09-15T16:04:40Z

Gyan:

[[Media:LO-Writer-C2-Introduction_to_LO_Writer-Urdu.pdf| LO-Writer-C2-Introduction_to_LO_Writer-Urdu.pdf script]]

LibreOffice-Suite-Writer/C2/Introduction-to-LibreOffice-Writer/Urdu

2014-09-15T16:03:02Z

Gyan:

[[Media:Camstudio-Bhojpuri.pdf| Camstudio-Bhojpuri.pdf script]]

File:Camstudio-Bhojpuri.pdf

2014-09-15T16:01:34Z

Gyan:

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Oriya

2014-09-15T15:02:17Z

Gyan: Created page with " How-to-Dub-WMM-Oriya.pdf script"

[[Media:How-to-Dub-WMM-Oriya.pdf | How-to-Dub-WMM-Oriya.pdf script]]

File:How-to-Dub-WMM-Oriya.pdf

2014-09-15T15:00:57Z

Gyan:

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Kannada

2014-09-15T10:04:41Z

Gyan: Created page with " How-to-Dub-WMM-Kannada.pdf script"

[[Media:How-to-Dub-WMM-Kannada.pdf | How-to-Dub-WMM-Kannada.pdf script]]

File:How-to-Dub-WMM-Kannada.pdf

2014-09-15T10:03:38Z

Gyan:

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Bhojpuri

2014-09-15T10:01:15Z

Gyan: Created page with " How-to-Dub-WMM-Bhojpuri.pdf script"

[[Media:How-to-Dub-WMM-Bhojpuri.pdf| How-to-Dub-WMM-Bhojpuri.pdf script]]

File:How-to-Dub-WMM-Bhojpuri.pdf

2014-09-15T10:00:04Z

Gyan:

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Assamese

2014-09-15T07:50:24Z

Gyan:

[[Media:How-to-Dub-WMM-Assamese.PDF | How-to-Dub-WMM-Assamese.PDF script]]

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Assamese

2014-09-15T07:50:10Z

Gyan: Created page with " How-to-Dub-WMM-Assamese.PDF script"

[[Media:How-to-Dub-WMM-Assamese.PDF | How-to-Dub-WMM-Assamese.PDF script]]

File:How-to-Dub-WMM-Assamese.PDF

2014-09-15T07:48:14Z

Gyan:

Spoken-Tutorial-Technology/C2/Editing-a-spoken-tutorial-using-Movie-Maker/Tamil

2014-09-15T07:21:42Z

Gyan: Created page with "அன்பு நண்பர்களே, CDEEP IIT பாம்பே சார்பாக உங்களை இந்த செய்முறை விளக்க..."

அன்பு நண்பர்களே, CDEEP IIT பாம்பே சார்பாக உங்களை இந்த செய்முறை விளக்க

பயிற்சிக்கு வரவேற்கிறோம். இந்த பயிற்சியில் Windows Movie Maker ஐ பயன்படுத்தி எவ்வாறு edit செய்வது என்பதை அறிந்துகொள்வோம்.

Windows Movie Maker என்பது Microsoft கழகத்தின் ஒரு எடிட்டிங் மென்பொருள். இது அனைத்து புதிய Windows OS version - Me, XP, Vista வில் உள்ளது. உங்கள் கம்ப்யூட்டரில் இந்த மென்பொருள் இல்லை என்றால் நீங்கள் www.microsoft.com/downloads என்ற இணையதளத்தில் இலவசமாக டவுன்லோட் செய்துகொள்ளலாம்.

இந்த மென்பொருளை உபயோகிக்க Windows Movie Maker பட்டனை இரண்டு முறை கிளிக் செய்யவும். உங்கள் திரையில் movie project காணலாம். நீங்கள் வலது மேல்புறத்தில் மெயின் மேனுவை காணலாம். இதில் நிறைய optionகள் உள்ளது நாம் அதனை விரிவாக இந்த பயிற்சியில் அறிந்துகொள்ளலாம்.

திரையில் இடது புறத்தில் movie Tasks Panel, மத்தியில் Collection பநெல் மற்றும் வலது புறத்தில் display panel ஐ நீங்கள் காணலாம். நீங்கள் Windows Movie Maker ஐ முதல்முறையாக உபயோக படுத்தும் போது collection panel காலியாக இருக்கும். தேவையான அனைத்து video clips, audio narrations மற்றும் music files ஐ import செய்யும் போது அதனை collection panel இல் காணலாம். நீங்கள் இந்த மென்பொருளை முன்பே பயன்படுத்தி இருந்தால், நீங்கள் முன்பு பயன்படுத்திய video மற்றும் audio clips உங்கள் collection panel இல் தெரியும். Main menu வில் உள்ள file button ஐ click செய்து new project ஐ தேர்வு செய்யவும். இது புதிய movie project ஐ உங்கள் திரையில் open செய்யும். இப்போது உங்களுக்கு தேவையான file களை Windows Movie Maker க்கு import செய்யலாம்.

Movie task panel இல் பலவிதமான option களை காணலாம், இதில் Capture Video, Edit Movie, Finish Movie மற்றும் Movie Making Tips ஆகியவை முக்கியமான ஒன்றாகும். capture video option இல் import video option ஐ காணலாம், அதை click செய்யவும். மாற்றாக நீங்கள் Main menu வில் உள்ள file button ஐ click செய்து Import into Collections sub-option ஐ தேர்வு செய்யலாம். இவை இரண்டும் Import File dialog box ஐ திரையில் open செய்யும். இங்கு நீங்கள் எடிட் செய்வதற்கு தேவையான videoவை சரியான path மற்றும் file name கொடுத்து தேர்வு செய்யலாம். நான் இந்த videoவை தேர்வு செய்து import button ஐ click செய்கிறேன். தேவையான வீடியோ collection panel இல் உள்ளது, வீடியோவின் அளவு பெரியதாக இருப்பின் Windows Movie Maker தானாகவே சிறு clips களாக split செய்துகொள்ளும். Keyboard இல் CTRL+A key ஐ press செய்து அனைத்து clips களையும் தேர்வு செய்யவும், இப்போது mouse இல் right click செய்து Add to Timeline option ஐ தேர்வு செய்யவும். clips கள் timeline இல் வரிசையாக இருக்கும், நீங்கள் ஒரு ஒரு clips ஆக

collection panel இல் இருந்து drag செய்தும் time line இல் add செய்யலாம்.

சிறிய நீல செவ்வகத்தை timeline இன் மேல்புறம் கவனிக்கவும், இது frame-head என அழைக்கபடும். இது video வின் தற்போதைய position ஐ காண்பிக்கும். பொதுவா இது timeline இன் ஆரம்பத்தில் இருக்கும். முதல் clip ஐ click செய்யவும். Display panel இல் video வின் முதல் frame ஐ காணலாம். video play செய்யும்போது display panel இல் நீங்கள் காணலாம். நீங்கள் VCR control button களை display panel அடியில் காணலாம், இதை பற்றி விரிவாக காண்பதற்கு முன்பு, நான் frame head ஐ இங்கு நகர்த்துகிறேன். முதல் button play மற்றும் pause, இது play mode இல் இருக்கும் போது frame head முன் புறமாக நகர்ந்து செல்லும். இது pause mode இல் இருக்கும் போது frame head தன் நிலையிலே நிற்கும். இரண்டாவது button playback ஐ stop செய்வதற்கு பயன் படுகிறது, இதை click செய்யும்போது playback stop ஆகும் ஆனால் frame head மறுபடியும் time line இன் ஆரம்பத்திற்கு சென்றுவிடும். இப்போது நான் frame head ஐ இங்கு நகர்த்துகிறேன். முன்றாவது button ஒரு clip ஐ rewind செய்ய உதவும், frame head ஒரு clip பின்நோக்கி செல்வதை காணலாம். ஆறாவது button ஒரு clip ஐ forward செய்ய உதவும், நான்காவது மற்றும் ஐந்தாவது button கள் இவ்வாறு rewind மற்றும் forward செய்ய உதவும்.

இது split button என அழைக்கபடுகிறது, இது audio மற்றும் video clip களை தற்போதைய position இல் இரண்டாக split செய்ய உதவும். இது சக்திவாய்ந்த editing tool ஆகும்.

இப்போது timeline இன் layout ஐ விரிவாக காணலாம், timeline முன்று பகுதிகளாக பிரிக்கப்பட்டு உள்ளது அவை Video, audio/music, மற்றும் title overlay. video வின் அருகில் உள்ள plus குறியை click செய்யவும். இது video timeline ஐ expand செய்து audio timeline ஐ காண்பிக்கும். இது dubbing செய்வதற்கு உதவியானது. Dubbing செய்வது எப்படி என்பதை மற்றொரு செய்முறை விளக்கப்பயிற்சியில் தெரிவித்து உள்ளோம், நீங்கள் அதனை காண ஆர்வபடலாம். நான் இப்போது video timeline button ஐ click செய்து collapse செய்கிறேன்.

Timeline ற்கு மேல் உள்ள icon கள் editing செய்வதற்கு உதவுகிறது. Zoom button, video timeline ஐ stretch செய்வதால் ஒவ்வொரு video frame களை edit செய்யலாம். Zoom out button, video வை collapse செய்வதால் நாம் மொத்த video வை timeline ற்குள் காணலாம். இது rewind timeline button. இதை press செய்யும் பொது frame head உங்கள் வீடியோவின் ஆரம்பத்திற்குசெல்லும். இது play timeline button, இதை click செய்வதன் மூலம் வீடியோவைdisplay panel இல் play செய்யலாம். இது VCR control play button போலவேபணிபுரிகிறது. Windows Movie Maker பற்றி இன்னும் அறிந்து கொள்ள movie tasks panel இல் உள்ள Movie Making Tips option ஐ ஆராய்ந்து அறிந்து கொள்ளலாம்.

இப்போது நாம் Windows Movie Maker screen இன் அடிப்படை layout ஐ பார்த்தோம், நாம் எவ்வாறு video portion ஐ add செய்வது மற்றும் remove செய்வது என்பதை காணலாம். Video import செய்தப்பிறகு அதனை ஆரம்பம் முதல் முடிவு வரை play செய்து, எந்த எந்த இடங்களை நீங்கள் edit செய்ய வேண்டும் என்பதை குறித்து கொள்ளவும். நான் இந்த இடத்தில் சிறு நொடிகள் வீடியோவை remove செய்ய வேண்டும் அதனால் frame head ஐ இங்கு நகர்த்தி clip ஐ play செய்யவும். இங்கு playback ஐ pause செய்கிறேன் ஏன் என்றால், இது தான்நான் remove செய்ய வேண்டிய video வின் ஆரம்பப்பகுதி. இப்பொழுது நான்split button ஐ click செய்கிறேன், இந்த இடத்தில் clip இரண்டாக பிரிவதை

கவனிக்கவும். இங்கு நான் மீண்டும் play செய்து delete செய்ய வேண்டிய video முடியும் இடத்தில் pause செய்து spilt button ஐ click செய்வதன்மூலம் video மறுபடியும் split செய்வதை காணலாம். இப்பொழுது நான் இந்தclip ஐ select செய்து keyboard ல் உள்ள delete key ஐ press செய்வதன் மூலம் வீடியோவை remove செய்யலாம். இதை போலவே நாம் வீடியோவில் இருந்து மற்ற portion களை delete செய்யலாம்.

இனி நாம் எப்படி மற்றொரு வீடியோவை add செய்வது என்பதை பார்போம். நான் இந்த சிறிய clip ஐ என் வீடியோவில் சேர்க்க விரும்புகிறேன். அதனால் நான் இந்த வீடியோவை collection panel ற்கு import செய்து கொள்கிறேன், clip இப்பொழுது collection panel ல் உள்ளது. நான் இந்த clip ஐ drag செய்து timeline இல் வேண்டிய இடத்தில drop செய்வதம் மூலம் clip timeline இல் தெரிகிறது. இதை போலவே, நாம் எந்த portion ஐயும் வீடியோவில் add செய்யலாம். இதே முறையை பயன்படுத்தி இரண்டு அல்லது அதற்கு மேற்பட்டவீடியோக்களை இனணக்கலாம்.

நான் இப்பொழுது எவ்வாறு clip அல்லது clip portion இன் நீளத்தை அதிகப்படுத்துவது என்பதை செய்து காட்ட விரும்புகிறேன். இது dubbing செய்யும் பொழுது மிக உதவியாக இருக்கும். சில சமயங்களில் dub செய்ய வேண்டிய மொழி original மொழியை விட அதிக வார்த்தைகள் கொண்டு இருக்கும், அந்த நேரங்களில் நமக்கு video clip களில் அதிக நேரம்தேவைப்படும். உங்கள்ளுக்கு தேவையான பகுதியை முன்பு சொன்ன முறைப்படிதேர்வு செய்யவும். நான் இதை செய்து காட்டுகிறேன், வீடியோவை இங்கு clipசெய்யவும்- play மற்றும் pause, மறுபடியும் வீடியோவை clip செய்யவும் – clip செய்த பகுதியை தேர்வு செய்யவும் - mouse இல் right click செய்து copy ஐ தேர்வு செய்யவும் - frame head ஐ paste செய்ய வேண்டிய இடத்திற்கு நகற்றவும் மீண்டும் right click செய்து paste ஐ தேர்வு செய்யவும். மாற்றாக நீங்கள் keyboard இல் CTRL+C copy செய்வதற்கும் மற்றும் CTRL+V paste செய்வதற்கும் பயன்படுத்தலாம்.

இந்த வசதிகளை, உங்கள் வீடியோவை Windows Movie Maker ல் edit செய்ய பயன்படுத்துங்கள். முன்பு சொன்னதை போல் நீங்கள் எவ்வாறு dubbing செய்வது என்கின்ற செய்முறை பயிற்சியை காண விரும்பலாம். நீங்கள் editing மற்றும் dubbing இன் அடிப்படையை கற்ற பிறகு, எவ்வாறு video effects மற்றும் transistion, title அல்லது credit மற்றும் audio அல்லது music ஐ உங்கள் வீடியோவில் add செய்வது என்பதை மற்ற செய்முறை விளக்கப்பயிற்சியில் கண்டு தெரிந்து கொள்ளலாம். இந்த பயிற்சி

உங்களுக்கு உதவியாக இருக்கும் என நம்புகிறோம். இப்படிக்கு அன்புடன் Ramkumar, IIT Bombay வில் இருந்து. இந்த செய்முறை பயிற்சியை கண்டதற்கு நன்றி.

Spoken-Tutorial-Technology/C2/Editing-a-spoken-tutorial-using-Movie-Maker/Bhojpuri

2014-09-15T07:18:14Z

Gyan:

[[Media:How_To_Edit-Bhojpuri.pdf | How_To_Edit-Bhojpuri.pdf script]]

Spoken-Tutorial-Technology/C2/Editing-a-spoken-tutorial-using-Movie-Maker/Bhojpuri

2014-09-15T07:11:53Z

Gyan:

[[Media:How_To_Edit-Bhojpuri.pdf | How_To_Edit-Bhojpuri.pdf script]]

Spoken-Tutorial-Technology/C2/Editing-a-spoken-tutorial-using-Movie-Maker/Bhojpuri

2014-09-15T06:59:34Z

Gyan: Created page with "Media:How_To_Edit-Bhojpuri.pdf"

[[Media:How_To_Edit-Bhojpuri.pdf]]

File:How To Edit-Bhojpuri.pdf

2014-09-15T06:57:29Z

Gyan:

Main Page

2014-06-27T05:48:05Z

Gyan:

Spoken-Tutorial-Technology/C2/Editing-a-spoken-tutorial-using-Movie-Maker/Marathi

2014-05-12T12:09:26Z

Gyan:

<pdf>http://script.spoken-tutorial.org/images/f/f7/How_to_Edit-Marathi.pdf</pdf>

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Marathi

2014-05-12T12:08:31Z

Gyan:

<pdf>http://script.spoken-tutorial.org/images/d/d4/How-to-Dub-WMM-Marathi.pdf</pdf>

Spoken-Tutorial-Technology/C2/Editing-a-spoken-tutorial-using-Movie-Maker/Marathi

2014-05-12T11:59:59Z

Gyan:

[http://script.spoken-tutorial.org/images/f/f7/How_to_Edit-Marathi.pdf Marathi]

Spoken-Tutorial-Technology/C2/Editing-a-spoken-tutorial-using-Movie-Maker/Marathi

2014-05-12T11:58:33Z

Gyan: Created page with '[ http://script.spoken-tutorial.org/images/f/f7/How_to_Edit-Marathi.pdf Marathi ]'

[ http://script.spoken-tutorial.org/images/f/f7/How_to_Edit-Marathi.pdf Marathi ]

File:How to Edit-Marathi.pdf

2014-05-12T11:57:29Z

Gyan:

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Marathi

2014-05-12T11:54:46Z

Gyan:

[http://script.spoken-tutorial.org/images/d/d4/How-to-Dub-WMM-Marathi.pdf Marathi]

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Marathi

2014-05-12T11:42:53Z

Gyan:

[[http://script.spoken-tutorial.org/images/d/d4/How-to-Dub-WMM-Marathi.pdf]] Marathi

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Marathi

2014-05-12T11:41:39Z

Gyan:

Marathi [http://script.spoken-tutorial.org/images/d/d4/How-to-Dub-WMM-Marathi.pdf]

Spoken-Tutorial-Technology/C2/Dubbing-a-spoken-tutorial-using-Movie-Maker/Marathi

2014-05-12T11:37:53Z

Gyan: Created page with '[http://script.spoken-tutorial.org/index.php/File:How-to-Dub-WMM-Marathi.pdf]'

[http://script.spoken-tutorial.org/index.php/File:How-to-Dub-WMM-Marathi.pdf]

File:How-to-Dub-WMM-Marathi.pdf

2014-05-12T11:37:04Z

Gyan:

Main Page

2014-05-12T06:51:05Z

Gyan:

Main Page

2014-05-12T06:46:59Z

Gyan:

Main Page

2014-05-12T06:46:22Z

Gyan:

Geogebra/C3/Relationship-between-Geometric-Figures/Hindi

2013-12-19T12:00:28Z

Gyan: Created page with '{|border =1 !Visual Cue !Narration |- ||00:00 ||नमस्कार। |- ||00:01 ||जियोजेब्रा में विभिन्न ज्यामिती…'

{|border =1
!Visual Cue
!Narration

|-
||00:00
||नमस्कार।

|-
||00:01
||जियोजेब्रा में विभिन्न ज्यामितीय आकृतियों के मध्य संबंध पर इस स्पोकन ट्यूटोरियल में आपका स्वागत है।

|-
||00:07
||हम मानते हैं कि आपको जियोजेब्रा के कार्य का बुनियादी ज्ञान है।

|-
||00:11
||यदि नहीं। तो कृपया आगे बढ़ने से पहले “Introduction to Geogebra” ट्यूटोरियल देखें।
|-
||00:18
||कृपया ध्यान दें, कि इस ट्यूटोगियल को पढ़ाने का मकसद वास्तविक कॅम्पास बॉक्स की जगह लेना नहीं है।

|-
||00:24
||जियोजेब्रा में संरचना निर्माण प्रोपर्टिज को समझने के लिए की जाती है।

|-
||00:29
||इस ट्यूटोरियल में हम निम्न बनाना सीखेंगे।

|-
||00:32
||चक्रीय चतुर्भुज और अन्तःवृत्त।

|-
||00:35
||इस ट्यूटोरियल को रिकॉर्ड करने के लिए, मैं लिनक्स ऑपरेटिंग सिस्टम

|-
||00:39
||उबंटु वर्जन 10.04 LTS

|-
||00:43
||और जियोजेब्रा वर्जन 3.2.40.0 का उपयोग कर रहा हूँ।
|-
||00:48
||संरचना बनाने के लिए हम निम्न जियोजेब्रा टूल्स का उपयोग करेंगे।
* compass

* segment between two points

* circle with center through point

* polygon

* perpendicular bisector

* angle bisector and

* angle

|-
||01:02
||अब जियोजेब्रा विंडो पर जाते हैं।

|-
||01:05
||ऐसा करने के लिए applications, Education और Geogebra पर क्लिक करें।

|-
||01:13
||मैं इस विडों का आकार बदलता हूँ।

|-
||01:18
||आकृति को स्पष्ट करने के लिए options मेन्यू पर क्लिक करें, font size पर क्लिक करें और फिर 18 point पर क्लिक करें।

|-
||01:25
||अब एक चक्रीय चतुर्भुज बनाते हैं।

|-
||01:27
||ऐसा करने के लिए टूलबार से "Regular Polygon" टूल चुनें, "Regular Polygon" टूल पर क्लिक करें, drawing pad पर किन्हीं दो बिंदुओं पर क्लिक करें।

|-
||01:38
||हम देखते हैं कि डिफॉल्ट वेल्यू '4' के साथ एक डायलॉग बॉक्स ओपन होता है।

|-
||01:42
||OK क्लिक करें।

|-
||01:43
||एक समचतुर्भुज 'ABCD' बन गया है।

|-
||01:46
||अब “Move” टूल का उपयोग करके समचतुर्भुज को झुकाते हैं, जो कि बायें कोने पर है।

|-
||01:51
||टूलबार से "Move" टूल चुनें, Move tool पर क्लिक करें।

|-
||01:56
||'A' या 'B' पर माउस प्वॉइंटर रखें। मैं B की चुनाव करूँगा।

|-
||02:01
||B पर माउस प्वॉइंटर रखें और माउस के साथ इसे ड्रैग करें। हम देखते हैं कि समचतुर्भुज अब झुकाव की स्थिति में है।

|-
||02:10
||वृत्तखंड 'AB' पर एक लम्ब द्विभाजक बनाएँ।

|-
||02:15
||ऐसा करने के लिए, टूलबार से “Perpendicular bisector” टूल चुनें।

|-
||02:20
||"Perpendicular bisector" टूल पर क्लिक करें।

|-
||02:22
||बिंदु 'A' पर क्लिक करें।

|-
||02:24
||और फिर बिंदु 'B' पर क्लिक करें।

|-
||02:26
||हम देखते हैं, कि लम्ब द्विभाजक ("Perpendicular bisector") बन गया है।

|-
||02:30
||वृत्तखंड 'BC' पर दूसरा लम्ब द्विभाजक बनाएँ। ऐसा करने के लिए,

|-
||02:36
||टूलबार से “perpendicular bisector” टूल चुनें, “perpendicular bisector” टूल पर क्लिक करें।

|-
||02:42
||बिंदु 'B' पर क्लिक करें।

|-
||02:44
||और फिर बिंदु 'C' पर क्लिक करें।

|-
||02:46
||हम देखते हैं, कि लम्ब द्विभाजक एक बिंदु पर प्रतिच्छेद करता है।

|-
||02:50
||इस बिंदु को 'E' के रूप में चिन्हित करें।

|-
||02:54
||अब केंद्र 'E' के साथ एक वृत्त बनाएँ, जो C से होकर गुजरता है।

|-
||03:01
||टूल बार से "circle with centre through point" टूल चुनें, "circle with centre through point" टूल पर क्लिक करें।

|-
||03:09
||केंद्र के रूप में बिंदु 'E' पर क्लिक करें, जो बिंदु 'C' से होकर गुजरता है। बिंदु 'E' और फिर बिंदु 'C' पर क्लिक करें।

|-
||03:18
||हम देखते हैं, कि वृत्त चतुर्भुज के सभी शीर्षों से होकर गुजरेगा। एक चक्रीय चतुर्भुज बन गया है।

|-
||03:29
||क्या आप जानते हैं, कि भुजा की लम्बाई के समान क्रम के चतुर्भुजों में से चक्रीय चतुर्भुज का क्षेत्रफल अधिक होता है।

|-
||03:37
||अब आकृति को एनिमेट करने के लिए "Move" टूल का उपयोग करें।

|-
||03:42
||ऐसा करने के लिए, टूल बार से "Move" टूल चुनें, "Move" टूल पर क्लिक करें, 'A' या 'B' पर माउस प्वॉइंटर रखें। मैं 'A' चुनूँगा।

|-
||03:52
||माउस प्वॉइंटर 'A' पर रखें और एनिमेट करने के लिए इसे माउस के साथ ड्रैग करें।

|-
||03:58
||सत्यापित करने के लिए कि संरचना सही है।

|-
||04:01
||अब फाइल को सेव करें।

|-
||04:04
||"File" "Save As" पर क्लिक करें।

|-
||04:07
||मैं फाइल का नाम "cyclic_quadrilateral" टाइप करूँगा।

|-
||04:21
||और save पर क्लिक करें।

|-
||04:23
||अब एक अन्तःवृत्त को बनाने के लिए नया जियोजेब्रा विंडो खोलें।

|-
||04:28
||ऐसा करने के लिए, File और New चुनें।

|-
||04:35
||अब एक त्रिकोण बनाएँ, ऐसा करने के लिए, टूल बार से "Polygon" टूल चुनें, "Polygon" टूल पर क्लिक करें।

|-
||04:44
||बिंदु A,B,C पर क्लिक करें और त्रिकोण को पूरा करने के लिए A पर पुनः क्लिक करें।

|-
||04:52
||अब इस त्रिकोण के कोणों को मापते हैं।

|-
||04:55
||ऐसा करने के लिए, टूल बार से "Angle" टूल चुनें, "Angle" टूल पर क्लिक करें।

|-
||05:00
||बिंदु 'B,A,C' , 'C,B,A' और 'A,C,B' पर क्लिक करें।
|-
||05:15
||हम देखते हैं, कि कोण मापे गए हैं।

|-
||05:18
||अब इन कोणों पर कोण-द्विभाजक बनाएँ।

|-
||05:21
||टूल बार से "Angle bisector" टूल चुनें।
|-
||05:25
||"Angle bisector" टूल पर क्लिक करें। बिंदु 'B,A,C' पर क्लिक करें।
|-
||05:32
||दूसरा कोण-द्विभाजक को बनाने के लिए, फिर से टूल बार से "Angle bisector" टूल चुनें।

|-
||05:39
||"Angle bisector" टूल और टूल बार पर क्लिक करें, बिंदु A,B,C पर क्लिक करें।

|-
||05:48
||हम देखते हैं, कि दो कोण-द्विभाजक एक बिंदु पर प्रतिच्छेद करते हैं।

|-
||05:52
||इसे 'D' के रूप में चिन्हित करें।
|-
||05:55
||अब एक लंबवत्त रेखा बनाएँ, जो बिंदु D और वृत्तखंड AB से होकर गुजरती है।

|-
||06:02
||टूल बार से “perpendicular line” टूल चुनें, “perpendicular line” टूल पर क्लिक करें, बिंदु D पर क्लिक करें और फिर वृत्तखंड AB पर क्लिक करें।

|-
||06:12
||हम देखते हैं कि लंबवत्त रेखा वृत्तखंड AB को एक बिंदु पर प्रतिच्छेद करती है।

|-
||06:17
||इस बिंदु को 'E' के रूप में चिन्हित करें।

|-
||06:20
||अब केंद्र D के साथ एक वृत्त बनाएँ, जो 'E' से होकर गुजरता है।

|-
||06:27
||टूल बार से "compass" टूल चुनें, "compass" टूल पर क्लिक करें, केंद्र के रूप में बिंदु D और त्रिज्या के रूप में DE पर क्लिक करें।

|-
||06:37
||'D' और बिंदु 'E' पर क्लिक करें तथा आकृति की पूर्णता के लिए 'D' पर फिर से क्लिक करें।

|-
||06:46
||हम देखते हैं कि वृत्त त्रिकोण के सभी भागों को स्पर्श करता है।
|-
||06:50
||एक अन्तःवृत्त बन गया है।

|-
||06:53
||इसी के साथ हम इस ट्यूटोरियल के अंत में आ गये हैं।

|-
||06:57
||संक्षेप में-

|-
||07:02
||इस ट्यूटोरियल में हमने बनाना सीखा-

|-
||07:05
||चक्रीय चतुर्भुज और

|-
||07:07
||जियोजेब्रा टूल्स का उपयोग करके अन्तःवृत्त।

|-
||07:10
||एक नियत-कार्य के रूप में, मैं चाहता हूँ कि आप एक त्रिकोण ABC बनाएँ।

|-
||07:15
||BC पर बिंदु D को चिन्हित करें, AD जोड़ें।
|-
||07:19
||त्रिज्या r, r1 और r2 के त्रिकोण ABC, ABD और CBD के लिए अन्तवृत्त बनाएँ।

|-
||07:28
||BE ,h की ऊँचाई होगी।
|-
||07:30
||संबंध को सत्यापित करने के लिए,

|-
||07:33
||त्रिकोण ABC के शीर्षों को स्थानांतरित करें।

|-
||07:35
||(1 -2r1/h)*(1 - 2r2/h) = (1 -2r/h)

|-
||07:43
||नियत-कार्य का आउटपुट इस तरह दिखना चाहिए।

|-
||07:52
||इस url पर उपलब्ध विडियो देखें।

|-
||07:55
||यह स्पोकन ट्यूटोरियल को सारांशित करता है।

|-
||07:57
||यदि आपके पास अच्छा बैंडविड्थ नहीं है तो आप इसे डाउनलोड़ करके भी देख सकते हैं।
|-
||08:02
||स्पोकन ट्यूटोरियल प्रोजेक्ट टीम: स्पोकन ट्यूटोरियल का उपयोग करके कार्यशालाएँ भी चलाती है।

|-
||08:06
||जो ऑनलाइन टेस्ट पास करते हैं उनको प्रमाण-पत्र भी देते हैं।

|-
||08:09
||अधिक जानकारी के लिए contact@spoken-tutorial.org पर लिखें।

|-
||08:16
||स्पोकन ट्यूटोरियल प्रोजेक्ट टॉक-टू-अ-टीचर प्रोजेक्ट का हिस्सा है।

|-
||08:19
||यह भारत सरकार के एमएचआरडी के “आईसीटी के माध्यम से राष्ट्रीय साक्षरता मिशन” द्वारा समर्थित है।

|-
||08:25
||इस मिशन पर अधिक जानकारी इस लिंक पर उपलब्ध है।

|-
||08:29
||यह स्क्रिप्ट देवेन्द्र कैरवान द्वारा अनुवादित है। आई.आई.टी बॉम्बे की ओर से मैं रवि कुमार अब आप से विदा लेता हूँ।

PHP-and-MySQL/C4/User-Registration-Part-6/English-timed

2013-10-25T11:16:27Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:00 |Hello everyone, welcome to this Spoken Tutorial, which is more of an update tutorial and not a full length video. |- |0:08 |Some one has p…'

{| border=1
!Time
!Narration
|-
|0:00
|Hello everyone, welcome to this Spoken Tutorial, which is more of an update tutorial and not a full length video.
|-
|0:08
|Some one has pointed out to me that in my register script, I need some kind of check to note if the user has been registered or not by the username that they specify.
|-
|0:19
|Let us go back to our form which is here. Here you can type your fullname. You can choose a username and a password.
|-
|0:28
|I have had these values here before. Let us get rid of them for now.
|-
|0:33
|But, what we want is, when we are choosing the username...
|-
|0:37
|For example, lets say I'm registering with the username "alex". In the database we can see here that username "alex" already exists.
|-
|0:44
|So what we will do is check the existence of the username.
|-
|0:49
|If the username already exists, we are not going to let the user register because we don't want a double username.
|-
|1.01
|If I were to register here, let me put the password in and choose the username as "alex". The username "alex" is already in the database.
|-
|1:13
|Let's just change this for namesake and click register. I have been successfully registered.
|-
|1:23
|Let us look inside our database. We can see that we have two usernames with alex. Now this causes problems while logging in.
|-
|1:33
|The 1st occurrence of name, this one here will be logged in. And this one will be ignored. So this person really will never be able to login into the database.
|-
|1:45
|So let's just delete this.
|-
|1:48
|You need to create some kind of check to see if the username already exists.
|-
|1:53
|This is incredibly easy. There are more that one method for doing it.
|-
|1:59
|But I am going for the simplest and probably the most effective way which is going to work.
|-
|2;04
|The first thing I want to do is, take my code to connect to my database.
|-
|2:11
|Selecting my database. I want to take this up to just where the submit button is checked.
|-
|2:21
|So, it is just connecting to the database. I am inside here.
|-
|2.26
|Then, under here I can start my code to check my username.
|-
|2:31
|Now bear in mind that you can't put your check anywhere. For simplicity I am just going to put it here and kill the rest of the script.
|-
|2.30
|If the username has been found, I can put it in anywhere. Take care when you are using a full length page in your website, the die function will cut off the rest of the code. So I don't recommend using this.
|-
|2:51
|I recommend casing the checks that you already have inside the next statement and not really to kill the script.
|-
|3:00
|But you will get the general idea here on how to work on what we are trying to do.
|-
|3:06
|We need to just type a query that specifies taking a record with a particular username.
|-
|3:18
|So I will say "namecheck query" here. I will call the variable "namecheck" and this will be a mysql query.
|-
|3.28
|I will select "username" for simplicity. This is not going to select all the data.
|-
|3:40
|So I am selecting username from users, since that's our table name here.
|-
|3:47
|I am going to say where username is equal to... If we look up here username of the person that submits the form is in the variable name "username".
|-
|3:57
|So we can just come down here and type "username" now.
|-
|4:03
|Now if we choose the name "alex", this would select every record in the database that has the username "alex" and we can see there's one at the moment.
|-
|4:13
|Now if I were to specify in this case, with only one record...
|-
|4:17
|If I were to specify the username as "Dale", for example, no records will be returned.
|-
|4:25
|So therefore, the username won't exists, if no records would be returned. So we need a function to check how many records are returned.
|-
|4:32
|You can do this by creating a count variable. Its "mysql num rows". It just returns the amount of records or rows that are contained within your query which is called "namecheck".
|-
|4:50
|So lets just test this. I am going to echo out count and then kill the script. The rest of the code does not execute.
|-
|4:57
|Lets go back to register and I'll type my fullname as "alex". Fullname, then choose a username. I am going to choose "Dale".
|-
|5:10
|The password won't be checked so we could skip that.
|-
|5:18
|But I will just put them there for the sake of it and click Register. We see that we have got a value of zero that is returned.
|-
|5:29
|That's because "Dale" is not actually in the data base as a username.
|-
|5:35
|However if I change this to "alex", that will be a small "a".
|-
|5:43
|We have got some... strip tags. The way to deal with case sensitivity as well, is.... so this is another pointer....
|-
|5:53
|When we are taking the username into account what we are going to say "str to lower" here, just to make sure that this will always convert to lowercase.
|-
|6:07
|Next we are going to... let me find it.... Click Register.
|-
|6:13
|We see that the value of one is returned. So the check that we were looking for here is - if this variable we are echoing out, is not equal to zero,...
|-
|6:25
|...then we need to tell the user that the username is already registered.
|-
|6:30
|So here we will create a simple if statement and our block.
|-
|6:36
|Then we can say, if our count doesn't equal zero, meaning there is a record present under this condition where the username is already specified...
|-
|6:47
|...then we can just kill the script and say "Username already taken" or any other message. Coming back here, lets refresh.
|-
|6:56
|We can choose "alex". Let me type in a password and click register. You can see that we have got "Username already taken" error.
|-
|7:07
|If I was to type "Dale" and choose a new name and password and click register, we can see that it has been successfully registered into the database because the username does not exists.
|-
|7:24
|So I will leave it at that. You can see that we have got our registered user in. Add a "str to lower" function, which is a really useful thing to keep everything simple.
|-
|7:35
|Or you can just use a "str to lower" function in your if statement. However, to keep it simple I would recommend that you convert all usernames to lowercase.
|-
|7:52
|You need to incorporate that into a login script as well. You need to convert whatever the user is typing into the login box to lowercase.
|-
|7:55
|I encourage you to play around with it. That's a good way to find some errors.
|-
|8:02
|Try them but if you do need any help, please email me. Make sure you subscribe for updates.
|-
|8:07
|Thanks for watching. This is __________ dubbing for the Spoken Tutorial project.

PHP-and-MySQL/C4/User-Registration-Part-5/English-timed

2013-10-25T11:15:18Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to the 5th part of the User registration tutorial. We are going to tidy up a few bits and pieces together in our registration login…'

{| border=1
!Time
!Narration
|-
|0:00
|Welcome to the 5th part of the User registration tutorial. We are going to tidy up a few bits and pieces together in our registration login process.
|-
|0:11
|Then we'll give a full test to see if it really works.
|-
|0:14
|In the last part, you saw that I registered myself in this database. Everything has worked out fine and I am at the login screen here.
|-
|0:24
|Lets see if I can login. Let's say username is "alex" and my password is the password that I used.
|-
|0:33
|I can see that when I click in login, again, "Incorrect password".
|-
|0:37
|This doesn't mean that my username hasn't been found.
|-
|0:40
|Let me type this in username and type in my password. It will tell me "That user doesn't exists!".
|-
|0:50
|But here, it is saying that my username does exist but my password is wrong.
|-
|0:55
|Now, the reason my password is wrong is that my plain text password here is being compared to my "md5-encrypted" password inside my data base.
|-
|1:07
|The way we do this is, we go back to our login page, which we covered in the previous tutorial - the userlogin tutorial.
|-
|1:18
|At the part where we compare our passwords to check if they match. That's checking our username there and this is checking our password.
|-
|1:34
|We need to check our password. At the moment, let's say I typed in my password as "slicer u k 1".
|-
|1:47
|So, this is the password I am typing in here. Its quite an old one.
|-
|1:56
|"slicer u k 1". Okay and this is checking this and this password here is equal to sliceruk1.
|-
|2:06
|But this "password" is equal "dbpassword". So we are not getting the comparison.
|-
|2:12
|We get to choose this when we encrypt our password.
|-
|2:19
|So now this will actually be equal to this, so this is encrypted "slicer u k 1", which is equal to this "slicer u k 1".
|-
|2:30
|So we are comparing an md5 encrypted password to an md5 encrypted password in our database.
|-
|2:37
|Let me resubmit this form again and login. Oh! error again!
|-
|2:42
|Let me try again. Click on login. No, its not working.
|-
|2:47
|Let's check this. "password" equals to "POST password" so md5 is the password. Let me go back and refresh this.
|-
|3:01
|I type my password. Al-right, I know what the problem is here.
|-
|3:10
|The problem here is that our md5 password is absolutely correct but it is being compared to a password which is cut short in our database.
|-
|3:22
|That's because if we go to our structure and go down to our password field here and edit this, we have currently got a length of 25 as its limit.
|-
|3:37
|So we are going increase the limit for this to, say, 100.
|-
|3:43
|I am not exactly sure how long an md5 string is, but I will say length value = 100. Save that.
|-
|3:50
|I am going to browse our table and delete this value. Then I am going to go back and re-register.
|-
|4.00
|So, register. Choose your username. Let's say "alex", like I said before. Choose a password, let's say "slicer u k 1". And I will click "Register".
|-
|4:14
|"You have been registered. Return to login page".
|-
|4:17
|Now, let's check our database again. This is looking longer already, it hasn't been cut short because I have changed the length of this.
|-
|4:27
|So now when I try to log back in and let me type this properly.
|-
|4:33
|We can login and we are in. Okay so check things like string length.
|-
|4.43
|Hopefully you have got this.
|-
|4.45
|If you want me to expand this tutorial please just let me know.
|-
|4:52
|And that is user registration.
|-
|4:55
|This is followed on from our user login tutorial. So by putting these together, we have got a fully functional user register and login process.
|-
|5:04
|I will be using this in a lot of my project work. Say for example.
|-
|5:12
|I might create a project on something that uses a user login and user registration. So I will be using this a lot.
|-
|5:19
|So check my projects on user login and registration for more information.
|-
|5:28
|If you have any questions or would like me to expand on anything, please just let me know.
|-
|5:35
|Please subscribe for updates in the future. Thanks for watching. This is _________ dubbing for the Spoken Tutorial project.

PHP-and-MySQL/C4/User-Registration-Part-4/English-timed

2013-10-25T11:14:23Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to part 4 of "User Registration". We are going through these processes thoroughly. We are using security and checks for our "userna…'

{| border=1
!Time
!Narration
|-
|0:00
|Welcome to part 4 of "User Registration". We are going through these processes thoroughly. We are using security and checks for our "username" and "password", which is really good.
|-
|0:10
|If I am being confusing please let me know. Drop me an email or a comment through "youtube".
|-
|0:18
|Getting onto "registering our user" process.
|-
|0:21
|We need to connect to our database first. We are going to open up our table and input our values.
|-
|0:29
|You might think this is very simple.
|-
|0:33
|So, first of all, I am going to write a message saying "Success".
|-
|0:39
|Back to our page. I'll just go back into this and check all our checks that we had created first.
|-
|0:52
|So I will click "Register" and it says "Please fill in all fields".
|-
|0:56
|If I fill a variety of fields, then forget one and click register its still saying a message.
|-
|1:01
|So I am going to type "alex" and am going to choose my username. Then type my fullname and I am going to choose a password which is "abc".
|-
|1:11
|The next one I will just type a mix of characters. So, when I click register, it should say "Your passwords do not match".
|-
|1:20
|So, go back to square one. We are going to type "Alex Garrett". We will choose a username. We are going to choose a password say "abc".
|-
|1:29
|Since this is under 6 characters, when I click "Register" - "Passwords must be between 25 and 6 characters". So that check works.
|-
|1:41
|Now what I will type is my fullname as "Alex Garrett" and my username as "alex". The password is going to be just a full length password.
|-
|1:54
|More than 6 characters. I will click "Register". You can see that - "Length of the username or fullname is too long!".
|-
|2:01
|So you can write these checks if you want. I'll leave it up to you.
|-
|2:05
|So, at the moment we have now got a successful form validation.
|-
|2:11
|Now what we will do is continue with registering our user.
|-
|2:17
|Now this form validation isn't good. Every time we get an error, these fields disappear; they are gone.
|-
|2:31
|And the user has to retype.
|-
|2:33
|So what I am going to say is, we have got our fullname, username and password variables here.
|-
|2:42
|Considering this is a php page itself, we can incorporate php into this html code over here.
|-
|2:52
|Under your fullname I am going to say "value equal to" a value inside the box and open up a phptag.
|-
|2:58
|Close the php tag inside. Here I am going to echo username or rather fullname.
|-
|3:07
|I will do exactly the same with our username. So value equals, open php tags, close php tags and echo out username.
|-
|3:22
|Make sure the line terminator is in there.
|-
|3:25
|Now what will happen is, let's say I choose this ridiculously long name here and choose a username say "alex".
|-
|3:34
|You don't want your passwords to be stored. So just leave that upto the user.
|-
|3:41
|I've got a too long username and it should produce this error again.
|-
|3"44
|When I click register, this time its kept our fullname and username.
|-
|3.51
|So it's a rule. If you get an error and you have to retype your username, your fullname, your password or your firstname, middle name, your surname; I don't know how many fields are there in your user form....
|-
|4:04
|It's annoying to type your name over and over again.
|-
|4:08
|So using this, your php echo inside php tags, inside the values of your html input type and it so useful and much more convenient for the user and much more user friendly.
|-
|4.22
|Okay, otherwise echo "Success!!". I have not actually given a successful form yet.
|-
|4:29
|So I will type "Alex Garret" and my password is going to be over 6 characters and under 25 characters.
|-
|4:37
|Click "Register". Oh! an error messge. Let's see.
|-
|4:40
|We have picked up an error and.... - if string length of the password is greater than 25.....
|-
|4:48
|...or the string length of the password is lesser than 6.... echo password - should be enough.... but we have run into the same problem.
|-
|5:03
|I have just realised that we have an encrypted value for our password. And our md5 encrypted string is massive. It's much bigger than 25 characters.
|-
|5:14
|So again what I will do is take this block of code, that has been encrypting our password. Cut out that and bring it down underneath "register the user".
|-
|5:26
|So you can see from experience that order of things are very important. If you get errors like this go through your code.Look at them and realise what are you doing.
|-
|5:34
|Use echo things out in between your code, just as a sort of debug process.
|-
|5:41
|Now I will go back to my form and I'm going to retype my perfectly acceptable password in.
|-
|5:46
|Click on "Register". We have got our "Success" message.
|-
|5:50
|So you see, going through your code helps to see if there are problems.
|-
|5:56
|I am a bit quick at realising these. But sometimes I pause the video, have a look at the code and then resume the video. I don't like to keep the viewers on hold.
|-
|6:02
|You, too, will soon realise your mistakes. So we have got our "Success" and now we will say "open our database".
|-
|6:13
|To do this, we need our connect variable, no you don't... I am going to say my "sql connect".
|-
|6:20
|And am connecting to my local host server, which is my computer and root and my password is nothing.
|-
|6:31
|I am going to say "mySQL select db". This is going to select our database. So let's say "select data base".
|-
|6:38
|Even though this is obvious. This is php login and here I am going to say give a query.
|-
|6:49
|So "query register". This is going to be equal to "mysqlL query".
|-
|6:54
|This is the important part of this tutorial where we actually input our values and we register our username.
|-
|7:02
|Now let me scroll down so you can see. This is "INSERT INTO users". If we go back to here, this is it "php login" is our table that we have selected. So "mySQL select db php login".
|-
|7:20
|And we are inserting into "users" which is our table into the database.
|-
|7:28
|And we will say values brackets, each value of the table. So each field that is present into the table.
|-
|7:40
|So if we go back to here and click on browse or structure - that one - we got id, name, username, password, date. So 1 2 3 4 5.
|-
|7:52
| Here also we need 1 2 3 4 5. The id is auto increment, if you know from the last tutorial.
|-
|8:00
|So we just need in here; the order is very important.
|-
|8:06
|We have got our name, username, password, date. So this is just name, username. This is password, no need for repeat password, that was just for check and this is going to be the date.
|-
|8:19
|So these variables here, if you are not too sure, are from up here, where we have our fullname, username, password and date.
|-
|8:28
|Lets change this to fullname. Okay, so this should work. After this is done I will say, "You have been registered". In fact what I am going to do is say "die".
|-
|8:48
|"You have been registered. Click here to return to login page". Put this as a link back to out index page in which the user could login.
|-
|9:08
|You can see how it executes in a second and here is my previous page.
|-
|9:14
|Lets say "Alex Garret". Choosing username as "alex" and this as your password. "You have been registered. Return to login page".
|-
|9:32
|I will now check my database in "browse". You can see that I have got "Alex Garret". My id is 3 my username is "alex"
|-
|9:42
|My password is my encrypted password and my date is date.
|-
|9:45
|That's it. So in the next part I will show you how to tidy a few things out and test the login process.
|-
|9:52
|So I'll see you there. This is __________ dubbing for the Spoken Tutorial project.

PHP-and-MySQL/C4/User-Registration-Part-3/English-timed

2013-10-25T11:13:25Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0.00 |Welcome to the 3rd part of the User Registration tutorial. In this part we are going to check for existence of all that was discussed in t…'

{| border=1
!Time
!Narration
|-
|0.00
|Welcome to the 3rd part of the User Registration tutorial. In this part we are going to check for existence of all that was discussed in the last part.
|-
|0.07
|Let us have a quick recap of what was done in the last part.
|-
|0:09
|We have striped the tags off our "fullname" and "username".
|-
|0:12
|We have stripped and encrypted our "password".
|-
|0:17
|Remember this sequence for the functions, so that we are not striping off our encrypted value.
|-
|0:23
|Here we are going to start our registration process. I'll be checking the existence of all these.
|-
|0:33
|Just before I do that I am going to set the "date". Now, this is using the date function.
|-
|0:38
|Inside we have "Y" for the year "m" for the month and "d" for the date.
|-
|0:45
|It's the capital "Y" for a 4-digit year. If we use a small "y", we would have a 2-digit year.
|-
|0:59
|So, in my database, at the moment. I have my year first, then my month and my day and these are separated by hyphens.
|-
|1:08
|You can see this when we enter our database here and say insert a value into "users".
|-
|1:13
|We can see that the "date" is in a specific format, if we use this kind of function here.
|-
|1:19
|When I click today, you can see here that we have got the year in a 4-digit format and our month here and our day here, separated by hyphens.
|-
|1:29
|Its adjusted into that structure inside my database.
|-
|1:33
|Okay, so "if submit", then we need to check for existence. I will add a comment here "check for existence".
|-
|1:46
|Now, this is really easy. All we want to do is we have to say is "if" statement and a block a code after that.
|-
|1:55
|The condition will be "if fullname, username, password and repeat password exist".... we have the evidence here.... we will say "if username" followed by "and", so double ampersand symbol.
|-
|2:10
|Then we will say "password" and then we'll say....
|-
|2:14
|Oh! I forgot the "fullname" here, so I'll add it here.
|-
|2:18
|Separated these with a double ampersand sign.
|-
|2:21
|The last one is "repeat password" so type that.
|-
|2:26
|We are going to require all of these.
|-
|2.31
|Else, we will say - echo "Please fill in" and in bold, "all fields".
|-
|2:42
|We will put a paragraph break after that.
|-
|2:45
|Also let me put a paragraph break before the form so that we don't need to add it to every error message we give.
|-
|2:57
|So that's it. Let's just try it.
|-
|3:00
|I will go back to my "register" page. We got it here. Lets click in register.
|-
|3:05
|"Please fill in all fields".
|-
|3:07
|Lets type a couple of fields here.
|-
|3:10
|Lets choose one of our passwords. We will not repeat our password.
|-
|3:15
|Register. Oh! repeat password..... repeat password.
|-
|3.32
|The reason this is not working at the moment is, an "md5" value of nothing is equal to an "md5" string of text. An encrypted string of text.
|-
|3:44
|So, I realise what we need to do is, take out the "md5" function here.
|-
|3.51
|Make sure you remove the end brackets. I will come down here and check for all of our data.
|-
|3:59
|So, let me go back and try this again.
|-
|4:01
|Remember it didn't work before when we didn't chose a "repeat password".
|-
|4:05
|So if I didn't chose a password or a repeat password we get our error.
|-
|4:10
|If I again choose a value except the repeat password, we still get this error.
|-
|4:16
|That's the problem. What we should say is - if everything exists then we can convert our password and repeat password.
|-
|4:25
|So I will just say "password" is equal to "md5" of password".
|-
|4:30
|This will encrypt our original variable value and store a new password code in the same variable.
|-
|4:40
|We also need to say "repeat password" equals "md5" and "repeat password".
|-
|4:52
|Here comment this as "encrypt password". We have encrypted our password.
|-
|4:58
|Now we will go ahead and add all our data into our data base.
|-
|5:07
| I am going to do this. Because we have got our data going to our registration, we are going to set a maximum limit for each data that is input.
|-
|5:19
|Now we say 25 characters for our fullname, username, password and repeat password. So the maximum value is 25.
|-
|5.32
|So I will say- if the string length of username is bigger or greater than 25.... or.... string length of the fullname is greater that 25
|-
|6:00
|Let us look at these individually and say if the length of your username or fullname is too long.
|-
|6:09
|Let me put this correctly.
|-
|6:12
|If each of these values is greater than 25 or bigger than 25.
|-
|6:15
| We are going to echo out these values saying "username" or...... no....
|-
|6:25
|Let me say "Max limit for username or fullname are 25 characters".
|-
|6:36
|Otherwise I will proceed to check my password length.
|-
|6:40
|Now I have decided to do this - "check password length" because I want a specific check for this.
|-
|6:48
|Let me say "if string length of my password is greater than 25.... or.... string length.....
|-
|7:08
|No... um... lets get rid of this, get rid of "else".
|-
|7:15
|The first check I want to do is to see if my passwords match.
|-
|7:21
|Let me say "if password equals equals to repeat password" then continue the big block of code.
|-
|7:31
|Otherwise echo out to the user "Your passwords do not match". Okay?
|-
|7:41
|So, you can type here and we can keep checking our character length.
|-
|7:44
|Now to check the character length of "username" and "fullname". So, "check char length of username and fullname".
|-
|7:56
|And that is going to be what we said before, "if username is greater than 25"
|-
|8:02
|Rather if the string length used in this function is greater than 25...
|-
|8.08
|Or the string length of fullname is greater that 25, then we echo "Length of username or fullname is too long!".
|-
|8:24
|So, just to keep it simple and then otherwise we will say "check password length".
|-
|8:36
|Here I am going to specify or say "if"... now remember our passwords match...
|-
|8:42
|So we only need to check this on one of the password variables.
|-
|8:46
|Here I will say - if the string length of the password is greater than 25 or string length of our password is lesser than 6 characters....
|-
|9.00
|...then we will echo out an error saying "Password must be between 6 and 25 characters". This will work for sure.
|-
|9:16
|We will continue this discussion in the next tutorial.
|-
|9:19
|Before that let me just conclude this with an "else" statement.
|-
|9:25
|So, otherwise we will say "register the user". Our code to register the user will go here.
|-
|9:35
|In the next tutorial we'll test this out and will learn how to register the user and we will put our code here in that tutorial.
|-
|9:42
|This is basically for checking a minimum or maximum limit on our password and this block of code here is will be our magical "register the user" piece of code.
|-
|9:52
|So join me in the next part. Bye-bye. This is ____________ dubbing for the Spoken Tutorial project.

PHP-and-MySQL/C4/User-Registration-Part-2/English-timed

2013-10-25T11:12:25Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to the second part of the User registration tutorial. |- |0:05 |In this part we will check the existence of these forms. Let us jus…'

{| border=1
!Time
!Narration
|-
|0:00
|Welcome to the second part of the User registration tutorial.
|-
|0:05
|In this part we will check the existence of these forms. Let us just get rid of these values in these fields that we've typed.
|-
|0:12
|And we are going to do the encrypting of the password.
|-
|0:16
|We are also going to move html tags.
|-
|0:23
|Consider I am encrypting for my login part... Let me just open this file "login dot php".... And we will have to make a few adjustments to my page here.
|-
|0:37
|We would be taking a password straight for our database.
|-
|0:44
|So we need to change this "dbusername" value and our "dbpassword".
|-
|0:50
|If you have not watched the 1st video you need to do so, to be able to write this code out.
|-
|0:56
|Back to our "register dot php" and first of all we will check for "submit".
|-
|1:02
|I don't have a "submit" variable at the moment.
|-
|1:06
|So this will be equal to "dollar sign underscore POST" and now "submit".
|-
|1:14
|This is because when the user clicks the submit button here, this will hold a value of "Register".
|-
|1:23
|And this will say "if the user has clicked this button", then we can carry on with our code.
|-
|1:31
|Now, the other values we need to get are the name of the user. So, the fullname of the user. I will just type "fullname = $ underscore POST" and "fullname". You can just see evidence of this here .
|-
|1:51
|So, we are just mimicking the name given over here, once we have got fullname, username, password, repeat pasword, okay?
|-
|1:59
|So, we have got "fullname" and now we have "username".
|-
|2:09
|What I will do is, whenever I code, I copy and paste these down.
|-
|2:12
|So "pasword" and "repeat password". Here is the "password" and "repeat password". I'm going to change these values. No need to type them out.
|-
|2:26
|If you are new to php I would suggest that you type these out again and again just for practice. So you won't forget them.
|-
|2:34
|So we have got all our values here.
|-
|2:37
|So, if "submit". I'll just echo them out to show you that all these have been submitted correctly.
|-
|2:49
|I suggest you do this for debugging. You might have spelt something wrong and its no good if you are trying to put data which is spelt wrong into your database.
|-
|2:54
|Here I will say echo the "username" and forward slash and "password". Then "repeat password" and then "fullname" of the user followed by the line terminator.
|-
|3:16
|So we have got all the data here that we have extracted from our form.
|-
|3:21
|So I will just comment this as "form data".
|-
|3:24
|You should now know how to do this by now.
|-
|3:27
|If the form has been submitted, I am going to echo this out, to make sure it is there.
|-
|3:32
|Here if I click "Register" nothing happens. I have been clicking and nothing is being done.
|-
|3:40
|So here I will just type my full name and I can type my username and choose a password which will be "abc" for now.
|-
|3:49
|Click on "Register" and nothings happened.
|-
|3:52
|So "if submit", "POST submit".
|-
|3:57
|This is why. In our "form action" we need to set a "method" which is going to be "POST".
|-
|4:05
|I forgot to include that.
|-
|4:07
|We need a method of "POST" otherwise it's default as "GET". Yes, you can see it all up here.
|-
|4:13
|What I will do now is refresh this page and retype my data.
|-
|4:21
|So that's "Alex Garrett" and username "alex". This will be "abc" and "abc". Click on "Register" and my data has been shown here.
|-
|4:30
|We can check if its correct. My fullname was "Alex Garrett". My username chosen was "alex" and of course "abc" here and here.
|-
|4:40
|Now I want to encrypt these passwords.
|-
|4:43
|And if you read up on Google or any search engine about "MD5 encryption" that's "M D 5". Let me just write this down for you. It is a very useful way of encrypting data.
|-
|4:54
|Let's just get rid of this. Now everything is right. Md5's function in php takes a string or numerical value, string value or just a data value.
|-
|5:09
|And this is encrypted to MD5 encryption.
|-
|5:13
|Lets say I encrypt "alex" to Md5. Let's echo it out and refresh.
|-
|5:19
|Don't resend the data. So it should just come straight back from here and re-click on register.
|-
|5:26
|Let's go here and see if "if submit" is ok. Let's take out this condition and refresh.
|-
|5:34
|So that is my name encrypted in Md5.
|-
|5:39
|It's always the same length and I believe its impossible to crack unless you encrypt a string and then you compare it to your two encrypted values.
|-
|5:53
|If you don't understand this I have a tutorial on "MD5 encryption". So don't worry. Just go ahead and watch it.
|-
|6:01
|Now I will say "if submit" and then our code.
|-
|6:08
|My fullname, username and password are fine.
|-
|6:10
|I will add this "MD5 encryption" around my submitted password and repeat password.
|-
|6:21
|Don't forget that.
|-
|6:23
|Then if I echo out, lets say, "password" and just have a break and "repeat password".
|-
|6:32
|When I go to refresh or rather when I go to submit my form, I will say my password is "abc" and my repeat password is "abc".
|-
|6:45
|Register that.
|-
|6:46
|You can see that my 2 encrypted passwords are identical and both of them are ready to be put in the database.
|-
|6:52
|Now if you say someone hacked into your database and finds out people's passwords which is typed in as abc, they will be able to get it easily.
|-
|7:01
|Let me type it here. But now they won't be able to find what it is because that's encrypted.
|-
|7;06
|Okay, we have got our passwords encrypted. Now we are going to strip any tags of our data and to do this we have strip tags.
|-
|7:21
|"strip tags". This will strip HTML tags.
|-
|7:25
|When I am using my password, I will not say "strip tags" before the "md5" function.
|-
|7:36
|I will use the "md5" Function to encrypt the already striped version of my password.
|-
|7:41
|So that should be fine.
|-
|7:43
|Let me copy and past that down there.
|-
|7:46
|Ok, that's done and lets go back and see that.
|-
|7:54
|I type in "html" here and for my username I say "body" and just keep my password as "abc".
|-
|8:02
|Lets go and echo out "username" and just add a break.
|-
|8:12
|Fullname. Echoing out all that will be typed in here.
|-
|8:19
|I will just type "test" after this and "test" after this.
|-
|8:23
|Now this "strip tag" function must get rid of this "html" and this "body".
|-
|8:27
|You should just have "test" and "test" given to us.
|-
|8:31
|Oh! We have got an error.
|-
|8:34
|Lets go back and check. Didn't use the line terminator. Refresh and Resend the data.
|-
|8:38
|As you can see over here, we got "test" and "test". So whatever you type in here as tag or as html tag, its just blank.
|-
|8:49
|So you know some people can be funny and say my username is going to be an "image". Register. That doesn't work !
|-
|8:59
|It isn't echoed up here.
|-
|9:01
|But if we take say "alex" and we click "Register", its taken into account.
|-
|9:05
|So that's it. In the next tutorial we will check if every single field is typed in as they are all required for registration.
|-
|9:15
|Ok I'll see you in the next part. Bye. This is _________ dubbing for the Spoken Tutorial project.

PHP-and-MySQL/C4/User-Registration-Part-1/English-timed

2013-10-25T11:11:34Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to the Spoken Tutorial on how to create a user registration form and how to register a user into mysql database. |- |0:09 |One sugg…'

{| border=1
!Time
!Narration
|-
|0:00
|Welcome to the Spoken Tutorial on how to create a user registration form and how to register a user into mysql database.
|-
|0:09
|One suggestion before starting this tutorial is that you watch my "User login" tutorials first. I've posted a link to it.
|-
|0:19
|I would suggest that you do so before going through these tutorials. The reason I have created "User login" before "User registration" is because I find it a lot easier to do the "User login" process before doing the "Registration" process.
|-
|0:34
|Once you've got the "login" process right and you've got the fields in the database you can start our registration process.
|-
|0:43
|I just find it a lot more easier to this way, as you know what you're registering in to your data base.
|-
|0:49
|To start with, in the first part we will create our form and check for the existence of my login information.
|-
|0:56
|From my existing tutorials, I am using my "login session" folder.
|-
|1:03
|This here is my login session and all my fields but here I will create a new file.
|-
|1:12
|Just add some tags first.
|-
|1:15
|I will create this inside my login session folder with the "index dot php" which is the main page you saw.
|-
|1:22
|Log in, log out and the member page if users are logged in and I will save this as "register dot php".
|-
|1:32
|I am creating a user registration form so that the user can register before they decide to login.
|-
|1:40
|I have created my "register dot php" and I am also going to open my index file. I will create a link underneath the form.
|-
|1:48
|And this is going to be just a link to that register page and I will type "Register" here.
|-
|2:02
|So what we get here is a link called "Register" which goes to our page where we have nothing at the moment.
|-
|2:09
|Following from the last tutorial where we could login, I will just put a link to a page that you can register before you do this.
|-
|2:20
|Before we were just typing data into our database. If I open up a new window, I will go across to "php my admin".
|-
|2:29
|And this is the database that will be used called "php login" and this is my "users" table.
|-
|2:38
|You can see I have added an extra field called "name" and I will add another field called "date".
|-
|2:47
|At the end of the table that's going to be called "date" and it will be in date format. So where is it? Um.... Here it is.
|-
|3:04
|Before you get confused about what the date will be, it will be the current date when the users registered and we go there and save that.
|-
|3:15
|So from the last tutorial on the "User login" we just have id, username and password. Now I have added a name so its going to be the user name and we've added date, the date when he registered.
|-
|3:29
|Just browse in here. We have got a couple of values here already.
|-
|3:35
|I will delete these because I am registering my users. So I can start from a clean database.
|-
|3:40
|Assuming I have got no users at all and I have got my link here to the register page, here is my register page.
|-
|3:49
|Now I'll briefly explain this html code which tells you how to create this page and we will have a form first of all.
|-
|3:59
|This is going to be a self submitting form. It's going to submit back to "register dot php".
|-
|4:07
|And we are going to create a table and inside this we will have a row here.
|-
|4:13
|Then we have two columns, so two td blocks here and the 1st one will have, say your fullname
|-
|4:21
|I leave it up to you. Just to speed up I will do it this way.
|-
|4:29
|In our second column here, I will put my input type as "text" and my name equals "fullname".
|-
|4:38
|So you can see at the moment, let me go back to my original page, click on register.
|-
|4:47
|You can see, this is one column here, split down here. This is another column with the input box in.
|-
|4:56
|And I will also go up here and inside the php code, I will echo out a header. I will explain a bit later why I have done this.
|-
|5:07
|So we got that. At the moment we have this. To speed up, I will just copy and paste this down.
|-
|5:15
|So make sure you choose from "t r" till "end t r".
|-
|5:22
|I will paste it down and then I will say "Choose a username" and obviously I will change this to "username".
|-
|5:32
|I will paste that again and say "Choose a password". This text is just to secure in case any one's looking over our users' shoulder or any screen capture software being used to infiltrate this computer.
|-
|5:47
|And the next one down here I will just copy and paste this here to say "Repeat your password".
|-
|5:58
|Again "password" here.
|-
|6:07
|We can't say "password" again so I will call this "repeat password".
|-
|6:10
|We will use this to compare the passwords once they have been submitted as a safety measure in case the user made any mistakes.
|-
|6:20
|And we don't need any other field. That is the last one.
|-
|6:24
|What we do need is the "date". But I will do that when I submit the form.
|-
|6.31
|Okay so this is our form created. Lets go back and refresh.
|-
|6:37
|You can see how this is evenly arranged, that's why we have used a table.
|-
|6:42
|We need a submit button also.
|-
|6:45
|Underneath our table, I will create a paragraph break.
|-
|6:48
|And my input type here is going to be "submit"; my name is going to be "submit".
|-
|6:54
|And we have to check the existence and the value will just be "register".
|-
|6:57
|Lets refresh. There we are, you can see that the password fields have been blanked out.
|-
|7:05
|Also we have a fullname and username there for the users to type their values.
|-
|7:12
|Okay that's about it. I will stop the tutorial here.
|-
|7:16
|If you are following this step by step, make sure you have got your form written out and try out another design if you wish.
|-
|7:25
|I wish I had more time to do it. So go ahead and create your form as you want.
|-
|7:30
|Do anything you want to it. Change these labels.
|-
|7:33
|Just make sure you got your boxes and your register.
|-
|7:35
|In the next part we will talk about checking that the user has typed each one of these fields in.
|-
|7:44
|We will compare the passwords to see if they match. I mean if I say there are two passwords and these don't match as they differ in character length, then the user can't register as they might have made a mistake.
|-
|7:59
|I am sure most of you watching must have registered at some point and would have typed in your password again.
|-
|8:07
|We will also encrypt our passwords and remove any dangerous or any pretentiously dangerous html tags from these forms. So we'll have some bit of security to our registration form.
|-
|8:17
|So I see in the next part. Thanks for watching. This is Sidhartha dubbing for the Spoken Tutorial project.

PHP-and-MySQL/C4/User-Password-Change-Part-3/English-timed

2013-10-25T11:09:01Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:03 |This is the 3rd part of my “change password” tutorial. In this part, we’re going to change the password in the database. |- |0:11 |We…'

{| border=1
!Time
!Narration
|-
|0:03
|This is the 3rd part of my “change password” tutorial. In this part, we’re going to change the password in the database.
|-
|0:11
|We’ve already connected to our database up here.
|-
|0:14
|We’re already connected here so there’s no need to reconnect, since that command has already been reissued.
|-
|0:23
|I’ll create a new query called “query change” and that will be equal to “mysql query" function.
|-
|0:30
|Now, this is a new bit of code. So I will scroll down so that you can see it easily.
|-
|0:36
|This is “UPDATE”. So I’m going to say “UPDATE users” - which, you can see is our table - so to update our "users" table.
|-
|0:44
|I will say “SET password equal to new password”
|-
|0:51
|making sure I use inverted commas here.
|-
|0:56
|Then I’ll say WHERE username is equal to the "user" variable that I’ve got on my page currently.
|-
|1:03
|Now this equates
|-
|1:07
|to what we have in this column here.
|-
|1:12
|So since we’ve already processed our php session,
|-
|1:18
|that is equal to "Alex".
|-
|1:21
|This piece of code is basically saying “update the table, change the password to the new password entered by the user. – this is the password they want.
|-
|1:32
|and change this “where” to Alex,
|-
|1:37
|as this is equal to Alex.
|-
|1:40
|So, this password will be changed because this username is equal to Alex.
|-
|1:45
|So this starts with 900 and as soon as we change it, we can refresh this and check that it actually has been changed.
|-
|1:56
|So I’ll just add a few more things
|-
|2:03
|Let’s just put this back up here.
|-
|2:06
|And I’ll kill the page and say “die” and then say “Your password has been changed”.
|-
|2:15
|Then I’ll put a link in saying “return” and that’s going to return to the main page.
|-
|2:23
|And that is “index.php”.
|-
|2:27
|Before we kill the page, I’m going to destroy the session.
|-
|2:31
|So “session destroy”.
|-
|2:33
|The reason being, once the user has changed their password, this link will take them back to the main page, and this will destroy the session.
|-
|2:42
|So they’ll need to login again using the new password.
|-
|2:59
|So if we test this, remember in here, my current password is "abc" whose md5 hash starts with 900.
|-
|3:00
|And if I go back here, write my old password- "abc", my new password "123" and click “change password”. , we see that all the validation has been checked, our password has been changed,, and we get this message to return back to the main page.
|-
|3:18
|Now if I try to go back to the member page, you will see that you must be logged in. Our session has been destroyed, as we used our “session destroy” function here.
|-
|3:32
|And also, when I login again and type "abc" as my password which is my old password, we get an “Incorrect password” message.
|-
|3:43
|If I try "123", you’re in, and evidence of this is shown in here.
|-
|3:50
|Let’s just go back and click “browse”. Lets scroll down and we can see that the password has been changed from 900 to 202.
|-
|3:59
|Therefore this is a completely new hash and a completely new password.
|-
|4:06
|So everything’s working fine. You can see that it is quite simple to do this.
|-
|4:11
|All you need to do is learn your "sql" queries properly. I have tutorials on that, too.
|-
|4:18
|And you need to think logically about how to check your old password, and your two new passwords,
|-
|4:24
|Obviously when we did our registration, we had a limit for how big the password should be.
|-
|4:31
|I’ll leave that to you to enter another check to see if the password should be bigger than 6 characters or no bigger than 25 characters.
|-
|4:42
|So really there are a lot of checks you can do, but this is the basic skeleton for changing the password in php using a mysql database.
|-
|4:53
|Hope you enjoyed this. If you have any comments or questions please let me know. Also subscribe to video updates.
|-
|5:01
|Thanks for watching! This is Harini dubbing for the Spoken Tutorial Project.
|-

PHP-and-MySQL/C4/User-Password-Change-Part-2/English-timed

2013-10-25T11:07:44Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to the 2nd part of our “Change Password” tutorial. In the last one, we learnt how to check if our forms were submitted. |- |0…'

{| border=1
!Time
!Narration
|-
|0:00
|Welcome to the 2nd part of our “Change Password” tutorial. In the last one, we learnt how to check if our forms were submitted.
|-
|0:09
| We’ve got our data values in here.
|-
|0:13
|Please remember that inside our database, our passwords are encrypted.
|-
|0:18
|So, as soon as these fields are coming in, I will encrypt them into an md 5 hash.
|-
|0:27
|Make sure you put the brackets.
|-
|0:35
|What I have highlighted here is our parameter.
|-
|0:38
|So, here we will have our md5 encrypted passwords.
|-
|0:43
|We will need to check this field to see whether they exist or not.
|-
|0:51
|At the moment when we submit our form, we see that nothing really happens.
|-
|0:57
|First I will say “check password against db” and then we have to connect to our database.
|-
|1:08
|We have already connected to the database in several of these pages- like the Login page.
|-
|1:15
|You can put this into a separate file, say, “include” and” include connect .php” with your one time login script in, so that you don’t have to keep typing it.
|-
|1:29
|But for our tutorial's sake, I will keep typing it over and over again because this is a good way to learn.
|-
|1:35
|We type here - "connect = mysql_connect".
|-
|1:40
|And we will be connecting to our local host database, with my username as root and my password as nothing, I am going to select my database.
|-
|1:50
|So that is “phplogin” which here. Lets go there and you can see it here.
|-
|1:58
|Our table is "users", which we can use later on.
|-
|2:01
|Next we will create a query to get the passwords.
|-
|2:05
|So I will type “ query get” which is equal to mysql.......... "mysql query" and here we will type "SELECT password" - We need to ascertain the password from the database "users".
|-
|2:26
|You can see here. This is the "users" table.
|-
|2:31
|Then we type “Where username is equal to user”. This is our session variable holding our user’s user name.
|-
|2:39
|So, what we are doing is we are selecting our password hash from this table where the username is equal to the session name, and that is equal to “Alex”.
|-
|2:49
|So, that should be a successful query. And you can type at the end “ or die "Query didn’t work”" - some error message.
|-
|2:59
|You can be a bit imaginative with these error messages and type what you like.
|-
|3:08
|Same here. You can say “or die”. You can add your own error message in here but to save time, I am not going to right now.
|-
|3:17
|Now, we will use this slightly differently, before we use the "while" function to loop through every record in the data base.
|-
|3:25
|I was informed about this method through a comment someone posted. I will say "row = mysql_fetch_associative". And that‘s "query get"
|-
|3:41
|We will set “old password db” which is a new variable name . Don’t mistake this with the old password that has been submitted.
|-
|3:50
|Our old password inside the database will be equal to our row.
|-
|3:55
|Remember this creates an array.
|-
|3:58
|So this value is” password”, because inside our database, this is “password” here. You need to use the labels.
|-
|4:06
|So from here on we can check our passwords.
|-
|4:08
|Checking our old passwords and our new passwords is just a simple “IF” statement.
|-
|4:16
|Lets type - if the old password is equal to the old password inside the database.
|-
|4:25
|These are both md5 hashes because we converted them into an md5 hash earlier.
|-
|4:30
|So, if they are equal then we’ll run a block of code, otherwise we’ll kill the page and say ” Old password doesn’t match!”.
|-
|4:44
|So here, assuming we’ve got through the first stage of our validation,- we checked the old password with to old password in the database - now we need to our two new passwords.
|-
|4:57
|Now this is just as simple as typing “if new password is equal to repeat new password”, then we can write a block of code, otherwise we can just kill the page and say “ New passwords don’t match!”.
|-
|5:20
|So here this is “success” and then we’ll say “change password in database”.
|-
|5:31
|So now what I’ll do is echo out “success” and I’ll go back to my page.
|-
|5:38
|I’ll type my password wrong on purpose. So I’ll just type this.
|-
|5:41
|My new password I’ll type as "abc" and then clicking on “change password” we get the message "Old password doesn’t match!".
|-
|5:49
|If I type "abc" as my old password, which it is, and "123" as my new password and random letters in the next, we should get.....Oh "Old password doesn’t match!"
|-
|6:00
|Lets go back and check the code. Old password......... row - password............ query get........
|-
|6:13
|What we can do here to debug is just say “echo old password db” with a break on the end, and just say echo old password with another break.
|-
|6:31
|What we can do now is, run the script again, so old password equals "abc", new password equals "123" and then random letters.
|-
|6:44
|okay so let’s compare these. They both look the same to me, so we can see that we’ve got a problem here.
|-
|6:50
|Again lets check the code. Checking for the spellings.
|-
|7:15
|Ok I just found out the problem. If I go back to my database here, we see that I had added in this value myself and I had created this space at the end of this - you can see it highlighted in blue - I’ll just get rid of that quickly and I’ll come back to my page.
|-
|7:33
|I’ll login again as usual and quickly change my password, I’ll put my old password in correctly and random text for my two new passwords.
|-
|7:45
|You can see that my two new passwords don’t match.
|-
|7:49
|We've echoed this out already, so now we can delete this.
|-
|7:53
|So assuming my passwords do match, let me echo this success message.
|-
|7:58
|So let’s just delete these. I put them for debugging.
|-
|8:02
|I’ll just type in my old password, my new passwords 123 and 123, click change password, and we’ve got success.
|-
|8:10
|So I apologise for that last slip-up there.
|-
|8:18
|So in the 3rd part of this tutorial, we will continue with updating the user's password and just making sure everything’s working properly.
|-
|8:29
|Thanks for watching. This is Joshwa Mathew dubbing for the Spoken Tutorial Project.

PHP-and-MySQL/C4/User-Password-Change-Part-1/English-timed

2013-10-25T11:06:49Z

Gyan: Created page with '{| border=1 !Time !Narration |- | 0:00 |Welcome. In this tutorial, we will talk about how a user can change their password. |- |0:08 |We will learn how to give the user the opti…'

{| border=1
!Time
!Narration
|-
| 0:00
|Welcome. In this tutorial, we will talk about how a user can change their password.
|-
|0:08
|We will learn how to give the user the option to change their password if they want to.
|-
|0:13-
|This shouldn’t take too long. It will be covered in 3 parts.
|-
|0:18
|We’ll give the user a form and ask the user to type their old password and their new password twice.
|-
|0:27
|We will check their old password, the one that’s in the database.
|-
|0:31
|Remember, they’re encrypted.
|-
|0:33
|Then we will compare the two new passwords to see if they match, to see if they’ve made any mistake.
|-
|0:39
|Next we will update the database using the new sql codes.
|-
|0:44
|So first of all I will start my "session" on my "member" page. As you can see we’ve got our "session_start" here.
|-
|0:53
|I’ll just copy and paste that to the top of my page. So, we’ve started our session.
|-
|0:59
|We need to use a variable called "user" which will be equal to the session that we’ve set over here.
|-
|1:09
|First, we need to check that the users have logged in - this is the code I was talking about - before we start to change their password or let them change their password.
|-
|1:19
|I’ll set this "user" variable as our "session" name which is here.
|-
|1:24
|Okay, now we will say “ if the user exists”, we’ll let them change their password otherwise we kill the page and say “You must be logged in to change your password".
|-
|1:41
|This is the block for “User is logged in”. So, assuming the user has logged in, after we’ve checked for the existence of the login , we need to give them a form to fill up.
|-
|1:49
|I'll echo out our code here which will be our form. It’s a self- submitting form so it’ll to go back to "change password dot php" and end the form here.
|-
|2:14
|So that's the page we are already on and so I’ll use a check to verify all the details.
|-
|2:21
|The method of the form is POST because we don’t want to let any password information into the URL.
|-
|2:30
|Next we’ll create a few input boxes. First “Old password:” which won't be a password type, so the entry won't be hidden. So input type will be "text" and name will "password".
|-
|2:48
|I’ll put a paragraph break. Next is "New password:" and I will create an input type as "password" so that it is hidden from everyone. The name will be “new password”.
|-
|3:02
|I'll put a line break here. Now copy paste this sentence and make a few changes. The label here will be “Repeat new password” and the name will be "repeat new password" followed by a paragraph break.
|-
|3:23
|Lastly we need a “submit" button. The name will be "submit" so we can check if that’s being pressed and the value will be "Change password".
|-
|3:33
|Okay, so let’s go to our page. I’ll stick a link in the members’ page, in order to help us change our password.
|-
|3:40
|For now, I’ll just login using the details. My password at the moment is “abc and my username is “Alex”.
|-
|3:48
|Click on login. It says "Welcome Alex". Here is the member page. The session has been set. If we need to log out, we can log out. But we need another option to change our password.
|-
|4:01
|So we go back to our "member dot php" page and I’ll create another link.
|-
|4:08
|And that will be “Change password”.
|-
|4:11
|And this will link to “change password dot php".
|-
|4:14
|So if we refresh this we’ll get another option. Click here and we get our form that we had created earlier. I'll type my old password here and my new passwords in here.
|-
|4:26
|Click "Change password" but nothing happens. So we want to check whether this has been submitted or not. Delete this extra line here.
|-
|4:38
|What we need to do is create an If statement to say “if POST submit” which just means "has the user pressed this submit button?". The name is submit, therefore we’ve got submit written here.
|-
|4:52
|And if the user has submitted then we start changing our password here.
|-
|4:59
|Otherwise, if the user hasn’t submitted we’re going to echo out this code here.
|-
|5:05
|If the user hasn’t already submitted, then they’ll have to present with the form here, in order to submit the form.
|-
|5:12
|Let’s go ahead and test this. What we’ll do here is echo out “test” to see if this works.
|-
|5:18
|Lets go back and fill in. Actually we don’t need to fill anything. We will just click the submit button. And we get an echo of “test” to show that our form has been submitted successfully.
|-
|5:34
|Ok so we need to start changing the password. Delete this and here we will say “check fields”.
|-
|5:40
|We’ve got a few variables that we need to set - our old password which will be equal to POST variable name “old password”. We have given that name down here in our form.
|-
|5:55
|And I’ll just replicate these for each value that we are submitting.
|-
|6:00
|Next one is “new password” and then we have “repeat new password”. We’ll just change these.
|-
|6:10
|To make sure these are working, and I do recommend you do this all the time, echo out “old password”, “new password” and ”repeat new password”.
|-
|6:25
|It check for the form existence, whether the form has been submitted, and then we get our variables and our post variables into the variable name.
|-
|6:38
|I’ll echo out what we’ve typed in the box just to see if everything is working.
|-
|6:40
|So my old password is “abc” and my old password is “123”. Click "Change password" and we get abc, 123 and 123.
|-
|6:52
|So that form information has been submitted. There are no spelling mistakes. I can be confident that I can get my user to set up a new password.
|-
|7:00
|I’m going to stop the tutorial now. In the next part I'll teach how to check the old password against the new password in the database, how to check if the new password and the repeated password match and then to change the user’s password.
|-
|7:24
|Thanks for watching. This is Joushwa Mathew dubbing for the Spoken Tutorial project.

PHP-and-MySQL/C4/User-Login-Part-3/English-timed

2013-10-25T11:05:36Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to the 3rd part of our "User login" tutorial. |- |00:07 |Here, we'll create a session in which the user can enter a page and they'…'

{| border=1
!Time
!Narration
|-
|0:00
|Welcome to the 3rd part of our "User login" tutorial.
|-
|00:07
|Here, we'll create a session in which the user can enter a page and they're allowed to be inside the page as long as they have successfully logged in.
|-
|0:16
|To start any session, we will need a function which is "start session".
|-
|00:25
|Is it "start session" or "session start"? Let's just test it quickly.
|-
|00:34
|Right, an error! So, it must be "session start". Sorry I was a bit confused there.
|-
|00:40
|"Session start", okay? So refresh, resend and "You're in!"
|-
|0:42
|We've started the session and this lets us add a session variable.
|-
|0:51
|So, "You're in!". After this I'll say "Click here to enter the secret... no, the member page." okay?
|-
|1:12
|And this is going to be a link to a page called "member dot php".
|-
|1:19
|Let's just recap. As long as we send the right data we're going to say "Click here to enter the member page" which we haven't created yet.
|-
|1:30
|Let me remind you here that we just created our "session start" here, which is very important.
|-
|1:36
|We're going to create a session and to do this let me start and type here the dollar sign underscore session and then in brackets, in square brackets, we will give it a session name.
|-
|1:53
|I'll call it "username" and that will be equal to our "username". I think I will say "dbusername" because that's a more direct value from the database.
|-
|2:08
|We have our session set.
|-
|2:10
|As long as the user is in their browser not the browser you evoked them with, then when we echo out our session in any page now, this will be set as a session.
|-
|2:20
|To prove this I'll create a new page.
|-
|2:25
|It'll be the "member dot php" page.
|-
|2:28
|So I'll save this as "member dot php".
|-
|2:30
|Here I'll say "echo" and I'll echo the "username session", okay?
|-
|2:42
|In fact, I'll concatenate at the start "Welcome" and at the end, just to make it more expressive let me add an exclamation mark.
|-
|2:55
|As long as we are logged in, this should run this command here, setting our session in our browser to our "username" on any other page we create.
|-
|3:06
|If this is any other page over here and you use this code to set, it will work.
|-
|3:11
|You will, of course, need this function inside here, as well.
|-
|3:18
|So you need "session start" inside every page that you call or declare a session in.
|-
|3:29
|There we restart. Let's go back to the main page.
|-
|3:35
|I'll login with my details as "Alex" and "abc", click log in.
|-
|3:41
|"You're in! Click here to enter the member page". Now as you can see, there is no error. I've successfully created my session.
|-
|3:49
|If I click here, we get "Welcome!" We have got only that. Let's see what happened.
|-
|3:52
|Let's go back and see what I've done wrong. This should be "username".
|-
|4:00
|I'm not using any comparison here but I've put a double equals to sign here. That might be wrong.
|-
|4.07
|Now this should work. Let's go back to our "index" page and let's log in again, as we did before.
|-
|4:17
|Login, okay, "You're in! Click here to enter the member page". Click here and "Welcome, alex!".
|-
|4:26
|Now I'll go back to the login page.
|-
|4:28
|Most people would think all that data has been lost now.
|-
|4:32
|If I go back to the member page which is "member dot php" and press enter it is still saying "alex".
|-
|4:40
|And in some second-starts if I close my browser and reopen it and I go to "local host php academy" then go back to my page which is the "login" session and back to my member page I'm still logged in. okay?
|-
|5:03
|So my user is logged in. If I close the browser I am still going to be logged in when I enter back.
|-
|5:12
|This is a very useful function if you're doing this kind of logging in.
|-
|5:19
|A lot of websites to do this to keep you logged in.
|-
|5:23
|But now I want to create a log out page.
|-
|5:26
|To log out all we need to do is, we need to create a separate page and let's just save it as "logout dot php".
|-
|5:33
|And we need to end our session here.
|-
|5:39
|First of all, before we destroy our session we need to start it.
|-
|5:46
|So I'll type "session start" here. Let me confirm it once.
|-
|5:55
|Ok and then we need to say "session destroy". Sorry, not sestroy, destroy.
|-
|6:04
|If we run this page here, it will destroy our session.
|-
|6:08
|Here I could type a friendly error message "You've been logged out. Click here to return".
|-
|6:20
|Let me create a link back to our "index dot php" page.
|-
|6:32
|Now I'll test this again. For example, lets say.....
|-
|6:35
|Lets put a break there. Here I'll create a link to log out.
|-
|6:41
|Its important to give the link the user to our "logout dot php" page otherwise they'll not know how to logout.
|-
|6:50
|We refresh this and it will create a log out link, to log out from the php page.
|-
|6:55
|Click on this and you get "You've been logged out. Click here to return."
|-
|6:59
|I assume that we've been logged out. Trying to go back to our member page dot php.
|-
|7:04
|We have got no variable here.
|-
|7:06
|Now you don't want the users to get access to this page because they are not logged in right now.
|-
|7:13
|So, here I'll say session start then I'll say "if session and the session name which is username.
|-
|7:19
|Next I'll echo out my data to say "Welcome" else I'll say die.
|-
|7:25
|No! Not me - I want my page to die! So I'll say "You must be logged in".
|-
|7:45
|We're saying, if this session exists or if it has been created by using a correct username and password we can echo out our friendly message to say "Welcome" otherwise kill the page and say "You must be logged in!".
|-
|7:55
|So, this is all in this part of the tutorial. Let me summarise this for you.
|-
|8:04
|Remember I'm not logged in. So let me login.
|-
|8:06
|I am in. There's my member page. I can log out. I return here.
|-
|8:10
|Now as we've created member dot php, press Enter.
|-
|8:14
|It displays, "You must be logged in!".
|-
|8:16
|So for example I'm going to log in but I'll not click here to go.
|-
|6:22
|I'll just forward myself to "member dot php". Message has been created and I've been allowed access.
|-
|8:29
|Okay so that's it for now. This is the last part of this tutorial. If you have any questions on this I'll be more than happy to help.
|-
|8:37
|This is Evan Varkey dubbing for the Spoken Tutorial Project. Bye.

PHP-and-MySQL/C4/User-Login-Part-2/English-timed

2013-10-25T11:04:47Z

Gyan: Created page with '{|Border=1 !Time !Narration |- |0:00 |Welcome to the second part. Here I’ll show you how to edit your "login dot php" page to connect to the database and also how to check our…'

{|Border=1
!Time
!Narration
|-
|0:00
|Welcome to the second part. Here I’ll show you how to edit your "login dot php" page to connect to the database and also how to check our username and password against that in the database.
|-
|0:14
|Now we’ve already connected to our database.
|-
|0:18
|Refreshing this and resending my username and password, we can establish that there have been no errors.
|-
|0:24
|I mean this error here.
|-
|0:25
|And we have seen that if we don’t type data we will get an error.
|-
|0:28
|Now. First of all I’m going to setup a query.
|-
|0:36
|If you have used "mysql" or any structured query language before, you will know that you can query a database.
|-
|0:43
|I think Microsoft Access has this.
|-
|0:46
|So here we are going to say, "SELECT", in fact we’re going to say "SELECT *" because we need the ID, the username and the password.
|-
|0:54
|I don’t think we need the id but "SELECT *" anyway so that it will grab all the data.
|-
|0:59
|So "SELECT * FROM" and we’ve called this, users, I think. Let me confirm that.
|-
|1:04
|Yes, users. So "SELECT * users" and here we’ll say "WHERE username" which is the name of this...... this, here.
|-
|1:20
|And we will say "WHERE username equals" the "username" that has been typed.
|-
|1:30
|Now if that "username" doesn’t exist, we need to display some kind of an error message to say that "This user doesn’t exist".
|-
|1:37
|So what we will do is we will use another function, a mysql function called "mysql num rows".
|-
|1:46
|This counts the number of rows that have been retrieved from the query you’ve given the database.
|-
|1:53
|So we’ll say "numrows equals mysql_num_rows" and in the brackets we have the name of our query, the variable that I have stored the query function in.
|-
|2.08
|And if we echo out the number of rows, I’ll just prove to you and test for myself that we should get 1 because we have just 1 row.
|-
|2.16
|Let me click insert and add another row of data, for example - another username and another password.
|-
|2:26
|I’ll just try that now. I’ll be testing this later on. Lets see, lets say username is "Kyle" and password is "123" this time.
|-
|2:38
|Okay, lets try that. And there we are. Hold on a second. Where am I? Ah there we go.
|-
|2:53
|So we have got "Alex" and "Kyle".
|-
|2:55
|We can see the ids have been automatically incremented.
|-
|2:58
|You can see both our passwords here and the 2 usernames.
|-
|3:02
|Now we will refresh this and see what we get.
|-
|3.06
|Oh Ok. This is the whole part of the check.
|-
|3:10
|The reason this has returned 1 is that if I were just selecting every user and then counting the row, the value would increment.
|-
|3:18
|Go back here and refresh and we’ll get the value of 2 because there are 2 rows.
|-
|3:22
|But if I’m saying "SELECT where the username equals my username", we’re obviously only selecting where my username exists and that is in 1 row.
|-
|3:34
|Usually on a website, you won’t have duplicate username.
|-
|3:40
|Okay. So now that we have got this, what is the purpose of finding out how many rows there are.
|-
|3:47
|Now the purpose is that we can say "if num_rows is equal to zero", then that means we can.. Sorry, if "my num_rows doesn’t equal zero", then we can execute the code we need to do, that we will need to login.
|-
|4.01
|Otherwise, sorry "else", we need to echo out, sorry "else die". We will give the message "That user doesn’t exist".
|-
|4:16
|So what we’re doing is, we’re checking that a row has been returned where we have supplied that username.
|-
|4:25
|And if it doesn’t equal zero, we can execute our code to login.
|-
|4:29
|Otherwise we’ll say die and "Tthat username doesn’t exist".
|-
|4:33
|This will be equal 1, 2, 3, 4 and so on.
|-
|4:38
|Sorry it will equal...
|-
|4:40
|If it doesn’t equal zero, then it must equal something.
|-
|4:44
|And if it does equal something, then the code in here will be executed.
|-
|4:47
|So if it is equal to 0, that basically means that no result can be returned.
|-
|4:52
|I’ll resend this. Let’s go back.
|-
|4:57
|And......... let’s get rid of our "echo num_rows".
|-
|5:05
|Okay. So let’s go back to our main page and we’ll login with "Alex" and "abc"; password doesn’t matter at the moment.
|-
|5:13
|Nothing’s happened because no errors have been returned.
|-
|5:15
|Now let me use Billy, for example, and type the password in and click on login.
|-
|5:21
|"That user doesn’t exist!" because no rows that have the username equal to Billy have been returned.
|-
|5:26
|So we can see that that’s working.
|-
|5:28
|I’ll go back to my original thing.
|-
|5:31
|So "Alex" and my password is "abc".
|-
|5:37
|Now the code to login.
|-
|5:39
|Inorder to login, we need to perform a password check.
|-
|5:42
|So to grab the password, I’ll use a function.
|-
|5:46
|Sorry not a function, I’ll use...... a loop and that loop will be the "while" loop.
|-
|5:52
|I will type a variable name here. I’ll call it "row" and that is equal to "mysql"..... "mysql_ fetches a row as an array". Okay?
|-
|6:11
|So I’ll say "mysqul_fetch_assoc" for short.
|-
|6:22
|And this is going to be my query. So I’ve got my query there.
|-
|6:28
|From this, we are fetching each column data from here and putting it into an array called "row".
|-
|6:40
|So obviously with the while loop, we’ll have our brackets and now we’ll set some variables.
|-
|6:45
|I’ll say "db username", which is the username that I’ll extract from the database, is equal to the "row" and this is the row name, "username".
|-
|6:55
|So as we can see here, this is the row name here.
|-
|6:59
|If this is an array of the data, then each of these are going to be id, username and password.
|-
|7:06
|We’re not using 0,1,2. But I’m not sure whether that works.
|-
|7:10
|Now we’ll keep it simple and we’ll directly reference the name of our column.
|-
|7:20
|So the database username will be "row" and that since this is an array which is using this function on our query.
|-
|7:26
|Next we will say "db password equals row" and then our password.
|-
|7:38
|So after this we could echo out....
|-
|7:43
|No, in fact we don’t need to echo out our contents of our db username and password unless we want to run into errors.
|-
|7:49
|We already know what they are. We’ve seen them in the database.
|-
|7:51
|Now what we’ll do is we will perform a check. So "check to see if they match".
|-
|8:00
|It’s very simple to do this using an "if" statement.
|-
|8:04
|"if" our username equals our db username and our password is equal to our db password , then we’ll say it’s correct.
|-
|8:19
|Otherwise, we’ll say it’s incorrect.
|-
|8:22
|I will remove the brackets because there is only one line. So echo "Incorrect password!". Just leave it like that.
|-
|8:34
|And here we’ll say echo "You’re in!".
|-
|8:41
|Okay we’ll just test this before I end this part of the video.
|-
|8:46
|I’ll first say "Alex" and I’ll put a wrong password in. "Incorrect password!".
|-
|8:51
|And now I’ll put "abc" as password and "You’re in!".
|-
|8:55
|So we’ve checked our username and it exists.
|-
|8:58
|We’ve checked our fields exist so please enter in your username and password.
|-
|9:04
|If we enter in a username and a wrong password we get an error message – "Incorrect password".
|-
|9:11
|If we enter the correct password, we get- "You’re in".
|-
|9:13
|And if we enter a username that is not found, we get an error message saying the user doesn’t exist.
|-
|9:24
|Okay so join me in the next part, and I’ll show you how to create your sessions and your log out page. See you then!
|-
|9:32
|This is Antara dubbing for the Spoken Tutorial project.

PHP-and-MySQL/C4/User-Login-Part-1/English-timed

2013-10-25T11:03:25Z

Gyan: Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to the tutorial on user login and sessions. |- |0:03 |This tutorial will give a few aspects of php that will focus on how an html …'

{| border=1
!Time
!Narration
|-
|0:00
|Welcome to the tutorial on user login and sessions.
|-
|0:03
|This tutorial will give a few aspects of php that will focus on how an html form can be submitted and how to check for user name and password.
|-
|0:14
|The entered values will be checked against a database.
|-
|0:16
|I'll show you how to set-up a database with your user name and password, how to connect to a database and also to process a logout function.
|-
|0:25
|Since we're using sessions, the user will remain logged-in until they press the logout button.
|-
|0:32
|To start with I'll create an html form.
|-
|0:35
|I'll take you through some of the mySQL features that we will set up.
|-
|0:42
|In our html form, we have the action going to a page called "login dot php".
|-
|0:47
|We'll keep separate pages to keep it simple.
|-
|0:49
|Our method is going to be POST.
|-
|0:50
|Lets end our form here.
|-
|0:54
|I'll start creating our input type which will be "text" and the name will be "username".
|-
|1:06
|A line break here.
|-
|1:09
|Copy-paste this line and change "text" to "password".
|-
|1:15
| And its called "password". Depending on which operating system we are using, this will appear as stars or circles.
|-
|1:24
|And finally we'll create a "submit" button and its value will be "Log in".
|-
|1:31
| Let's try this. Refresh and we have a page here.
|-
|1:36
|"index dot php" with a user name and password.
|-
|1:39
|I'll log in and it goes to a page that doesn't exist.
|-
|1:43
|Now let's make it a bit more user friendly and type out labels here.
|-
|1:54
|Refresh and there we are.
|-
|1:59
|Now let us create our "login dot php" file.
|-
|2:01
|First I will open "php my admin".
|-
|2:04
|If you are using "xampp" then it will be installed by default using the local host for "php my admin".
|-
|2:11
|If it isn't installed yet, I would suggest you google it and install a copy on the local host directory and start using it.
|-
|2:21
|Now, we'll create a new database.
|-
|2:25
|So here, create new database called "php login" and click create.
|-
|2:40
|We can see it appears here and we can now create tables.
|-
|2:46
|In case you're not familiar with sql, let me brief you.
|-
|2:50
|A basic structure is a database which stores tables and tables store rows and rows store values.
|-
|3:00
|Lets name it "users" and click on OK.
|-
|3:06
|An error - the number of fields!
|-
|3:10
|When I create a new database, I open up a notepad or a context editor and note down all the fields that I'll use.
|-
|3:20
|I'll use "id" for start, next "user name" and lastly "password". That's all we want at the moment.
|-
|3:28
|We can also add the "first name", "date of birth" etc. depending on your program.
|-
|3:36
|But for now we're using these 3 fields making it a total of 3 fields.
|-
|3:42
|Let's go back here. So, three fields and that will create that first.
|-
|3:49
|Now we proceed with typing in the the field names.
|-
|3:53
|We type "id" and we will make this an integer.
|-
|3:57
|This is the primary key and we want it to make auto increment.
|-
|4:02
|Now, every-time a new record is created the id values will increment by one.
|-
|4:07
|So, for example, the first user who registers will have an id of one, the second user who registers will have an id of two and so on and so forth.
|-
|4:15
|Okay, next one will be the user name and last one is going to be the password.
|-
|4:23
|Next we'll set them as VARCHARs and I'll set this as 25 characters and the password as 25 characters, as well.
|-
|4:31
|There is nothing else that we need to set for these.
|-
|4:34
|Let us scroll down and lets click on SAVE.
|-
|4:40
|Okay so once I save here, we can come down and see this here.
|-
|4:44
|And you can insert values in them.
|-
|4:48
|We'll do it because we're testing.
|-
|4:50
|I have created some tutorials on how to make a user registration form. We can discuss this further there.
|-
|5:01
|The value of "id" will be auto-incremented, so we don't have to put anything.
|-
|5:05
|It'll go to 1 straight away.
|-
|5:07
|In user name, I'll say "Alex".
|-
|5:10
|My password will be "abc". I would recommend you a better password, though.
|-
|5:16
|Okay so user name is "Alex" and password is "abc" - easy to remember. That's what has been stored.
|-
|5:26
|To browse, just click the browse tab.
|-
|5:28
|Let's scroll down. We have user name and password as "Alex" and "abc" and the id has already been set to 1.
|-
|5:37
|Now, we'll create the "login dot php" page.
|-
|5:46
|Lets save this quickly - "Login dot php".
|-
|5:51
|Let us see how to create our php tags.
|-
|5:55
|I'll take into account some POST variables now.
|-
|5:59
|In "index dot php", we used the method as POST.
|-
|6:01
|We'll set user name as dollar sign underscore POST and rename the variable which is "username".
|-
|6:11
|It is found here and.... password will equal a POST value and that will be "password".
|-
|6:25
|First of all, we will check whether both the user name and the password were entered.
|-
|6:30
|We won't start validating the form. Its unnecessary to do so since we know the user has entered both these fields.
|-
|6:38
|Now, I will type my "if" statement.
|-
|6:40
|This will be a big block because all the code that I require after I check this will go in here.
|-
|6:45
|So here I'll say if "username" which means if "username" has a value, it will return TRUE and I'll say "password".
|-
|6:56
|So this requires the "username" and "password" for this to be TRUE and to execute this block of code here.
|-
|7:04
|What should we write here? We need to connect to our database.
|-
|7:08
|To do this we create a variable called "connect" equal to "mysql_connect".
|-
|7:20
|And inside this the first parameter will be a "host" which is "localhost" for me.
|-
|7:28
|The second one will be "username" and I'll use "root".
|-
|7:31
|The third one is the "password" which I believe I don't have. We'll check on that.
|-
|7:37
|After this we can say "or die" and give an error message.
|-
|7:39
|So, for example, we can say "Couldn't connect".
|-
|7:44
|I am not sure about my password. I think its something else.
|-
|7:48
|We'll try something then it will say "Couldn't connect".
|-
|7:51
|Now we need to select our table, sorry our database.
|-
|7:58
|We'll say "mysql select db" which is another built-in function when you have the php module installed.
|-
|8:06
|It also comes with XAMPP.
|-
|8:11
|Here I'll put a double quote and say "phplogin"
|-
|8:19
|So assuming that everything is okay, I can add my error message here "Couldn't find db". Okay?.
|-
|8:30
|Refresh page. Click login. Nothing happened.
|-
|8:37
|Let's edit our "if" statement and say "else" echo or instead the best function is "die".
|-
|8:47
|Here it will just stop executing anything after this point, after this function is called.
|-
|8:54
|And it'll also pass a message of your choice.
|-
|8:58
|So here I'll say "Please enter a user name and a password".
|-
|9:08
|Refresh this. Resend the data and we get this error message.
|-
|9:13
|Next I'll type "Alex" and "123", sorry "abc" and click log in.
|-
|9:18
|No error message, which means we are connected to the database.
|-
|9:25
|That's the end of this part. In the next one I will show how to connect to our database and check for the user name and password.
|-
|9:34
|Thanks for joining us. This is Royston dubbing for the Spoken Tutorial Project. Bye.