The usage of databases in
A continuation of the series,
As your website grows you may
This is a detailed tutorial
larger web-based
"Data Integrity Using
run into two problems: Your
intended for the PHP
applications is essential.
MySQL and PHP," this
website has so much
programmer interested in
By using basic
article discusses the
information that visitors
learning more about database
object-orientated techniques
concept of auto_increment
can't quickly find what they
connectivity - using the
we can minimize the fuss of
fields in MySQL, to cause
want and visitors want to
ODBC standard. You should be
connecting and interacting
MySQL to store a unique,
give you information. Both
familiar with PHP syntax and
with a database. We can also
incrementing integer in the
of these problems can be
have a working knowledge of
reuse this code in other
field of each new row.
solved by building a
databases.
applications: a huge benefit
database on a website. This
of 'OO' programming.
introductory article shows
you how to do this using
basic PHP-MySQL interaction.
Date: Apr, 29 2003 Date: Dec, 06 2000 Date: Jan, 18 2000 Date: Mar, 26 2001 |
Got a MySQL database with
OO approach described in this
This is an overview of
When interacting with a
content within it? Want to
article helps to create data
relational database
database, functions are
be able to search it and
layer abstractions which are
concepts, specifically
called that are common to
display paged search results
easy to port to other
MySQL. It illustrate each of
every transaction; functions
on screen? This tutorial and
databases without altering
the concepts through simple
to establish a connection,
script will do just that.
the application code
examples.
execute the query and then
(Apache, PHP, MySQL database
close the connection. This
required)
article shows how to create
functions that will
eliminate this redundancy.
The tutorial uses MySQL as
the database, but the
database layer is
irrelevant. These functions
can be adapted to use other
databases.
Date: Jan, 06 2003 Date: Apr, 16 2005 Date: Dec, 06 2000 Date: Jul, 17 2000 |