Prepared Statement not working (mysql 5)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello list,

The following example script uses prepared statements to bind input and
output parameters It works flowlessy using php 5 & mysqli on a client
machine and MySQL 5.0.7 beta on the server (192.168.0.2):

1: <?php 
2: $m = new mysqli('192.168.0.2', 'xxx', 'xxx');
3: $m->select_db('xxx');
4: 
5: $sql = "SELECT des FROM comune WHERE descrizione LIKE ?";
6: $param='tre%';
7: 
8: $stmt = $m->stmt_init();
9:
10: if ($stmt->prepare($sql)) {
11:    
12:     $stmt->bind_param('s', $param);
13:     $stmt->execute();
14:     $stmt->bind_result($col1);
15: 
16:     echo "<p>";
17:     while ($stmt->fetch()) {
18:         echo "$col1<br/>";
19:     }
20:     echo "</p>";
21: 
22:     $stmt->close();
23: }
24: 
25: $m->close();
26: 
27: ?>

Now, upon moving the script on to the server and replacing line 2 with 
2: $m = new mysqli('localhost', 'xxx', 'xxx');
it stops working (ie no output at all on screen). 

Removing the bound output parameter (line 14) results in a mock "too
many parameters to bind_param" error on line 12.
Replacing the PS with a simple query makes the script work again.
The PS at the mysql command interface level is working as expected.

It looks like there is a problem with mysqli PS when the client and the
server share the same machine. 
Does anyone have a clue on what is going on or point me to some tests I
can do?

Thank you all,
marco

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux