Update PHP variables when the page is reloaded


I am new to this and I am learning, but I have a problem that I can not solve.

I have a variable called $ result where it collects all the information from the database when you log in, but I need to update it every time you update or access a web page.

The way I have it is as follows:

  • Action of the login button:

<form class="nav-login-form" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
  • Web pages:

	if(isset($_POST['login'])) {
	include 'php/login.php';
  • Login.php file

include 'MySQL-conn.php';	

$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);

if (!$conn) {
	die("Conexion fallida: " . mysqli_connect_error());

$NickEmail = $_POST['nick-email']; 
$Password = $_POST['password'];

if ($result = mysqli_query($conn, "SELECT Nick, Email, Password, Rank, Coins FROM accounts WHERE Nick = '$NickEmail' OR Email = '$NickEmail'")) {
	$row = mysqli_fetch_assoc($result);

	$hash = $row['Password'];

	if (password_verify($_POST['password'] , $hash)) {
		$_SESSION['logged'] = true;
		$_SESSION['Nick'] = $row['Nick'];
		$_SESSION['Email'] = $row['Email'];
		$_SESSION['Rank'] = $row['Rank'];
		$_SESSION['Coins'] = $row['Coins'];
		$_SESSION['start'] = time();
		$_SESSION['expire'] = $_SESSION['start'] + (60 * 60);						
		echo "<style>div.successful-login {display: inline;}</style>";

From this code when you log in, I want to make a code for the reload of the variable $ result and at the same time you overwrite the variable $ _SESSION.

The code of the button is in all the pages because I have a login form in the nav of each page, therefore the first 2 codes are in all the pages. And the code of the login.php file is that, only the part where the MySQL database reads, which is what I need to reload, to $ result.

Any solution? Whatever it is.

asked by 04.01.2019 в 12:15

0 answers