Content management system

1
Content management system

• CMS (Drupal, Joomla)

2
WHAT IS CMS?

• Used to manage work flow needed to create, edit,
  review, index, search and publish the web page.
• Most of the CMS are developed by Php and MySQL.
  Ex Drupal, Mambo/Joomla, Wordpress, etc.
• Drupal One of the best CMS
• www.drupal.org website
• Drupal 6 download, themes, modules

3
PHP (Personal Home Page)

• One of the Server side Scripting Language.
• Other Server side Scripting Languages are ASP
  (Active Server Page) , JSP (Java Server Page),
  Python and etc.
• http//www.php.net/get/php-5.2.10-Win32.zip/from/a
  /mirror - PHP software for windows
• Hello world
• lt?php
• echo (Hello World)
• ?gt

4
MySQL

• OPEN SOURCE database.
• http//dev.mysql.com/get/Downloads/MySQL-4.1/mysql
  -4.1.22-win32.zip/from/pickmirrors
• Apache is a server which used to run php
  programs.
• Apache, MySQL, PHP together for windows

Apache
wamp
5
Working with wamp
6
Introduction to php

• Create helloworld.php as follows
• Notepad
• lt?php
• echo (Helloworld)
• ?gt
• Save as C\wamp\www\helloworld.php
• Open browser and type URL
• http//localhost/helloworld.php

7
datatypes

• Integer
• Ex age22
• Float
• Ex temperature98.6
• String
• Ex nameMANI
• Arrays
• Ex name5
• name0mani
• a  array(1 gt 'one', 2 gt 'two', 3 gt 'three')

8
statements

• If..elseif..else
• if (condition)  code to be executed if condition
  is true
• elseif (condition)  code to be executed if
  condition is true
• else  code to be executed if condition is false
• FOR loop
• (for i0ilt5i)
• echo (i)
• WHILE loop
• while ( ilt10)
• //do this code

9
Php within html

• ltHTMLgt
• ltHEADgtltTITLEgtphp with htmllt/TITLEgtlt/HEADgt
• ltBODYgt
• lt?php
• Echo (ltbgtHello lt/bgtltfont colorredgtWorldlt/fontgt)
  
• ?gt
• lt/BODYgt
• lt/HTMLgt
• RESULT
• Hello World

10
Working with mysql
11

• create database database-name
• Ex create database students
• use students (to select database)
• create table year1(name varchar(10), age int(2),
  primary key(name))
• PRIVILEGES
• grant all privileges on . to username _at_
  localhost identified by password with grant
  option