lundi 2 février 2015

SQL Selecting Data with WHERE “. $variable .”


My question is:

I have an issue with my code (SELECTING data from MySql)

This is my code:



<?php $user_name = $_SESSION['user_name']; $user_email = $_SESSION['user_email'];
echo $user_email;
$con = mysqli_connect("localhost", "root", "", "minehelp");
$id_query = mysqli_query($con, "SELECT user_name FROM users_en WHERE user_name = '" .
$user_name . "' OR user_email = '" . $user_email . "';");
while ($row_id_query = mysqli_fetch_assoc($id_query)){
print($row_id_query['user_name']); } ?>




I want to select data WHERE the "user_name is $user_name" This is login system, that means the $_SESSION'user_name' is part of my code and i can't remake it.



Thanks for every answer,

Jakubk-0





Aucun commentaire:

Enregistrer un commentaire