|
Got a MySQL database with
If you are writing an
This is a MySQL CHM (Compiled
This is a nice tutorial on
content within it? Want to
application that is used in
HTML Manual), based on
how to use PostgreSQL and
be able to search it and
multiple environments and
original html-vsersion of
PHP together. Topics covered
display paged search results
operating systems, you need
manual from www.mysql.com.
include: Installation of
on screen? This tutorial and
to plan to support multiple
PostgreSQL, PHP, and Apache,
script will do just that.
databases. This article is
A Brief Introduction and
(Apache, PHP, MySQL database
based on my experiences with
Basic Commands, Different
required)
multiple database systems,
Types of Data, Retrieving
stretching from 4th
Data from a Database,
Dimension in my Mac days, to
Inserting Data into a
the databases I currently
Database, Updating Data in a
use, which are: Oracle,
Database, Deleting Data from
FoxPro, Access, MS SQL
a Database, Dealing with
Server and MySQL. Although
Errors, and Including Files.
most of the advice here
The tutorial is also
applies to Perl, Python and
available for download.
other programming languages,
we will focus on PHP and how
the ADOdb database
abstraction library offers
some solutions.
Date: Jan, 06 2003 Date: Apr, 15 2002 Date: Apr, 22 2001 Date: Jan, 08 2001 |
|
This article addresses two
The author notes, "Last
This tutorial explains how to
When interacting with a
SQL-related issues in PHP:
week we introduced you to
program Next / Previous
database, functions are
1) Creating complex,
the basics of creating an
buttons with a dynamic,
called that are common to
powerful, queries to take
efficient database table
reusable class using PHP and
every transaction; functions
advantage of your table
structure. After today's
MySQL or PostGreSQL.
to establish a connection,
schemas, and 2) Building
concluding article of this
execute the query and then
those queries on the fly
series you'll be able to
close the connection. This
according to user input.
create some of your own
article shows how to create
MySQL-powered applications,
functions that will
or use this syntax as the
eliminate this redundancy.
basis for learning to create
The tutorial uses MySQL as
normalized databases on your
the database, but the
database server of
database layer is
choice."
irrelevant. These functions
can be adapted to use other
databases.
Date: Jan, 08 2001 Date: Dec, 06 2000 Date: Nov, 29 2000 Date: Jul, 17 2000 |