ID: 42680 Updated by: [EMAIL PROTECTED] Reported By: ahmedt at student dot cbhs dot school dot nz -Status: Open +Status: Feedback -Bug Type: Unknown/Other Function +Bug Type: MySQLi related Operating System: Windows XP SP2 PHP Version: 5.2.4 New Comment:
What exactly are you reporting here? Your example script has so many typos that it surely can not work. And it doesn't make any difference what client version you use of Mysql as long as it's above 4.x :) And as you're using windows, you need to grab the latest snapshot from snaps.php.net first. (some mysql related bug was fixed after releasing 5.2.4!) And to see the errors, you should set error_reporting=E_ALL and display_errors=On in your php.ini.. Previous Comments: ------------------------------------------------------------------------ [2007-09-16 00:54:20] ahmedt at student dot cbhs dot school dot nz 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 this bug report at http://bugs.php.net/?id=42680&edit=1
