PC TRAINING: Working With PHP

Working With PHP

This Manual is for developing a web application starting fromScratch , we here discuss every thing from the Beginning and giving you a step by step knowledge , expecting you don’t know about the web development, how can you start web development, what is the requirements & tools, what is theeditors to be used etc.In spite of these we here give a step by step help section, print screens, Interview Questionsand appendix to actually visualize you to grasp the Logic as well as presentation of actual web development.

This manual, teaches you all flavors of development phases starting from Learning the concept, explaining with examples, basic requirement for a software development, tools software’s, leaning materials and giving the idea of how a software development process going on with providing DFD, flowchart E-R diagram, and suitable screen shots and of course project documentation.

And as soon as you follow this, at the last you must feel that the fear of the evil of development will go, and now you have capability to develop software.

STRUCTURE PATTERN

FLOW CHART

FLOW CHART: A flowchart is common type of chart, that represents an algorithm or process, showing the steps as boxes of various kinds, and their order by connecting these with arrows. Flowcharts are used in analyzing, designing, documenting or managing a process or program in various fields.

A flow chart can therefore be used to:

• Define and analyze processes;

• Build a step-by-step picture of the process for analysis, discussion, or communication; and

• Define, standardize or find areas for improvement in a process

	Start and End This symbol is used to indicate both the beginning and the end of your program.
	Graphic/Text This symbol indicates individual content for screens, pages, or frames.
	Decision This symbol is used when there is interactivity between your audience and the program. It is usually in the form of a yes/no question, with branching flow lines depending upon the answer.

System Flow Chart: A system flowchart explains how a system works using a diagram. The diagram shows the flow of data through a system.

In our language a system Flow chart is a presentation of all process in our page( web).Through which we can show what types of process is being used throughout the programmed. (it does not have any decision box ) and every process is separately shown in the flow chart.

Flow chart for individual process

1:- Flow chat for user process

2:- Flow chat for Edit process

3:- Flow chat for user process

Flow chart for Admin:

STRUCTURE PATTERN

DATA FLOW DIAGRAM (DFD) :

DATA FLOW DIAGRAM (DFD) : A data-flow diagram (DFD) is a graphical representation of the "flow" of data through an information system. It differs from the flowchart as it shows the data flow instead of the control flow of the program.

A data-flow diagram can also be used for the visualization of data processing (structured design).

Data flow diagrams are used to describe how the system transforms information. They define how information is processed and stored and identify how the information flows through the processes.

0 Level DFD:

Context Level DFD

1st Level DFD:

First Level Data Folw Diagram

2nd Level DFD:

STRUCTURE PATTERN

E-R DIAGRAM:

Database

Creating Database

Table structure for table admin's

Field	Type	Null	Default
id	tinyint(6)	Yes	NULL
user	varchar(25)	Yes	NULL
pass	varchar(255)	Yes	NULL
name	varchar(25)	Yes	NULL
created	datetime	Yes	NULL
updated	timestamp	Yes	CURRENT_TIMESTAMP

Table structure for table categories

Field	Type	Null	Default
id	tinyint(6)	Yes	NULL
name	varchar(25)	Yes	NULL
remarks	tinytext	Yes	NULL
status	enum('0', '1')	Yes	NULL

Table structure for table questions

Field	Type	Null	Default
id	int(11)	Yes	NULL
category_id	tinyint(6)	Yes	NULL
question	tinytext	Yes	NULL
option_a	varchar(100)	Yes	NULL
option_b	varchar(100)	Yes	NULL
option_c	varchar(100)	Yes	NULL
option_d	varchar(100)	Yes	NULL
ans	enum('a', 'b', 'c', 'd', 'e')	Yes	NULL
status	enum('0', '1', '2')	Yes	NULL
created	datetime	Yes	NULL
updated	timestamp	Yes	CURRENT_TIMESTAMP

Table structure for table quizzes

Field	Type	Null	Default
id	bigint(20)	Yes	NULL
user_id	int(11)	Yes	NULL
category_id	tinyint(6)	Yes	NULL
total	tinyint(6)	Yes	NULL
correct	tinyint(6)	Yes	NULL
wrong	tinyint(6)	Yes	NULL
skip	tinyint(6)	Yes	0
created	timestamp	Yes	CURRENT_TIMESTAMP

Table structure for table users

Field	Type	Null	Default
Id	int(11)	Yes	NULL
user	varchar(50)	Yes	NULL
pass	varchar(255)	Yes	NULL
name	varchar(50)	Yes	NULL
Dob	date	Yes	NULL
gender	enum('m', 'f')	Yes	NULL
qualification	varchar(100)	Yes	NULL
email	varchar(50)	Yes	NULL
phone	varchar(12)	Yes	NULL
status	enum('0', '1', '2')	Yes	NULL
created	datetime	Yes	NULL
updated	timestamp	Yes	CURRENT_TIMESTAMP