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

PHP doesn't send my mail
Hi all, I found this and used it to send mail. Simple contact form with some required fields. The va

getting Vars to pass to next page.
Hello all,
I have a confusing situation on my hands, i am a member of a gaming community and we

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text whi

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

$variable = $variable
Hello

Sorry if this is a really simple question but I have run out of ideas. Is there a reall