Query skips out of IF and go to else

[Kylon]

Hey guys. It's me again.
I'm currently working on some new stuff for myself. And I got a really big problem.

I look if the table have an value, if the table don't have a value, then echo "n0 p0s7s h3r3".
But he skips all the time the if-loop and go into the else-loop. But the text 'n0 [...]' will display.

My Code:

    public function getLastPostFromCat($subID) {
        $subID = $this->Database()->escape(htmlspecialchars($subID));


        $threadStmt = $this->Database()->getCon()->query("SELECT * FROM forum_threads WHERE subID = ".$subID." ORDER BY forumID DESC LIMIT 1");


        if($threadStmt->rowCount() == 0) {
            echo "No posts here";
        } else {
            $thread = $threadStmt->fetchObject();
            $postStmt = $this->Database()->getCon()->query("SELECT userID, forumID FROM forum_posts WHERE forumID = ".$thread->forumID);


            return $postStmt->fetchObject();
        }
    }

  public function getThreadByID($id) {
        $id = $this->Database()->escape($id);
        $stmt = $this->Database()->select('*')->from('forum_threads')->where("forumID = ".$id);


    if($stmt->row() == 0) {
      //return nothing
    } else {
      return $stmt->get();
    }
    }

<a href="/thread/december-and-january-update-495/"><?= htmlspecialchars($this->ForumThreads->getThreadByID($this->ForumPosts->getLastPostFromCat($sub['subID'])->forumID)->forumTitle); ?></a>

Error:

[URL="http://localhost/thread/december-and-january-update-495/"]No posts hereError: 8
Message: Trying to get property of non-object 
File: C:\xampp\htdocs\application\views\Home\Home.tpl
Line: 21[/URL]

 

[s-p-n]

What does $threadStmt->$rowCount() return?

Side note, it would be better to

You must be registered to see links

rather than concatenating it inside of the query string.

 

[Kylon]

What does $threadStmt->$rowCount() return?

first time int(1), because one value exists for a other var and int(0)

 

[s-p-n]

strange.. 0 is 0 is 0. Investigate your problem a little deeper, but saying in code .. if(0 == 0) you will get through that condition.. The computer doesn't make mistakes

 

[Future]

It might be possible that your SQL query does not return what you expect it to. You should try to separate your SQL code into a real SQL query and run it against your database directly. See if the results you expect are returned, and so on. Maybe it does return rows you do not expect from it because your query produces faulty output out of a logic error.

 

[Naty48]

cast them to integers and try.

 

[MaxZeus]

You could try printing the results and checking what is resulted, then make the proper changes.

 

[ovflowd]

$this->Database()->getCon()->query

Kylon this path is huge. Try implement a cleanest Design Pattern. Haha for few seconds i was thinking in Jinja for PHP (But Jinja is a Template engine, and yes, a lot of people uses it for "Native SQL Queries being Dynamic" don't do that Ky...) Try Implement a Design Pattern following Factories.

Here is live Example:

You must be registered to see links

You can see other example here:

You must be registered to see links

(Go ahead Chapter 4 > App.Ado)

In Java is DAO but in PHP is ADO. wut.

 

[Kylon]

$this->Database()->getCon()->query

@Kylon this path is huge. Try implement a cleanest Design Pattern. Haha for few seconds i was thinking in Jinja for PHP (But Jinja is a Template engine, and yes, a lot of people uses it for "Native SQL Queries being Dynamic" don't do that Ky...) Try Implement a Design Pattern following Factories.

Here is live Example:

You must be registered to see links

You can see other example here:

You must be registered to see links

(Go ahead Chapter 4 > App.Ado)

In Java is DAO but in PHP is ADO. wut.

bruuh, that's an old thread. :'(

You must be registered to see links

<- updated version <3

 

[ovflowd]

Nice!



Observation: Ins't good including Vendors folders inside Github. Composer need necessary resolve they.