Find Jobs
Hire Freelancers

PDO if statement

$10-30 USD

Selesai
Disiarkan lebih dari 5 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran
Here is the code. If there are not records /result I want it to say "No Records Were Found" otherwise the results will show. I have been working with this for a couple of hours and for some reason I just can not get it to work if a PHP if statement... <?php $log_id = $result['log_id']; $query = "SELECT * FROM calls_for_service WHERE log_id = :log_id "; $stmt = $handler->prepare($query); $stmt->bindParam(':log_id', $log_id, PDO::PARAM_INT); $stmt->execute(); $result = $stmt->fetchAll(); foreach ( $result as $row ) { ?> <div class="container" style="background-color: #ffffff;"> <div class="row" align="left" style="color:black;"> <br> <div class="col-sm-2"> <font size="2"><strong> Case # &nbsp; </strong></font> </div> <div class="col-sm-1"> <font size="2"><strong>Call Time &nbsp; </strong></font> </div> <div class="col-sm-1"> <font size="2"><strong> Arrival &nbsp; </strong></font> </div> <div class="col-sm-1"> <font size="2"><strong> In Service &nbsp; </strong></font> </div> <div class="col-sm-5"> <font size="2"><strong> Actions &nbsp; </strong></font> </div> <div class="col-sm-1"> <font size="2"><strong> Edit &nbsp; </strong></font> </div> <div align="center" class="col-sm-1"> <font size="2"><strong> Delete &nbsp; </strong></font> </div> </div> <br> </div> <div class="container" style="background-color: #ffffff;"> <div align="left" class="row"> <div class="col-sm-2"> <em><font color="#008080"><?php echo $row['case_number']; ?></font></em> </div> <div class="col-sm-1"> <em><font color="#008080"><?php echo $row['time_of_call']; ?></font></em> </div> <div class="col-sm-1"> <em><font color="#008080"><?php echo $row['time_of_arrival']; ?></font></em> </div> <div class="col-sm-1"> <em><font color="#008080"><?php echo $row['time_in_service']; ?></font></em> </div> <div class="col-sm-5"> <em><font color="#008080"><?php echo $row['action']; ?></font></em> </div> <div class="col-sm-1"> <a href="call_for_service/[login to view URL]<?php echo $row['call_id']; ?>"><em><font color="#990000">Edit</font></em></a> </a> </div> <div class="col-sm-1"> <a href="call_for_service/[login to view URL]<?php echo $row['call_id']; ?>"><em><font color="#990000">Delete</font></em></a> </div> </div> <br> </div> <?php } ?> <br><br>
ID Projek: 18525295

Tentang projek

6 cadangan
Projek jarak jauh
Aktif 5 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
HI, i can help you here. Please come over chat and discuss in details. Thanks. ................................................
$10 USD dalam 1 hari
5.0 (39 ulasan)
5.3
5.3
6 pekerja bebas membida secara purata $18 USD untuk pekerjaan ini
Avatar Pengguna
Hello, if you award my bid I can send you code which displays "no records" etc. I can do it in 15 min.
$15 USD dalam 1 hari
5.0 (1391 ulasan)
8.8
8.8
Avatar Pengguna
Hi there, Quick and easy. Consider it done in the next 5 minutes. Seriously! I have a 99% project completion rate and a 4.99 reputation (out of max 5.0!) from more than 1150 projects from a period of 12 years. Thanks. I look forward to hearing from you! Best Regards, Rajesh Soni.
$15 USD dalam 0 hari
4.9 (1059 ulasan)
8.9
8.9
Avatar Pengguna
Hi, I can show "no records found" message when no records from database are fetched. I am certain I can do it.
$25 USD dalam 1 hari
5.0 (383 ulasan)
7.4
7.4
Avatar Pengguna
We Believe in Delivering Perfect Work and Providing Full Satisfaction to Our Client . We also Insure to Deliver the Work in the given Time Frame . we have highly Qualified Professionals in our team. Expertise in Photoshop, HTML , CSS, Javascript , PHP , yii2, laravel, NodeJs , AngularJs , ionic, AJAX , SQL , Crom Extension,Python MongoDB , Wordpress , Game Development and all the related Web Technologies.
$15 USD dalam 0 hari
4.8 (27 ulasan)
4.9
4.9
Avatar Pengguna
sure, inbox me and i can do it, today if u want, using motor in real time to see whats ur error, so write me
$25 USD dalam 0 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera UNITED STATES
Port Charlotte, United States
5.0
56
Ahli sejak Apr 30, 2010

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.