9 2156
"Ruby Tuesday" <ru**********@yahoo.com> wrote in message news:<c0*************@ID-205437.news.uni-berlin.de>... Which one is better to do dynamic websites using MySQL? Thanks
a.. ADODB, http://php.weblogs.com/ADOdb/ b.. Metabase, http://www.phpclasses.org/browse.html/package/20.html c.. PEAR::DB, http://pear.php.net/manual/en/core.db.php d.. PHPLib database wrappers, http://sourceforge.net/projects/phplib
In the company I work for, we're preparing some framework for our
projects. When we tried the above, we find that they all go for "too
much" abstraction---which is somewhat messy. Say for example, they
check the choosen DB and then use the appropriate function for that
DB.
If you like procedural style, you better to go for
<http://in2.php.net/dbx>
For us, we decided to go for our simple abstraction so that when
to switch to another DB, just it is enough to touch the class alone.
Example:
class DB
{
//var ...
function DB() ///constructor
{
///...
}
function dbConnect()
{
mysql_connect(); // or pg_connect(); or whatever
//...
}
function dbClose()
{
mysql_close(); // or pg_close(); or something else
//...
}
function dbQuery()
{
mysql_query();
//...
}
function dbFetchArray()
{
mysql_fetch_array();
//...
}
function dbGetError()
{
mysql_error();
}
function dbGetErrno()
{
mysql_errno();
}
}
--
"Success = 10% sweat + 90% tears"
If you live in USA, please support John Edwards.
Email: rrjanbiah-at-Y!com
Ruby Tuesday wrote: Which one is better to do dynamic websites using MySQL? Thanks
a.. ADODB, http://php.weblogs.com/ADOdb/ b.. Metabase, http://www.phpclasses.org/browse.html/package/20.html c.. PEAR::DB, http://pear.php.net/manual/en/core.db.php d.. PHPLib database wrappers, http://sourceforge.net/projects/phplib
We have had outstanding success with the ADODB package for our JAYA123
order-entry, invoicing web-service ( http://www.jaya123.com). We tried the
fist three and thought all did a good job, were fast, easy to use, simple to
install, etc. We chose ADODB because it had some classes that allowed syntax
that was similar to how Microsoft Jet is coded and we have a lot of
experience on that platform from past lives, so our learning curve was a bit
flatter. I highly recommend ADODB, but the others are fine as well. I think
it will come down to personal preference. Try them all... there is no wrong
answer here IMO. YMMV.
Al Canton, Vice President
Adams-Blake Company, Inc.
***
JAYA123 - the new web-based total-office system for the
small biz. Order entry, billing, bookkeeping, etc. for $14.95
a month. Everyone says "It's cool as a moose!!"
See why at: http://www.jaya123.com
***
In my case they provide too little abstraction. I wanted to isolate the
database, queries et al, completely from the application code. For my own
abstraction layer, it was more straight forward to call the PHP functions
directly.
Uzytkownik "R. Rajesh Jeba Anbiah" <ng**********@rediffmail.com> napisal w
wiadomosci news:ab**************************@posting.google.c om... "Ruby Tuesday" <ru**********@yahoo.com> wrote in message
news:<c0*************@ID-205437.news.uni-berlin.de>... Which one is better to do dynamic websites using MySQL? Thanks
a.. ADODB, http://php.weblogs.com/ADOdb/ b.. Metabase, http://www.phpclasses.org/browse.html/package/20.html c.. PEAR::DB, http://pear.php.net/manual/en/core.db.php d.. PHPLib database wrappers, http://sourceforge.net/projects/phplib
In the company I work for, we're preparing some framework for our projects. When we tried the above, we find that they all go for "too much" abstraction---which is somewhat messy. Say for example, they check the choosen DB and then use the appropriate function for that DB.
If you like procedural style, you better to go for <http://in2.php.net/dbx>
For us, we decided to go for our simple abstraction so that when to switch to another DB, just it is enough to touch the class alone.
Example:
class DB { //var ... function DB() ///constructor { ///... } function dbConnect() { mysql_connect(); // or pg_connect(); or whatever //... } function dbClose() { mysql_close(); // or pg_close(); or something else //... } function dbQuery() { mysql_query(); //... } function dbFetchArray() { mysql_fetch_array(); //... } function dbGetError() { mysql_error(); } function dbGetErrno() { mysql_errno(); } }
-- "Success = 10% sweat + 90% tears" If you live in USA, please support John Edwards. Email: rrjanbiah-at-Y!com
Hello,
On 02/16/2004 03:26 AM, Ruby Tuesday wrote: Thanks to all. Perhaps anyone can narrow it down to just one or two selection where I can do the following easily:
- database search, add, replace, edit .. - database paging of the result set - have a nice(don't have to be fancy) forms display - easily maintain - less coding etc
I think you want something that goes beyhond just database abstraction.
You may want to try Metastorage. This is a tool that will generate data
access object classes from a simple data model definition. It wraps you
database tables into classes as if the your table rows were objects of
those classes.
Metastorage also generates classes that installs the database schema for
you as well generate forms that handle common types of manipulations
like creating new objects (table row entries).
Forms presentation is defined from themes that can be chosen from a
pre-defined selection that makes your Web forms look like familiar
desktop OS applications or you can design your own with your templates.
As a bonus, it generates nice UML class diagrams to let you make a good
impression your boss or your clients.
Take a look at the screenshots here: http://www.meta-language.net/screenshots.html
Find all about Metastorage here: http://www.meta-language.net/metastorage.html
--
Regards,
Manuel Lemos
PHP Classes - Free ready to use OOP components written in PHP http://www.phpclasses.org/
PHP Reviews - Reviews of PHP books and other products http://www.phpclasses.org/reviews/
Metastorage - Data object relational mapping layer generator http://www.meta-language.net/metastorage.html
With total disregard for any kind of safety measures "Ruby
Tuesday" <ru**********@yahoo.com> leapt forth and uttered: Thanks to all. Perhaps anyone can narrow it down to just one or two selection where I can do the following easily:
- database search, add, replace, edit .. - database paging of the result set - have a nice(don't have to be fancy) forms display - easily maintain - less coding etc
Thanks
For those kind of features it might be worth checking out the Web
Application Component Toolkit project http://wact.sourceforge.net/
It features some nice database abstraction, provides a
compatibility layer for both PEAR::DB and ADODB, has a Paging
feature and has a very cool template engine. You can implement a
paged recordset with only a few lines of PHP code.
--
Phil Roberts | Nobody In Particular | http://www.flatnet.net/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lawrence |
last post by:
A user writes this sentence: "It was the New Urbanist's nightmare of
sprawl run amok."
They input that and my PHP script hits it with addslashes() and then
the sentence gets put in the database....
|
by: Rainer Collet |
last post by:
hi!
i tested several php database abstraction layers (db, mdb(2), creole,
adodb, etc), but i always missed one really important feature:
i need a method for a limited select which gives me the...
|
by: SectorUnknown |
last post by:
I've written a database (Access mdb) front-end using Python/wxpython/and
ADO. However, the scope of the project has changed and I need to access
the same data on an MSSQL server. Also, the...
|
by: David |
last post by:
Is there a good DataBase Abstraction layer that will handle the
mySql, Sql Server, and MS Access engines? I do not wish to write the
same functions with the three different PHP db functions.
...
|
by: Brett |
last post by:
If I want to easily swap the database I'm using, what is the best method for
developing that tier in my application?
I'll have basically a 4 tier app:
1. presentation
2. business logic
3. data...
|
by: DartmanX |
last post by:
I'm looking for any comparisons of PHP Database Abstraction Layers out
there, with an eye towards speed/efficiency. I'm still using PEAR::DB,
which obviously leaves something to be desired.
I'm...
|
by: Colin McKinnon |
last post by:
Hi all,
There's lots of DB abstraction layers out there, but a quick look around
them hasn't turned up anything which seems to met my requirements. Before I
go off and write one I thought I'd...
|
by: rickycornell |
last post by:
Greetings All,
On past projects in PHP4 I had always just written my own libraries to
deal with database interaction. Somehow I was operating in the dark
that there were all these database...
|
by: Ivan S |
last post by:
What are your recommendations for lightweight database abstraction
library (Oracle/MySQL)?
I prefer OOP. :)
Tnx, Ivan.
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |