SQL connecting

[Scripter47]

Hey

It got a problem with python to connect to my SQL DBs, that's installed
on my apache server. how do i connect to sql? Gettting data? Insert into it?

it is a localserver with php if that means something

here is a *REALLY* dirty solution that a have used:

from urllib import *
# sql query
s = 'INSERT INTO `test` (`test`) VALUES ("1");'
 
# encode and insert into db
params = urlencode({'sql': sql})
urlopen("http://localhost/in/sql.php?%s" % params)
 

--
_________ .__ __ ______________
/ _____/ ___________|__|______/ |_ ___________ / | \______ \
\_____ \_/ ___\_ __ \ \____ \ __\/ __ \_ __ \/ | |_ / /
/ \ \___| | \/ | |_ | \ ___/| | \/ ^ / / /
/_______ /\___ >__| |__| __/|__| \___ >__| \____ | /____/
\/ \/ |__| \/ |__|

[John Nagle]

Scripter47 wrote:

Hey

It got a problem with python to connect to my SQL DBs, that's installed
on my apache server. how do i connect to sql? Gettting data? Insert into
it?

You need a third-party open source package called "MySQLdb".

John Nagle

[Scripter47]

John Nagle skrev:

Scripter47 wrote:

>Hey

It got a problem with python to connect to my SQL DBs, that's installed
on my apache server. how do i connect to sql? Gettting data? Insert into
it?

You need a third-party open source package called "MySQLdb".

John Nagle

Yeah look great but im using python 2.5, and it only support 2.3-2.4 :(,
but thanks :)

Any better solutions :)

[Scripter47]

Dennis Lee Bieber skrev:

On Mon, 29 Jan 2007 19:45:47 GMT, John Nagle <na***@animats.com>
declaimed the following in comp.lang.python:

>Scripter47 wrote:

>>Hey

It got a problem with python to connect to my SQL DBs, that's installed
on my apache server. how do i connect to sql? Gettting data? Insert into
it?

You need a third-party open source package called "MySQLdb".

Call me a nit, but did the original poster mean "MySQL" databases,
or only that he uses SQL to access "my databases". The spelling is
unclear as to what DBMS engine is actually being used. If it is /not/
MySQL, then MySQLdb is futile.

Sry i didn't said it. it is a MySQL DB on a apache server