database - php login form not working correctly -


i'm trying create simple login functionality it's not working, , i'm relatively new mysqli please bear me. want check if email address , password correct , if log user in. in advance.

here login code checks credentials:

updated code - added report , i'm getting internal server error

<?php  require_once 'connect.php'; mysqli_report(mysqli_report_all);   session_start();  if (!isset($_session['email'])) {  $e = trim($_request['email']); $email = $mysqli->real_escape_string($e); $p = trim($_request['password']); $password = $mysqli->real_escape_string($p);  /* if ($result = $mysqli->query("select email, password, user_id" .                                              " users" .                                              " email = '$email' , password = '$password'")) {     printf("select returned %d rows.\n", $result->num_rows); echo 'total results: ' . $result->num_rows;  } */  if ($stmt = $mysqli->prepare("select email, password, user_id users email=? , password=?")) {      /* bind parameters markers */     $stmt->bind_param("ss", $email, $password);      /* execute query */     $stmt->execute();      /* bind result variables */     $stmt->bind_result($email, $password);      /* fetch value */     $stmt->fetch();     if ($stmt->num_rows==1) {    $row = $stmt->fetch_assoc(mysqli_num);    $user_id = $row['user_id'];    $_session['user_id'] = $user_id;    $_session['email'] = $email;    header("location: home.php");      /* close statement */     $stmt->close(); } else {     printf("error message: %s\n", $mysqli->error); } /* if ($result->num_rows==1) { $row = $result->fetch_assoc(mysqli_num);    $user_id = $row['user_id'];  if ($query_group = $mysqli->query("select *" .                                                         " user_groups" .                                                         " user_id = '".$user_id."'")) {    //no more setcookie    $_session['user_id'] = $user_id;    $_session['email'] = $email; } else { echo 'did not work'; } } */      /* free result set */     // $result->close(); } }  ?>

and here connect.php connect database:

<?php $mysqli = new mysqli("data", "username", "password", "db");  if($mysqli->connect_errno > 0){     die('unable connect database [' . $mysqli->connect_error . ']'); }  ?>

did try remove 1 of brackets in end of ypur code. guess have remove 1 of them.


Comments

Post a Comment

Popular posts from this blog

visual studio - vb.net filter binding source by time -

Image
hi there have database date/time (highlighted in red in image below) fields , formatting medium time shown below. and field type , format of log_in_time field.. i've connected database vb.net project , i'm using following code filter binding source log_in_time field of database. i'm using datetimepicker input source. note logouttime datetimepicker code.. private sub logintime_valuechanged(byval sender object, byval e system.eventargs) handles logintime.valuechanged, logintime.keypress 'filter binding source input data try '30-dec-99 default date time paymentdetailsbindingsource.filter = "log_in_time = '30-dec-99 " & logintime.text & "'" catch ex exception end try end sub the format of datetimepicker set custom format hh:mm tt problem above code not work, returns empty search result.. doing wrong appreciated.. thanks.. as per comment above, issue including more (or ...
Read more

php - SPIP: From Tag directly to an article -

i work spip , plugin called tagsphere works fine tags in spip. have tag groupe put 1 article tag. when click on tag in tagsphere send me before menu can see articles linked tag. want send me directly article without see tag menu before. here code model of thagsphere: <div id="tagsphere-#env{id_article}"> <ul> <boucle_mot(mots){id_groupe ?}> <li>[<a href="#url_mot">(#titre)</a>]</li> </boucle_mot> </ul> </div> anybody idea? if want skip tag page, have link directly article. <b_article> block prevents display tag if no article linked. <div id="tagsphere-#env{id_article}"> <ul> <boucle_mot(mots){id_groupe ?}> <b_article> <li> <a<boucle_article(articles){...
Read more

jquery - isAjaxRequest always return false -

i got error message 404,'model has not been saved' following code my action controller public function actionextend($id) { $model=$this->loadmodel($id); if(yii::app()->request->isajaxrequest) { $model->todate = date('y-m-d h:i:s a',(strtotime('next month',strtotime(date('y-01-d'))))); if($model->save()) { yii::app()->end(); } else { throw new chttpexception(404,'model has not been saved'); } } } the jquery call $("#buttonextend<?php echo $this->post_row;?>").click(function(e){ $.ajax({ type: "post", url: "<?php echo yii::app()->createurl('post/extend', array('id' => $data['id'])); ?>", }); }); why not ajax call ? thank help i found response, missed } , function ...
Read more