stebuklas Posted October 21, 2006 Share Posted October 21, 2006 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? Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/ Share on other sites More sharing options...
stebuklas Posted October 22, 2006 Author Share Posted October 22, 2006 Nobody know? Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/#findComment-112606 Share on other sites More sharing options...
LazyJones Posted October 22, 2006 Share Posted October 22, 2006 The problem is not in the pattern, it's somewhere else (SQL syntax maybe......) Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/#findComment-112609 Share on other sites More sharing options...
stebuklas Posted October 22, 2006 Author Share Posted October 22, 2006 [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 Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/#findComment-112613 Share on other sites More sharing options...
stebuklas Posted October 22, 2006 Author Share Posted October 22, 2006 btw... when I try to make output in window.. Then It puts all file, not a links what I need.... Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/#findComment-112614 Share on other sites More sharing options...
JasonLewis Posted October 22, 2006 Share Posted October 22, 2006 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. Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/#findComment-112642 Share on other sites More sharing options...
stebuklas Posted October 22, 2006 Author Share Posted October 22, 2006 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... Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/#findComment-112688 Share on other sites More sharing options...
stebuklas Posted October 23, 2006 Author Share Posted October 23, 2006 please, somebody help me :) Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/#findComment-113063 Share on other sites More sharing options...
JasonLewis Posted October 25, 2006 Share Posted October 25, 2006 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. Link to comment https://forums.phpfreaks.com/topic/24663-problem-with-pattern-in-preg_match_all/#findComment-114102 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.