|
A litte tool to create an
DESCRIPTION:
Simple SQL
A class that makes it
phpSQLiteAdmin is a Web
alter-script for the
provides functions to
ridiculously easy to
use
interface for the
differences between two
retrieve single fields or
mySQL, Oracle8,
administration of SQLite
databases.
Since 1.4.0
rows of a table, insert rows
Inerbase/Firebase,
databases. Right now the
InnoDB FOREIGN KEYS are
given arrays of column names
PostgreSQL, SQLite (PHP),
following operations are
supported.
MySQLdiff 1.5.0
and values, update single
SQLite (C++) and/or MS-SQL
supported: Create, drop and
added support for FULLTEXT
fields of a given table row,
database(s) within your
vacuum databases; Show
Indexes so a
delete given table rows and
PHP/C++ script. Includes
database information
auto_increments. There was
many other common
lots of examples making it
(schema, tables, indexes,
also added the
needs.
ADVANTAGES:
-
very easy to understand how
file metadata); Create,
(experimental) feature to
This PHP class file will
to work with databases.
browse, empty and drop
upload sql-scripts to
eliminate nearly all code
ezSQL has excellent debug
tables; Show table structure
compare them against another
from the built in std mysql
functions making it
and indexes; Execute sql;
script or an existing
PHP functions.
- Speed, it
lightning-fast to see what’s
database.
will dramatically decrease
going on in your SQL code.
development and execution
ezSQL can dramatically
time.
- Extremely easy to
decrease development time
use; one hardly has to
and in most cases will
understand the MySQL
streamline your code and
syntax.
- It automatically
make things run faster as
determines whether or not
well as making it very easy
there is an open connection
to debug and optimise your
to the MySQL server. It will
database queries. It is a
connect and reconnect
small class and will not add
automatically.
- The built
very much overhead to your
in debugging functions make
website.
it easy to solve syntax
error and logic error.
-
Supports arrays for
arguments and returns ASSOC
arrays from the DB with
indexes.
- Stores resource
links and common variables
such as the last table used.
Date: Oct, 01 2004 Date: Jul, 07 2004 Date: Jun, 28 2004 Date: Mar, 08 2004 |
|
The PHP MySQL Table Manager
Paginator is a php class that
MySQL-Formmaker is a tool for
This project provides
is designed to simplify
will help you to split your
easily creating
functions for generating SQL
administration of a MySql
record sets into pages. I
administration forms and
queries, HTML tables, and
web database.
It allows you
wrote this class to save
displaying the output of
XML documents. It consists
to easily create, drop or
myself some time and then
data for MySQL. You define
of two classes and a set of
rename tables. Alter tables
thought others might find it
your forms, types of input,
utility functions. SQLGen
structures by adding or
helpful. Paginator will
order, etc., and the system
provides PHP functions for
dropping keys and indexes.
return a number that you can
makes a database, the
generating SQL query strings
Adding, removing or changing
use to set your base record
admin-files and the
from arrays. TableMaker
the properties of columns.
and a number to use as an
output-files for you.
generates an HTML table or
Edit, add, search or delete
offset. For now I know it
Version 1.3 focuses on a lot
XML document from an ADOdb
table records.
works in mySQL queries and
of javascript features for
result set or an array.
with arrays. It also has
admin's textarea. A lot of
Since the output of each
methods to make it easy to
bugfixes offcourse, mostly
SQLGen method is a SQL query
make your page links. There
mentioned by users.
string, the library is
also is an extension with
compatible with ADOdb, PEAR
some pre-made link sets to
DB, PHPLib, and any other
make things even easier.
database abstraction layer
that can execute SQL query
strings. Useful for
constructing complicated SQL
queries that vary according
to the situation. Different
if-then clauses can push
items onto from the argument
array - SQLGen will take
care of inserting commas and
"ands" into the
query string as necessary.
Date: Oct, 19 2003 Date: Sep, 28 2003 Date: Feb, 10 2003 Date: Sep, 12 2002 |