replace the mysql with sqlite for php

hi all ,i have some code with php+mysql,i want replace the mysql with
sqlit .how can i do.thanks.
my some code:
<?php
session_start();
$DRIVER='mysql';
$HOST='localhost';
$USER='user';
$PASSWD='OsluseR';
$DATABASE='users';
$ADODB_PATH='/usr/local/lib/php/adodb/adodb.inc.php';
$user_table="password";
include("$ADODB_PATH");

$db=NewADOConnection("$DRIVER");
$db->connect("$HOST","$USER","$PASSWD","$DATABASE") or die("connect
".$DATABASE." failed");

if(isset($_GET['id']) && !empty($_POST['submit']))
    unset($_GET['id']);

if($_POST['submit']=="&#204;í&#188;&#211;")
{
   $name=&$_POST['name'];
   $password=md5($_POST['password']);
   $UID=&$_POST['UID'];
   $GID=&$_POST['PID'];
   $home=&$_POST['home'];
   $shell=&$_POST['shell'];
   $limitdate=&$_POST['limitdate'];

易方优IT博客电子杂志2006年7月25号第一期!

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

ADO Connections in Python

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

(no subject)

Witaj adodb-general!

--

-- 
Pozdrowienia,
 Mirek Rusin

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Clarification Desired

   There is an application that I would like to use with postgresql-8.1.4 as
the back end. The application is written in php and uses adodb to connect to
mysql.

   The developers tell me that there are a number of reasons why postgres is
not currently supported. When I read the adodb site and skim the manual I'm
left with the impression that there should be no reason why any application
that writes to adodb should not work with any supported dbms.

   I'm not asking for help from you as I'm not on the development team for
this application. Nor am I chastising the developers. I'm trying to
reconcile my understanding from your site that postgres should work just as
well as mysql does, with the fact that it doesn't.

   Please help me understand where the issues are. Perhaps, then, I could
contribut to the postgres port of this application.

Thanks,

Rich

--

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)    |            Accelerator
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

Re: Clarification Desired

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

Re: Clarification Desired

Rich Shepard wrote:

>    There is an application that I would like to use with postgresql-8.1.4 as
> the back end. The application is written in php and uses adodb to connect to
> mysql.
> 
>    The developers tell me that there are a number of reasons why postgres is
> not currently supported. When I read the adodb site and skim the manual I'm
> left with the impression that there should be no reason why any application
> that writes to adodb should not work with any supported dbms.
> 
>    I'm not asking for help from you as I'm not on the development team for
> this application. Nor am I chastising the developers. I'm trying to
> reconcile my understanding from your site that postgres should work just as
> well as mysql does, with the fact that it doesn't.
> 
>    Please help me understand where the issues are. Perhaps, then, I could
> contribut to the postgres port of this application.

I work on a project where I support the Firebird implementation, while 
others work in Postgres, oracle and a few insist on MySQL ;)

We had to add a few additions to ADOdb in the 'wrapper' that accesses 
it, some of which allow PEARdb to be used as an alternative to ADOdb, 
but mainly we added a number of small additions to allow for the easier 
management of 'portable' SQL.

Even with that, we still have to watch out for Reserved Words used in 
the wrong place, and structures of SQL that ADOdb does not map between 
the different engines.

As Alfredo has said - you can use ADOdb and still write an application 
that is specific to one database engine.

It took me a while to iron out all the problems in tikipro - now called 
bitweaver - to get Firebird working, and then another round of work 
addressed Oracle, but since Firebird and Oracle are similar in 
requirements, that became easier. So provided that you have the support 
of the MySQL developers, ADOdb means that a port to Postgres can be 
attempted. How successful it will be will depend on how tidy the 
existing code is and if the other programmers cooperate.

--

-- 
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop - 
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

Re: Clarification Desired

On Mon, 7 Aug 2006, Alfredo Yong wrote:

> the point you are arising is very interesting. In fact, it can be reasonable
> to think that if your application uses adodb, it should be possible to have
> any database behind it.

Alfredo,

   To repeat: this is not _my_ application. Rather, it is one that I would
like to use with postgres but which has been developed specifically for
mysql.

> The answer is a definitive may be. IF you have written the queries
> thinking in porting, then it should be no problem. You have to understand
> that you can execute through adodb propietary extensions of the SQL
> language. If you, as programmer, are used to that extensions (I have that
> "problem" with my beloved PostgreSQL) then it may be hard to you to limit
> yourself to the ANSI 92 (or ANSI 99) SQL standard.

> On the other hand, adobd have some support to propietary estensions,
> providing, depending upon the driver to the dabatase you are using, a
> wrapper or a emulation of that extension.

   Now I understand. The application's developers may have incorporated mysql
extensions and local dialect in the application, and that is what is fed to
adodb.

   I've been told my core PostgreSQL developers that it is more ANSI
compliant than is mysql, and that can cause portability issues.

> Hope my English is good enough to be understood, and also  i hope this help
> you in your decision. I would like to ask you to tell us about your decision
> and the reasons behind it.

   As a businessman I am frustrated that there is no readily useful client
management and sales lead, prospect, and campaign administration
application that supports postgres. Well, there is one, but they want to add
even more layers on top of apache, and that's not what I want to support.
Large enterprises with separate computer support staffs might not mind all
the time and effort required to keep everything running, but we're much too
small to devote that level of effort.

Thanks,

Rich

--

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)    |            Accelerator
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

Re: Clarification Desired

On Tue, 8 Aug 2006, Lester Caine wrote:

> I work on a project where I support the Firebird implementation, while
> others work in Postgres, oracle and a few insist on MySQL ;)

Lester,

   It's easy to get the impression that too many insist on MySQL. Oh, well.
It's their business, I suppose.

> Even with that, we still have to watch out for Reserved Words used in the
> wrong place, and structures of SQL that ADOdb does not map between the
> different engines.

   Aha! Good points.

> As Alfredo has said - you can use ADOdb and still write an application
> that is specific to one database engine.

   I suppose that if one does not look sufficiently far ahead this is what
happens. "Gee, someone wants to use another backend?"

> So provided that you have the support of the MySQL developers, ADOdb means
> that a port to Postgres can be attempted. How successful it will be will
> depend on how tidy the existing code is and if the other programmers
> cooperate.

   Yup. Those are the keys all right.

Many thanks,

Rich

--

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)    |            Accelerator
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642