Hey , you have quite intrestening question. you can use PDO in PHP5. But that is data-access abstrection layer but not database abstraction layer. :) ---- ganu. On 8/15/07, hernan Hernan Velasquez <hernamvel@xxxxxxxxx> wrote: > > I love adodb but all options are ok. Your answer is in php abstaction > libraries. > > I asked linktaker "how can i encapsulate the data access in php?" and I > got this answers. > > http://www.linktaker.com/grab.php?idQ=69 > > Hernán Mauricio Velásquez > Ingeniero Sistemas y Computación > Universidad de los Andes > Santafé de Bogotá > > ----- Mensaje original ---- > De: vanila2000 <vanila2000@xxxxxxxxx <vanila2000%40yahoo.com>> > Para: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com> > Enviado: martes, 14 de agosto, 2007 2:25:56 > Asunto: Re: I need a universal connection > > You can also use PEAR DB Package which is by default available with > > PHP 5 and above. It is a set of abstraction library allowing you to > > connect to any database you want to connect. > > --- In php-objects@ yahoogroups. com, Krishna Srikanth > > <krishna.srikanth@ ...> wrote: > > > > > > Hi Anees, > > > > > > 1) For this, in your package, you need to package all kinds of > > libraries, > > > mysql, mssql, odbc, etc.. > > > 2) While installing, you can ask for the type of database the user > > wishes > > > to have and write it into some config file. > > > 3)While running your script (after installation is finished), based > > on the > > > config file value, include only that db library. > > > > > > Just wanted to tell you that, for sql server, using stored > > procedures is > > > an efficient way, instead of querying with big sql statements. > > MySQL can > > > bare the sqlquery transport, but SQL server itself is very heavy > > loaded, > > > and causes problems. So use stored procedures for your mssql > > > installations. > > > > > > Bye, > > > Manda Krishna Srikanth > > > http://www.krishnas rikanth.com > > > http://www.ksjourna l.info > > > > > > php-objects@ yahoogroups. com wrote on 08/08/2007 11:37:39 PM: > > > > > > > Hi, > > > > > > > > I am interested in developing a web application to which I can > > > > attach any of db like mysql,access, sql server,oracle ... as it is > > > > there in most of projects where during the installation we select > > > > any of optional db. > > > > > > > > > > > > how to write such a code which can work with all of databases. > > > > > > > =====-----== ===-----= ==== > > > Notice: The information contained in this e-mail > > > message and/or attachments to it may contain > > > confidential or privileged information. If you are > > > not the intended recipient, any dissemination, use, > > > review, distribution, printing or copying of the > > > information contained in this e-mail message > > > and/or attachments to it are strictly prohibited. If > > > you have received this communication in error, > > > please notify us by reply e-mail or telephone and > > > immediately and permanently delete the message > > > and any attachments. Thank you > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > <!-- > > #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, > sans-serif;} > #ygrp-mlmsg table {font-size:inherit;font:100%;} > #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, > sans-serif;} > #ygrp-mlmsg pre, code {font:115% monospace;} > #ygrp-mlmsg * {line-height:1.22em;} > #ygrp-text{ > font-family:Georgia; > } > #ygrp-text p{ > margin:0 0 1em 0;} > #ygrp-tpmsgs{ > font-family:Arial; > clear:both;} > #ygrp-vitnav{ > padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} > #ygrp-vitnav a{ > padding:0 1px;} > #ygrp-actbar{ > clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} > #ygrp-actbar .left{ > float:left;white-space:nowrap;} > .bld{font-weight:bold;} > #ygrp-grft{ > font-family:Verdana;font-size:77%;padding:15px 0;} > #ygrp-ft{ > font-family:verdana;font-size:77%;border-top:1px solid #666; > padding:5px 0; > } > #ygrp-mlmsg #logo{ > padding-bottom:10px;} > > #ygrp-vital{ > background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} > #ygrp-vital #vithd{ > > font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} > #ygrp-vital ul{ > padding:0;margin:2px 0;} > #ygrp-vital ul li{ > list-style-type:none;clear:both;border:1px solid #e0ecee; > } > #ygrp-vital ul li .ct{ > > font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} > #ygrp-vital ul li .cat{ > font-weight:bold;} > #ygrp-vital a { > text-decoration:none;} > > #ygrp-vital a:hover{ > text-decoration:underline;} > > #ygrp-sponsor #hd{ > color:#999;font-size:77%;} > #ygrp-sponsor #ov{ > padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} > #ygrp-sponsor #ov ul{ > padding:0 0 0 8px;margin:0;} > #ygrp-sponsor #ov li{ > list-style-type:square;padding:6px 0;font-size:77%;} > #ygrp-sponsor #ov li a{ > text-decoration:none;font-size:130%;} > #ygrp-sponsor #nc { > background-color:#eee;margin-bottom:20px;padding:0 8px;} > #ygrp-sponsor .ad{ > padding:8px 0;} > #ygrp-sponsor .ad #hd1{ > > font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} > #ygrp-sponsor .ad a{ > text-decoration:none;} > #ygrp-sponsor .ad a:hover{ > text-decoration:underline;} > #ygrp-sponsor .ad p{ > margin:0;} > o {font-size:0;} > .MsoNormal { > margin:0 0 0 0;} > #ygrp-text tt{ > font-size:120%;} > blockquote{margin:0 0 0 4px;} > .replbq {margin:4;} > --> > > __________________________________________________ > Correo Yahoo! > Espacio para todos tus mensajes, antivirus y antispam ¡gratis! > Regístrate ya - http://correo.espanol.yahoo.com/ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
