How to get value from a table column

Question

I wanted to take the value of logged in user points and put on my page. This is the table "users"

For example: "You have x points"

Below page login.php

  <?php 
  $login = $_POST['login'];
  $entrar = $_POST['entrar'];
  $senha = md5($_POST['senha']);
  $connect = mysql_connect('xxxx','xxxxx','xxxxxxx');
  $db = mysql_select_db('xxxxxxxxx');
    if (isset($entrar)) {

      $verifica = mysql_query("SELECT * FROM usuarios WHERE login = '$login' AND senha = '$senha'") or die("erro ao selecionar");
        if (mysql_num_rows($verifica)<=0){
          echo"<script language='javascript' type='text/javascript'>alert('Login e/ou senha incorretos');window.location.href='login.html';</script>";
          die();
        }else{
          setcookie("login",$login);
          header("Location:index.php");
        }
    }
?>

Answer 1

I edited the response and updated it to MySQLi because the version you are using MySQL is discontinued

$connect = new mysqli ("localhost", "USUARIO", "SENHA", "Nome_DB");

$sql="SELECT * FROM usuarios WHERE login = '$login' AND senha = '$senha'";
$buscar=mysqli_query($connect,$sql);
$dados=mysqli_fetch_array($buscar);

$result=mysqli_num_rows($buscar);

if ($result==1) {

    $pontos = $dados["pontos"];

    setcookie("login",$login);
    header("Location:index.php?pontos=".$pontos);

}else|{

    echo"<script language='javascript' type='text/javascript'>alert('Login e/ou senha incorretos');window.location.href='login.html';</script>";
    die();

}

On the index page recover via GET

$pontos = $_GET['pontos'];

then you put it where you want it

within PHP

 echo $pontos;

within HTML

<?php echo $pontos ?>

Answer 2

There are already threads explaining how to do this, not specifically your problem, but as you reported that is layman in language I will explain in response.

This is your code (apparently it’s working)

  <?php 
  $login = $_POST['login'];
  $entrar = $_POST['entrar'];
  $senha = md5($_POST['senha']);
  $connect = mysql_connect('xxxx','xxxxx','xxxxxxx');
  $db = mysql_select_db('xxxxxxxxx');
    if (isset($entrar)) {

      $verifica = mysql_query("SELECT * FROM usuarios WHERE login = '$login' AND senha = '$senha'") or die("erro ao selecionar");
        if (mysql_num_rows($verifica)<=0){
          echo"<script language='javascript' type='text/javascript'>alert('Login e/ou senha incorretos');window.location.href='login.html';</script>";
          die();
        }else{
          setcookie("login",$login);
          header("Location:index.php");
        }
    }
?>

Along those lines $verifica = mysql_query("SELECT * FROM usuarios WHERE login = '$login' AND senha = '$senha'") or die("erro ao selecionar"); you are selecting everything from the table usuarios where credentials are in agreement.

This query is bringing all the data from the table, as long as the entered data is ok.

Along those lines if (mysql_num_rows($verifica)<=0) you are checking if the user does not exist on else you are saving the login in a session, the logic is the same, just in the block of the else add $fetch = mysql_fetch_object($verifica); and access the value of points $fetch->pontos;

at the end your code would be

  <?php 
  $login = $_POST['login'];
  $entrar = $_POST['entrar'];
  $senha = md5($_POST['senha']);
  $connect = mysql_connect('xxxx','xxxxx','xxxxxxx');
  $db = mysql_select_db('xxxxxxxxx');
    if (isset($entrar)) {

      $verifica = mysql_query("SELECT * FROM usuarios WHERE login = '$login' AND senha = '$senha'") or die("erro ao selecionar");
        if (mysql_num_rows($verifica)<=0){
          echo"<script language='javascript' type='text/javascript'>alert('Login e/ou senha incorretos');window.location.href='login.html';</script>";
          die();
        }else{
          setcookie("login",$login);

          $fetch = mysql_fetch_object($verifica);
          $_SESSION["pontos"] = $fetch->pontos;
          header("Location:index.php");
        }
    }
?>

To access the session value in index.php just sign in to the file and get the value.

index php.

session_start();

echo "you have " . $_SESSION["points"] . " points";