php - Get information from database without signing out and back in -


i want updated information database when site refreshed instead of having log out , in.

i information form user.php when login, redirected memberpage.php. when refresh memberpage.php, if changed on database changed on memberpage aswell. if logged in isbanned_reason = 0 , change 1 on database, want change on memberpage aswell.

heres code : user.php

<?php include('password.php'); class user extends password{      private $_db;      function __construct($db){         parent::__construct();          $this->_db = $db;     }      private function get_user_hash($username){          try {             $stmt = $this->_db->prepare('select password, username, memberid, isbanned_reason, rank members username = :username , active="yes" ');             $stmt->execute(array('username' => $username));              return $stmt->fetch();          } catch(pdoexception $e) {             echo '<p class="bg-danger">'.$e->getmessage().'</p>';         }     }      public function login($username,$password){          $row = $this->get_user_hash($username);          if($this->password_verify($password,$row['password']) == 1){            $_session['loggedin'] = true;           $_session['username'] = $row['username'];           $_session['memberid'] = $row['memberid'];           $_session['rank'] = $row['rank'];           $_session['isbanned_reason'] = $row['isbanned_reason'];               return true;         }     }      public function logout(){         session_destroy();     }      public function is_logged_in(){         if(isset($_session['loggedin']) && $_session['loggedin'] == true){              $_session['rank'];              $_session['isbanned_reason'];                          return true;         }     }  }   ?>

memberpage.php

<?php require('includes/config.php');     //if not logged in redirect login page if(!$user->is_logged_in()){ header('location: login.php'); }     //define page title $title = 'members page';  //include header template  ?>  <link rel="stylesheet" type="text/css" href="style/stylememberpage.css">       <?php if ($_session['isbanned_reason'] == 0) {?> <body>    <center> <p> <h1 id="caption1">secret website title</h1> <h2 id="caption2">you logged in staff member</h2> <ul id="menu"> <li id="items"><a href="index.php">home</a></li> <li id="items"><a href="registrer.php">staff site</a></li> <li id="items"><a href="leaderboards.html">games</a></l1> <li id="items"><a href="contact.html">leaderboard</a></li> <li id="items"><a href="logout.php">log out</a></li> </body> </ul>     </p> </center>  <?php } ?>            <?php if ($_session['isbanned_reason'] == 1) {?> <body>    <center> <p> <h1 id="banned1">your account has been locked.</h1> <h2 id="banned2">you banned until: 12.12.2020 reason : scamming/exploit.</h2> <ul id="menu"> <li id="items"><a href="index.php">home</a></li> <li id="items"><a href="registrer.php">staff site</a></li> <li id="items"><a href="leaderboards.html">games</a></l1> <li id="items"><a href="contact.html">leaderboard</a></li> <li id="items"><a href="logout.php">log out</a></li> </body> </ul>     </p> </center>  <?php } ?>

and, if possible. when change isbanned_reason on database, there way "apply" without user having refresh page? because want them banned when changed. how that?

you can use jquery ajax function check on server or database changed value, use setinterval function trigger ajax on every 5 seconds

try this:

jquery ajax: (on pages want trigger check continuously)

setinterval(function(){   $.ajax({     url : 'check_db.php', //url: lets have check_db.php in same directory file     datatype : 'html',     data : 'post',     data : {user_id : 'user_id'},     success : function(response){       //catch response here server       if (response == 1) {         window.location.href="logout.php"; //redirecting user logout       }     }   }) },5000);//every 5 seconds

also, make sure load jquery library run jquery function on top of page head

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

if don't want redirect page login , ask re-login inside success method of ajax call, need write ajax set session variable , hide banned area. updating session variable required because if user refresh page if statement must work check banned session variable.

that's why better learn ajax clearly. link


Comments

Post a Comment

Popular posts from this blog

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more