Grant instruction PHP script execute statement-CodePudding

Figure 1

Figure 2

Problem: execute the statement is no problem, figure 2 can normal results, but the figure a write something wrong or not which leaders help see

SQL='$UPDATE mac_vod
The SET vod_play_url="brother, the first"
WHERE vod_play_url ';
This is a error figure

I want to perform is to [brother replace the first]
UPDATE mac_vod SET vod_play_url=replace (vod_play_url, 'brother', 'the first')
Want to statements in PHP execution timing task graph one red square part need to modify the part of the

CodePudding user response:

Vod_play_url the what?

This appeared to be an appropriate where clause for? If is a variable, double quotes with $