sql字符串中的php变量 [英] php variable in sql string

问题描述

要求文件中包含多个查询标记。


根据用户输入，选择一个字符串。一切顺利

顺利进行，直到我想在字符串中输入变量。如果我

把字符串放在程序中工作正常，但是，如果我使用来自require文件的字符串我

似乎无法插入字符串。


$ cccb_id是sting .....插入$ query4并根据用户输入改变

。


$ query4 =" ;选择cccb.cccb_name作为''cccb''，CONCAT（member_fname，''

''，member_lname）作为''member''来自member_cccb_lnk加入成员

（member.member_no = member_cccb_lnk.member_no）加入cccb

member_cccb_lnk.cccb_id = cccb.cccb_id和cccb.cccb_id =" $ cccb_id"

按会员排序" ;;


输出为：选择cccb.cccb_name为''cccb''，CONCAT（member_fname，''

''，member_lname）为''member' 'from member_cccb_lnk加入会员

（member.member_no = member_cccb_lnk.member_no）加入cccb

member_cccb_lnk.cccb_id = cccb.cccb_id和cccb.cccb_id = order by

memberError 1 064

你可以看到
，$ cccb_id不在查询字符串中。


任何帮助将不胜感激。

Have require file with several query stings in it.

Depending on user input one of strings is selected. Everything going
along smoothly until I wanted to also input a variable in string. If I
put string in program works ok, but, if I use string from require file I
can not seem to insert string.

$cccb_id is sting..... to be inserted into $query4 and changes depending
on user input.

$query4 = "select cccb.cccb_name as ''cccb'', CONCAT(member_fname,''
'',member_lname) as ''member'' from member_cccb_lnk join member on
(member.member_no = member_cccb_lnk.member_no) join cccb on
member_cccb_lnk.cccb_id = cccb.cccb_id and cccb.cccb_id = "$cccb_id"
order by member";

output is: select cccb.cccb_name as ''cccb'', CONCAT(member_fname,''
'',member_lname) as ''member'' from member_cccb_lnk join member on
(member.member_no = member_cccb_lnk.member_no) join cccb on
member_cccb_lnk.cccb_id = cccb.cccb_id and cccb.cccb_id = order by
memberError 1064

as you can see, "$cccb_id" is not in query string.

any help will be appreciated.

推荐答案

cccb_id是sting .. ...插入

cccb_id is sting..... to be inserted into

query4并根据用户输入改变

。

query4 and changes depending
on user input.

query4 ="选择cccb.cccb_name作为''cccb''，CONCAT（member_fname，''

''，member_lname）作为''member''来自
（member.member_no = member_cccb_lnk.member_no）加入cccb

member_cccb_lnk.cccb_id = cccb.cccb_id和cccb.cccb_id ="

query4 = "select cccb.cccb_name as ''cccb'', CONCAT(member_fname,''
'',member_lname) as ''member'' from member_cccb_lnk join member on
(member.member_no = member_cccb_lnk.member_no) join cccb on
member_cccb_lnk.cccb_id = cccb.cccb_id and cccb.cccb_id = "

这篇关于sql字符串中的php变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！