MySQL +php?

I am wanting to pass data from Miva Script to a php file that inturn would
do an insert to a MySQL database.

I also need to view it.

Bill

MySQL +php?



That's easy, just pass the variables in as post or get
and then php natively supports sql queries that you
can run against mysql. There's tons of php/sql examples
online, it's really easy.

David

Bill Gilligan wrote:
> I am wanting to pass data from Miva Script to a php file that inturn
> would do an insert to a MySQL database.
>=20
> I also need to view it.
>=20
> Bill
>=20
>=20
>=20

MySQL +php?



Bill,

You could also use built-in ODBC support in the MVM (on Windows). =
There's
also a free module available from Copernicious on Linux for direct MySQL
support (if you have access to the server).

Ben

-----Original Message-----
From: [email protected] =
[mailto:[email protected]]
On Behalf Of David Hubbard
Sent: Thursday, December 09, 2004 9:48 PM
To: Bill Gilligan; Miva Users; Miva Merchant Coders
Subject: RE: [mrc] MySQL +php?

That's easy, just pass the variables in as post or get
and then php natively supports sql queries that you
can run against mysql. There's tons of php/sql examples
online, it's really easy.

David

Bill Gilligan wrote:
> I am wanting to pass data from Miva Script to a php file that inturn
> would do an insert to a MySQL database.
>=20
> I also need to view it.
>=20
> Bill
>=20
>=20
>=20

MySQL +php?



My understanding of the Copernicus module is that it is for querys only.
I need to manipulate the data.

The site is on linux.
Bill

-----Original Message-----
From: Ben Walsh [mailto:[email protected]]
Sent: Saturday, December 11, 2004 10:21 AM
To: 'Bill Gilligan'; 'Miva Users'; 'Miva Merchant Coders'
Subject: RE: [mrc] MySQL +php?


Bill,

You could also use built-in ODBC support in the MVM (on Windows). There's
also a free module available from Copernicious on Linux for direct MySQL
support (if you have access to the server).

Ben

-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of David Hubbard
Sent: Thursday, December 09, 2004 9:48 PM
To: Bill Gilligan; Miva Users; Miva Merchant Coders
Subject: RE: [mrc] MySQL +php?

That's easy, just pass the variables in as post or get
and then php natively supports sql queries that you
can run against mysql. There's tons of php/sql examples
online, it's really easy.

David

Bill Gilligan wrote:
> I am wanting to pass data from Miva Script to a php file that inturn
> would do an insert to a MySQL database.
>
> I also need to view it.
>
> Bill
>
>
>

MySQL +php?



Hi Bill,

You can issue any direct MySQL query with mvSQL-QUERY, including
updates.

Regards,
James

-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Bill Gilligan
Sent: Saturday, December 11, 2004 10:30 AM
To: Ben Walsh; 'Miva Users'; 'Miva Merchant Coders'
Subject: RE: [mrc] MySQL +php?


My understanding of the Copernicus module is that it is for querys only.
I need to manipulate the data.

The site is on linux.
Bill

-----Original Message-----
From: Ben Walsh [mailto:[email protected]]
Sent: Saturday, December 11, 2004 10:21 AM
To: 'Bill Gilligan'; 'Miva Users'; 'Miva Merchant Coders'
Subject: RE: [mrc] MySQL +php?


Bill,

You could also use built-in ODBC support in the MVM (on Windows). There's
also a free module available from Copernicious on Linux for direct MySQL
support (if you have access to the server).

Ben

-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of David Hubbard
Sent: Thursday, December 09, 2004 9:48 PM
To: Bill Gilligan; Miva Users; Miva Merchant Coders
Subject: RE: [mrc] MySQL +php?

That's easy, just pass the variables in as post or get
and then php natively supports sql queries that you
can run against mysql. There's tons of php/sql examples
online, it's really easy.

David

Bill Gilligan wrote:
> I am wanting to pass data from Miva Script to a php file that inturn
> would do an insert to a MySQL database.
>
> I also need to view it.
>
> Bill
>
>
>