Writing first mysql abstraction layer, would like suggestions

Hi, I'm learning PHP and want to try writing a beginner's library to do all my mysql stuff. I want to be able to connect to a server, use a database and open a table (maybe later a generalized query, but not now) and basically abstract the pieces of mysql into a set of objects in php.

One of the things I tried to do before (and posted a question in this forum about) is a function that takes a SQL query, runs it, and hands me back the result to work with. I realize mysql_query already does this, but I want to wrap it, and have my wrapper hand the query resource back to me as a return value or something like it.

Can anyone suggest a strategy for this? Thanks!

Sep 9 '07 #1

Subscribe Post Reply

1190

kovik

1,044

Expert 1GB

There is a good forum post here at TSDN.

Sep 9 '07 #2

jpenney

I realize it's policy, but in the spirit of free software, I don't think it's necessary or prudent to remove "competing" links. In fact, I don't think the concept of "competing" even makes sense in a free software world.

Sep 10 '07 #3

pbmods

5,821

Expert 4TB

I realize it's policy, but in the spirit of free software, I don't think it's necessary or prudent to remove "competing" links. In fact, I don't think the concept of "competing" even makes sense in a free software world.

Good argument, wrong place for it. Feel free to start a discussion in the site feedback forum, and we'll see what the site administrators have to say about it.

Sep 10 '07 #4

Similar topics

MySQL to PostGres conversion

by: Th3L0rD | last post by:

Hi, I'm porting some php code from mysql to postgres but I canàt find something equivalent to mysql_select_db(). I use this function to switch from a DB on machine 1 to a db on machine 2. Is there...

PHP

php + mysql multilingual support

by: Aditya Ivaturi | last post by:

We have a CMS which is written is based on php & mysql. Recently we received a request to support multiple languages so that sites in that particular laguage can be created. I did some search on...

PHP

Converting from MySQL commands to Oracle: HELP!

by: Mark Wilson CPU | last post by:

A colleague has written a prototype program in PHP, using a MySQL database. It's a relatively simple app, with a restricted set of mysql commands used (see below). The MySQL DB is being replaced...

PHP

default MYSQL server password

by: ruud | last post by:

I just installed MySQL server 3.23.58-1. Now I can't find the password en can's change the settings. Who knows this password?

MySQL Database

Php and DataBase Abstraction for mySql, Sql Server, and MS Access?

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. ...

PHP

what is better - one field or eight - mysql bit testing

by: windandwaves | last post by:

Hi Folk I have to store up to eight boolean bits of information about an item in my database. e.g. with restaurant drive-through facility yellow windows

PHP

Abstraction question

by: Eric Cathell | last post by:

I am using dOOdads as my persistence layer. I have a business object Person that sits in a Project called DOMAIN I have 2 dOOdads in a project called BLL. one is _Person and is declared...

Visual Basic .NET

Mysql database in UTF8, PHP shows latin1 (iso-8859-1)

by: alex | last post by:

I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...

PHP

suplied argument not valid mysql sql resource

by: bilibytes | last post by:

hi, i tried to create sort of a db abstraction layer in order to be able to change of database (Mysql | oracle | pg |...). i implemented that on a obejct oriented way. i made a sql factory in...

MySQL Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

What is ONU?

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,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General