Essential

Building Dynamic Web Sites with MySQL

By: Simon Stobart

Write A Review

Paperback | 28 June 2002

At a Glance

Paperback
268 Pages

Dimensions(cm)
22.86 x 15.24 x 1.91

Paperback

$84.99

or 4 interest-free payments of $21.25 with

Ships in 5 to 7 business days

How to create dynamic web environments using the PHP language and the MySQL database!
If you are familiar with the syntax for C, C++ and Java, then PHP will seem very familiar. Once you have got up to speed with this HTML embedded scripting language, you will soon be creating dynamic HTML database-enabled web pages quickly and easily.
This quick and practical introduction explains:
- how PHP works and what a dynamic web page is;
- the software development environment;
- the syntax and features of the language;
- how PHP can be integrated with MySQL databases;
- dynamic database applications.
Clearly written, this book provides you with all the essential information you need to create your own dynamic web environments using PHP.
Additional material is available from the Essential series web site: http://www.essential-series.com

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Graphical & Digital Media Applications Web Graphics & Design Computer Programming & Software Development Database Programming Programming & Scripting Languages Web Programming Computer Science Databases Information Retrieval Gardening

Digital Lifestyle & Online World: Consumer & User Guides Internet Guides & Online Services Software Engineering Data Warehousing Business Applications

Introduction	p. 1
Introduction	p. 2
Why PHP and MySQL?	p. 2
Is this Book for You?	p. 3
How to Use this Book	p. 4
Creating a Typical PHP Development Environment	p. 7
Introduction	p. 8
Web Browser	p. 8
Web Server	p. 10
PHP	p. 15
Text Editor	p. 15
Database	p. 16
Summary	p. 16
Introducing PHP	p. 17
Introduction	p. 18
A Simple HTML Document	p. 18
First PHP Script	p. 19
The History of PHP	p. 22
Static and Dynamic Web Pages	p. 22
How Is PHP Different?	p. 23
Formatting PHP Instructions	p. 25
Jumping In and Out of PHP	p. 25
Echo and Print Statements	p. 26
Comment Statements	p. 27
Summary	p. 28
Variables: Integer and Floating-Point Data Types	p. 31
Introduction	p. 32
What Is a Variable?	p. 32
Assigning a Variable by Value	p. 33
Assigning a Variable by Reference	p. 34
Different Types of Variables	p. 36
Integers	p. 37
Floating-Point Numbers	p. 39
Summary	p. 41
Variables: Strings	p. 43
Introduction	p. 44
Single Quoted Strings	p. 44
Double Quoted Strings	p. 45
Variables in Strings	p. 46
Joining Strings	p. 47
Referencing Characters in a String	p. 48
String Length	p. 50
Converting Strings	p. 51
Summary	p. 53
Accessing Environment and PHP variables	p. 55
Introduction	p. 56
Predefined Variables	p. 56
Environment Variables	p. 57
PHP Variables	p. 60
Summary	p. 61
Investigating Expressions, Operands and Operators	p. 63
Introduction	p. 64
Expressions	p. 65
Operators	p. 66
Operands	p. 66
Arithmetic Operators	p. 67
The Assignment Operator	p. 68
Bit Manipulation Operators	p. 70
Comparison Operators	p. 73
The Conditional Operator	p. 73
Increment and Decrement operators	p. 74
Logical Operators	p. 76
Operator Precedence	p. 77
Summary	p. 79
Controlling the Flow of Control	p. 81
Introduction	p. 82
Sequence, Selection and Iteration	p. 82
The if Statement	p. 84
The else Statement	p. 85
The elseif Statement	p. 87
The while Loop	p. 88
The do while Loop	p. 90
The for Loop	p. 91
Nested Loops	p. 94
Breaking Out of Loops	p. 96
The continue Statement	p. 97
The switch Statement	p. 98
Summary	p. 101
Interacting with the User	p. 103
Introduction	p. 104
PHP and Forms	p. 104
Simple Form Processing	p. 104
GET and POST Methods	p. 107
Combining PHP and Forms	p. 107
Retaining Form Field Data	p. 110
Interacting with a PHP Application	p. 113
Summary	p. 115
Arrays	p. 117
Introduction	p. 118
Single-Dimensional Arrays	p. 118
Multi-Dimensional Arrays	p. 121
Arrays and the foreach Loop	p. 125
Strings and Arrays	p. 126
Combination Arrays	p. 127
Manipulating Arrays at Run Time	p. 129
Summary	p. 131
The MySQL Database Management System	p. 133
Introduction	p. 134
What Is MySQL?	p. 134
Starting the Database	p. 135
Creating a Database	p. 136
Dropping a Database	p. 139
Hiding the WinMySQLadmin Application	p. 140
Creating Database Tables	p. 140
Selecting a MySQL Database	p. 142
Creating Database Tables from a Dump File	p. 145
Dropping MySQL Databases and Tables	p. 147
Quitting MySQL	p. 147
Summary	p. 147
Accessing MySQL Databases Using PHP	p. 149
Introduction	p. 150
A Simple PHP Script to Display Database Records	p. 150
Accessing Multiple Records by Record Number	p. 153
Accessing Multiple Records by Column Name	p. 154
Checking for the Existence of Records	p. 156
Searching for Specific Records	p. 157
Using HyperLinks to Select Records	p. 159
Using a Form to Select Records	p. 161
Using a Form to Search on Different Fields	p. 163
Adding Records	p. 166
Deleting Records	p. 169
Updating Records	p. 171
Summary	p. 173
Implementing Functions	p. 175
Introduction	p. 176
Advantages of Functions	p. 176
A Simple Function	p. 177
More Power to Functions: Using Arguments	p. 180
Functions with Multiple Parameters	p. 182
Functions and Local Variables	p. 184
Arguments Passed by Value	p. 185
Arguments Passed by Reference	p. 186
Default Argument Values	p. 188
Returning a Value from a Function	p. 189
Function Calls Within Functions	p. 192
Summary	p. 194
Cookies	p. 195
Introduction	p. 196
Limitations of Cookies	p. 196
Setting a Cookie	p. 196
Viewing a Cookie	p. 198
Deleting a Cookie	p. 199
Using Cookies to Personalize Pages	p. 199
Summary	p. 201
File Handling	p. 203
Introduction	p. 204
Opening a File	p. 204
Closing a File	p. 205
Reading Characters from a File	p. 206
The End of File Function	p. 209
Reading Lines from a File	p. 209
Reading a Remote File	p. 211
Writing to a File	p. 213
Summary	p. 214
Classes and Objects	p. 215
Introduction	p. 216
A Simple Class	p. 217
Accessing an Object's Variables	p. 220
Multiple Objects of a Class	p. 222
Constructors	p. 224
Arrays of Objects	p. 225
Objects in Objects	p. 226
Inheritance	p. 230
Summary	p. 233
Further Information Resources	p. 235
Introduction	p. 236
The PHP Manual	p. 236
The PHP Online Manual and FAQ	p. 237
The MySQL Manual	p. 238
The MySQL Online Manual and FAQ	p. 239
Other Online Resources	p. 240
And Finally	p. 241
Index	p. 243
Table of Contents provided by Publisher. All Rights Reserved.

Essential

Building Dynamic Web Sites with MySQL

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Data Warehousing

Real-Time Intelligence with Microsoft Fabric

Empowering Data-Driven Decisions in the Era of AI

Designing Data-Intensive Applications

The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Building a Scalable Data Warehouse with Data Vault 2.0

Data Science on AWS

Implementing End-To-End, Continuous AI and Machine Learning Pipelines

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Data Governance: The Definitive Guide

People, Processes, and Tools to Operationalize Data Trustworthiness

SQL Pocket Guide

A Guide to SQL Usage

Data Strategy

How to Use Data and Artificial Intelligence to Transform Your Business

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

In a Nutshell (O'Reilly)

In a Nutshell (O'Reilly)

Data-Centric Artificial Intelligence for Multidisciplinary Applications

Intro to Python for Computer Science and Data Science

Learning to Program with AI, Big Data and The Cloud, Global Edition

Amazon Redshift: The Definitive Guide

Jump-Start Analytics Using Cloud Data Warehousing

Fundamentals of Data Observability

Implement Trustworthy End-To-End Data Solutions

Data Quality Techniques

Fix Your Data and Transform Your Business

Data Quality Techniques

Fix Your Data and Transform Your Business

Advances in Information Retrieval

48th European Conference on Information Retrieval, ECIR 2026, Delft, The Netherlands, March 29 â" April 2, 2026, Proceedings, Part IV

Health Information Processing

11th China Health Information Processing Conference, CHIP 2025, Dongguan, China, November 22â"24, 2025, Proceedings

Ai-Ready Data Blueprints

From Raw Data to Ai-Driven Innovation

Data Pipelines with Apache Airflow, Second Edition

Orchestration for data and AI

Collaborative Computing: Networking, Applications and Worksharing

21st EAI International Conference, CollaborateCom 2025, Shanghai, China, November 15â"16, 2025, Proceedings, Part I

Learning SQL

Generate, Manipulate, and Retrieve Data

Practical Statistics for Data Scientists

50+ Essential Concepts Using R and Python

Accelerating Cloud Adoption

Optimizing the Enterprise for Speed and Agility

This product is categorised by