Trying to access array offset on value of type null

It has to do with Latte because I have double-checked the code and the database. There are entries in the database so it has to be something in the code for Latte as I followed the Latte documentation to set up this iteration of my site.

LMAO, no I didn't. I didn't even think about that. I'll do that and see what happens. Thanks.

Cupara wrote:

So I did var_dump($news2); and it returns NULL but I'm not understanding why so I'm scouring through the docs for Latte to make sure I implemented the call right. I'm not used to using $result->fetch_assoc(); to fetch a single entry.

@Cupara
As David pointed out earlier, the problem is not in Latte. It is in these two lines:

$result = $conn->query("SELECT * FROM news WHERE slug = '$slug'");
$news2 = $result->fetch_assoc();

First problem: row 1 contains SQL injection vulnerability. Use prepared statements. If I am correct in the assumption that you are using mysqli class, it would be something like:

$statement = $conn->prepare("SELECT * FROM news WHERE slug = ?");
$statement->bindParam('s', $_GET['slug']);
$statement->execute();
$result = $statement->get_result();
$news2 = $result->fetch_assoc();

Second problem – condition in your SQL query probably does not match any rows – which is why $news2 is NULL.

@Cupara Well… you could dump your query with specific value for the slug (“SELECT * FROM news WHERE slug = ‘foobar’”) and then execute it in your database admin tool (Adminer, PHPStorm etc.) to see if it returns anything. Also maybe dump $_GET['slug'] to verify that it does not contain any trailing whitespace or other unwanted characters.

@nightfish I already did the dump of $_GET['slug'] and it's grabbing that right.

@nightfish I am running out of ideas as well.

Here is the link to it online: https://serenitydev.xyz/…-is-a-test-2

@nightfish that's what I'm saying. I don't understand it at all.

@nightfish What?!? That makes no sense.

Also, could you check my db.php file to make sure I have no vulnerabilities, please? I'm trying to handle this on my phone as my ex-wife is driving down a bumpy road.

db.php:

<?php

$servername = "localhost";
$username = "XXXXXXXXXX";
$password = "XXXXXXXXXX";
$dbname = "XXXXXXXXX";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

function generateSlug($text) {
    $text = strtolower(trim($text));
    $text = preg_replace('/[^a-z0-9-]/', '-', $text);
    $text = preg_replace('/-+/', '-', $text);
    return $text;
}

Ignore the function as that isn't implemented yet.

@Cupara The db.php file looks okay-ish, but I would probably advise against using mysqli. It is preferable to use PDO or rather another higher-level database abstraction layer (nette/database, dibi/dibi, doctrine/dbal, nextras/dbal).

If you want to go full-Nette, I would advise using nette/database, as it can be tightly integrated with Nette.
And maybe base your project on nette/web-project and if you are new to Nette, go through the tutorial – https://doc.nette.org/en/quickstart. It will show you how to create a simple blog website (not dissimilar to your News/NewsDetail).