Page 518 - Computer_Science_F5

In this example when you open the (b) HTML page integrating PHP to
HTML file in a web browser, it will
display the dynamic content fetched
from the database and styled using
the CSS. This allows you to create a
FOR ONLINE READING ONLY
dynamic gallery of farming crops based
on the data stored in this database.
Activity 8.27:
Creating dynamic content with php
Aim:
To demonstrate the integration of
PHP within HTML and CSS to create
dynamic web content, including
displaying text and current date
dynamically retrieved from a server-
side script.
Materials:
1. Computer with Internet access
2. PHP development environment
(Such as XAMPP, WAMP)
3. Text editor (Such as Visual Studio
Code, Sublime Text)
Instruction:
Develop a basic PHP script to showcase
“Welcome to the computer science
course!” along with today’s date on a
web page. Additionally, integrate PHP
within HTML and CSS to generate
dynamic content from a local database
table with four columns.
Deliverables:
(a) PHP script displaying “Welcome
to the computer science course!”
and the current date.
509
Student’s Book Form Five
Computer Science Form 5.indd 509
display dynamic content.
(c) Optionally, demonstrate the use of
PHP to fetch and display data from
a local database table. Chapter Eight: Databases and Database Management Systems
Integrating or connecting PHP with
SQL database
This section connects PHP to an SQL
database, enabling you to create, read,
update, and delete database records
through a PHP application.
PHP and SQL can be integrated for web
development. When a user requests a
web page that needs database access,
the PHP script on the server retrieves
the data from the database and generates
the HTML code for the page. Thus,
Integrating PHP with SQL typically
involves connecting to a database using
PHP code and then executing SQL
queries to retrieve or manipulate data. To
connect PHP to MySQL, you can use the
MySQLi extension or PDO (PHP Data
Objects). MySQLi is object-oriented
and only works with MySQL databases,
while PDO can work with different
database systems. These methods allow
developers to create, read, update, and
delete database records.
Case 1: Connecting PHP to MySQL
using MySQLi function
Connecting PHP to SQL systems like
MySQL using the MySQLi extension is
a common approach. It involves setting
up a connection by providing details
23/07/2024 12:35