Skip to content

Instantly share code, notes, and snippets.

@sebbdk
Last active August 29, 2015 14:02
Show Gist options
  • Select an option

  • Save sebbdk/3b9f43850a1f10b0a459 to your computer and use it in GitHub Desktop.

Select an option

Save sebbdk/3b9f43850a1f10b0a459 to your computer and use it in GitHub Desktop.
Henrik code
foreach ($artikler as $row) {
$link = htmlspecialchars($row['link']);
$titel = $row['title'];
$date = $row['date'];
$author = $row['rss_title'];
$findlinkQry = "SELECT * FROM rss_artikler WHERE link = '$link'";
$result = mysql_query($findlinkQry) or die(mysql_error());
if(mysql_num_rows($result) === 0) {//if the link does not exist, add it, then find it
$saveQuery = "INSERT INTO rss_artikler VALUES($titel', '$date', '$author', '$link', 1)";
$saveSuccess mysql_query($saveQuery);
var_dump($saveQuery);
$result = mysql_query($findlinkQry) or die(mysql_error());
}
var_dump($result);
$rows = mysql_fetch_array($result);
echo '<article>';
$id = $rows['id'];
echo "<a href='updatecount.php?id=$id'>";
echo '<h4>' . $row['title'] . '&nbsp;';
echo '<span class="color3"> (' . date('H:i', strtotime($row['date'])) . ')</span><span class="color2">&nbsp;' . $row['rss_title'] . '</span></h4></a>';
echo '<hr>';
echo '</article>';
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment