Guest User

Untitled

a guest
Aug 22nd, 2018
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.64 KB | None | 0 0
  1. Simple table query syntax error?
  2. <?php
  3. session_start();
  4. $_SESSION['sessionemail'] = $_POST['email'];
  5. $_SESSION['sessionpassword'] = $_POST['password'];
  6. $_SESSION['authuser'] = 0;
  7.  
  8. $dbhost = 'somewhere.com';
  9. $dbuser = 'user';
  10. $dbpass = 'pw';
  11.  
  12. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  13.  
  14. $dbname = 'medreunten_db1';
  15. mysql_select_db($dbname) or die(mysql_error($conn));
  16.  
  17.  
  18. $query = 'SELECT
  19. name, smacker, surname, sex, age, nationality, email
  20. FROM
  21. employee
  22. WHERE
  23. email = ' . $_POST['email'];
  24. $result = mysql_query($query, $conn) or die (mysql_error($conn));
  25. extract(mysql_fetch_assoc($result));
  26.  
  27.  
  28. while ($row = mysql_fetch_array($result)) {
  29. echo $row['name'];
  30. echo $row['surname'];
  31. echo $row['age'];
  32. }
  33. ?>
  34.  
  35. $email = mysql_real_escape_string($_POST['email']);
  36.  
  37. $query = "
  38. SELECT name, smacker, surname, sex, age, nationality, email
  39. FROM employee
  40. WHERE email = '$email'
  41. ";
  42.  
  43. <?php
  44. session_start();
  45. $_SESSION['sessionemail'] = $_POST['email'];
  46. $_SESSION['sessionpassword'] = $_POST['password'];
  47. $_SESSION['authuser'] = 0;
  48.  
  49. $dbhost = 'dedi147.cpt2.host-h.net';
  50. $dbuser = 'medreunten_1';
  51. $dbpass = 'AGqrVrs8';
  52.  
  53. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  54.  
  55. $dbname = 'medreunten_db1';
  56. mysql_select_db($dbname) or die(mysql_error($conn));
  57.  
  58.  
  59. $query = "SELECT name, smacker, surname, sex, age, nationality, email FROM employee WHERE email = '" . $_POST['email']."'";
  60. $result = mysql_query($query, $conn) or die (mysql_error($conn));
  61. extract(mysql_fetch_assoc($result));
  62.  
  63.  
  64. while ($row = mysql_fetch_array($result)) {
  65. echo $row['name'];
  66. echo $row['surname'];
  67. echo $row['age'];
  68. }
  69. ?>
Add Comment
Please, Sign In to add comment