Page 231 - Open Soource Technologies 304.indd
P. 231
Open Source Technologies
Notes Unit 14: Connecting to MYSQL with PHP
CONTENTS
Objectives
Introduction
14.1 Connecting to MySQL with PHP
14.1.1 Creating the Connection
14.1.2 Closing the Connection
14.2 Working with MySQL Data
14.2.1 Connecting to the Server
14.2.2 Connecting to the MySQL server
14.2.3 Issuing Queries
14.2.4 Creating a Database
14.2.5 Removing a Database
14.2.6 Creating Tables
14.2.7 Inserting Data into the Table
14.2.8 Retrieving Information from a Table
14.2.9 Editing and Deleting Records
14.2.10 Altering the Structure of Tables
14.2.11 Dropping a Table
14.2.12 Working with NULL Value
14.2.13 Backing up a Database
14.3 Summary
14.4 Keywords
14.5 Self Assessment Questions
14.6 Review Questions
14.7 Further Reading
Objectives
After studying this unit, you will be able to:
• Discuss creating the connection.
• Discuss closing the connection.
• Understand with MySQL Data.
226 LOVELY PROFESSIONAL UNIVERSITY
