[PHP-DB] RE: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

2009-04-19 Thread Andi Gutmans
Btw, in Zend Framework while we based our adapter interface on PDO we allow for adapters which are not based on PDO (via quackable interfaces). DB2, Oracle and MySQLi are supported in that way as well as of course many PDO drivers. You can easily take one of those native DB adapters and make them

Re: [PHP-DB] Please help a newbie

2009-04-19 Thread mrfroasty
Thanks Great tip there... Gr mrfroasty Chris wrote: mrfroasty wrote: Hello, May be try something like this: $query1= CREATE TABLE contacts( id int(16) NOT NULL auto_increment, phone varchar(15) NOT NULL, name varchar(15) NOT NULL, address varchar(15) NOT NULL, PRIMARY KEY (id) ); $que

Re: [PHP-DB] Please help a newbie

2009-04-19 Thread Chris
mrfroasty wrote: Hello, May be try something like this: $query1= CREATE TABLE contacts( id int(16) NOT NULL auto_increment, phone varchar(15) NOT NULL, name varchar(15) NOT NULL, address varchar(15) NOT NULL, PRIMARY KEY (id) ); $query2 = "INSERT INTO contacts VALUES ('NULL','$phone', '$name'

[PHP-DB] RE: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

2009-04-19 Thread David Sceppa
Richard, As pointed out on other branches of the thread, PDO_ODBC is currently your best option for accessing SQL Server via PDO and technologies that rely on PDO. We are investigating producing a PDO driver for SQL Server Driver going forward. David Sceppa Program Manager - Microsoft SQL Serv

Re: [PHP-DB] Please help a newbie: Fixed

2009-04-19 Thread Rij
Ok, figured it out. I was using an int for the field but the value was too large for it. I used bigint instead and life is suddenly so much better. Well it helps that its bright and sunny here too :) On Sun, Apr 19, 2009 at 10:37 AM, mrfroasty wrote: > Try using var_export() or var_dump() to debu

Re: [PHP-DB] Please help a newbie

2009-04-19 Thread Daniel Carrera
Rij wrote: I input the values from a HTML form. Here is the partial code. $phone = $_POST['phone']; $name = $_POST['name']; $address = $_POST['address']; $query = "INSERT INTO contacts VALUES ('$phone', '$name', '$address')"; if (mysql_query($query, $con))

Re: [PHP-DB] Please help a newbie

2009-04-19 Thread mrfroasty
Hello, May be try something like this: $query1= CREATE TABLE contacts( id int(16) NOT NULL auto_increment, phone varchar(15) NOT NULL, name varchar(15) NOT NULL, address varchar(15) NOT NULL, PRIMARY KEY (id) ); $query2 = "INSERT INTO contacts VALUES ('NULL','$phone', '$name', '$address')";

[PHP-DB] Re: Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

2009-04-19 Thread Manuel Lemos
Hello, on 04/14/2009 11:38 AM Richard Quadling said the following: > I'm trying to find an ORM tool to allow me to talk to Microsoft SQL > servers (V7, 2000 and 2005) for Windows. > > For those that use ORM, what do you use? > > I've looked at Doctrine (requires php_pdo_mssql which isn't part of

[PHP-DB] Please help a newbie

2009-04-19 Thread Rij
Hello, I am new to the world of PHP and MySQL. My objective is to create a table, insert values in it and read it back. Here's the partial code to create a table from a PHP file: if (!$table_exists) { $query="CREATE TABLE contacts (id int(20) NOT NULL, name varchar(15) NOT NULL, address