[RESOLVED] Get Page Contents (ahhh)

[kikki]

Hi guys,
I'm trying to get "page contents from links" and insert that into database(auto process). I've tried the following way, but it doesn't seems to be working, I guess the file() function doesn't grab the contents on time when mysql is requesting it or something. I'm sure there are many other clean ways to do trick, but this is the way I've tried.. Please take a look at the code, you'll understand better what I'm saying..

problem: It gets the contents, but doesn't update the mysql row after that.. but it updates the field without the "grabbed website contents", please lend me a hand on this one. 🙂

TIA

<?php
//connect to db
//Mysql select the link and id from mylinks bla bla bla.. limit 0,1 to TEST..

//list the links
    while($row = mysql_fetch_array($result))
    {
        list($ID, $Link) = $row; 

//get the content
$count = file($Link);
$Contents = '';
foreach ($count as $line_num => $line)
{
$Contents = $Contents . $line;
}

$Contents = cleanHTML($Source);

}

//update a row with contetns
$query = mysql_query("UPDATE mylinks SET `pagecontents` = '$Contents' WHERE `id` = '$ID'");
echo 'Content Updated For ' . $Link . '<br>';


?>

[matt72]

What you're trying to add to the database probably needs to be 'escaped'.

Have a try with something like this:

//connect to db 
//Mysql select the link and id from mylinks bla bla bla.. limit 0,1 to TEST.. 

//list the links 
    while($row = mysql_fetch_array($result)) 
    { 
        list($ID, $Link) = $row; 

//get the content - the quick way
$Contents = file_get_contents($Link);

$Contents = cleanHTML($Contents); // Source is meant to be Contents, right?

// Strip the slashes if magic quotes is on
if (get_magic_quotes_gpc()) 
{
$Contents = stripslashes($Contents);
}
// Escape the string
$Contents = mysql_real_escape_string($Contents);
} 

//update a row with contetns 
$query = mysql_query("UPDATE mylinks SET `pagecontents` = '$Contents' WHERE `id` = '$ID'"); 
echo 'Content Updated For ' . $Link . '<br>'; 

[matt72]

By the way, you can find out if there's a problem with your query & mysql by using

$query = mysql_query("Your query");
if(!$query)
{
echo mysql_error();
}

[kikki]

amazing matt72,
thats it.. the problem is solved.. I think the problem was escape the string, just like you said..
Thank you v-much, really appreciate it 🙂

[bradgrafelman]

Don't forget to mark this thread resolved.

[kikki]

sure thing bradgrafelman.. 🙂