How To Force MySql With Php To Show Final Row Only?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
UniqueIdeaMan
Forum Contributor
Posts: 197
Joined: Wed Jan 18, 2017 3:43 pm

How To Force MySql With Php To Show Final Row Only?

Post by UniqueIdeaMan »

Buds!

How to code so php forces mysql to show only the final row of the column ?
The followings are how I coded (2 copied youtube tuts) to show all rows to allow user to delete multiple rows:

SAMPLE 1

Code: Select all

<?php
session_start();
require "conn.php";
require "site_details.php"; ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Follow Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form" action="" method="post">
<table border=1 cellpadding=1 cellspacing=1>
	<tr>
		<th>Id</th>
		<th>Username</th>
		<th>Password</th>
		<th>Email</th>
		<th>Delete</th>
	</tr>
<?php
$res=mysqli_query($conn,"SELECT * FROM users");
while($row=mysqli_fetch_array($res))
{
	echo "<tr>";
	echo "<td>"; ?> <input type="checkbox" name="num[]" class="other" value="<?php echo $row["id"]; ?>" /> <?php echo "</td>";
	echo "<td>"; echo $row["ids"]; echo "</td>";
	echo "<td>"; echo $row["usernames"]; echo "</td>";
	echo "<td>"; echo $row["passwords"]; echo "</td>";
	echo "<td>"; echo $row["emails"]; echo "</td>";
	echo "</tr>";
}
?>
</table>
<input type="submit" name="submit" value="delete selected">
</form>
<?php
if(isset($_POST["submit"]))
{
   $box=$_POST['num'];
   while (list ($key,$val) = @each ($box))
	{
      mysqli_query($conn,"DELETE FROM users WHERE id='$val'");
    }
?>
       <script type="text/javascript">
       window.location.href=window.location.href;
       </script>
<?php
}
?>

</body>
</html>
SAMPLE 2:

Code: Select all

<?php
session_start();
require "conn.php";
require "site_details.php"; ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Follow Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table border=1 cellpadding=1 cellspacing=1>
	<tr>
		<th>Id</th>
		<th>Username</th>
		<th>Password</th>
		<th>Email</th>
		<th>Delete</th>
	</tr>
<?php 
$sql = "SELECT * FROM users";
$result = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($result))
	{
		echo "<tr>";
		echo "<td>".$row['ids']."</td>";
		echo "<td>".$row['usernames']."</td>";
		echo "<td>".$row['passwords']."</td>";
		echo "<td>".$row['emails']."</td>";
		echo "<td><a href=delete2b.php?id=".$row['ids'].">Delete</a></td>";
	}

?>
</table>
</body>
</html>
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: How To Force MySql With Php To Show Final Row Only?

Post by Celauran »

UniqueIdeaMan wrote:How to code so php forces mysql to show only the final row of the column ?
Are you talking about LIMIT clauses? If not, can you clarify what you're asking?
UniqueIdeaMan wrote:The followings are how I coded (2 copied youtube tuts)
That's not going to end well...
Post Reply