Re: PHP How To: Execute a SQL statement...

2006-11-08 Thread Steve Holdoway
On Wed, 08 Nov 2006 18:39:10 +1300 Joseph Miller <[EMAIL PROTECTED]> wrote: > Take a look at http://adodb.sourceforge.net/ > > The thing about ADODb is that's usage syntax is similar to MSs ADO, but > that's about it. Is this a good thing? I'd recommend Pear::DB, although Pear::MDB2 is still be

Re: PHP How To: Execute a SQL statement...

2006-11-08 Thread Kerry Mayes
Yeah but Don, you're using up all the goodwill of the group!  Leave some for the rest of us! :-)On 08/11/06, Don Gould < [EMAIL PROTECTED]> wrote:No one's holding a guy to anyone to answer my posts :)

Re: PHP How To: Execute a SQL statement...

2006-11-08 Thread Don Gould
That looks useful. Thanks Cheers Don Joseph Miller wrote: Take a look at http://adodb.sourceforge.net/ The thing about ADODb is that's usage syntax is similar to MSs ADO, but that's about it. The basic pattern to use is: $dsn = 'mysql://user:[EMAIL PROTECTED]/mydb'; $conn = ADONewConnection

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Joseph Miller
Take a look at http://adodb.sourceforge.net/ The thing about ADODb is that's usage syntax is similar to MSs ADO, but that's about it. The basic pattern to use is: $dsn = 'mysql://user:[EMAIL PROTECTED]/mydb'; $conn = ADONewConnection($dsn) $statement = $conn->Prepare('insert into table (col1,col

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Don Gould
No one's holding a guy to anyone to answer my posts :) Nicholas Rogers wrote: You need the PEAR libraries. You also *need to **read* -> Chapter 11 Accessing your MySQL Database from the web with PHP in: PHP and MyQL Web Development, Welling & Thomson, 3rd Edition, Developers Library O

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Don Gould
Steve Holdoway wrote: I suggest we start charging. Good idea. You can have 50% of what I'm making out of it this week, would you like to share the costs as well? Cheers Don -- Don Gould www.thinkdesignprint.co.nz - www.tcn.bowenvale.co.nz - www.bowenvale.co.nz - www.hearingbooks.co.nz -

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Don Gould
Ok guys, let's stay on topic. First I want to make things go with basic stuff. I've been looking at the ADOdb guys web site and that's a consideration. Right now I'm just trying to wack some simple stuff together to get functionality. :) From: http://phplens.com/phpeverywhere/node/view/32

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Steve Holdoway
On Wed, 08 Nov 2006 17:25:06 +1300 Nicholas Rogers <[EMAIL PROTECTED]> wrote: > You need the PEAR libraries. > > You also need to read -> Chapter 11 Accessing your MySQL Database > from the web with PHP in: > > PHP and MyQL Web Development, Welling & Thomson, 3rd Edition, > Developers Librar

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Nicholas Rogers
You need the PEAR libraries. You also need to read -> Chapter 11 Accessing your MySQL Database from the web with PHP in:PHP and MyQL Web Development, Welling & Thomson, 3rd Edition, Developers LibraryOn 08/11/2006, at 5:12 PM, Don Gould wrote:This list is quicker by miles...This list is more forgiv

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Don Gould
This list is quicker by miles... I am asking, I was just attempting to demonstrate that I've done some homework and am not just expecting that spoon you're so quick to wack me with :) Thanks Andrew Cheers Don Andrew Errington wrote: On Wed, 08 Nov 2006 16:47, you wrote: What function shou

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Joseph Miller
My advice is to always use a DB abstraction layer when talking to SQL databases from PHP (or any other language for that matter) I recommend ADOdb, and the use of prepared statements in conjunction with input filtering to make sure no nasties make their way into your SQL from 'user' input. It's

Re: PHP How To: Execute a SQL statement...

2006-11-07 Thread Andrew Errington
On Wed, 08 Nov 2006 16:47, you wrote: > What function should I be using to execute an INSERT statement? > > See: http://au3.php.net/manual/en/ref.mysql.php > > I'm suspecting mysql_query() > > See: http://au3.php.net/manual/en/function.mysql-query.php > Are you asking the question, or thinking a

PHP How To: Execute a SQL statement...

2006-11-07 Thread Don Gould
What function should I be using to execute an INSERT statement? See: http://au3.php.net/manual/en/ref.mysql.php I'm suspecting mysql_query() See: http://au3.php.net/manual/en/function.mysql-query.php INSERT INTO tblMACOwner (MAC, Name, Address, PhoneNumber, EmailAddress, RoomNumber) VALUES