From: ahmedt at student dot cbhs dot school dot nz Operating system: Windows XP SP2 PHP version: 5.2.4 PHP Bug Type: Unknown/Other Function Bug description: Help to find extension for Mysqli 5.0.41 and help with getting Mysql server.
Description: ------------ I can't find mysqli extension for MYSQL server 5.0.41 to download. In phpMyadmin it " says that Mysql and mysqli client library vrsion is 5.0.37 differs from actual MYSQL server version 5.0.41 which may cause unpredicatble behaviour." Thats same in phptest foe MYsql and Mysqli client version. The estension that I am using is the same one that came with the php 5.2.3 package. I9 also tried looing in the url http://www.de.mysql.com/downloads/connector/php but they don't have one for mysql server 5.0.41 , it's only have up to Mysql server 5.0.27. I can't get the data to be displayed in IE6 although I can connect to Mysql Sever because everytime I open the IE browser MYSQL server 'connection ID' increases when I check in Mysql Command line. Reproduce code: --------------- That's a sample script that I tried to do : <?php $conn = new mysqli('ocalhost', 'user', 'password','database') or die ('Cannot no connect or open databse') return $conn ; $sql = 'SELECT * FROM images'; // submit the query and capture the result $result = $conn->query($sql) or die(mysqli_error($conn)); // find out how many records were retrieved $numRows = $result->num_rows; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> <html xmlns="http://www.w3.org/1999/xhtml";> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Connecting with MySQLI extension</title> </head> <body> <p>A total of <?php echo $numRows; ?> records were found.</p> <table> <tr> <th>image_id</th> <th>filename</th> <th>caption</th> </tr> <?php while ($row = $result->fetch_assoc()) { ?> <tr> <td><?php echo $row['image_id']; ?></td> <td><?php echo $row['filename']; ?></td> <td><?php echo $row['caption']; ?></td> </tr> <?php } ?> </table> </body> </html> Expected result: ---------------- To connect to the databse and dispaly the rtesult in table and tell how many records are there. Actual result: -------------- A blank screen in IE6 , no errior recorded in Apache2 log or php error log. URL in browser looks like someting "http://127.0.0.1/record.php"; insraed of display the page title which is "Records" that I have put in into HTML code. -- Edit bug report at http://bugs.php.net/?id=42680&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42680&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42680&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42680&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42680&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42680&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42680&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42680&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42680&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42680&r=support Expected behavior: http://bugs.php.net/fix.php?id=42680&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42680&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42680&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42680&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42680&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42680&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42680&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42680&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42680&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42680&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42680&r=mysqlcfg
