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]