Php having problems with Login -

Php having problems with Login -

i have login function, returns me blank page when tried login. first form

<form name="form1" method="post" action="checklogin.php"> <input type="hidden" name="action" value="login"> <input type="hidden" name="hide" value=""> <table class='center'> <tr><td>username:</td><td><input type="text" name="username"></td></tr> <tr><td>password:</td><td><input type="password" name="password"></td></tr> <tr><td>&nbsp;</td><td><input type="submit" value="enter"></td></tr> <tr><td colspan=2>&nbsp;</td></tr> <tr><td colspan=2>don't have admin business relationship yet? click <a href="register.php">here</a>!</td></tr> <tr><td colspan=2>thank using sentence scramble , sequencer</td></tr> </table> </form>

followed php file

<?php // connect server , select databse. $server = 'localhost'; $username = 'root'; $password = ''; $database = 'project'; mysql_connect($server,$username,$password) or die(mysql_error()); mysql_select_db($database) or die(mysql_error()); function signin () { session_start(); if(!empty($_post['username'])) { $query = mysql_query("select * register myusername = '$_post[username]' , mypassword = '$_post[password]'") or die(mysql_error()); $row = mysql_fetch_array($query) or die(mysql_error()); if(!empty($row['myusername']) , !empty($row['mypassword'])) { $_session['myusername'] = $row['mypassword']; echo "success"; } else{ echo "sorry"; } } } if(isset($_post['submit'])) { login_success.php(); } ?>

'myusername' , 'mypassword' elements of table user register username , password into.

there number of issues code.

you're using deprecated mysql_* functions. should switch pdo or mysqli you're declaring function signin() never using/calling it your method validate credentials wrong. should check number of rows returned , should equal 1 this throw syntax error: login_success.php();

the reason might getting blank page because have error_reporting set none. that's reason errors beingness suppressed.

so if want code work,

<?php error_reporting(e_all); // print out errors if $server = 'localhost'; $username = 'root'; $password = ''; $database = 'project'; $db = new pdo("mysql:host=$server;dbname=$database;charset=utf8", '$username', '$password'); function signin ($db) { session_start(); if(!empty($_post['username'])) { $un = $_post['username']; $pw = $_post['password']; $stmt = $db->prepare("select count(*) register myusername = ? , mypassword = ?"); $stmt->execute(array($un, $pw)); // improve approach validate credentials if($stmt->fetchcolumn() == 1) { while($row = $stmt->fetch(pdo::fetch_assoc)) { $_session['myusername'] = $row['mypassword']; } echo "success"; } else{ echo "sorry"; } } else { echo 'username empty. please go , seek again.'; } } if(isset($_post['submit'])) { signin($db); } else { echo 'direct script access not allowed'; }

php login