0

Hi,

Imagine there is a tbl called "users" and it has a column called "your blog url".
Now, imagine you want to display that blog's url in an iframe on one of your pages. How would you code it ?
I did the following but the iframe fails to load the webpage.
I guess this is due to me failing to get the iframe to pic one url or one entry from the "your blog url" column.

The best attempt I made was this:

[code]
<?php 
    //Display User's blog?>
    <iframe src="<?php $row["blog"];?>"></iframe>
​​​​​​​[/code]

How would you code it yourself ? Imagine, you want to display in the iframe the url that is the final entry in the "your blog url" column in users tbl in mysql db.

Imagine the tbl looks like this:

     users
id|your_blog_url
6|http://myownblog.com

And since the "http://myownblog.com" is the final entry in the "your_blog_url" column you want to load that in the iframe.

Whatever sample you provide, make sure it works by checking it in your wamp/xampp before adding your code in this thread.

Thanks!

4
Contributors
7
Replies
64
Views
3 Months
Discussion Span
Last Post by diafol
0

Ok,

Here's the original script.
I shortened it 2 nights ago so you guys don't have to wade through many lines of code. And while shortening it, I made mistakes. And so, here's the full script for that particular page.
config.php contains the db connection details and other files.

[code]
<html>
<head>
<title>
Home Page
</title>
</head>
<body>

<?php
include 'config.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 users WHERE usernames = '".$user."'";
    $result = mysqli_query($conn,$sql);
    $numrows = mysqli_num_rows($result);
    if($numrows >1)
    {   
        while ($row = mysqli_fetch_assoc($sql))
        {
            $db_id = $row["id"];
            $db_username = $row["usernames"];
            $db_first_name = $row["first_names"];
            $db_surname = $row["surnames"];
            $db_email = $row["emails"];
            $db_blog_url = $row["blogs_urls"];

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

            <?php
            //Display log-out link.
            echo "<a href='logout.php'>$user Log Out</a>";?>|<br>

            <?php 
            //Display User's own blog Page in iframe.?>
            <iframe src="<?php echo $db_blog_url;?>"></iframe>
            <br>

            <?php 
            //Display 1st User's blog Page (regardless of who the user is) in iframe.?>
            <iframe src="<?php echo ".$blogs_urls[0].";?>"></iframe>

            <?php 
            //Display All Users' blogs Pages in iframe.?>
            <iframe src="<?php echo $row['blogs_urls'];?>"></iframe>
            <?php 
        }
    }       
}
?>

</body>
</html>
[/code]    

Ignore the part where my code is not secure from sql injection. I will deal with that later. In the meanwwhile, concentrating on how to fix this frame thing. I attempted 3 different ways to code the iframe to load a webpage but no luck. I don't get any errors but a complete blank page. (Error settings is full set to show error messages).

Edited by UI

0

The url in db is google.com which is supposed to load in iframe.

0

Gentlemedia,

No matter what url I try, same result.

Man, atleast one url should load properly in my inframe since not every website in the world would not be putting measures to foil iframes.
How-about you try loading a page and when it works then give me the url to check out on my end.

I've now taken out all the session code altogether.
Code now looks like this:

[code]

<html>
<head>
<title>
Home Page
</title>
</head>
<body>
<body background=".png">

<?php
include 'config.php';

$sql = "SELECT * FROM users WHERE usernames = 'USERNAME WENT HERE'";
$result = mysqli_query($conn,$sql);
$numrows = mysqli_num_rows($result);
if($numrows >0)
{   
    while ($row = mysqli_fetch_assoc($result))
    {
        $db_id = $row["ids"];
        $db_username = $row["usernames"];
        $db_first_name = $row["first_names"];
        $db_surname = $row["surnames"];
        $db_email = $row["emails"];
        $db_blog_url = $row["blogs_urls"];

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

        <?php 
        //Display User's own blog Page in iframe.?>
        <iframe src='<?php echo $row["blog_urls"];?>'></iframe>
        <br>

        <?php 
        //Display 1st User's blog Page (regardless of who the user is) in iframe.?>
        <iframe src="<?php echo '.$blogs_urls[0].';?>"></iframe>

        <?php 
        //Display 1st User's blog Page (regardless of who the user is) in iframe.?>
        <iframe src='<?php echo ".$blogs_urls[0].";?>'></iframe>
        <?php 

    }
}
else
{
echo "<p>No Results!</p>\n" ;
}   

?>

</body>
</html>

[/code]

I have changed the url from my db to:

[url]http://www.goviralnow.net/traffic-generation-techniques-for-2017/[/url]

But I don't see any pages loading. I however, now see no blank page but 3 iframes with 3 error messages:

1st error message:

Access forbidden!

You don't have permission to access the requested object. It is either read-protected or not readable by the server.

If you think this is a server error, please contact the webmaster.

Error 403

localhost
Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9

2nd error message:

Object not found!

The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404

localhost
Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9

3rd error message:

Same as 1st error message.

Note from my most recent code, I have 3 iframes coding 3 different ways with php. Looking at these error messages and my 3 iframe codes, what is your conclusion ? What do you make out of all this ?

Edited by UI

0

Guys,

Check how this programmer managed to frame pages:

I can see all 5 links are shown in frames here:
https://supiet.tk/assets/sp-a/index.php?files=yes

Can clearly see 2nd & 6th links in frames here:
https://supiet.tk/assets/sp-a/index.php?object=yes

Can also see 2nd & 6th links in frames here:
https://supiet.tk/assets/sp-a/index.php?frame=yes

Can also see 2nd & 6th links in frames here:
https://supiet.tk/assets/sp-a/index.php?embed=yes

He says he tried displaying a couple of URLs inside an iframe but not all rendered. And a Google search recommended using file_get_contents(); inside a div and another to use curl();. He solved his URL display like that.
I only touched on curl once and haven't got to file_get_contents() yet. And so, if you have any idea what he's talking about and manage to get a working code sample then do kindly share here with everyone.

Thanks!

1

file is sometimes disabled on servers so you have to resort to curl. Otherwise file is easier.

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