Skip to main content

ADODB for PHP

ADODB for PHP


If you have used PHP, you would simply get enthralled by the excellent set of database connectivity libraries that are shipped with the installer itself. The comprehensive documentation that you get and that too from the local country mirror to facilitate a superfast download all add crowning feathers' to the cap of PHP.

I have been using PHP since about for three years and have been recommending it to many. I have also architect a full-fledged value-chain management product for an Ambur-based leather tannery sometime in 2002-03. The only downside is that database connectivity API go like mysql_Connect and hence at the later point of time, if you wish to change the database, this might warrant a code change.

The more elegant approach would be to have a database abstraction layer. Being an opensource development effort, there are a lot of database abstraction libraries for PHP. Some of the applications like Phprojekt have thier own full-fledged database abstraction layers but have customized to the product-line. A few more are generic and have been listed here:

  1. ADODB Database Abstraction Library for PHP and Python
  2. Pear DB Abstraction Library

I personally feel that ADODB library is very friendly for developers hailing from Windows background since the syntax would be similar to ASP style. It is also part of a huge enterprise application server product line called PhpLens.

Comments

Popular posts from this blog

Google NCR

Google NCRMost of you would be knowing about this trick in navigating to Google generic website. But I just came to know only a few days before and hence thought I would share the information with others too.
Whenever you type http://www.google.com/, Google automatically tries to redirect you to your country-specific website. For me, it always redirects to http://www.google.co.in/ (Google India). But when we specifically want to navigate to Google Generic website for some reason, there are two ways to accomplish the same.Click the 'Go to Google.com' link at the bottom of the webpage that is displayed from http://www.google.co.in/To prevent this redundant click, you can opt to type http://www.google.com/ncr/ which would prevent the redirect from happening. The NCR stands for No Country Redirect. There is a brief discussion about this NCR over this forum.You may also like to check out Google help documentation regarding the country redirections from here.

Elegant 'MailTo' Replacement

Elegant 'MailTo' Replacement

MailTo tags have become a bane to all websites since spammers run spam robots which crawl the web to capture the email addresses, add to their catalogs and send spams to them. I just thought of sharing with others a simple JavaScript function which would trigger open the default email client instead of having mailto: embedded in the HTML Page.

Just have the following function included in your webpage

<script language='Javascript'>
function WriteMailTo(user,domain)
{
location.replace ('mailto:'+user+'@'+domain);
}
</script>

And whereever you want to invoke the mailto, just called WriteMailTo('user','example.com') and the user's default email client should be launching (if configured) without any hassles.

Contacts import utility from Web2Project to Addressbook

I have been using Web2Project for planning my personal and professional tasks for a few years now. Now I have bifurcated the tools into the following:

Project PierAddress Book The only issue I had was to import my addressbook from Web2Project to AB. PP is a different animal. It does not serve as a comprehensive candidate for addressbook and hence I needed this bifurcation. 
I wrote up a following simple script to import the contacts to AB. The pre-requisite for this script is to hop on to PhpMyAdmin, export the contacts as a PHP array and then  modify the path in our import script to whatever you downloaded from PhpMyAdmin.
Our import script would explode the entries as SQL scripts into the browser window. Copy them and execute into PhpMyAdmin AB database to have the contacts imported.

Script URL: https://gist.github.com/lavanyadeepak/5177500#file-import-php