Cyber Zone Technologies

PHP & MySQL

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. PHP and MySQL Database Development and Administration is a practical hands-on course that covers the key and fundamental areas of the PHP Web scripting language and the development and administration of MySQL databases. It is excellent for creating dynamic, database-driven Web sites. PHP (Hypertext Preprocessor) is a tool that lets you create dynamic web pages. PHP - enabled web pages are treated just like a regular HTML pages and you can create and edit them the same way you normally create regular HTML pages. The course will take you through all you need to know to use PHP in creating an incredible web site. MySQL is the leading open source relational database management system and is extensively deployed around the world. Gain the skills needed to administer and maintain MySQL databases. A database can do many things like collection of data and whatever the data is depends on the kind of database you are currently working with e.g. of database used in our everyday lives include - address books, card index, etc. e.g of DBMS (Database Management System) are Oracle, MS - SQL, Access, MYSQL etc. MYSQL in particular is flexible, fully featured and very powerful. MYSQL is also seen as a natural partner of PHP.

Advantage of the Course

PHP Hypertext Processor is a server-side web programming language that can be embedded into HTML. PHP uses are widespread, and can include any kind of server functionality that takes user's input and displays or manipulates the input. PHP can run on both UNIX and Windows servers, which makes it more accessible than Windows (ASP). This scripting language is growing day by day. PHP5 a fully object oriented language and its platform independence and speed on Linux server helps to build large and complex web applications.PHP is a particularly useful programming language because it allows for advanced programming and is easy to integrate with web pages. Another plus of PHP is that the language interfaces very well with MySQL, a popular type of online database. MYSQL is a commercial grade database application that is made available free under the Open Source to anyone. Another plus of PHP is that it is Open Source Code. The actual code that is PHP is available to the public for free, while the source code for products such as ASP is not. So PHP is very cheap. Because PHP is open source, there is a large community of PHP programmers that help each other with code. This means PHP programmers can rely on each other by using reusable pieces of code called functions and classes rather than constantly reinventing the wheel. This can dramatically cut down on production time.

Course Outline

Module 1. Introduction


Module 2. Basic PHP Development


Module 3. Control Structures


Module 4. Functions


Module 5. Arrays


Module 6. Working with the file system


Module 7. Working with forms


Module 8. Introduction to database


Module 9. cookies


Module 10. Session


Module 11. Disk Spaces,,I/O,Math and Mail


Module 12. JavaScript


Module 13. Cascading style sheet


Module 14. Joomla (Content Management System and Web Application Framework)


Module 15. Smarty (Library For Creating HTML Templates)


Module 16. Cake PHP (Rapid Development Framework)