Page 1 of 1

Why is not mysql getting UPDATED ?

Posted: Sat Mar 18, 2017 7:39 pm
by UniqueIdeaMan
Hiya Folks,

Why is not mysql getting UPDATED, do you reckon ?

Code: Select all

<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>

Re: Why is not mysql getting UPDATED ?

Posted: Sat Mar 18, 2017 11:53 pm
by thinsoldier
http://catb.org/~esr/faqs/smart-questions.html#intro

Reduce your code example to the bare minimum.

Re: Why is not mysql getting UPDATED ?

Posted: Sun Mar 19, 2017 7:20 am
by Celauran
thinsoldier wrote:http://catb.org/~esr/faqs/smart-questions.html#intro

Reduce your code example to the bare minimum.
+1

Re: Why is not mysql getting UPDATED ?

Posted: Sun Mar 19, 2017 3:51 pm
by thinsoldier
Why is your markup coming out as html entities?

Are you copying and pasting from a really old version of Dreamweaver?

Code: Select all

<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 <h2>$db_forename $db_surname!</center>"?></h2>|

                <?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>$user Status To Friends:<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>$user Status To Public:<br>
                $db_status_to_public";
        }
        ?><br>
        <br>
                       
        <?php
        //Display User's Latest View.
        echo "<br>Latest View:<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>Bio:<br>";
        echo "$db_bio";?><br>
        <br>
       
        <?php
}

?>

</body>
</html>