beginTrans(); $pdo = $trans->getPDO(); $stmt = $pdo->prepare('SELECT article_id, title, htmltitle, subtitle, adtext, ad_width, image_url, image_alt, meta_keywords, meta_description FROM article WHERE path_text = ?'); $stmt->bindValue(1, $path); $stmt->execute(); if ($myrow = $stmt->fetch(PDO::FETCH_NUM)) { $aid = $myrow[0]; $title = $myrow[1]; $htmltitle = $myrow[2]; $subtitle = $myrow[3]; $adtext = $myrow[4]; $adwidth = $myrow[5]; $imageurl = $myrow[6]; $imagealt = $myrow[7]; $metakeywords = $myrow[8]; $metadescription = $myrow[9]; } else is404(); ?> <?= $htmltitle ?> '; if ($metakeywords) echo ''; ?>

prepare('SELECT content, tag, paragraph_id FROM paragraph WHERE article_id = ? ORDER BY paragraph_id ASC'); $stmt->bindValue(1, $aid); $stmt->execute(); while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) { if ($count++ == 9 && $adtext) $body .= '
'. $adtext .'
'. "\r\n"; $body .= '<'. $myrow[1] .'>'. $myrow[0] .'' ."\r\n"; } $links = ''; $latest = ''; $stmt = $pdo->prepare('SELECT path_text, title, article_id, SUBSTRING(blurb, 1, 84), sm_image_url, image_alt FROM article WHERE status = \'A\' AND article_id != ? ORDER BY article_id DESC LIMIT 5'); $stmt->bindValue(1, $aid); $stmt->execute(); while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) { if (!$latest) $latest = ''. $myrow[1] .''. "\r\n"; if ($myrow[4]) $links .= '
  • '. $myrow[5] .''; $blurb = $myrow[3]; $links .= ''. $myrow[1] .''. substr($blurb, 0, strrpos($blurb, ' ')) ."...
  • \r\n"; } ?>
    '. "\r\n"; ?>

    Latest Article at 10Spot.net:

    prepare('INSERT INTO referer (url, searchval, article_id, hit_date) VALUES (?, ?, ?, CURRENT_TIMESTAMP)'); $stmt->bindValue(1, $referer); $stmt->bindValue(2, $searchval); $stmt->bindValue(3, $aid); $stmt->execute(); } $useragent = strtolower($_SERVER['HTTP_USER_AGENT']); if (strpos($useragent, 'googlebot') || strpos($useragent, 'slurp') || strpos($useragent, 'msnbot')) { $stmt = $pdo->prepare('INSERT INTO referer (url, article_id, hit_date) VALUES (?, ?, CURRENT_TIMESTAMP)'); $stmt->bindValue(1, $useragent); $stmt->bindValue(1, $aid); $stmt->execute(); } $trans->commit(true); } catch (Exception $e) { if ($trans) $trans->rollback(); } } else is404(); ?>