Help to finish the code.

bass · October 14, 2016

I have code in which I list the flights.

Help write the code, so if flight is not found, displays a message that NO schedules!

<table class="table table-bordered" width="40%" border="0" cellspacing="0" cellpadding="0">
 <tr class="active">
   <th colspan="7"><center>
  Ð¡Ð¿Ð¸ÑÐ¾Ðº Ñ€ÐµÐ¹ÑÐ¾Ð² Ð¸Ð· ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚Ð°
   </center></th>
   </tr>
 <tr class="active">
   <th>ÐÐ¾Ð¼ÐµÑ€ Ñ€ÐµÐ¹ÑÐ° <i class="soap-icon-status"></i></th>
<th>ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚ Ð²Ñ‹Ð»ÐµÑ‚Ð° <i class="soap-icon-securevault"></i></th>
<th>ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚ Ð¿Ñ€Ð¸Ð±Ñ‹Ñ‚Ð¸Ñ <i class="soap-icon-securevault"></i></th>
   <th>Ð’Ñ‹Ð»ÐµÑ‚<i class="soap-icon-wifi"></i></th>
<th>Ð’Ñ€ÐµÐ¼Ñ Ð² Ð¿ÑƒÑ‚Ð¸<i class="soap-icon-wifi"></i></th>
<th>Ð”Ð°Ð»ÑŒÐ½Ð¾ÑÑ‚ÑŒ<i class="soap-icon-wifi"></i></th>
<th>ÐÐ°Ð·Ð½Ð°Ñ‡ÐµÐ½ Ð±Ð¾Ñ€Ñ‚<i class="soap-icon-wifi"></i></th>
   </tr>
  <?php
$query = "SELECT * FROM phpvms_schedules WHERE depicao='$name->icao'";
$Result = DB::get_results($query);
foreach($Result as $
{ ?>
 <tr>
   <td><?php echo $b->code; ?><?php echo $b->flightnum; ?></td>
   <td><?php echo $b->depicao; ?> <?php $country = OperationsData::getAirportInfo($b->depicao);
					    $imgicao = array_search($country->country, Countries::$countries); ?> <img
						    src="<?php echo SITE_URL; ?>/lib/images/countries/<?php echo strtolower($imgicao); ?>.png"
						    alt="<?php echo strtolower($imgicao); ?>"/> </td>
<td><?php echo $b->arricao; ?> <?php $country = OperationsData::getAirportInfo($b->arricao);
					    $imgicao = array_search($country->country, Countries::$countries); ?> <img
						    src="<?php echo SITE_URL; ?>/lib/images/countries/<?php echo strtolower($imgicao); ?>.png"
						    alt="<?php echo strtolower($imgicao); ?>"/></td>
<td><?php echo $b->deptime; ?></td>
<td><?php echo $b->arrtime; ?></td>
<td><?php echo $b->distance; ?> Ml</td>
<td><?php echo $b->airbr; ?></td>

   </tr>
 <?php } ?>
</table>

bass · October 14, 2016

bass · October 14, 2016

As seen in the photo, if there are no schedules, the system displays an error message.

How to make wrote message! THERE ARE NO SCHEDULES ???

Edited October 14, 2016 by bass

web541 · October 14, 2016

Are you able to post your full code (module if needed), where is the $name->icao variable coming from?

$query = "SELECT * FROM phpvms_schedules WHERE depicao='$name->icao'";

Sava · October 14, 2016

<table class="table table-bordered" width="40%" border="0" cellspacing="0" cellpadding="0">
<tr class="active">
 <th colspan="7"><center>
	 Ð¡Ð¿Ð¸ÑÐ¾Ðº Ñ€ÐµÐ¹ÑÐ¾Ð² Ð¸Ð· ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚Ð°
 </center></th>
 </tr>
<tr class="active">
 <th>ÐÐ¾Ð¼ÐµÑ€ Ñ€ÐµÐ¹ÑÐ° <i class="soap-icon-status"></i></th>
<th>ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚ Ð²Ñ‹Ð»ÐµÑ‚Ð° <i class="soap-icon-securevault"></i></th>
<th>ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚ Ð¿Ñ€Ð¸Ð±Ñ‹Ñ‚Ð¸Ñ <i class="soap-icon-securevault"></i></th>
 <th>Ð’Ñ‹Ð»ÐµÑ‚<i class="soap-icon-wifi"></i></th>
<th>Ð’Ñ€ÐµÐ¼Ñ Ð² Ð¿ÑƒÑ‚Ð¸<i class="soap-icon-wifi"></i></th>
<th>Ð”Ð°Ð»ÑŒÐ½Ð¾ÑÑ‚ÑŒ<i class="soap-icon-wifi"></i></th>
<th>ÐÐ°Ð·Ð½Ð°Ñ‡ÐµÐ½ Ð±Ð¾Ñ€Ñ‚<i class="soap-icon-wifi"></i></th>
 </tr>
<?php
$query = "SELECT * FROM phpvms_schedules WHERE depicao='$name->icao'";
$Result = DB::get_results($query);
if($Result != null) {
foreach($Result as $
{ ?>
<tr>
 <td><?php echo $b->code; ?><?php echo $b->flightnum; ?></td>
 <td><?php echo $b->depicao; ?> <?php $country = OperationsData::getAirportInfo($b->depicao);
												 $imgicao = array_search($country->country, Countries::$countries); ?> <img
														 src="<?php echo SITE_URL; ?>/lib/images/countries/<?php echo strtolower($imgicao); ?>.png"
														 alt="<?php echo strtolower($imgicao); ?>"/> </td>
<td><?php echo $b->arricao; ?> <?php $country = OperationsData::getAirportInfo($b->arricao);
												 $imgicao = array_search($country->country, Countries::$countries); ?> <img
														 src="<?php echo SITE_URL; ?>/lib/images/countries/<?php echo strtolower($imgicao); ?>.png"
														 alt="<?php echo strtolower($imgicao); ?>"/></td>
<td><?php echo $b->deptime; ?></td>
<td><?php echo $b->arrtime; ?></td>
<td><?php echo $b->distance; ?> Ml</td>
<td><?php echo $b->airbr; ?></td>

 </tr>
<?php } ?>
</table>
<?php } else { echo 'No Schedules'; } ?>

Try this, and modify the string to what you need for the page to look good and how you want. Let me know if it works.

Edited October 14, 2016 by Sava

bass · October 15, 2016

Are you able to post your full code (module if needed), where is the $name->icao variable coming from?
$query = "SELECT * FROM phpvms_schedules WHERE depicao='$name->icao'";

Is the module "Airport", I just decided to fill it as different information.

bass · October 15, 2016

<table class="table table-bordered" width="40%" border="0" cellspacing="0" cellpadding="0">
<tr class="active">
 <th colspan="7"><center>
	 Ð¡Ð¿Ð¸ÑÐ¾Ðº Ñ€ÐµÐ¹ÑÐ¾Ð² Ð¸Ð· ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚Ð°
 </center></th>
 </tr>
<tr class="active">
 <th>ÐÐ¾Ð¼ÐµÑ€ Ñ€ÐµÐ¹ÑÐ° <i class="soap-icon-status"></i></th>
<th>ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚ Ð²Ñ‹Ð»ÐµÑ‚Ð° <i class="soap-icon-securevault"></i></th>
<th>ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚ Ð¿Ñ€Ð¸Ð±Ñ‹Ñ‚Ð¸Ñ <i class="soap-icon-securevault"></i></th>
 <th>Ð’Ñ‹Ð»ÐµÑ‚<i class="soap-icon-wifi"></i></th>
<th>Ð’Ñ€ÐµÐ¼Ñ Ð² Ð¿ÑƒÑ‚Ð¸<i class="soap-icon-wifi"></i></th>
<th>Ð”Ð°Ð»ÑŒÐ½Ð¾ÑÑ‚ÑŒ<i class="soap-icon-wifi"></i></th>
<th>ÐÐ°Ð·Ð½Ð°Ñ‡ÐµÐ½ Ð±Ð¾Ñ€Ñ‚<i class="soap-icon-wifi"></i></th>
 </tr>
<?php
$query = "SELECT * FROM phpvms_schedules WHERE depicao='$name->icao'";
$Result = DB::get_results($query);
if($Result != null) {
foreach($Result as $
{ ?>
<tr>
 <td><?php echo $b->code; ?><?php echo $b->flightnum; ?></td>
 <td><?php echo $b->depicao; ?> <?php $country = OperationsData::getAirportInfo($b->depicao);
												 $imgicao = array_search($country->country, Countries::$countries); ?> <img
														 src="<?php echo SITE_URL; ?>/lib/images/countries/<?php echo strtolower($imgicao); ?>.png"
														 alt="<?php echo strtolower($imgicao); ?>"/> </td>
<td><?php echo $b->arricao; ?> <?php $country = OperationsData::getAirportInfo($b->arricao);
												 $imgicao = array_search($country->country, Countries::$countries); ?> <img
														 src="<?php echo SITE_URL; ?>/lib/images/countries/<?php echo strtolower($imgicao); ?>.png"
														 alt="<?php echo strtolower($imgicao); ?>"/></td>
<td><?php echo $b->deptime; ?></td>
<td><?php echo $b->arrtime; ?></td>
<td><?php echo $b->distance; ?> Ml</td>
<td><?php echo $b->airbr; ?></td>

 </tr>
<?php } ?>
</table>
<?php } else { echo 'No Schedules'; } ?>

Try this, and modify the string to what you need for the page to look good and how you want. Let me know if it works.

No, did not help(

Error - Warning: Invalid argument supplied for foreach() in /home/vaflying/public_html/cargo/lib/skins/travelo/airport_info.tpl on line 228

Error shows in this line: if($Result != null) {

Vangelis · October 15, 2016

<table class="table table-bordered" width="40%" border="0" cellspacing="0" cellpadding="0">
<tr class="active">
	 <th colspan="7"><center>
			 Ð¡Ð¿Ð¸ÑÐ¾Ðº Ñ€ÐµÐ¹ÑÐ¾Ð² Ð¸Ð· ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚Ð°
	 </center></th>
	 </tr>
<tr class="active">
	 <th>ÐÐ¾Ð¼ÐµÑ€ Ñ€ÐµÐ¹ÑÐ° <i class="soap-icon-status"></i></th>
<th>ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚ Ð²Ñ‹Ð»ÐµÑ‚Ð° <i class="soap-icon-securevault"></i></th>
<th>ÐÑÑ€Ð¾Ð¿Ð¾Ñ€Ñ‚ Ð¿Ñ€Ð¸Ð±Ñ‹Ñ‚Ð¸Ñ <i class="soap-icon-securevault"></i></th>
	 <th>Ð’Ñ‹Ð»ÐµÑ‚<i class="soap-icon-wifi"></i></th>
<th>Ð’Ñ€ÐµÐ¼Ñ Ð² Ð¿ÑƒÑ‚Ð¸<i class="soap-icon-wifi"></i></th>
<th>Ð”Ð°Ð»ÑŒÐ½Ð¾ÑÑ‚ÑŒ<i class="soap-icon-wifi"></i></th>
<th>ÐÐ°Ð·Ð½Ð°Ñ‡ÐµÐ½ Ð±Ð¾Ñ€Ñ‚<i class="soap-icon-wifi"></i></th>
	 </tr>
<?php
$params['s.depicao']= $name->icao ;
$query = SchedulesData::findSchedules($params);
if($query != null) {
foreach($query as $
{ ?>
<tr>
	 <td><?php echo $b->code; ?><?php echo $b->flightnum; ?></td>
	 <td><?php echo $b->depicao; ?> <?php $country = OperationsData::getAirportInfo($b->depicao);
																									 $imgicao = array_search($country->country, Countries::$countries); ?> <img
																													 src="<?php echo SITE_URL; ?>/lib/images/countries/<?php echo strtolower($imgicao); ?>.png"
																													 alt="<?php echo strtolower($imgicao); ?>"/> </td>
<td><?php echo $b->arricao; ?> <?php $country = OperationsData::getAirportInfo($b->arricao);
																									 $imgicao = array_search($country->country, Countries::$countries); ?> <img
																													 src="<?php echo SITE_URL; ?>/lib/images/countries/<?php echo strtolower($imgicao); ?>.png"
																													 alt="<?php echo strtolower($imgicao); ?>"/></td>
<td><?php echo $b->deptime; ?></td>
<td><?php echo $b->arrtime; ?></td>
<td><?php echo $b->distance; ?> Ml</td>
<td><?php echo $b->airbr; ?></td>

	 </tr>
<?php } ?>
</table>
<?php } else { echo 'No Schedules'; } ?>

Edited October 15, 2016 by Vangelis

Vangelis · October 15, 2016

2ond post please delete

Edited October 15, 2016 by Vangelis

Sign In

Help to finish the code.

Recommended Posts

bass

Link to comment

Share on other sites

bass

Link to comment

Share on other sites

bass

Link to comment

Share on other sites

web541

Link to comment

Share on other sites

Sava

Link to comment

Share on other sites

bass

Link to comment

Share on other sites

bass

Link to comment

Share on other sites

Vangelis

Link to comment

Share on other sites

Vangelis

Link to comment

Share on other sites

Join the conversation