I am trying to use mysqli's prepared statements to execute a stored
procedure that returns multiple result sets. I've been struggling with
this for some time now. I have created a short example test script that
demonstrates the problem. The script can be found here:
I'm a little surprised no one else has commented on this, but for a
website that complicated, 10k is way too low. I've done work on
websites that do almost all of those things separately, but not
combined and I can tell you to have a high quality website that does
just one of the things you
Alice, make sure the php-mssql package is installed.
# yum install php-mssql
You shouldn't have to compile php or freetds as there are packages
available to do what you want...
Ken
On Thu, Jun 12, 2008 at 11:14 AM, Wei, Alice J. [EMAIL PROTECTED] wrote:
Hi,
I am currently using a Linux box
] wrote:
From: Ken Keefe [EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 1:44 PM
To: Wei, Alice J.
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] PHP to MS SQL Package
Alice, make sure the php-mssql package is installed.
# yum install php-mssql
You
That error message tells you that you are getting closer. Next step
would be to make sure you have a connection to that system:
$ ping 192.168.10.128
Next thing I would do is see if that port is open on the server:
$ telnet 192.168.10.128 1433
If it says something about Escape character is ...
I know the package you need is called php-sybase in ubuntu. It's
probably something similar in Fedora. Know that this package will only
let you do a subset of the mssql function calls. If you are just
connecting and doing a normal query, it will suffice. If you need to
do prepared statements for
Unfortunately it is windows only (written with .NET). When I was stuck
on a windows box, it was a very nice tool. I'd use it now if it
existed on other platforms...
Ken
On Thu, May 1, 2008 at 9:30 AM, Yves Sucaet [EMAIL PROTECTED] wrote:
Just like to point out http://www.sqlyog.com, an
Try doing print_r($row); in your while loop and see what exactly is in
that array.
Ken
On Tue, Apr 29, 2008 at 1:46 PM, Jon L. [EMAIL PROTECTED] wrote:
I could be wrong, but I don't think table aliases continue to exist in PHP;
only the column names.
$g_name = $row[gigName];
Is it possible to have multiple prepared statements associated with a
single mysqli object at one time?
For example:
$db = new mysqli($sqlServer, $sqlUser, $sqlPass, $sqlDB);
$query1 = $db-prepare($sql1);
$query2 = $db-prepare($sql2);
foreach ($arr as $key = $val)
if($val)
{