Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Simple table query syntax error?
- <?php
- session_start();
- $_SESSION['sessionemail'] = $_POST['email'];
- $_SESSION['sessionpassword'] = $_POST['password'];
- $_SESSION['authuser'] = 0;
- $dbhost = 'somewhere.com';
- $dbuser = 'user';
- $dbpass = 'pw';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
- $dbname = 'medreunten_db1';
- mysql_select_db($dbname) or die(mysql_error($conn));
- $query = 'SELECT
- name, smacker, surname, sex, age, nationality, email
- FROM
- employee
- WHERE
- email = ' . $_POST['email'];
- $result = mysql_query($query, $conn) or die (mysql_error($conn));
- extract(mysql_fetch_assoc($result));
- while ($row = mysql_fetch_array($result)) {
- echo $row['name'];
- echo $row['surname'];
- echo $row['age'];
- }
- ?>
- $email = mysql_real_escape_string($_POST['email']);
- $query = "
- SELECT name, smacker, surname, sex, age, nationality, email
- FROM employee
- WHERE email = '$email'
- ";
- <?php
- session_start();
- $_SESSION['sessionemail'] = $_POST['email'];
- $_SESSION['sessionpassword'] = $_POST['password'];
- $_SESSION['authuser'] = 0;
- $dbhost = 'dedi147.cpt2.host-h.net';
- $dbuser = 'medreunten_1';
- $dbpass = 'AGqrVrs8';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
- $dbname = 'medreunten_db1';
- mysql_select_db($dbname) or die(mysql_error($conn));
- $query = "SELECT name, smacker, surname, sex, age, nationality, email FROM employee WHERE email = '" . $_POST['email']."'";
- $result = mysql_query($query, $conn) or die (mysql_error($conn));
- extract(mysql_fetch_assoc($result));
- while ($row = mysql_fetch_array($result)) {
- echo $row['name'];
- echo $row['surname'];
- echo $row['age'];
- }
- ?>
Add Comment
Please, Sign In to add comment