MSQLI SELECT FROM

Vote count:

0

how do i show my database to users by using the same php script? Over here, after i get the $_POST data from my form, i want to show the whole table to the user. How can i achieve that? Thank You GURUS in advance! (:

<?php
$db_hostname = 'localhost';
$db_database = 'userdata';
$db_username = '';
$db_password = '';

$mysqli = new mysqli($db_hostname, $db_username, $db_password, $db_database);

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

function sanitizeString($var)
{
    $var = strip_tags($var);
    $var = stripslashes($var);
    $var = htmlentities($var);

    return mysql_real_escape_string($var);  
}

function queryMysql($query)
{
    $result = mysqli_query($query) or die(mysql_error());
    return $result; 
}


 $var1 = $_POST['VAR1'];
 $var2 = $_POST['VAR2'];
 $var3 = $_POST['VAR3'];



 $query = "INSERT INTO users (username, userpass, email)
 VALUES ('".$var1."','".$var2."' ,'".$var3."')";

 $result = mysqli_query($mysqli, $query); 

mysqli_close($mysqli);

echo $var1 ." ". $var2 ." ". $var3 ;

 $query = "SELECT FROM users";
 $result = mysqli_query($mysqli, $query);

?>

asked 29 secs ago

user3363154

3