Jump to content

Archived

This topic is now archived and is closed to further replies.

stebuklas

problem with pattern in preg_match_all()

Recommended Posts

Hi, I'm trying to take all links from the file with this pattern: $pattern = "/<li class=\"first\">(.*)<\/li>/"; and then when I launch site they put an error: 'You have an error in your SQL syntax near 't get the results you expected?'


Maybe someone can help me? what's wrong with it?

Share this post


Link to post
Share on other sites
[code]$pattern = "/<li class=\"first\">(.*)<\/li>/";
preg_match_all($pattern, $fd, $matches);
// ..............
foreach($matches[1] as $num => $bu){
      $new_link_insert = "INSERT INTO linkai (linkai) VALUES('$bu')";
mysql_query($new_link_insert,$db_connection) or die (mysql_error());
}
[/code]
I think pattern :) But maybe is smth with SQL

Share this post


Link to post
Share on other sites
btw... when I try to make output in window.. Then It puts all file, not a links what I need....

Share this post


Link to post
Share on other sites
try going like this:
[code=php:0]new_link_insert = "INSERT INTO linkai (linkai) VALUES('".addslashes($bu)."')";[/code]
mysql dosnt like '. so when you add slashes words like don't become don\'t. I think this should solve your problem.

Share this post


Link to post
Share on other sites
Thanks, it's working correctly, but... Like I sayed it not take all links from file, but he shows all file... I think you understand me...

Share this post


Link to post
Share on other sites
whats exactly wrong with it now? it isnt grabbing all the links from the text file. well if it isnt doing that smething is wrong with your pattern.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.