Prev: Attachment to email from form.
Next: Using fopen or SQL to check image
From: "David Stoltz" on 25 Jun 2010 12:31
The only reasons are I'm a PHP newbie ;-)

I'm not really familiar with all the ways to hit a MS SQL server, this particular way always worked for me. It's not difficult to code, and has been working for years, so I've grown accustom to it.

There are only a few instances left to connect to MS MSQL for me, so it's not used too often - we're now developing with mySQL.

Thanks for the info.


-----Original Message-----
From: Andrew Ballard [mailto:aballard(a)gmail.com]
Sent: Friday, June 25, 2010 10:38 AM
To: David Stoltz
Cc: php-general(a)lists.php.net
Subject: Re: [PHP] Returning a Recordset from a Funtion

On Fri, Jun 25, 2010 at 9:55 AM, David Stoltz <Dstoltz(a)shh.org> wrote:
> Hi Folks,
>
>
>
> Upon occasion, I have the need to hit our MS MSL database from our
> PHP/mySQL server. So I've created a function, but I'm not sure if you
> can return a recordset from a function. My code is below...
>
>
>
> In the calling page I code:
>
> <?php
>
> include('../includes/mssql.php');
>
> hitMSSQL("server","database","username","password","SELECT * FROM
> TABLE1");
>
> echo $rs->Fields(1);
>
> ?>
>
>
>
> The mssql.php include file is:
>
> <?php
>
> function hitMSSQL($server,$db,$login,$pass,$query){
>
>
>
>                $conn = new COM ("ADODB.Connection")
>
>                  or die("Cannot start ADO");
>
>                $connStr =
> "PROVIDER=SQLOLEDB;SERVER=".$server.",1433;UID=".$login.";PWD=".$pass.";
> DATABASE=".$db;
>
>                $conn->open($connStr);
>
>                $rs = $conn->execute($query);
>
>                return $rs;
>
>
>
> }
>
> ?>
>
>
>
> If I have the echo statement in the function, it works.
>
>
>
> And of course I can return a single value like:
>
> Return $rs-Fields("value");
>
>
>
> But I can't return the whole recordset...
>
>
>
> Does anyone have any good ideas so I can access the recordset in the
> calling page?
>
>
>
> Thanks!
>
>

Is there a reason you need to work with COM/ADODB to get the
information from SQL Server as opposed to one of the PHP libraries? If
your are using COM you must be running under Windows which means you
should be able to use Microsoft's SQL Server Driver for PHP, which is
the best tool I've seen to date for the task. There are also the older
mssql and the newer PDO_MSSQL libraries, or even odbc or PDO_ODBC that
will work OK in many cases as well. Any of these are much simpler to
work with than COM variants in PHP.

Andrew
First  |  Prev  | 
Pages: 1 2
Prev: Attachment to email from form.
Next: Using fopen or SQL to check image