Re: Input Query string from a file

[Peter Brawley]

$result = mysqli_query ($dbLink, 'SELECT fname, lname FROM ticket_tbl WHERE lname = $qfile ') ;

To get variable values to substitute for their names inside PHP strings, PHP needs double quotes round the strings. Read about strings and variables in the PHP manual.

SQL needs quotes round string values like $gfile.

So the query string needs to be:

"SELECT fname, lname FROM ticket_tbl WHERE lname = '$qfile' "

or

"SELECT fname, lname FROM ticket_tbl WHERE lname = \"$qfile\" "

(About the second alternative, read about the escape character in the PHP manual.)

But $gfile is a file name, not a person's name, so I can't make sense of that query.