Kapalı

Code PHP snippet with mysql

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.

Beceriler: PHP, MySQL, SQL, Yazılım Mimarisi, HTML

Daha fazlasını gör: run multiple mysql database queries php send xml, shirt shop online code php mysql, software code php mysql philippines accounting, source code php mysql create user registration, submit coupon code php mysql, track projects workers company source code php mysql, online quiz code php mysql, mysql injection code php analyzer, php code show video mysql web page, sample php code adding customers mysql database, appointment calendar code php mysql, php code uploading xls mysql, free php code pull data mysql, php sanitize mysql queries, free zip code php mysql projects, maps google code php ajax mysql, logout code php ajax mysql, DB connection error

İşveren Hakkında:
( 36 değerlendirme ) Zuerich, Switzerland

Proje NO: #29392231

Bu iş için 5 freelancer ortalamada $31 teklif veriyor

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 Daha Fazla

$25 USD in 7 gün içinde
(603 Değerlendirme)
7.7
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 in 7 gün içinde
(52 Değerlendirme)
6.7
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 Daha Fazla

$25 USD in 7 gün içinde
(2 Değerlendirme)
1.9
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 in 7 gün içinde
(4 Değerlendirme)
1.6
upender788

i read your requirement. i am expert in sql . ready to start now

$20 USD in 2 gün içinde
(0 Değerlendirme)
0.0