/**

popular collection of scripts for all

*/
/** Search */

Using Sql

 }

DB_Browser

Hits: 14
*****
0.0

Insert Using SQL

Hits: 14
*****
0.0
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
{ Copyright } ©2006 NuclearScripts.com