mysql - How to use username which is used to login, in all the php files -
i have login page data getting stored in database table name "users". want use inputuser "users" have stored shown on php files have created , connected same database.
i want use value of "users" have used login database, can know logged in. pasting login page , 1 php page example.
login.php
<?php $inputuser = $_post["user"]; $inputpass = $_post["pass"]; $user = "root"; $password = ""; $database = "abcd"; $connect = mysql_connect("localhost", $user, $password); // variable initializes connection database @mysql_select_db($database) or die("database not found"); $query = "select * `users` `user` = '$inputuser'"; $querypass = "select * `users` `pass` = '$inputpass'"; echo $password; $result = mysql_query($query) or die(mysql_error()); $resultpass = mysql_query($querypass) or die( mysql_error()); $row = mysql_fetch_array($result); $rowpass = mysql_fetch_array($resultpass); $serveruser = $row["user"]; $serverpass = $rowpass["pass"]; if ($serveruser && $serverpass){ if(!$result){ //header('location: fail.html'); die("username name or password invalid"); } echo "<br><center>database output</b> </center><br><br> "; mysql_close(); echo $inputpass; echo $serverpass; if($inputpass == $serverpass){ header('location: home.php'); } }else { header('location: fail.html'); echo "sorry, bad login"; } ?>
sample.php
<?php $taken = "false"; $database = "abcd"; $password = ""; $username = "root"; // connect database $con = mysql_connect('localhost', $username, $password) or die("unable connect database"); @mysql_select_db($database, $con) or die("unable connect"); $paper_title = mysql_real_escape_string($_get['id']); $query = "select * paper ptitle = '$paper_title'"; $result = mysql_query($query); $row = mysql_fetch_array($result); mysql_close(); ?> <div align = "center"> <form method="post" action="updatedata.php" /> <table> <tr> <td>title: </td> <td><input type="text" name="ptitle" value="<?php echo "$row[ptitle]" ?>"> </td> </tr> </table> <input type ="submit" value ="update information"> </form> </div>
<?php $inputuser = $_post["user"]; $inputpass = $_post["pass"]; $user = "root"; $password = ""; $database = "abcd"; $connect = mysql_connect("localhost", $user, $password); // variable initializes connection database @mysql_select_db($database) or die("database not found"); $query = "select * `users` `user` = '$inputuser'"; $querypass = "select * `users` `pass` = '$inputpass'"; echo $password; $result = mysql_query($query) or die(mysql_error()); $resultpass = mysql_query($querypass) or die( mysql_error()); $row = mysql_fetch_array($result); $rowpass = mysql_fetch_array($resultpass); $serveruser = $row["user"]; $serverpass = $rowpass["pass"]; if ($serveruser && $serverpass){ if(!$result){ //header('location: fail.html'); die("username name or password invalid"); } echo "<br><center>database output</b> </center><br><br> "; mysql_close(); echo $inputpass; echo $serverpass; if($inputpass == $serverpass){ session_start(); $_session["user"] = $row["user"]; header('location: home.php'); } }else { header('location: fail.html'); echo "sorry, bad login"; } ?>
// , you'll may use in pages. when logout, close session.
attention: change mysql_ mysqli_
Comments
Post a Comment