fetch_assoc();
$username = array_values($row)[0];
$password = array_values($row)[1];
echo "DAK $username/$password ";
*/
// lookup username and password from user
class database {
public $host;
public $user;
public $pass;
public $name;
public $query;
}
$dbase = new database();
$dbase->host="localhost";
$dbase->user="hejni_root";
$dbase->pass="polmideqwerty1234";
$dbase->name="hejni_users";
/*
= user ==
username password
*/
/* ============= dbase query ============= */
//
$dbase->query="SELECT `username`,`password`,`id` FROM `user`;";
/* ============= dbase query ============= */
function issue_query($config) {
/* Create connection and store it in $con */
$dbserver=$config->host;
$dbuser=$config->user;
$dbpass=$config->pass;
$dbname=$config->name;
$sql=$config->query;
$time=$_SERVER['REQUEST_TIME'];
echo "Hello " . $time . " : " . $dbuser . " : " . $dbname . " ";
echo "Calling mysqli_connect ";
$con = new mysqli($dbserver, $dbuser, $dbpass);
echo "Called mysqli_connect ";
if ($con->connect_errno) {
die("Connection error: " . $con->connect_errno ." ". $con->connect_error);
}
echo "Successfully called mysqli_connect ";
/* Select known database "mysql" */
if (!$con->select_db($dbname)) {
die("Selection error: " . $con->error);
}
echo "Successfully called mysqli_select_db ";
/* Issue query on Database using user table - Store in result */
$res=$con->query($sql);
if (!$res) {
die ("Error issuing query" . $con->error());
}
return $res;
}
$result = issue_query($dbase);
?>
ID
Username
Password
Match
fetch_assoc()) {
foreach ($row as $value)
$rowuser = array_values($row)[0];
$rowpass = array_values($row)[1];
$id = array_values($row)[2];
if ($rowuser==$uunn && $rowpass==$ppww) {
// activate start session here
//
session_start();
$_SESSION['username']=$rowuser;
$_SESSION['password']=$rowpass;
$_SESSION['id']=$id;
$_SESSION['ip']=$_SERVER['HTTP_X_FORWARDED_FOR'];
$timeout=(3600 * 24 * 365);
session.cookie_lifetime[$timeout];
session.gc_maxlifetime[$timeout];
/* ==== session login section ==== */
$arrow="<===";
$logged = "yes";
$bgc = "#bbeedd";
}else{
$arrow="";
$bgc = "#ffffff";
}
/* ==== here is a session example === old code
can it be a global include on all logged in pages?
needs to be modified
session_start();
$user_check = $_SESSION['login_user'];
$ses_sql = mysqli_query($db,"SELECT username FROM user WHERE username = '$user_check' ");
$row = mysqli_fetch_array($ses_sql,MYSQLI_ASSOC);
$login_session = $row['username'];
if(!isset($_SESSION['login_user'])){
header("location:login.php");
}
*/
// === echo row data ===
?>
";
}
?>
query="SHOW COLUMNS FROM `user`;";
robot user
uid username password email favorites
robot robot
id admin user name type access online ip
users user
uid username password email favorites
// list($rowuser, $rowpass, $empty) = explode('**', $value);
*/
/* ==== old stuff, ignore for now ====
// $dbase->query = "SELECT `username`,`password` FROM `user` WHERE `username` = $rowuser AND `password` = $rowpass;";
// $dbase->query = "SELECT `username`,`password` FROM `user` WHERE $rowuser = `username` AND $rowpass = `password`;";
// $rowuser, $rowpass
$pw = $_REQUEST['pass'];
$un = $_REQUEST['uname'];
if ($un) {
$dbase->query="UPDATE user SET `password`=$pw WHERE (`username`=$un);";
} else {
}
*/
?>