Osvaldo posted

Using a variable in the WHERE Clause

I am using PHP with MySQL database. i need to how to pass the value from PHP to Where Clause.

How to use a variable in the WHERE Clause with PHP ?

select statement with where clause which getting value from PHP
treat SQL statement as string and append the value from PHP as needed for example :


$student_fname='Mike';
$select="select * from student where `first_name`='".$student_fname."'";
mysqli_query($select);

above query will find the student who have name is "Mike"

Post Answer

OMG! You need to Login / Register to Post Answer

[code] Bold LE LP LD LW LDR WAR INF DAN SUC FYI h2 h3 italic