PHP MYSQL basic Training Course
Duration:
35 HRS
Subjects:
PHP, MYSQL, HTML, CSS
- concept on open source technology
- about GPL and GNU fundation
- About Apache , MySQL , PHP on Linux Platform
- Installation of Apache,MySQL and PHP on Linux,Windows and Mac OS
- About Xampp , Wamp ,Lamp and Mamp Software and installation
- settings in php.ini file
- settings in httpd.conf file
- php basic syntax
- Your first php code with Hello World
- php variables
- php echo keyword for printing data
- php print keyword for printing data
- Difference between echo and php keyword
- php constant with const keyword
- php constant with define() function
- php constant with defined() function
- php isset() function to check variables & constant
- php unset() function to remove variables,array & constant
- difference between single quote (') and double quote (") in php
- php error with parse error
- php error with notice
- php error with fatal error
- php error with warnings
- php 3 types of comments
- php arithmatatic operators
- php logical operators
- php not operator
- php conditional operator
- php ternary operator
- php if else
- php nested if
- php for loop
- php while loop
- php switch case
- php numeric array
- php associative array
- php mixed array
- php multi dimensional array
- php foreach loop with values
- php foreach loop with indexes and values both
- php print_r() function for array and objects
- php explode() function
- php implode() function
- php count() function
- php sort() function
- php asort() function
- php ksort() function
- php rsort() function
- php arsort() function
- php ksort() function
- php array_count_values() function
- php array_sum() function
- php array_product() function
- php strtoupper() function
- php strtolower() function
- php strtolower() function
- php ucwords() function
- php ucfirst() function
- php lcfirst() function
- php substr() function
- php ltrim() function
- php rtrim() function
- php trim() function
- $_POST
- $_GET
- $_REQUEST
- $_SERVER
- $_FILES
- $_SESSION
- $_COOKIE
- move_uploaded_function()
- MIME File type
- file Name
- file tmp_name
- file size in bytes
- file error type
- form method post
- form method get
- form action attribute
- form enctype attribute
- submit form using submit button
- form input textbox
- form input password box
- form input file
- MySQL Database create query
- MySQL table create query
- MySQL show table query
- MySQL delete tables query
- MySQL drop database query
- MySQL alter table query
- MySQL alter column query
- MySQL insert query
- MySQL select query
- MySQL delete query
- MySQL update query
- MySQL where clause
- MySQL where clause with and & or logic
- MySQL between query
- php to mysql connection using mysqli_connect()
- php to mysql query execution using mysqli_error()
- php to mysqli connection with hostname,username,password and database
- php to mysql connection with mysqli_error()
- php mysql process with die() function
- php to mysql host connection using mysql_connect()
- php to mysql database connection using mysql_select_db()
- php to mysql query execution using mysql_error()
- php to mysqli connection with hostname,username,password and database
- php to mysql connection with mysql_error()
- php mysql process with die() function
- php with insert in database from userdefined form
- php with show records from mysql database in table format
- php with delete operation in mysql database using link tag
- php with update operation in mysql database using link tag