Tamamlanmış

PDO Select with multiple Parameters

Hi, I have a form with 3 fields - after submit the database should be displayed in a table. but I do not get any results as I think the Select is wrong.

Here is what I have:

if (isset($_POST['submit'])) {

$stmnt = $pdo->prepare('SELECT * FROM wccrm_photos WHERE vorname_braut = :first AND vorname_braeutigam = :second and datum = :third ORDER BY action asc');

$stmnt->execute([

'first' => $_POST[vorname_braut],

'second' => $_POST[vorname_braeutigam],

'third'=> $_POST[datum]

]);

// $stmnt->execute(array($_POST[vorname_braut], $_POST[vorname_braeutigam], $_POST[datum]));

$data = $stmnt->fetchAll();

?>

<div class="table-container">

<table>

<tbody>

<tr>

<td>Braut</td>

<td>Bräutigam</td>

<td>Action</td>

</tr>

<?php foreach ($pdo->query($stmnt) as $daten) { ?>

<tr>

<td><input name="vorname_braut" type="text" class="style13" id="vorname_braut" value="<?php echo $daten[vorname_braut]?>" style="width: 50px" readonly></td>

<td><input name="vorname_braeutigam" type="text" class="style13" id="vorname_braeutigam" value="<?php echo $daten[vorname_braeutigam]?>" style="width: 50px" readonly></td>

<td><input name="action" type="text" class="style13" id="action" value="<?php echo $daten[action]?>" style="width: 150px" readonly></td>

</tr>

</tbody>

<?php } ?>

</table>

</div>

<?php

} else {

//here is the form... }

Beceriler: PHP, MySQL

Daha fazlasını gör: select multiple category php, select multiple database records php ajax, tcp select multiple sockets, scriptaculous select multiple draggables, php select multiple files upload, select multiple documents lotus notes view, select multiple scriptaculous, ajax select multiple categories php, select multiple, php multiple file upload select multiple, select multiple file dialog box upload php, select multiple file choose file dialog javascript, php display multiple rows mysql array, android select multiple photos, select multiple photos android gallery

İşveren Hakkında:
( 11 değerlendirme ) Wien, Austria

Proje NO: #20427452

Seçilen:

iotait

Hello There, I will be able fix your PDO script. Please share your PHP file & Database SQL so I can debug the code and send you back the fixed code within few minutes. I am an experienced PHP Developer with more th Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(9 Değerlendirme)
2.7

Bu iş için 22 freelancer ortalamada €23 teklif veriyor

webdesign786

Hi, I am fully capable of this job. I am professional in PHP/WordPress/HTML/CSS and working as a freelancer for more than 8 years. I know how to handle this type to work with in time. If you are looking for best servi Daha Fazla

€24 EUR in 7 gün içinde
(155 Değerlendirme)
7.4
shahid864

Hi, My name is Shahid, i am working in web development from past four years. Will provide you quality work and hopefully we will have long term relationship in web development. Let me know if i can help you. let's disc Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(462 Değerlendirme)
6.9
bjrupani

Hello hiring member i hope you are doing well i am bhavik ai have 3+years experience in php , laravel , ajax , jquery , javascript ,, html ,css , bootstrap i have done many thinngs with php i can start it right now and Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(125 Değerlendirme)
6.4
nixtech

Hello Sir, I can fix the issue right away and can ensure data actually get entered and displayed. I am willing to start right away. Please check my profile for work and experience. Regards Ashwin

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(189 Değerlendirme)
6.4
shijudasan

I will resolve the issue for you if u let me.. I am a php developer with more than 8 years exp. developing websites..

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(31 Değerlendirme)
6.0
TSCreators

Dear hiring manager, We have experienced developer on php more than 4 years and developed many sites and internal system. Ordering system [login to view URL] Username: admin Paswd: PassWord!23_ I h Daha Fazla

€19 EUR in 7 gün içinde
(67 Değerlendirme)
5.7
Dmitry610

Hello Dear, Greetings for the day! ⭐⭐⭐⭐⭐ I CAN START IMMEDIATELY ⭐⭐⭐⭐⭐ My name is Dmitry Kraitor and I am individual full-stack&full-time web developer. I have gone through the project description and I am very int Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(20 Değerlendirme)
5.6
ShrineWeb

Hi, I have done this before but I have a few questions, can we chat please? I have 10 years of experience in PHP.

€20 EUR in 14 gün içinde
(41 Değerlendirme)
5.5
dreammate0621

Hello! I am a web developer. I have checked your project description. I can help you I guarantee the good result. I will wait for your reply. Thank you.

€19 EUR in 7 gün içinde
(19 Değerlendirme)
5.4
kovirijagdish

I believe in providing good quality code and services with security. I am a Web Security Researcher, ColdFusion and Php Web Developer & Bug Bounty Hunter at HackerOne, BugCrowd, BountyFactory and many other Independen Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(68 Değerlendirme)
4.8
BestService222

Dear client, how have you been? I've read your project description carefully. I am a excellent Full-Stack Web development expert. I think your project is very suitable for me. I 'm very interested in your project. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(12 Değerlendirme)
4.5
purplemaestro

Hello. My name is Muhammad Hassan. I have high level expertise in PDO and PHP and MYSQl as well. I can start right now and wont disappoint you. Please share other details with so that I can start working on it.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(12 Değerlendirme)
2.9
ibtesamnaasan

Hello and welcome in our group we so happy for this chance to give us this opportunity to work with you in your project My name is Ibtisam the CEO of our group I read the description that related in your project and Daha Fazla

€19 EUR in 7 gün içinde
(1 Yorum)
3.1
AshleyTripp786

Hello, Thank you for the offer you submitted. I checked your project details and I understand your demand, I agree with you to do the job. I am a professional PHP and Wordpress Developer. I am here to help you & get Daha Fazla

€30 EUR in 7 gün içinde
(3 Değerlendirme)
1.1
ProgramICO

Hello I am a senior developer so i can do it very easily if you want. Contact me right now i am ready to start this project for you. Low cost and high quality result reply to discuss more about this project

€19 EUR in 7 gün içinde
(2 Değerlendirme)
2.1
csahu66

Hi, I have 5+ Years experience in Web Designing/Development & Graphics Designing with good experience in following skills. 1. HTML/HTML5 2. css/css3 3. JS (Angular JS, Backbone JS, React JS, node.js Express JS, Gulf Daha Fazla

€30 EUR in 7 gün içinde
(1 Yorum)
0.5
meet1511

Hello, im web developer and i have 3 years experience in php and im working on pdo since last 3 years. I can help you in this and i guarantee to solve this issue.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
ukendiran

Hi, I will help you to complete the task in time. I am having 10 + years of experience in web development. Connect me to start work. Thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
nikhilhiwrale

hello , i am senior software developer,,I have studied your issue. i would like to help you solving your issue

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
nasimahmed1998

hi dear I will you do this work free. If you like, I'll give me 20 euro. You will send me all the details Thank you

€16 EUR in 2 gün içinde
(0 Değerlendirme)
0.0