PHP PROGRAMMING FOR YOU : PHP PROGRAMMING FOR YOU DAY 3
WHERE WE ARE : WHERE WE ARE On Day 1:
Why PHP
Where are we reaching after 10 hours
What do you need to know- The Pre-requisites
"Hello PHP" example
"Hello yourname" - Dynamic pages
On Day 2:
PHP Basics
LAMP/WAMP- wampserver- overview- Control Panel
MySQL
using resources @ php.net;
BlueFish Editor: Sample Code:Snippets
Data Types, Variables, Changing Variable Types
WHAT YOU SHOULD HAVE ON DAY 3 : WHAT YOU SHOULD HAVE ON DAY 3 A working LAMP/ WAMP stack- wampserver
BlueFish Editor
Connecting phpMyAdmin
Patience. :)
DATABASE BASICS : DATABASE BASICS Collection of Data in form of Tables is a Database
Tables without any relationship with any other tables in a database does not make it efficient. That is why we have 'Relational' database
For example, Employee and Payroll table
RDBMS
RDBMS stands for Relational Database Management System.
RDBMS is the basis for SQL, and for all modern database systems like MySQL, Oracle, IBM DB2, Microsoft SQL and more.
The data in RDBMS is stored in database objects called tables.
A table is a collection of related data entries and it consists of columns and rows.
MYSQL - INTRODUCTION : MYSQL - INTRODUCTION - MySQL is a Open Source, Relational Database system
- Widely used for web sites.
- Allows Multiuser access to multiple Databases
-SQL is a standard language for accessing databases.
- SQL can be used to access and manage databases systems like MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.
MYSQL : MYSQL MySQL is a Relational Database Software
You can create one or more database in each installation instance
Database is a collection of Tables
Tables has columns and rows
The columns of Tables can be related to other columns of the table in a database.
USING SQL : USING SQL What Can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
DEMO USING PHPMYADMIN : DEMO USING PHPMYADMIN Open phpmyadmin (on the wampserver)
create a database
Notice the command executed
Run the same command with a new database name in the SQL command window of phpmyadmin
See the list of database created
Drop them
Create again
Create tables (with fields whch is no. of cloumns)
enter the field info now asked by phpmyadmin
notice autoincrement
notice the SQL command used
WORKING WITH MYSQL : WORKING WITH MYSQL Need three parameters to be used as args to connect to Databas
hostname
username
password
$dbname = "mydb";
$dbConnection = mysql_connect($hostname, $username, $password);
$dbSelection = mysql_select_db($dbname, $dbConnection);