Trying to get property of non-object & Undefined Index errors PHP

Question

Im trying to have posts from a user show on their profile, the current query I'm using worked fine for showing posts by everyone but when I try to edit it to only show posts by the users profile I am on it outputs these errors:

Notice: Undefined index: Tezma in C:\xampppp\htdocs\socialnetwork\profile_page.php on line 62

Notice: Trying to get property of non-object in C:\xampppp\htdocs\socialnetwork\profile_page.php on line 70

This is all the code that I have so far:

<?php
        $conn = new mysqli("localhost", "root", "", "login");
        if($conn->connect_error) {
            die("Connection Failed: " . $conn->connect_error);
        }
        $username = $_GET[$data->username]; <-- Line 62

        $sql = "SELECT *
                FROM posts
                WHERE post_user_name = $username
                ORDER BY post_date DESC";
        $result = $conn->query($sql);

        if($result->num_rows > 0) {  <-- Line 70
            while($row = $result->fetch_assoc()){
                echo "<div class='well well-sm'>";
                echo "<img style='float:left;margin-right:6px;box-shadow:0px 0px 1px #888;' src='user_pictures/default.jpg' width='7%'>";
                echo "<span class='bold'><a href='profile.php?user=".$row['post_user_name']."'>".$row['post_user_name']."</a></span><br>";
                echo "<span>".$row['post_date']."</span>";
                echo "<hr style='margin-top:2px;margin-bottom:2px;'>";
                echo "<p style='margin-bottom:0px;'>".$row['post_content']."</p>";
                echo "</div>";
            }
        } else {
            echo "<div class='well well-sm'>";
            echo "0 Results";
            echo "</div>";
        }
        $conn->close();
    ?>

Those are notices, not errors, and seem to be in the file profile_page.php not in the code you posted. Correct it and that's it — Borgtex, Jul 06 '16 at 15:59
I'm not sure what you mean Borgtex. If they aren't errors shouldn't my query still be showing results then? — TheTezma, Jul 06 '16 at 16:01
the URL is: socialnetwork/profile.php?user=Tezma but on my profile.php page I include_once profile_page.php which is where majority of my code it including the code shown above. — TheTezma, Jul 06 '16 at 16:02
Line 62: $data->username appears to contain "Tezma" as a $_GET-key, but that element ( $_GET['Tezma'] ) doesnt exist (probably you need to use $_GET['user'], not $_GET[$data->username]). — Werner, Jul 06 '16 at 16:02
@TheTezma basically `$_GET['Tezma'];` is the problem your url has no parameter as Tezma — Madhawa Priyashantha, Jul 06 '16 at 16:02
@TheTezma then it should be `$_GET['user'];` not `$_GET['Tezma'];` what is $data? so your query fail and return false then you get second error — Madhawa Priyashantha, Jul 06 '16 at 16:03
Line 70 is an if-statement. It evaluates $result->num_rows, but num_rows is not a property of $result... — Werner, Jul 06 '16 at 16:04

score 0 · Answer 1 · answered Jul 06 '16 at 16:03

0

Im not sure with line 62

$username = $_GET[$data->username];

$_GET[KEY] is retrieving value from key in the URL. Does the URL look like :username=username

answered Jul 06 '16 at 16:03

raviolican

362
4
14

Yep, it should be $_GET['user'], as commented above already :-) – Werner Jul 06 '16 at 16:05
the URL is: socialnetwork/profile.php?user=Tezma but on my profile.php page I include_once profile_page.php which is where majority of my code it including the code shown above, I am trying to retrieve posts created by the user from my database. – TheTezma Jul 06 '16 at 16:07
try and add add $result->store_result(); before line 70 seen here:http://php.net/manual/de/mysqli-result.num-rows.php – raviolican Jul 06 '16 at 16:20

Trying to get property of non-object & Undefined Index errors PHP

1 Answers1