PDO Select with multiple Parameters
€8-30 EUR
Paid on delivery
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... }
Project ID: #20427452
About the project
19 freelancers are bidding on average €22 for this job
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
Hi, I have done this before but I have a few questions, can we chat please? I have 10 years of experience in PHP.
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.
I will resolve the issue for you if u let me.. I am a php developer with more than 8 years exp. developing websites..
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.
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 More
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. More
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 More
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
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.
hello , i am senior software developer,,I have studied your issue. i would like to help you solving your issue
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