Jump to content

NathanSenn

New Members
  • Posts

    3
  • Joined

  • Last visited

NathanSenn's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. This is my new code still not adding anything to the DB <?php $linksav = mysql_connect($db['host'], $db['user'], $db['passwd']); $mysqldb = mysql_select_db('yousearc_YouSearch'); if (!$linksav) { die('Could not connect: ' . mysql_error()); } if (!$mysqldb) { die('Could not connect: ' . mysql_error()); } $sqlk = "SELECT url FROM bx_sites_main WHERE url = '{$link['link']}'"; $duperaw = mysql_query($sqlk); if (mysql_num_rows($duberaw) > 0) { echo "already exists DB"; } else { $html = file_get_contents_curl($link['link']); //parsing begins here: $doc = new DOMDocument(); @$doc->loadHTML($html); $nodes = $doc->getElementsByTagName('title'); //get and display what you need: $title = $nodes->item(0)->nodeValue; $metas = $doc->getElementsByTagName('meta'); for ($i = 0; $i < $metas->length; $i++) { $meta = $metas->item($i); if($meta->getAttribute('name') == 'description') $description = $meta->getAttribute('content'); if($meta->getAttribute('name') == 'keywords') $keywords = $meta->getAttribute('content'); } $sql = "INSERT INTO bx_sites_main (url, title, entryUri, description, allowView, allowComments, allowRate, tags) VALUES ('{$link['link']}, $title, $title.date(DATE_ATOM, mktime(0, 0, 0, 7, 1, 2000), $description, 3, 3, 3, $keywords')"; $addlink = mysql_query($sql); }
  2. Its not making my page quit working now but its not adding anything to the DB This is my Table in my database And this is the updated script <?php $linksav = mysql_connect($db['host'], $db['user'], $db['passwd']); if (!$linksav) { die('Could not connect: ' . mysql_error()); } $duperaw = mysql_query("SELECT * FROM bx_sites_main WHERE (url) = ('{$link['link']}')"); if (mysql_num_rows($duberaw) > 0) { echo "already exists DB"; } else { $sql = "INSERT INTO bx_sites_main (url) VALUES ('{$link['link']}')"; if (mysql_query($sql)) echo "Data Inserted"; } mysql_close($linksav); ?>
  3. Not sure what im doing wrong here if i take this line out everything works again mysql_query($linksav,"INSERT INTO bx_sites_main (URL) VALUES ('$link['link']')"); This is a little more of the script <?php $linksav = mysql_connect($db['host'], $db['user'], $db['passwd']); if (!$linksav) { die('Could not connect: ' . mysql_error()); } $duperaw = mysql_query("SELECT * FROM bx_sites_main", $link['link']); if (mysql_num_rows($duberaw) > 0) { echo "already exists DB"; } else { mysql_query($linksav,"INSERT INTO bx_sites_main (URL) VALUES ('$link['link']')"); echo "1 record added"; } mysql_close($linksav); ?>
×
×
  • Create New...

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.