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.

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

Your Answer:

Login to answer

Other forums

Problem with Subscreen
Dear Experts ,
I am facing a problem with the subscreens. My senario is as follows :

How do I get the row number from from an sql table query
Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query)

update the selected existing records of database
Hi frndz,
I am new to php and get stuck....

Edit.php > Update.php > Updatea

set xml path in flash when xml created in memorystream and webrequest
i am creating an xml file using memory stream and i want to load this xml file into the flash on cli

Javascript using window.location seems to lose state
Not sure what forum so let me know if I'm in the wrong place. I have a main window with a ajax grid

mail() says sent but no email received
My code is quite simple:

Code: <?php
$to = "Ty44ler@yahoo.com";
$subje

How to extract/download content from HTTPS page?
Hello to all the Members of this forum, Im Shoiab, A novice programmer in php.. for my first job I h

foreach result into a single variable
Hi,

I have this code...

Code: [Select]foreach ($_POST['Interests'] as $interest =&

MySQL issue
I am taking sentences through a form on page. Then checking some condition and trying to insert them

Lining up columns nicely.
Hello everyone, I'm having problems with making columns line up properly. Here is my code: