Quotes in my Replace

igarrett

Alright, I'm newish to php, I've done some echoing in my short time, to general success, but now I'm completely baffled and can't seem to the find the answer or correct syntax for what i'm trying to do.

I am replacing text in a string... er, or trying to, but the text I'm trying to replace has multiple quotes in it. The back story is that I'm running word press, which is syndicating a bunch of rss feeds into it's feed. This all works fine, except for google news feeds. Apparently google news feeds, when then don't have an image still carry an img tag, it's just 1px x 1px and has no src data.

So I've got the install set to create thumbnails of the first photo in each post, which works great until it hits this img tag and creates a thumbnail of the non-image.

My options seem to be to find a way to have it ignore this one type of tag, OR replace the tag in the database with an empty space. The later option seems easier, since it should just be a replace string. I want to put it in the footer php and then it runs it every time the page is visited so I don't have to. i figure it's so specific a tag that this should be fine.

So here is my replace strong where i'm getting the error, i've tried multiple variations on the quotation marks and escaping the quotes, but i keep getting a T_String parse error....:

<?php
$con = mysql_connect('server','igarrett','pass');

mysql_select_db('dbnamet', $con);


UPDATE wp_posts SET post_content = replace('post_content','<img alt="" height="1" width="1">',' ');

	 mysql_close($con)
  ?>

thoughts? THANKS!

laserlight

It looks like you forgot to actually put the SQL statement in a PHP string and run it:

<?php
$con = mysql_connect('server', 'igarrett', 'pass');

mysql_select_db('dbnamet', $con);

$subject = 'post_content';
$search = '<img alt="" height="1" width="1">';
$sql = "UPDATE wp_posts SET post_content = replace('$subject', '$search', ' ')";
mysql_query($sql);

mysql_close($con);
?>

That said, instead of the MySQL extension, I suggest that you use the PDO extension or the MySQLi extension.

igarrett

Thanks Laserlight!

So I tried this. It all looks like it should work to me, but this actually replaced the content of every field with "post_content" as opposed to finding the ... which was fun... so it almost worked. I did back up before I started this, so nothing lost, nothing gained.

Any thoughts as to why that statement did a complete replace of the field with the name of the field as opposed to the search and replace? could be my mistake.

If you think it would be better to go down another road, I'm all for that. Could you give me some direction on those means to get to my ends?

Thanks again!

laserlight

igarrett wrote:
Any thoughts as to why that statement did a complete replace of the field with the name of the field as opposed to the search and replace?

Because you did not use MySQL's replace function correctly 😉

Checking the MySQL documentation, you probably want to write this instead:

$search = '<img alt="" height="1" width="1">';
$sql = "UPDATE wp_posts SET post_content = replace(post_content, '$search', ' ')";

Your original example has "post_content" as a string instead of a column name.

igarrett

Laserlight,

you're brilliant, thanks so much for your help... I know I should have been able to figure this out, but thanks for taking the time to help me realize what I was doing wrong. This makes too much sense now 🙂

-ian-

laserlight

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.