New to mysqli library - Multiple query problem


Posted on 16th Feb 2014 07:03 pm by admin

Greetings,

I am writing a batch program that executes 3 queries on a single page. Using mysql libraries and regular queries works just fine. I am rewriting the page to include a stored procedure. The first query gets several thousand rows from a table, the second query calls a stored procedure which returns a resultset and the third query updates the table with the results from the stored procedure. Queries 2 & 3 are inside a while loop and execute once for every record from query 1.

Did you know?Explore Trending and Topic pages for more stories like this.
Here is my connection string to the database:
$connect = mysqli_connect("localhost", "username", "password","database") or
die ("The database is unavailable. Please try again later.");

Query 1 = $results = mysqli_query($connect,$query)
Query 2 = $results1 = mysqli_query($connect,$query1);
Query 3 = $results2 = mysqli_query($connect,$query2);

$query = Select * from table
$query1 = Call stored Procedure
$query2 = Update table set ...

The above fails with this error message:
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in pagename on line 103

If I create 3 connection variables everything works as expected.
$connect = mysqli_connect("localhost", "username", "password","database") or
die ("The database is unavailable. Please try again later.");
$connect1 = mysqli_connect("localhost", "username", "password","database") or
die ("The database is unavailable. Please try again later.");
$connect2 = mysqli_connect("localhost", "username", "password","database") or
die ("The database is unavailable. Please try again later.");

Is there a way to accomplish what I am trying to do without creating 3 identical connections to the database?

I am a noob to this so go easy on my coding practices. This code actually processes 40+ records per second on an old Dell laptop
No comments posted yet

Your Answer:

Login to answer
205 Like 15 Dislike
Previous forums Next forums
Other forums

How to restrict the display of report variants
Hello All,

I want t know how to restrict the display of report variants.
I mean, whe

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

help finding hacking loopholes
i was attacked by a redirect php injection

my pc is clean of viruses

so i figure that

SAP Management Console is blank
Dear All ,

I am facing problem in my des sever suddely in SAP Management Console is blank and

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

Cache PHP Objects/Classes?
Does anyone have ideas about caching PHP objects using something like: http://memcached.org/

split values
I have values that are returned to me in this format:

name=>test,age=>49

PHP hyperlinks generator - HELP plz
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

How to show more than 1 users with this code...
Hello,
i have a table that shows users only if I, as Administrator, want to be shown. But its sho

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash