PHP & Yii dasturlash (Mohirdev)

11 yillik tajribali mutaxassisdan PHP backend dasturlashni o'rganing.
 

Kurs tarkibi

1 Kirish

02.01. Mohirdevga xush kelibsiz
02.02. Eslatma!
02.03. Yopiq guruhga qo'shilish
02.04. Darslarni kompyuterda ko'rish
02.05. Darslarni telefonda ko'rish
02.06. Savol so'rash bo'yicha qo'llanma
02.07. Kurs ustozi bilan tanishuv
02.08. Kurs xaritasi

2 Web texnologiyalar

03.01. Internet
03.02. Web ilovalarning arxitekturasi
03.03. IP Domen URL Hosting
03.04. DNS
03.05. Frontend - Backend arxitekturasi
03.06. Protokollar
03.07. Web server
03.08. Ixtiyoriy bo'limlar: HTML, CSS, Bootstrap

3 Ish muhitini sozlash

04.01. Apache, Nginx, PHP, MySQL haqida
04.02. Sublime, PHPStorm, VSCode kod yozish muhitlari haqida
04.03. Open Server bilan tanishish va uni o'rnatish

4 Boshlang'ich tushunchalar

05.01. PHP tili sintaksisi. Comments
05.02. O'zgaruvchilar. Constant
05.03. Ma'lumotlar turlari
05.04. Boshlang'ich tushunchalar bo'yicha vazifa
05.05. Amaliy vazifalar qanday topshiriladi?
05.06. Boshlang'ich tushunchalar mavzusiga oid test

5 Operatorlar

06.01. Arifmetik operatorlar
06.02. O'zlashtirish operatorlari
06.03. IncrementDecrement operatorlar
06.04. Taqqoslash operatorlar
06.05. Ternary va string operatorlar
06.06. Mantiqiy operatorlar
06.07. Operatorlar bo'yicha vazifalar. 1-to'plam.
06.08. Operatorlar bo'yicha vazifalar. 2-to'plam.
06.09. Operatorlar bo'yicha vazifalar. 3-to'plam.
06.10. Operatorlar bo'yicha vazifalar. 4-to'plam.
06.11. Operatorlar mavzusiga oid testlar 1-to'plam

6 Matematik funksiyalar

07.01. abs(), sqrt(), pow() funksiyalari
07.02. ceil(), floor(), round()
07.03. pi(), max(), min(),rand(), mt_rand()
07.04. Matematik funksiyalarga doir testlar

7 Matnlar bilan ishlash

08.01. 1 baytli va multibayt (ko'p baytli) harflar
08.02. Matnlarga oid funksiyalar: strlen(), strtolower(), strtoupper(), ucfirst()
08.03. substr(), strpos(), strrpos()
08.04. str_shuffle(), str_replace(), md5(), htmlspecialchars(), strip_tags()
08.05. substr_count(), trim(), str_word_count(), strstr()
08.06. Matnlar bilan ishlashga oid vazifalar
08.07. Sinov testi

8 Tarmoqlanish

09.01. IF, IF-ELSE, IF-ELSEIF-ELSE
09.02. SWITCH
09.03. MATCH
09.04. Tarmoqlanishga oid vazifalar
09.05. SWITCHga oid masalalar
09.06. Tarmoqlanish moduliga oid test

9 Formalar

10.01. Formalar hosil qilish va ulardan foydalanish
10.02. GET va POST metodlari
10.03. is_null(), empty(), isset() funksiyalari
10.04. Amaliyot. Ro'yxatdan o'tish formasini hosil qilish
10.05. Formalar bilan ishlashga oid vazifalar
10.06. Formalar moduliga oid testlar

10 Funksiyalar

11.01. Funksiya hosil qilish va ulardan foydalanish
11.02. Qiymat qaytaruvchi funksiya
11.03. Argumentli va boshlang'ich qiymatli funksiya. 1-qism
11.04. Argumentli va boshlang'ich qiymatli funksiya. 2-qism
11.05. Rekursiv funksiya
11.06. Local, Global, Static o'zgaruvchilar
11.07. Funksiyalarga oid masalalar
11.08. Fuksiyalarga oid test

11 Takrorlanish (sikl) operatorlari

12.01. WHILE, DO WHILE LOOP
12.02. FOR LOOP
12.03. WHILE va DO-WHILE ga oid masalalar
12.04. FOOR loopga oid masalalar
12.05. siklga oid testlar

12 Massivlar

13.01. Indexed array
13.02. Associative array
13.03. Praktika Massivlarga oid masalalar 1-qism
13.04. Praktika Massivlarga oid masalalar 2-qism
13.05. Foreach LOOP
13.06. Array functions. 1-qism
13.07. Array functions. 2-qism
13.08. Array functions. 3-qism
13.09. Array functions. 4-qism
13.10. Array functions. 5-qism
13.11. Multidimensional array. Ko'p o'lchamli massivlar
13.12. Massivlarga oid vazifalar. 1.1
13.13. Massivlarga oid vazifalar. 1.2
13.14. Massivlarga oid vazifalar. 1.3
13.15. Ko'p o'lchamli massivlarga oid masalalar. 1.1
13.16. Ko'p o'lchamli massivlarga oid masalalar. 1.2
13.17. str_replace() funksiyasi
13.18. Massivlarga oid testlar

13 MySQL Basics

14.01. MySQL server va client haqida. 1-qism
14.02. MySQL server va client haqida. 2-qism
14.03. Database bilan ishlash
14.04. Jadval hosil qilish 1-qism
14.05. Ma'lumotlar tiplari. Numeric tiplar, INT, SMALLINT, DOUBLE, DECIMAL
14.06. Ma'lumotlar tiplari. String, Boolean, JSON tiplar. Bazaga_ulanish
14.07. Jadvallar bilan ishlash. Primary va Unique key. 2-qism.
14.08. SELECT - tanlash buyrug'i. Aggregate funksiyalar
14.09. INSERT
14.10. WHERE
14.11. ORDER BY - tartiblash
14.12. LIMIT va OFFSET
14.13. Tayyor bazani import qilsh
14.14. Mysqldan foydalanish
14.15. UPDATE REPLACE1
14.16. ALTER TABLE
14.17. DELETE
14.18. Databaselar bilan ishlashga doir vazifalar
14.19. SELECT, ORDER BY buyrug'iga va Agregat funksiyalarga oid masalalar
14.20. INSERT, WHERE LIMIT buyruqlariga oid masalalar. 1.1
14.21. INSERT, WHERE, LIMIT buyruqlariga oid masalalar. 1.2
14.22. UPDATE buyrug'iga oid masalalar
14.23. MYSQL BASICS moduliga oid testalr

14 MySQL Advanced

15.01. GROUP BY, Having, Distinct
15.02. PRAKTIKA- GROUP BY, Having
15.03. DATE funksiyalar
15.04. Normalization. 1,2,3 normal formalar
15.05. Foreign key. 1-qism
15.06. Foreign key. 2-qism. Actionlar
15.07. Joinlar. INNER JOIN
15.08. Joinlar. LEFT va RIGHT JOIN
15.09. Joinlarga oid masalalar
15.10. SUBQUERY
15.11. UNION
15.12. INDEXLASH
15.13. Amaliyot. O'quv markaz database strukturasini ishlab chiqish
15.14. Protsedura va DELIMITER
15.15. MySQLda o'zgaruvchilar
15.16. Protsedura hosil qilish va o'chirish
15.17. DECLARE va INTO
15.18. IN-OUT-INOUT parametrli protseduralar
15.19. IF-THEN-ELSE
15.20. CASE
15.21. LOOP
15.22. Errorlar bilan ishlash
15.23. Triggerlar bilan tanishish
15.24. BEFORE-AFTER insert, update, delete triggerlari
15.25. EVENT
15.26. VIEW
15.27. WHILE
15.28. Funksiyalar
15.29. CURSOR
15.30. GROUP BY va HAVING buyruqlariga oid masalalar. 1.1
15.31. GROUP BY va HAVING buyruqlariga oid masalalar. 1.2
15.32. GROUP BY va HAVING buyruqlariga oid masalalar. 1.3
15.33. DATE mavzusi bo'yicha vazifalar
15.34. JOINlar bo'yicha vazifalar. 1.1
15.35. JOINlar bo'yicha vazifalar. 1.2
15.36. JOINlar bo'yicha vazifalar. 1.3
15.37. UNION bo'yicha vazifalar
15.38. DB struktura vazifasi. O'quv markaz loyihasi.
15.39. DB struktura qilish. Quizapp loyihasi DBsi.
15.40. MySQL Advanced - Testlar

15 PHP Advanced

16.01. Require va Include
16.02. TRY - CATCH. Xatoliklar bilan ishlash
16.03. PDO haqida
16.04. Bazaga ulanish
16.05. PHP + MySQL INSERT - ma'lumotlarni qo'shish
16.06. PHP + MySQL SELECT - jadvaldan ma'lumot olish
16.07. PHP + MySQL UPDATE - ma'lumotlarni yangilash
16.08. PHP + MySQL DELETE - ma'lumotlarni o'chirish
16.09. Cookie bilan ishlash
16.10. Session bilan ishlash
16.11. Authentication and Authorization
16.12. JSON
16.13. DATE
16.14. Fayllar bilan ishlash
16.15. Fayl yuklash

16 Amaliyot

17.01. Yangiliklar sayti loyihasi strukturasini ishlab chiqish
17.02. Loyihaning Database strukturasini ishlab chiqish
17.03. Admin panel. Header menyularni qo'yish
17.04. Admin panel. Kategoriya CRUD
17.05. Admin panel. Pagination, LIMIT, OFFSET
17.06. Admin panel. UPDATE va DELETE qilish
17.07. Admin panel. News qo'shish.
17.08. Admin panel. Tag va Post Tag bo'limlari.
17.09. Ro'yxatdan o'tish. Registration
17.10. Login qilish qismi. Authentication. Logout
17.11. CURL bilan ishlash

17 OOP

18.01. Kirish. OOP bilan tanishish
18.02. Class, Object, Properties
18.03. Methodlar va $this dan foydalanish
18.04. Access Modifiers public, private, protected. Encapsulation
18.05. Constructor
18.06. Inheritance - meros olish. Overriding method.
18.07. Abstract klass
18.08. Interface, Polymorphism
18.09. Trait
18.10. Static method va propertylar
18.11. Constant. Magic Constantlar
18.12. Namespaces
18.13. Autoloading
18.14. Exception handling. try - catch
18.15. OOP moduli bo’yicha test
18.16. OOP topshiriqlar

18 BONUS: Videouchrashuvlar

19.01. Intro

19 OOP Amaliyot

20.01. OOP Framework. Kirish
20.02. Controller
20.03. View
20.04. Model
20.05. Amaliyot
20.06. CRUD qismini hosil qilish
20.07. Optimallashtirish
20.08. Composer bilan ishlash

20 Yii freymvorki

21.01. Bo'lim haqida
21.02. Yii frameworkni Composer orqali o'rnatish
21.03. Config va papkalar bilan tanishish
21.04. MVC haqida. Yii frameworkning ishlash arxitekturasi
21.05. Basic va Advanced templatelar farqlari
21.06. Yii frameworkni qo'llash mumkin bo'lgan loyiha turlari
21.07. Application. Controller. Action. View
21.08. Assets va layout
21.09. Alias va Helperlar
21.10. Model va FormModel haqida tushuncha.
21.11. Formalar hosil qilish.
21.12. Validatorlar
21.13. ActiveForm bilan forma hosil qilish. Active Field
21.14. Baza bilan ishlash. Database Access Object (DAO)
21.15. Query klassi. Query builder yordamida so'rovlar hosil qilish
21.16. Migration
21.17. Active Record va Active Query. 1-qism
21.18. Active Record va Active Query. 2-qism
21.19. Active Record va Active Query funksiyalari. 3-qism
21.20. Active Record. Relationlar. 4-qism
21.21. Data formatting
21.22. Pagination
21.23. Sorting
21.24. ActiveDataProvider
21.25. SqlDataProvider va ArrayDataProvider
21.26. Widgetlar. Alert va Breadcrumbs widgeti
21.27. ListView widgeti
21.28. DetailView widgeti
21.29. GridView. 1-dars
21.30. GridView. 2-dars
21.31. Modullar hosil qilish va foydalanish
21.32. GII moduli. 1-qism
21.33. GII moduli. 2-qism
21.34. Session
21.35. Cookie
21.36. Mailer. Email pochtaga xabar yuborish
21.37. Modallar bilan ishlash 1-qism
21.38. Modallar bilan ishlash. 2-qism
21.39. Widget hosil qilish
21.40. Route va URL
21.41. Frontend va Admin qismlarni sozlash
21.42. Database strukturani tayyorlash va migrationlar hosil qilish
21.43. CategoryProduct bo'limlarini hosil qilish. CRUD
21.44. Frontend qismiga shablon kiydirish va produktlar ro'yxatini chiqarish
21.45. File-Image upload qilish
21.46. Rasmlarni ko'rsatish va htaccess ni sozlash
21.47. Rollar bilan ishlash. Access Control
21.48. RBAC. Rollar hosil qilish va foydalanish. 1-qism
21.49. Rollar hosil qilish va foydalanish. 2-qism.
21.50. i18n. Tillar bilan ishlash
21.51. Loyihani ko'p tilli qilish
21.52. Eventlar bilan ishlash
21.53. Behaviorlar bilan ishlash
21.54. Caching. 1-qism
21.55. Caching. 2-qism
21.56. REST API. 1-qism. Sozlash
21.57. REST API. 2-qism
21.58. REST API. 3-qism. Filterlar
21.59. REST API. 4-qism. Versiyalash
21.60. REST API. 5-qism. CORS filter
21.61. REST API. 6-qism. Basic va Query Param Auth
21.62. REST API. 7-qism. BearerAuth. Authdan foydalanish
21.63. REST API. 8-qism. OAuth haqida tushuncha

21 HTML asoslari (ixtiyoriy)

22.01. Kurs haqida
22.02. WEB haqida
22.03. Kirish
22.04. Development Environment (Dasturlash Muhiti)
22.05. Hujjat strukturasi va DOCTYPE
22.06. Elementlar va "attribute"lar
22.07. "Headings" (Sarlavhalar)
22.08. "Paragraphs" (Xatboshilar)
22.09. Styles (Stillar)
22.10. Formatting (Formatlash)
22.11. Comments (Izohlar)
22.12. CSS 1-qism
22.13. CSS 2-qism
22.14. Links (Havolalar)
22.15. Images (Rasmlar)
22.16. "Tables" (Jadvallar)
22.17. Lists (Ro'yhatlar)
22.18. "ID"
22.19. "Class"
22.20. "Block" va "Inline" elementlar
22.21. "div" va "span"
22.22. "Forms" 1-qism
22.23. "Forms" 2-qism
22.24. "Forms" 3-qism
22.25. "Layout" va "Semantics"
22.26. "Head"
22.27. Audio, Video va Youtube
22.28. "Best practices"
22.29. Loyiha ("Project")

22 CSS (ixtiyoriy)

23.01. Kirish
23.02. CSS haqida. Kurs loyihasi
23.03. HTML hujjat va CSS. Loyiha strukturasi
23.04. Selectors (Tanlab oluvchilar)
23.05. Comments (Izohlar)
23.06. Specificity (O'ziga xoslik)
23.07. Inheritance (Meros olish)
23.08. Combinators (Kombinatorlar)
23.09. "Class"lar va qo'shma (combined) selektorlar
23.10. Class yoki ID. "!important" haqida
23.11. CSS asoslari yordamida loyihani yaxshilash
23.12. Box model (Quti modeli). Margin, Padding, Border
23.13. Margin collapsing. Shorthands (Qisqartmalar)
23.14. Height (balandlik), Width (kenglik). Max / Min - height / width
23.15. "Display" xossasi
23.16. Text align, Vertical align va Float
23.17. Text decoration. Pseudo classes va qoidalarni guruhlash
23.18. Asosiy xossalar yordamida loyihani yaxshilash (1-qism)
23.19. Asosiy xossalar yordamida loyihani yaxshilash (2-qism)
23.20. Asosiy xossalar yordamida loyihani yaxshilash (3-qism)
23.21. Joylashish va "static" qiymati
23.22. Relative va Fixed
23.23. Absolute va Sticky
23.24. Z-index va Overflow
23.25. Positioning yordamida loyihani yaxshilash
23.26. Background
23.27. Styling images
23.28. Gradient va Filterlar
23.29. Rasmlar (images) yordamida loyihani yaxshilash
23.30. Formalarga style berish (1-qism)
23.31. Formalarga style berish (2-qism)
23.32. Formalar yordamida loyihani yaxshilash
23.33. O'lchov birliklari (Units)
23.34. Foiz (%) o'lchov birligi
23.35. "em" o'lchov birligi
23.36. rem o'lchov birligi
23.37. Viewport o'lchov birligi
23.38. Units yordamida loyihani yaxshilab olish
23.39. Responsive Web Design (RWD)
23.40. Media queries
23.41. Breakpoints
23.42. RWD yordamida loyihani yaxshilash (1-qism)
23.43. RWD yordamida loyihani yaxshilash (2-qism)
23.44. Fonts
23.45. Yangi font qo'shish
23.46. Local font qo'shish
23.47. Font xossalari
23.48. Fonts yordamida loyihani yaxshilab olish
23.49. 2D transforms
23.50. 3D transforms
23.51. Transitions
23.52. Animations (1-qism)
23.53. Animations (2-qism)
23.54. CSS Advanced yordamida loyihani yaxshilash
23.55. Flexbox: asoslari va terminlari
23.56. Flexbox: flex-direction, flex-wrap, flex-flow va justify-content
23.57. Flexbox: align-items va align-content
23.58. Flexbox: order, flex-grow va flex-shrink
23.59. Flexbox: flex-basis, flex va align-self
23.60. Flexbox yordamida loyihani yaxshilash
23.61. CSS Grid
23.62. Best practices
23.63. Loyihani yakunlash. Kurs yakuni

23 Bootstrap (ixtiyoriy)

24.01. Kirish
24.02. Bootstrap va uning versiyalari. Kurs loyihasi
24.03. Bootstrapni o'rnatib olish
24.04. Breakpoints va Containers
24.05. Grid (1-qism)
24.06. Grid (2-qism)
24.07. Columns
24.08. Gutters
24.09. Typography
24.10. Images
24.11. Tables
24.12. Formalar. Form control
24.13. Select. Checks & Radios. Range
24.14. Input group
24.15. Floating labels. Form layout
24.16. Validation
24.17. Accordion, alerts, badge, breadcrumb
24.18. Button, button group
24.19. Card
24.20. Carousel
24.21. Collapse, Dropdowns, List group
24.22. Modal
24.23. Navs, tabs, navbar
24.24. Offcanvas, pagination
24.25. Popover, progress
24.26. Scrollspy, spinners
24.27. Toasts, Tooltips
24.28. Clearfix, coloured links, ratio, position
24.29. Visually hidden, stretched links, text-truncation
24.30. Background, borders, colors
24.31. Display, flex
24.32. Float, interactions, overflow
24.33. Position, shadows, sizing
24.34. Spacing, text
24.35. Vertical align, visibility
24.36. Bootstrap icons
24.37. Bootstrap'ni moslashtirish
24.38. Loyiha (1-qism)
24.39. Loyiha (2-qism)
24.40. Loyiha (3-qism)
24.41. Qo'shimcha CSS freymvorklar
24.42. Kurs yakuni, keyingi rejalar

Ommaviy ofertani ko'rish