|
One of the most powerful
This article explains how to
DB_Browser is a CGI tool for
This short tutorial
enhancements for any site is
design and program a
developers working with a
demonstrates how to insert
to establish community and
multifunctional shopping
relational database. It
data into a SQL database
personalization features. In
cart application using
easily facilitates
using SQL statements.
our new series, we are going
SQL Server, ASP, and
searching, editing, and
to demonstrate how to add
ODBC. Source code available
adding tables within a
community and
for download.
database, as well as
personalization features to
directly querying the
your web-site. The first
database using SQL in
step to reach this goal is
a web-browser form. While it
to allow user registration.
can be used as a regular
In this first article, we
interface to database data
show you how to add user
itself, it works well as a
registration to your site
supplemental tool for
using SQL Server and
developers creating their
ASP.
own primary interface.
Date: Aug, 11 2000 Date: Apr, 13 2001 Date: Dec, 04 2000 Date: Oct, 13 2000 |
|
jOmniGate is an O/R-mapper
Here's how to get started
In this second part of the
It is an often problem with
for timespending and
using SQL and
series, it describes 7
database intergration when
reusable development of
SQL-driven databases from
common mistakes in PHP
you use a reserved word.
databased applications
Perl. Main topics include:
programming that will lead
Often asked why a script
without using sql or
General information about
to drastically slower run
does not work and it quite
any database-specific
relational databases, About
times and less secure
often comes down the the
language. By using
SQL, What DBI is For,
scripts, in addition to less
author setting a field name
jOmniGate-api your programs
Example of How to Use DBI,
maintainable code. Topics
as a reserved word,
will run without any changes
Cached Queries, and
covered: Not Following Basic
confusing SQL and
the same with
MySql,
Transactions.
Naming Conventions (Variable
making debugging hard. To
Oracle, interbase and
Naming, Function Naming),
solve this problem here is a
others.
jOmniGate supports
Databases & SQL
quick list of the SQL
automatic table-creation and
(Misapplying database
Reserved Words.
-update, automatic mapping
functions, Misusing
between java-classes and
SQL: Not Fetching What
db-tables and much more.
You Need, Misusing
SQL: Not Fetching What
You Need), Lack of Error
Checking, Overusing OO,
Misusing Regular
Expressions, Programming PHP
Like It Was Some Other
Language, and Not Being
Security Conscious (System
Call Security, Checking an
e-mail address).
Date: Sep, 20 2001 Date: May, 12 2000 Date: Oct, 21 2000 Date: Aug, 28 2003 |