PDA Software - Analysis PHP Processing

PHP

• ‘PHP: Hypertext Pre-processor’ (PHP)is one of several programming

languages that includes instructions for operating on a server to act as
an interface between the web pages written in HTML that the user
sees and SQL databases that they access.

• PHP operations are normally hidden from the user, accepting input by

way of HTML Forms and providing output in the form of HTML code
that is sent to the user's browser for display.

PHP

• A ‘.php’ file can contain a mixture of HTML, CSS, JavaScript and

PHP code making them very flexible.

• However, a web browser ignores the PHP code and does not

execute the code.

• Any ‘.php’ file is processed by the server and the results sent to

the user as HTML code.

PHP

Most PHP programs follow the same basic sequence:
1. Connect to database
2. Accept name=value pairs from web page and assign to

variables

3. Create SQL query and submit to SQL server
4. Receive results from SQL server
5. Process the results
6. Transmit results to user in a formatted webpage.

PHP
Process

1. Connect to database
2. Accept name=value pairs from

web page and assign to
variables

3. Create SQL query and submit

to SQL server

4. Receive results from SQL

server

5. Process the results
6. Transmit results to user in a

formatted webpage.

Set up connection variables
Connect to the Database
Set up query and result variables
WHILE

Retrieve field names (Product Code, Product name, etc.)
DISPLAY field names (Product Code, Product name, etc.)
END WHILE

CLOSE DATABASE
RETURN

Pseudocode