CODEWITHSUNDEEP
phpmysqlphpfox
Vijay
Vijay

Reputation: 13

Replace forward to back slash in query string

MySql Code 

SELECT replace(replace(v.image_path,"\\","/"),"%s","_120") as image_path
FROM `artistkr_fox`.`phpfox_video` v;

My phpfox service file query string

$aVideos = $this->database()->select("REPLACE(REPLACE(v.image_path,'\','/'),'%s','_120') as image_path" . Phpfox::getUserField()) ->from($this->_sTable, 'v') ->execute('getSlaveRows');

This query can't return any value

error throw in this code "REPLACE(v.image_path,'\','/')"

Upvotes: 0

Views: 860

Answers (1)

Veger
Veger

Reputation: 37915

You need to make sure you are not mixing the quotes of the PHP string and your SQL query.

You can do this by either by escaping them using backslashes in front of your quote (\')

$query = 'SELECT replace(replace(v.image_path,"\\","/"),\'%s\',\'_120\') as image_path FROM artistkr_fox.phpfox_video v';

or by using double quotes (") for the PHP string and single quotes (') for your SQL query:

$query = "SELECT replace(replace(v.image_path,'\\\\','/'),'%s','_120') as image_path FROM artistkr_fox.phpfox_video v";

(Note when using double quotes for the PHP string, you need to escape the backslashes in y our SQL query)

Which one you choose depends on your preference and the situation (e.g. complexity of the query).

Upvotes: 1

Related Questions