0

Hello People,

Do you know why iframe is not opening to the url (variable value) ?
Here is latest update of the code but still it shows not the variable value as the iframe URL. Variable calls db row data. Mysql column "Latet_View" has an entry on position zero: http://www.google.com
The iframe is not opening to the URL mentioned in the variable $Latest_View.

Following not working:

[php]
<?php 
//Display User's Latest Viewed Url in iFrame.?> <iframe src='<?php echo $db_latest_view;?>'></iframe>
[/php]

Latest code:

[php]
<html> <head> <title> <?php 
$user?> Home Page
</title> </head> <body> <body background=".png"> <?php
session_start();
require "conn.php";

/*Check if user is logged-in or not by checking if session is set or not. 
If user is not logged-in then redirect to login page. Else, show user's account homepage.*/

if(!isset($_SESSION["user"])) 
{
    header("location:login.php");
}
else 
{
    $user = $_SESSION["user"];
    $sql = "SELECT * FROM $user WHERE Username = '".$user."'";
    $result = $conn->query($sql);
    while($row = mysqli_fetch_assoc($result))
    {
        $db_id = $row["Id"];
        $db_username = $row["Username"];
        $db_forename = $row["Forename"];
        $db_surname = $row["Surname"];
        $db_email = $row["Email"];
        $db_bio = $row["Bio"];
        $db_status_to_friends = $row["Status_To_Friends"];
        $db_status_to_public = $row["Status_To_Public"];
        $db_latest_view = $row["Latest_View"];    

        //Welcome user by name.
        echo "<center>Welcome <b><h2>$db_forename $db_surname!</center>"?></h2></b>|

        <?php
        //Display log-out link.
        echo "<p align='right'><a href='logout.php'>$user Log Out</a>";?>|</p><br> <form method="post" action=""> <div class="form-group"> <center><label>Post Status To Friends:</label> <input type="text" placeholder="Post Status To Friends" name="post_status_to_friends" /></center><br> <center><button type="submit" class="btn btn-default" name="post_status_to_friends" />Post Status To Friends!</button></center> </div> </form><br> <br> <form method="post" action=""> <div class="form-group"> <center><label>Post Status To Public:</label> <input type="text" placeholder="Post Status To Public" name="post_status_to_public" /></center><br> <center><button type="submit" class="btn btn-default" name="post_status_to_public" />Post Status To Public!</button></center> </div> </form> <?php
        //Post User Status To Friends in $user table.

        if  (isset($_POST['post_status_to_friends']))
        {
            $status_to_friends = trim($_POST["post_status_to_friends"]);
            $status_to_friends = mysqli_real_escape_string($conn,$status_to_friends);

            $sql = "UPDATE $user SET Status_To_Friends = '$db_status_to_friends' WHERE Username = '".$user."'";
            if($conn->query($sql)===TRUE)
            {
                echo "posted status for friends to $user table!";
            }
            else    
            {
                echo "posting status for friends to $user table failed!";
            }

            //Post User Status To Friends in "users" table.

            $sql = "UPDATE users SET Status_To_Friends = '$db_status_to_friends' WHERE Username = '".$user."'";
            if($conn->query($sql)===TRUE)
            {
                echo "posted status for friends to users table!";
            }
            else    
            {
                echo "posting status for friends to users table failed!";
            }
        }
        ?><br> <br> <?php
        //Post User Status To Public in $user table.

        if  (isset($_POST['post_status_to_public']))
        {
            $status_to_public = trim($_POST["post_status_to_public"]);
            $status_to_public = mysqli_real_escape_string($conn,$status_to_public);

            $sql = "UPDATE $user SET Status_To_Public = '$db_status_to_public' WHERE Username = '".$user."'";
            if($conn->query($sql)===TRUE)
            {
                echo "posted status for public to $user table!";
            }
            else    
            {
                echo "posting status for public to $user table failed!";
            }

            //Post User Status To Public in users table.
            $sql = "UPDATE users SET Status_To_Public = '$db_status_to_public' WHERE Username = '".$user."'";
            if($conn->query($sql)===TRUE)
            {
                echo "posted status for public to users table!";
            }
            else    
            {
                echo "posting status for public to users table failed!";
            }               
        }
        ?><br> <br> <?php 
    //Display User Status To Friends. Search for User's data with $user.

    $query = "SELECT * FROM $user WHERE Username = '".$user."'";
    $result = mysqli_query($conn,$query);
    $numrows = mysqli_num_rows($result);
    if($numrows = 0)
    {       
        echo "No data!";
    }
    else 
    {
        while($row = mysqli_fetch_assoc($result)) 
        {     
            $db_status_to_friends = $row["Status_To_Friends"];
        }
        echo "<br><b>$user Status To Friends:</b><br>
        $db_status_to_friends";
        }
    }
    ?><br> <br> <?php 
    //Display User Status To Public. Search for User's data with $user.
    $query = "SELECT * FROM $user WHERE Username = '".$user."'";
    $result = mysqli_query($conn,$query);
    $numrows = mysqli_num_rows($result);
    if($numrows = 0)
    {       
        echo "No data!";
    }
    else 
    {
        while($row = mysqli_fetch_assoc($result)) 
        {     
            $db_status_to_public = $row["Status_To_Public"];
        }
        echo "<br><b>$user Status To Public:</b><br>
        $db_status_to_public";
    }
    ?><br> <br> <?php 
    //Display User's Latest View.
    echo "<br><b>Latest View:</b><br>";
    echo "$db_latest_view";?><br> <br> <?php 
    //Display User's Latest Viewed Url in iFrame.?> <iframe src='<?php echo $db_latest_view;?>'></iframe> <?php 
    //Display User Bio.
    echo "<br><b>Bio:</b><br>";
    echo "$db_bio";?><br> <br> <?php 
}

?> </body> </html>

[/php]

iframe not showing any page on my google chrome.
Tried now (notice the single & double quotes) 3 different approaches to get the iframe to open to a url listed in the db entry:

<?php 
//Display User's Latest Viewed Url in iFrame.?> <iframe src='<?php echo $db_latest_view;?>'></iframe> <br> <iframe src="http://www.google.com"></iframe> <br> <iframe src='http://www.google.com'></iframe> <br>

[/php]

1
Contributor
1
Reply
5
Views
1 Week
Discussion Span
Last Post by UI
0

I tookout everything and left the page with only the following but I do not see any iframe today. Google Chrome.

<html>
<head>
<title>iframe</title>
</head>
<body>
<iframe src="http://www.google.com"></iframe>
<br>
<iframe src='http://www.google.com'></iframe>
<br>
</body>
</html>

I checked following and I can see on the right part of page the iframe has opened a page. That means iframe supported and working on my google chrome.
https://www.w3schools.com/tags/tryit.asp?filename=tryhtml_iframe

However, the leftside of the page shows:

<!DOCTYPE html>
<html>
<body>

<iframe src="https://www.w3schools.com">
<p>Your browser does not support iframes.</p>
</iframe>

</body>
</html>

Edited by UI

Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.