Update Keyword Mod

[inspireme]

The tag feature is cool, but if you import information to your database you often dont have keywords for the listings.

copy the code below and save it as "getkeywords.php" and then run it in your web browser to populate all entries with empty keywords in your directory. Zubby helped me with this a few months back and i thought i would add it here for others to take advantage of

<?

include "application.php";

$sql = "select link_id, url from idx_link where keywords = ''";
$rs = $dbConn->Execute($sql);
while ($row = $rs->FetchRow()) {
  echo "$row[url]<br />";
  flush();
  $content = HttpRequest($row["url"]);
  preg_match_all('/<[\s]*meta[\s]*name="?' . '([^>"]*)"?[\s]*' . 'content="?([^>"]*)"?[\s]*[\/]?[\s]*>/si', $content['html'], $match);
  for ($i = 0; $i < count($match[1]); $i++) {
    if (strtolower($match[1][$i]) == "keywords") {
      $keywords = trim(strip_tags($match[2][$i]));
      if ($keywords != '') {
        $keywords = addslashes($keywords);
        $sql = "update idx_link set keywords = '$keywords' where link_id = '$row[link_id]'";
        echo $sql . "<hr />";
        $dbConn->Execute($sql);
        flush();
      }
    }
  }
}
echo "Done.";

?>

[FSGDAG]

Thanks for sharing this Insprireme!!!

[inspireme]

no problem you need 5.4 for it to work, forgot to mention that.

[griller111]

inspireme if I changed all references from "keywords" to "description" would this harvest meta description tags from url's that don't have any description added in database? same as it does for keywords.

[inspireme]

should do, meta descriptions are usually pretty junk though.

[DGTALGOODIES]

TY works good

[kleinhev]

I ran the script and was suprised that it finished after updating only a couple of links. In my database, most links with missing tags keywords are NULL.

Therefore, shouldn't:

$sql = "select link_id, url from idx_link where keywords = ''";

rather be:

$sql = "select link_id, url from idx_link where keywords IS NULL";

?

[Bruceper]

Or perhaps this would work?

$sql = "select link_id, url from idx_link where keywords = ''NULL";

This script is used a lot by users that are uploading their own database, and typically the field keywords is blank. Of course you can change it to work for your own situation.

[inspireme]

NULL and '' are completely different, most situations will mean that your database will have keywords as '' if its blank. Looks like you imported, or have a non standard setup, jsut change the query as posted above for your situation.