'; include('includes/page_start.php'); ?> 'SET NAMES utf8' ) ); //the default error mode for PDO is PDO::ERRMODE_SILENT so lets change that to see errors $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); $query = 'SELECT ID, DATE_FORMAT(PUBLISH_DATE,"%d %b %Y") as date, HITS, HEADLINE, SECOND_HEADLINE, NEW_FULL, FRIENDLY_URL, PICTURE, AUTHOR, TAGS, FACEBOOK_OPEN_GRAPH_TAGS_AND_TWITTER_CARDS FROM news WHERE FRIENDLY_URL ="saison-2018-endet-mit-einem-sieg.html" ORDER BY ID LIMIT 1'; #echo $query; $stmt = $conn->prepare( $query ); $stmt->execute(); $count = $stmt->rowCount(); while( $row = $stmt->fetch() ) { $ID = $row['ID']; $date = $row['date']; $HEADLINE = $row['HEADLINE']; $SECOND_HEADLINE = $row['SECOND_HEADLINE']; $NEW_FULL = $row['NEW_FULL']; $FRIENDLY_URL = $row['FRIENDLY_URL']; $PICTURE = $row['PICTURE']; $AUTHOR = $row['AUTHOR']; $TAGS = $row['TAGS']; $FACEBOOK_OPEN_GRAPH_TAGS_AND_TWITTER_CARDS = $row['FACEBOOK_OPEN_GRAPH_TAGS_AND_TWITTER_CARDS']; $HITS = $row['HITS']; } #Update hits $new_hits = ++$HITS; $update_hits = 'UPDATE news SET `HITS` = ' . $new_hits . ' WHERE `news`.`ID` = "'. $ID .'" LIMIT 1'; $stmt = $conn->prepare( $update_hits ); $stmt->execute(); } catch( PDOException $e ) { echo 'ERROR: ' . $e->getMessage(); } ?>
'.$date.'
'. $count .' Comments
'.$HITS.' Views
'.$HEADLINE.'
'.$SECOND_HEADLINE.'
'.$AUTHOR.'
-
'.$date.'
'.$NEW_FULL.'
'; hashtags($TAGS); echo '
'; ?>
.')