PHP and MySQL Course Repository
Software Academy Soft Intellect
Slides( HTML format)
- 01-Introduction-into-Course
- 01-Introduction-into-Development
- 01-Introduction-into-PHP
- 01-Version-Control-Systems
- 02-HTML-basics
-
03-CSS
Links
CSS Selectors - 04-PHP-BASICS
- 05.DEBUG-1
- 05.PHP-BASICS-2
- 06.PHP-BASICS-ARRAY
- 07.FUNCTIONS
-
08.WORKING-WITH-FORMS
Links
Input element - 09.MYSQL-BASIC
-
10.MYSQL-ADVANCED
Links
MySQL Workbench -
11.PHP-AND-MYSQL
Links
PHP passwords - 12.OOP
- 13.Practice-webshop
- 14.OOP-IN-USE
-
15.SMALL-POLISHINGS
Links
PushOver - 16.Group-practice-blog
Examples( HTML format)
- 01.html-css-introduction
- index.html ( view )
- 02.html-basics
- 1.html-basic.html ( view )
- 2.html-structure.html ( view )
- 3.common-elements.html ( view )
- 4.html-tables.html ( view )
- 5.page-structure-divs.html ( view )
- 6.page-structure-html5.html ( view )
- 03.css-basics
- 1.css-with-attribute.html ( view )
- 2.inline-css.html ( view )
- 3.css-external-file.html ( view )
- 4.css-simple-selectors.html ( view )
- 5.css-selectors.html ( view )
- 6.color-values.html ( view )
- 7.box-model.html ( view )
- 8.css-sizes-documentation.html ( view )
- 9. text-properties.html ( view )
- 10.html-background.html ( view )
- 11.opacity.html ( view )
- 12.width.html ( view )
- 13.height.html ( view )
- 14.overflow.html ( view )
- 15.display.html ( view )
- 16.display-table.html ( view )
- 17.visibility.html ( view )
- 18.css-positioning.html ( view )
- 19.css-floating.html ( view )
- 04.php-basics
- 01.hello-word.php ( view )
- 02.php-embaded-in-html.php ( view )
- 03.html-generated-by-php.php ( view )
- 04.php-comments.php ( view )
- 05.php-simple-variables.php ( view )
- 06.php-variables-types.php ( view )
- 07.php-concatenation.php ( view )
- 08.simple-if-else.php ( view )
- 09.condition-operators.php ( view )
- 10.php-logical-operators.php ( view )
- 11.php-logical-operators-priority.php ( view )
- 12.if-else-if-simple.php ( view )
- 13.if-else-if.php ( view )
- 14.switch-construction.php ( view )
- 15.random.php ( view )
- 16.arithmetic-operators.php ( view )
- 17.modular-operator.php ( view )
- 18.pre-post-ops.php ( view )
- 05.debug-1
- 01.echo.php ( view )
- 02.print.php ( view )
- 03.print_r.php ( view )
- 04.var_dump.php ( view )
- 05.var_export.php ( view )
- 05.php-loops-includes
- 01.strings.php ( view )
- 02.conditions.php ( view )
- 03.while-loop.php ( view )
- 04.do-while-loop.php ( view )
- 05.for-loop.php ( view )
- 06.break.php ( view )
- 07.continue.php ( view )
- 08.php-define.php ( view )
- 09.include.php ( view )
- 10.header.php ( view )
- 11.footer.php ( view )
- 12.example.php ( view )
- 06.php-arrays
- 01.simple-array.php ( view )
- 02.initialization.php ( view )
- 03.print-array.php ( view )
- 04.add-remove-elements.php ( view )
- 05.array-iteration-for.php ( view )
- 06.associative-arrays.php ( view )
- 07.foreach.php ( view )
- 08.bublesort.php ( view )
- 09.array-functions.php ( view )
- 10.multidemensional-arrays.php ( view )
- 07.functions
- 01.simple-functions.php ( view )
- 02.params.php ( view )
- 03.default-params.php ( view )
- 04.return.php ( view )
- 05.reference.php ( view )
- 06.variating-params.php ( view )
- 07.scope.php ( view )
- 08.static-variables.php ( view )
- 08.working-with-forms
- 01.html-forms.php ( view )
- 02.print-form-values.php ( view )
- 02.submitting-forms.php ( view )
- 03.post-request.php ( view )
- 04.get-request.php ( view )
- 05.php-validation.php ( view )
- 06.php-bad-input.php ( view )
- 07.php-select-element.php ( view )
- 09.introduction-to-mysql
- 01.world_database.sql ( view )
- 02.create-table.sql ( view )
- 03.alter-table.sql ( view )
- 04.insert-data.sql ( view )
- 05.update-column.sql ( view )
- 06.select-simple.sql ( view )
- 07.select-where.sql ( view )
- 08.select-like.sql ( view )
- 09.order-by.sql ( view )
- 10.advanced-mysql
- 01.one-to-one.sql ( view )
- 02.one-to-many.sql ( view )
- 03.many-to-many.sql ( view )
- 04.aliases.sql ( view )
- 05.union-simple.sql ( view )
- 06.union-multiple-tables.sql ( view )
- 07.kindergarder-export.sql ( view )
- 08.join-simple.sql ( view )
- 09.left-join.sql ( view )
- 10.right-join.sql ( view )
- 11.multiple-join.sql ( view )
- 12.count.sql ( view )
- 13.average.sql ( view )
- 14.sum.sql ( view )
- 15.min-max.sql ( view )
- 11.php-and-mysql
- 01.php-insert-data.php ( view )
- 02.php-select-data.php ( view )
- 03.php-work-with-data.php ( view )
- 04.php-update.php ( view )
- 05.php-delete.php ( view )
- 06.users-table.sql ( view )
- 07.user-registration.php ( view )
- 08.login.php ( view )