Generic PHP MySQL connection class

Question

Are there any great, lightweight MySQL connection classes out there for PHP that anyone recommends?

I have written my own, and I do think it is pretty good but this seems like the sort of thing that many programmers better than me must have perfected long ago.

I'm interested in finding something that I can slot in generically and use as I need it with as little hassle as possible.

Some generic functions to support querying, connecting to multiple MySQL databases within the one application would also be a plus.

I am happy with just one function and no classes nor multiple connect support. It's all seems overkill to me — Your Common Sense
– Your Common Sense, Commented Aug 25, 2010 at 10:04
What's wrong with ext/mysqli (apart from messy prepared statements API)? — Mchl
– Mchl, Commented Aug 25, 2010 at 10:05

Andrei Serdeliuc ॐ · Accepted Answer · 2010-08-25 09:50:37Z

4

Have you had a look at PDO? http://php.net/manual/en/book.pdo.php

answered Aug 25, 2010 at 9:50

Andrei Serdeliuc ॐ

5,8785 gold badges41 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ajporterfield · Accepted Answer · 2010-11-28 21:50:42Z

2

PHP's PDO (PHP Data Objects) extension is my recommendation. I use it alongside a light-weight database class that extends PDO. You can find this open-source project on Google's Project Hosting at http://code.google.com/p/php-pdo-wrapper-class.

answered Nov 28, 2010 at 21:50

ajporterfield

1,0192 gold badges10 silver badges23 bronze badges

Comments

NikiC · Accepted Answer · 2010-08-25 10:03:22Z

1

A class of my own invention: DB

It may be called very lightweight (less than 100 lines of code). It is a wrapper around PDO and it actually only adds a very handy way of escaping variables and a short syntax (DB::query() instead of DB::instance()->query().)

But this short syntax results in it being limited to once connection.

answered Aug 25, 2010 at 10:03

NikiC

102k39 gold badges194 silver badges226 bronze badges

Comments

Edmhs · Accepted Answer · 2010-11-15 16:18:21Z

1

The simplest and lightweight db class is

http://code.google.com/p/edb-php-class/

<?php
$result = $db->q("select * from `users`limit 3");

foreach($result as $a){
        $a = (object) $a;
        echo $a->id.' '.$a->name.' '.$a->url.' '.$a->img.'</br>';
}


$result = $db->line("select * from `users` where id = '300' limit 1");
echo $result['name']; 
echo $result['surname']; 



$name = $db->one("select name from `ilike_pics` where id = '300' limit 1");
echo $name;
?>

answered Nov 15, 2010 at 16:18

Edmhs

3,76130 silver badges40 bronze badges

Comments

ovais.tariq · Accepted Answer · 2012-10-09 11:20:23Z

1

this is a very neat and easy to use class: http://justinvincent.com/ezsql

wordpress database class is also derived from the above class

edited Oct 9, 2012 at 11:20

answered Aug 25, 2010 at 11:46

ovais.tariq

2,62517 silver badges12 bronze badges

2 Comments

avance Over a year ago

links to site about blenders. spam?

ovais.tariq Over a year ago

@juggleware LOL looks like Justin Vincent doesnt own that domain now, so I have updated the link. You should probably have checked my profile and the cached version of the page, before marking it as spam. I am not supposed to update links if the author chooses to disown a domain :)

pablov · Accepted Answer · 2010-08-25 10:01:50Z

0

May try ADOdb and ADOdb Lite

answered Aug 25, 2010 at 10:01

pablov

1491 silver badge10 bronze badges

Collectives™ on Stack Overflow

Generic PHP MySQL connection class

6 Answers 6

Comments

Comments

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related