<?php
/*Datos de conexion a la base de datos*/
$db_host = "localhost";
$db_user = "root";
$db_pass = "root";
$db_name = "MCC_02_2018";


$conexion = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

if(mysqli_connect_errno()){
echo 'No se pudo conectar a la base de datos : '.mysqli_connect_error();
}
?>

CREATE TABLE `posts` (
`p_id` int(4) NOT NULL,
`nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`titulo` varchar(150) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`entradilla` varchar(250) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`articulo` varchar(2000) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`fecha` date NOT NULL,
`year` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `posts`
 ADD PRIMARY KEY (`p_id`);

$mostrar_post = "SELECT TOP 1 * FROM posts ORDER BY p_id DESC";
$result = $conexion->query($mostrar_post);
if($result){
if($result->mysqli_num_rows > 0) {
while($row = $result->fetch_assoc()){
echo "$row[titulo]";
}
}else {
 echo ("No hay datos");
 }
 }else{
 echo("Error en la base de datos");
}