简单的下一页分页MYSQLI

Question

Hi I'm trying to figure out if this will work in some sense. Right now of course it's not. I'm throwing now errors, but I'm also not getting anything outputting with the $nextLink variable..

Here is the full so we're clear how it all comes together:

<?php
// Check to see the URL variable is set and that it exists in the database
if (isset($_GET['id'])) {
// Connect to the MySQL database
include "includes/db_conx.php";
$id = intval($_GET['id']);// filter everything but numbers
// Use this var to check to see if this ID exists, if yes then get the product
// details, if no then exit this script and give message why


$sql = "UPDATE content SET views=views+1 WHERE ID=$id";
$update = mysqli_query($db_conx,$sql);

$sql = "SELECT * FROM content WHERE id=$id LIMIT 1";
$result = mysqli_query($db_conx,$sql);
$productCount = mysqli_num_rows($result);
//


if ($productCount > 0) {
// get all the product details
while($row = mysqli_fetch_array($result)){
$id = $row["id"];
$article_title = $row["article_title"];
$category = $row["category"];
$readmore = $row["readmore"];
$author = $row["author"];
$date_added = $row["date_added"];
$article = $row["article"];
$newDate = substr($date_added, 0, 10); 
}
} else {
echo "That item does not exist.";
exit();
}

} else {
echo "Data to render this page is missing.";
exit();
}
$sqltwo = "SELECT * FROM content WHERE id =(select min(id) from content where id > '$id') LIMIT 1";
$next = mysqli_query($db_conx,$sqltwo);
if($next > 0){
while($row = mysqli_fetch_array($next)){
$id = $row["id"];
$nextLink = '$id';
}
}

?>

and here is the snippet I'm working through.

$sqltwo = "SELECT * FROM content WHERE id =(select min(id) from content where id > '$id') LIMIT 1";
$next = mysqli_query($db_conx,$sqltwo);
if($next > 0){
while($row = mysqli_fetch_array($next)){
$id = $row["id"];
$nextLink = '$id';
}
}

I'm trying to select the next row by grabbing the bunch after current id and picking the next one to feed the $nextLink for the the HTML.

This was my vardump for $next

object(mysqli_result)#3 (5) {
  ["current_field"]=>
  int(0)
  ["field_count"]=>
  int(10)
  ["lengths"]=>
  NULL
  ["num_rows"]=>
  int(0)
  ["type"]=>
  int(0)
}

Answer 1

The reason you are not getting the desired output for the $nextLink variable is because you have enclosed it in single quotes ' .

Variables inside double quotes " get evaluated by the parser. Variables inside double quotes ' do not get evaluated by the parser and are treated as literal strings.

Instead of this

$nextLink = '$id';

Use this

$nextLink = $id; or even this will do (but is not advised ) $nextLink = "$id";

You will get the desired output for $nextLink. Hope that helps :)