Webrebel 2: PHP a MySQL

19h 40min
Time
141
Chapters
Programovanie
Category
4.8
Rating
Intermediate
Level
slovak
Language
Online course Webrebel 2: PHP a MySQL is available to

Chapters

Úvod
Available in course preview
DÚ #01
Available only with full access purchase
Available in course preview
Available in course preview
Tipy, rady a pravidlá pre každý kurz
Available only with full access purchase
Dynamické webstránky
Available in course preview
Available in course preview
Available in course preview
Available in course preview
Available in course preview
Kde ma nájdeš, poď na onlajn
Available only with full access purchase
DÚ #02
Available only with full access purchase
Available in course preview
Available in course preview
11 - Localhost, PHP server na počítači, AMP Stack (Apache, MySQL, PHP)
Available only with full access purchase
DÚ #03
Available only with full access purchase
Ak ti niečo nefunguje / Ideme inštalovať PHP
Available only with full access purchase
Inštalácia a nastavenie PHP (Mac)
Nepotrebuješ mať všetko nastavené ako ja
Available only with full access purchase
Laragon namiesto MAMP (hlavne pre Windows)
Available only with full access purchase
Ak sa ti cez Laragon nedá pripojiť k databáze
Available only with full access purchase
12 - Nastavíme Mac pre web development - Skryté súbory, plné cesty k súborom, klávesnica
Available only with full access purchase
13 - Nastavíme Mac - Rýchle animácie, lepšia konzola, command line devtools
Available only with full access purchase
Zmeny pre nový OSX na Mac
Available only with full access purchase
14 - Nastavíme Mac - PHP, Environment Variables, PATH
Available only with full access purchase
15 - Nastavíme Mac - Hombrew package manager
Available only with full access purchase
16 - Nastavíme Mac - Node, npm, bower, composer, xdebug, brew tap
Available only with full access purchase
17 - Nastavíme Mac - Princíp package managerov a PHP Composer
Available only with full access purchase
18 - Nastavíme Mac - Inštalujeme Laravel, Xdebug, Dash
Available only with full access purchase
Inštalácia a nastavenie PHP (Windows)
Ak ti niečo nefunguje / Nepotrebuješ mať všetko nastavené ako ja
Available only with full access purchase
Laragon namiesto MAMP (hlavne pre Windows)
Available only with full access purchase
19 - Nastavíme Windows pre web development - Nastavenia systému, Windows admin práva
Available only with full access purchase
20 - Nastavíme Windows - Klávesnice, Cmder git cygwin konzola
Available only with full access purchase
21 - Nastavíme Windows - MAMP, systémové premenné
Available only with full access purchase
22 - Nastavíme Windows - Environment variables, PATH
Available only with full access purchase
23 - Nastavíme Windows - Nastavenia php.ini, package / dependency manager
Available only with full access purchase
24 - Nastavíme Windows - Composer, node.js, npm, bower
Available only with full access purchase
25 - Nastavíme Windows - PHP xdebug
Available only with full access purchase
26 - [BONUS] - Chyba "CLI prestal fungovať" vo Windows konzole
Available only with full access purchase
Aplikácia s databázou 1 (Composer)
27 - TODO appka - Úvod a proces výučby
Available only with full access purchase
28 - TODO appka - PHPStorm a HTML kód aplikácie
Available only with full access purchase
29 - Spracovanie dát z formuláru, GET request, POST request, query string
Available only with full access purchase
30 - Na čo sú nám databázy a zobrazovanie PHP chýb?
Available only with full access purchase
31 - Zobrazenie PHP errorov a zmena php.ini nastavení
Available only with full access purchase
32 - Ako pridať package cez composer require
Available only with full access purchase
33 - PHP include vs require vs require_once a spojenie s databázou
Available only with full access purchase
Ak medoo nejde / Vypni Cache / Error výpisy a iné rady
Available only with full access purchase
34 - Databáza - DB SELECT, načítanie údajov z databázy
Available only with full access purchase
35 - Databáza - DB INSERT, vloženie údajov do databázy
Available only with full access purchase
36 - Composer update, PHP Error, Whoops a užitočnejšie výpisy chýb
Available only with full access purchase
37 - Ako vytvoriť databázu a rozchodiť appku, phpMyAdmin, adminer, SQL import
Available only with full access purchase
Nemusíš všetko (+ frustrujúce úlohy)
Available only with full access purchase
Aplikácia s databázou 2 (Ajax)
38 - AJAX - jQuery cez bower, exclude adresárov v PHPStorme
Available only with full access purchase
39 - AJAX - Uloženie novej položky do databázy cez AJAX
Available only with full access purchase
40 - AJAX - Zobrazenie AJAXom vloženého prvku cez fajnú animáciu
Available only with full access purchase
41 - AJAX - Ovládanie klávesnicou a rozmýšľanie nad prioritami
Available only with full access purchase
42 - Editačný formulár a vlastná 404 not found stránka
Available only with full access purchase
43 - Tvorba kódu, konzistentnosť, refactoring, prepisovanie a hrdosť na kód
Available only with full access purchase
44 - Databáza - DB UPDATE, upravenie hodnoty v databáze na novú
Available only with full access purchase
45 - Edit a Delete linky na editačný formulár
Available only with full access purchase
46 - Dizajn aplikácií, rozmýšľanie nad prioritou a pointou každej feature
Available only with full access purchase
47 - Databáza - DB DELETE, vymazanie záznamu z databázy, crawlers & robots
Available only with full access purchase
48 - Ako prepojiť HTML element s DB riadkom cez IDčko + globálne premenovanie
Available only with full access purchase
49 - Nech PHP aj AJAX používajú ten istý HTML kód, AJAX edit / delete linky
Available only with full access purchase
50 - Adresa stránky v Javascripte, ako v JS čítať hodnoty a nastavenia z PHP a CSS
Available only with full access purchase
51 - JSON, json_encode, json_decode, preposielanie dát medzi PHP a Javascriptom
Available only with full access purchase
52 - PHP funkcie isset, empty, global, vlastné PHP funkcie show_404 a get_item
Available only with full access purchase
DÚ #04
Available only with full access purchase
DÚ #05
Available only with full access purchase
53 - PHP is_ajax, ako v PHP zistiť, či request je AJAX, učesanie TODO appky
Available only with full access purchase
DÚ #06
Available only with full access purchase
Základy programovania 1
54 - Programovanie - Základy programovania
Available only with full access purchase
55 - Programovanie - Filozofovanie o programovaní
Available only with full access purchase
Nepotrebuješ PHPStorm ani LiveEdit, ak nefunguje, POKOJNE IGNORUJ
Available only with full access purchase
56 - Nastavenie Live Edit v PHPStorme, automatický resfresh stránky
Available only with full access purchase
57 - Programovanie - Premenné
Available only with full access purchase
58 - Programovanie - PHP premenné v praxi, správne názvy premenných
Available only with full access purchase
59 - Programovanie - Dátové typy, čísla, integer, float, modulus, type casting
Available only with full access purchase
60 - Programovanie - Boolean, if else elseif, ako PHP vyhodnocuje hodnoty a typy
Available only with full access purchase
61 - Programovanie - PSR-2 coding style, Content Type header
Available only with full access purchase
62 - Programovanie - Stringy, apostrofy vs. úvodzovky, zalamovanie textu
Available only with full access purchase
63 - Programovanie - Skryté znaky, new line, line feed LF, carriage return CR
Available only with full access purchase
64 - Programovanie - Polia, PHP Array, unset count sort push pop shift unshift
Available only with full access purchase
65 - Prechádzanie cez polia, cykly, PHP Loops, foreach while
Available only with full access purchase
66 - For loop, vyskočenie z cyklu, continue break, array_filter array_values
Available only with full access purchase
67 - Multi-dimenzionálne, asociatívne polia (for real, skutočný názov)
Available only with full access purchase
Základy programovania 2
68 - Explode implode map trim, skrátený zápis pre PHP echo
Available only with full access purchase
DÚ #07
Available only with full access purchase
69 - Objekty, PHP Object, kedy asociatívne pole a kedy object, a konverzie medzi nimi
Available only with full access purchase
70 - PHP dokumentáciia kedy použiť PHP kedy Ruby, užitočné array a string funkcie
Available only with full access purchase
71 - Matice, cyklenie v cykloch, ako zisťovať a overovať dátové typy premenných
Available only with full access purchase
72 - Funkcie 1 - Kedy ich vytvárať, ternárny operátor, parametre a argumenty funkcií
Available only with full access purchase
73 - Funkcie 2 - Správne názvy funkcií, premenné vo vnútri a mimo funkcie
Available only with full access purchase
74 - Funkcie 3 - Funkcií pre lepšiu čitateľnosť kódu, formátovanie čísel v PHP
Available only with full access purchase
75 - Funckie 4 - Default hodnoty, variabilný počet argumentov, DocBlock komentáre
Available only with full access purchase
76 - Funkcie 5 - Local global premenné, PHP $_SERVER a $GLOBALS
Available only with full access purchase
77 - Funkcie 6 - $_SERVER, HTTP_REFERER, redirect status code, func_get_args
Available only with full access purchase
DÚ #08
Available only with full access purchase
JSON, XSS, COOKIES, SESSIONS
78 - Zápisník - Zapisovnie do súboru, timestamp, JSON na ukladanie dát
Available only with full access purchase
79 - Zápisník - Čítanie zo súboru, default ?: operátor, formátovanie textu a dátumu
Available only with full access purchase
80 - Zápisník - JSON vs PHP serialize, == vs ===, ošetrenie vstupov a prihlásenie
Available only with full access purchase
DÚ #09
Available only with full access purchase
81 - XSS Cross-site scripting, spracovanie viacerých inputov s rovnakým name
Available only with full access purchase
DÚ #10
Available only with full access purchase
82 - MySQL úvod, syntax, databázové debug funkcie
Available only with full access purchase
83 - COOKIES, SESSIONS
Available only with full access purchase
84 - Session flash message, alerty o úspechu a neúspechu
Available only with full access purchase
MySQL
85 - MySQL - SELECT, MySQL funkcie, formátovanie dátumu, textu a peňázov
Available only with full access purchase
86 - MySQL - SELECT 2, usporiadanie, limity, štatistické funkcie
Available only with full access purchase
87 - MySQL - INSERT, NULL, DEFAULT, IS NULL, NULLIF
Available only with full access purchase
88 - MySQL - UPDATE, DELETE, CREATE, TRUNCATE, DROP
Available only with full access purchase
89 - MySQL - SELECT 3, LIKE, COUNT(*) vs COUNT(1), úvod do JOIN
Available only with full access purchase
90 - MySQL - INNER JOIN, LEFT JOIN, RIGHT JOIN, OUTER JOIN, UNION, MULTI DELETE
Available only with full access purchase
91 - GROUP BY, HAVING vs WHERE, JOIN vs SUBQUERY, DISTINCT, poradie MySQL príkazov
Available only with full access purchase
92 - MySQL - Vytvorenie databázy pre Blog, CREATE TABLE a CREATE TRIGGER
Available only with full access purchase
93 - MySQL - Vzťahy 1:N, 1:1, M:N, PIVOT tabuľky, funkcia GROUP_CONCAT
Available only with full access purchase
Blog
94 - Blog - Magic konštanty __DIR__ a __FILE__, realpath cesty, filtrovanie dát, filter_var
Available only with full access purchase
95 - Blog - Čisté URL adresy, odstrániť index.php z adresy, .htaccess
Available only with full access purchase
96 - Blog - Čisté adresy, URI segmenty, Routing PART 1
Available only with full access purchase
97 - Blog - Čisté adresy, URI segmenty, Routing PART 2
Available only with full access purchase
98 - Blog - Pripojenie na databázu, PHP Data Objects, PDO Error modes
Available only with full access purchase
99 - PHP try catch, Exceptions, logovanie errorov do súboru
Available only with full access purchase
100 - Blog - Získanie, naformátovanie, očistenie a zobrazovanie príspevkov
Available only with full access purchase
101 - Blog - Automatická príprava postu na výpis, SQL Injection
Available only with full access purchase
102 - SQL Injection, PDO Prepared Statements
Available only with full access purchase
103 - Blog - Zoznam príspevkov patriacich tagu, Refactoring
Available only with full access purchase
104 - Blog - Editačný formulár, predvyplnenie hodnôt, predvyznačenie tagov
Available only with full access purchase
105 - Blog - Editácia, sanitácia, validácia, UPDATE príspevku
Available only with full access purchase
106 - Blog - Pridanie nového príspevku, INSERT post, validácia
Available only with full access purchase
DÚ #11
Available only with full access purchase
107 - Blog - Mazanie, DELETE post, znovu-vyplnenie inputov ak neprejde validácia
Available only with full access purchase
Registrácia a login používateľa
108 - Login, PHP autentifikácia, autorizácia, HASH funkcie
Available only with full access purchase
109 - Autorizačné, Autentifikačné pekidže
Available only with full access purchase
110 - Nastavenie PHPAuth, PART 1
Available only with full access purchase
111 - Nastavenie PHPAuth, PART 2
Available only with full access purchase
112 - Registrácia používateľa, odosielanie emailov cez PHP
Available only with full access purchase
113 - Login, prihlásenie používateľa
Available only with full access purchase
114 - Login, logout, get_user, pomocné funkcie, skrytie obsahu za loginom
Available only with full access purchase
115 - Autorizácia, posty patria userom, majú autorov, KONIEC
Available only with full access purchase
DÚ #12
Available only with full access purchase
Záver
116 - Záver PHP a MySQL kurzu
Available only with full access purchase
DÚ #13
Available only with full access purchase
Yablko (Roman Hraška) Yablko (Roman Hraška)
Front-end, back-end
24 Online courses
0 Posts