PHP - How To Make My Print Button Only Appear If There Is Data..

so here the code that i am confusing the whole month , how can i get it to print out the filtered data

$sql="SELECT COUNT(*) as conflicts
        FROM rental
        WHERE Dispatch < :dropoff AND Dropoff > :dispatch";
$stmt = $pdo->prepare($sql);
$stmt->execute( [ 
                   'dropoff'  => $Dropoff,
                   'dispatch' => $Dispatch
                ]);

im so frustrated on myself that cant do anything

Hi all,

This has just been bugging me forever, I actually just hardcoded the line it in years ago to just be done with it.  But when I use the while loop to pull up the data for this table, it prints out every row but the last one.  I've wracked my brain for years trying to fix it, and just cannot find the solution.  Below is the entire page code I'm using and you can see at the bottom what I have sadly hardcoded in to make the last row display.  That's the row that will not show up.  If you want to see the actual live page it's he

https://www.lakerstats.com/numerical-roster/

The UNK line at the end if the one that never prints out that I hardcoded.

Page code as mentioned above. Appreciate any help!

[php]
$db = mysql_connect("localhost", "xxxx", "xxxx");

mysql_select_db("lakerstats",$db);
echo "<table class=numeric WIDTH=100% cellpadding=0 cellspacing=0 border=0>

<tr><td class=left colspan=\"2\" height=10><font size=\"2\" color=#000000>Current players are listed in ALL CAPS.<br />Retired uniforms are listed in <b><font color=\"#FF0000\">red</font></b>.<br /></font></td></tr><tr>";

$uniforms = "SELECT p.fname, p.lname, p.playerid, u.number, p.current_roster, u.retired, u.retired_player, p.profile_name, p.uniform_1, p.uniform_2 FROM player p, uniforms u WHERE u.number = p.uniform_1 or u.number = p.uniform_2 or u.number = p.uniform_3 or u.number = p.uniform_4 ORDER BY u.number+0, p.years, p.lname, p.fname";

$uniresult = mysql_query($uniforms) or die ("Query failed");
$numofrows = mysql_num_rows($uniresult);

//let's get the number of rows in our result so we can use it in a for loop

$temp = "0";
$sHTMLTemp = "";
while ($unirow = mysql_fetch_array($uniresult)) // Where $result is your result set
{
if ($temp != $unirow['number'])
  {
    $temp = $unirow['number'];
    if ($unirow['number'] == "100") {
    $unirow['number'] = "0";
    } else if ($unirow['number'] == "101") {
    $unirow['number'] = sprintf("%02d", 0);
    } else if ($unirow['number'] == "102") {
    $unirow['number'] = "UNK";
    } else {    
    $unirow['number'] = $unirow['number'];
    }

    $sHTMLTemp = preg_replace("/(.+),/","\\1",$sHTMLTemp);
    print $sHTMLTemp ;
    print "</tr>";

     $sHTMLTemp = "";


 if ($unirow[retired] == "yes") {
    echo "<tr><td class=left height=10><font size=\"2\" color=\"#FF0000\"><b>#" . $unirow[number] . "</b></font><font size=\"2\"> - ";
} else {
    echo "<tr><td class=left height=10><font size=\"2\" color=\"#000000\">#" . $unirow[number] . "</font><font size=\"2\"> - ";
}

}

 if ($unirow[current_roster] == "yes") {
$unirow[fname] = strtoupper($unirow[fname]);
$unirow[lname] = strtoupper($unirow[lname]);
} else {
$unirow[fname] = $unirow[fname];
$unirow[lname] = $unirow[lname];
}

 if ($unirow[retired_player] == $unirow[playerid]) {
$sHTMLTemp .= "<b><a href=\"/player-stats-bio/?pname=".$unirow['profile_name']."\"><font color=\"#FF0000\">" . $unirow['fname'] . " " . $unirow['lname'] . "</font></a></b>, ";
} else {
$sHTMLTemp .= "<a href=\"/player-stats-bio/?pname=".$unirow['profile_name']."\">" . $unirow['fname'] . " " . $unirow['lname'] . "</a>, ";
}

}


echo "<a href=\"/player-stats-bio/?pname=jim_fritsche\">Jim Fritsche</a>, <a href=\"/player-stats-bio/?pname=bobby_watson\">Bobby Watson</a>";

echo "</font></td></tr>";

echo "</font></td></tr></table>";

mysql_close($db);
[/php]

Hello,   I am fairly new to PHP and I found some php code to print an array of numbers that create a combination - however, its slams all the numbers together without a space or a comma separator.   How can I separate the numbers in this array with the given code?  Ive attached a photo of the code.

Hi

I have made this simple login page by setcookies function and I want now to make a logout button.

Here the code 

<?php
/*
PHP Form Login Remember Functionality with Cookies
*/
if(!empty($_POST["remember"])) {
	setcookie ("username",$_POST["username"],time()+ 3600);
	setcookie ("password",$_POST["password"],time()+ 3600);
    setcookie ("color",$_POST["color"],time()+ 3600);
    //3600 = 1 hour
    //86400 = 1 day
    //(8640*30) = 1 month
	echo "Cookies Set Successfuly";
} else {
	setcookie("username","");
	setcookie("password","");
    setcookie("color","");
	echo "Cookies Not Set";
}
?>
  <form action="Cookies.php" method="post"
 style="border: 2px dotted blue;
 text-align:center; width: 400px;">

 <p>Welcome <?php echo ( !empty($_POST ['username']) ) ?
  $_POST ['username'] : 'USER'; ?>
    </p>
	<p>Username: <input name="username" type="text" 
    value="<?php if(isset($_COOKIE["username"])) 
    { echo $_COOKIE["username"],( !empty($_POST ['username']) ) ?
  $_POST ['username'] : '';} ?>" >
	</p>
	<p>Password: <input name="password" type="password" value="
    <?php if(isset($_COOKIE["password"])) 
    { echo $_COOKIE["password"]; } ?>" >
	</p>
    <p>Choose Your Favorite Color: <input name="color" type="color" 
    value="<?php if(isset($_COOKIE["color"])) 
    { echo $_COOKIE["color"]; } ?>">
	</p>
	<p><input type="checkbox" name="remember" /> Remember me</p>
	<p><input type="submit" value="Login"></p>  
</form>

Any idea ??

<?
session_start();
error_reporting(E_ALL);
require("connection.php");
if(isset($_GET['page'])){

	$pages=array("products", "cart");
	if(in_array($_GET['page'], $pages)) {
	
		$_page=$_GET['page'];
	
	}else{
	
		$_page="products";
	
	}
	
}else{

$_page="products";

}
?>



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>


<body>
</body>
</html>

<link rel="stylesheet" href="style2.css" />

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js"></script>

<script type="text/javascript">
$(function() {

});
</script> 
</head>

<body>
<div id="container">

<div id="main">
<?php require($_page.".php");     ?>

</div>

<div id="sidebar">
<h1>Cart</h1>

<?php 
if(isset($_SESSION['cart'])){

$sql="SELECT * FROM products WHERE id_product IN (";

foreach($_SESSION['cart'] as $id => $value) {
$sql.=$id.",";
}
$sql=substr($sql, 0, -1).") ORDER BY name ASC";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){

?>
<p><?php echo $row['name'] ?> x <?php echo $_SESSION['cart'][$row['id_product']]['quantity'] ?></p>
<?php }

?>

<hr />
<a href="index2.php?page=cart">Go to Cart</a>


<?php





}else{

echo "<p>Your Cart is empty</p>";

}
?>
</div>

</div>
</body>

<?php

	if(isset($_GET['action']) && $_GET['action']=="add"){
	
		$id=intval($_GET['id']);
		
		if(isset($_SESSION['cart'][$id])){
		
			$_SESSION['cart'][$id]['quantity']++;
		
		}else{
		
			$sql_s="SELECT * FROM products
				WHERE id_product={$id}";
			$query_s=mysql_query($sql_s);
			if(mysql_num_rows($query_s)!=0){
				$row_s=mysql_fetch_array($query_s);
				
					
					
					$_SESSION['cart'][$row_s['id_product']]=array(
							"quantity" => 1,
							"price" => $row_s['price']
							
							);
				
				
				}else{
				
					$message="This product id it's invalid!";
	

		}
		}
		}
		
		


?>


<h1>Product List</h1>
<?php 

	if(isset($message)){
	echo "<h2>$message</h2>";
	}
?>
<table>
<tr>
    <th>Name</th>
	<th>Description</th>
	<th>Price</th>
	<th>Action</th>
</tr>
<?php
$sql="SELECT * FROM products ORDER BY name ASC";

$query=mysql_query($sql);

while ($row=mysql_fetch_array($query)) {

?>
<tr>
	<td><?php echo $row['name'] ?></td>
	<td><?php echo $row['description'] ?></td>
	<td>RM <?php echo $row['price'] ?></td>
	<td><a href="index2.php?page=products&action=add&id=<?php echo $row['id_product'] ?>">Add To Cart</a></td>
</tr>
<?php
}
?>

</table>

<?php
 if(isset($_POST['submit'])){
 
 foreach($_POST['quantity'] as $key => $val) {
 	if($val==0) {
	unset($_SESSION['cart'][$key]);
	}else{
	$_SESSION['cart'][$key]['quantity']=$val;
	
	}
	}
 
 
 }

?>



<a href="index2.php?page=products">Go back to product page</a>
<h1>View Cart</h1>

<form method="post" action"index2.php?page=cart">

<table>
<tr>
	<th>Name</th>
	<th>Quantity</th>
	<th>Price</th>
	<th>Item Price</th>



</tr>
<?php

	$sql="SELECT * FROM products WHERE id_product IN (";

foreach($_SESSION['cart'] as $id => $value) {
$sql.=$id.",";
}
$sql=substr($sql, 0, -1).") ORDER BY name ASC";
$query=mysql_query($sql);
$totalprice=0;
while($row=mysql_fetch_array($query)){
	$subtotal=$_SESSION['cart'][$row['id_product']]['quantity']*$row['price'];
	$totalprice+=$subtotal;

?>
<tr>
<td><?php echo $row['name'] ?></td>
<td><input type="text" name="quantity[<?php echo $row['id_product'] ?>]" size="5" value="<?php echo $_SESSION['cart'][$row['id_product']]['quantity'] ?>"</td>
<td>RM <?php echo $row['price'] ?></td>
<td>RM <?php echo $_SESSION['cart'][$row['id_product']]['quantity']*$row['price'] ?></td>



</tr>



<?php 
}

?>
<tr>
<td>Total Price: <?php echo $totalprice  ?></td>


</tr>

</table>
<button type="submit" name="submit"> Update Cart</button>


</form>
<br />
<p> To remove an item,set the quantity to 0</p>