Code PHP snippet with mysql

Închis Postat la acum 3 ani S-au achitat serviciile după ce au fost prestate
Închis S-au achitat serviciile după ce au fost prestate

I have the folowing situation:

On the webserver i call a MYSQL Stored Procedure that will return result of up tp 10 different tabels based on search string.

$sql = "CALL sherlock('$value2')";

$stmt = $pdo->prepare($sql);

if ($stmt->execute()) {

print("<div class='result success'><p>EXECUTED</p></div>");

} else {

die('DB CONNECTION ERROR.);

}

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

now instead of "EXECUTED" i would like to see the following result displayed in PHP / HTML (result of each of the 1 to 10 queries in the SP as a small table one after another)

-> Yellow part in the image.

the challange is:

you dont know how many "resultsets" the SP will give and each can have different amount of columns and rows.

so must be fully flexible.

PHP MySQL SQL Arhitectură software HTML

ID Proiect: #29392231

Detalii despre proiect

4 propuneri Proiect la distanță Activ acum 3 ani

4 freelanceri plasează o ofertă medie de 34$ pentru proiect

devikagupta

Hi there!, Hope all good there. I read your project details and I'm very interested to hear from you to discuss more asap. I can generally complete the work within 0-2 days but we can discuss the time. You can see some Mai multe

$25 USD în 7 zile
(626 recenzii)
7.9
stepinnsolution

Yes, I understand fully flow and i am willing to solve immediately. Can you please come in chat and discuss with me Syed

$65 USD în 7 zile
(62 recenzii)
7.4
Onlinexpertz07

Hello there. I read your project details. I have good working experience in designing and developing. I have 3 year working experice in php and wordpress.

$20 USD în 7 zile
(6 recenzii)
1.9
gondaliya0429

Hello, I am a web developer having over 4 years IT industry experience (Skilled in HTML5, CSS3, Bootstrap, JavaScript, jQuery, AJAX, PHP, MySQL, Codeigniter). I am quite keen to do this work for you and I can assure Mai multe

$25 USD în 7 zile
(2 recenzii)
1.9