php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #42680 Help to find extension for Mysqli 5.0.41 and help with getting Mysql server.
Submitted: 2007-09-16 00:54 UTC Modified: 2007-09-26 01:00 UTC
Votes:1
Avg. Score:4.0 ± 0.0
Reproduced:0 of 1 (0.0%)
From: ahmedt at student dot cbhs dot school dot nz Assigned:
Status: No Feedback Package: MySQLi related
PHP Version: 5.2.4 OS: Windows XP SP2
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2007-09-16 00:54 UTC] 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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-09-18 10:42 UTC] jani@php.net
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..
 [2007-09-26 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 08:01:27 2024 UTC