php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #42554 db operations not functioning
Submitted: 2007-09-04 22:30 UTC Modified: 2007-09-12 01:00 UTC
From: sufinoon at gmail dot com Assigned:
Status: No Feedback Package: MySQLi related
PHP Version: 5.2.4 OS: windows xp + linux
Private report: No CVE-ID: None
 [2007-09-04 22:30 UTC] sufinoon at gmail dot com
Description:
------------
problem:

trying to execute a query

description:

somewhere in the script i try to execute a simple select query like 
select * from users;
and i got an empty result although the table contain data
and the i have a database link.
I've tried a bug fix like:
 /**
  * *fix without it the query fails	 
  */

    mysqli_close ( $db->link_id );
    $link_id = mysqli_connect($db_host, $db_username, $db_password, $db_name, $db_prefix, $p_connect);


It's works only for one query and after that i need to use the fix again



if this bug is reported , although i couldn't find it, please post the bug id # for reference

Reproduce code:
---------------
$result = mysqli_query($link_id, 'SELECT g_id FROM groups');

Expected result:
----------------
to have some rows (i know i have them cause i check it in command client)

Actual result:
--------------
rows = 0

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-09-04 22:33 UTC] jani@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc. If the script requires a 
database to demonstrate the issue, please make sure it creates 
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.


 [2007-09-12 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: Mon Dec 02 15:01:30 2024 UTC