包含php数组键的mysql查询？ 即。 “WHERE profession = $ user ['profession']”

Question

How do i deal with something like this:

"SELECT skills FROM jobs WHERE profession = $user['profession']"

where profession is a string...

Answer 1

Just use

"SELECT skills FROM jobs WHERE profession = '{$user['profession']}'"

PHP allows you to mix quotation marks like that

Note Assuming all the security checks and validations are done before this bit