Advertisement
Guest User

Untitled

a guest
Mar 16th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. $row = mysql_fetch_assoc($query);
  2. $dbactive = $row['active'];
  3.  
  4. if ($dbactive == 1){
  5.  
  6. ...
  7.  
  8. }...
  9.  
  10. // don't use $mysqli->prepare here
  11. $query = "SELECT TeacherForename, TeacherSurname, TeacherUsername, TeacherPassword, Active FROM Teacher WHERE TeacherUsername = ? AND TeacherPassword = ? LIMIT 1";
  12. // prepare query
  13. $stmt=$mysqli->prepare($query);
  14. // You only need to call bind_param once
  15. $stmt->bind_param("ss",$teacherusername,$teacherpassword);
  16. // execute query
  17. $stmt->execute();
  18. // get result and assign variables (prefix with db)
  19. $stmt->bind_result($dbTeacherForename,$dbTeacherSurname,$dbTeacherUsername,$dbTeacherPassword, $dbActive);
  20.  
  21. while($stmt->fetch()) {
  22.  
  23. if ($teacherusername == $dbTeacherUsername && $teacherpassword == $dbTeacherPassword) {
  24. if ($dbActive == 1){
  25.  
  26. $loggedIn = true;
  27. }
  28. }
  29.  
  30. }
  31.  
  32. $dbactive = $stmt['active'];
  33.  
  34. $result = $myslqi->query($query);
  35. while($row = $result->fetch_object()){
  36. $row->active …
  37. }
  38.  
  39. if($query = $db->prepare("your sql query where field1=? AND field2=?")){
  40.  
  41. $query->bind_param('ss', $user_id);
  42. $query->execute();
  43. $query->bind_result($field1, $field2);
  44. $query->fetch();
  45. echo $field1;
  46.  
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement