include("databaseconnection.php");?>
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
//Page
if(isset($_GET['page']))
{
$page=$_GET['page'];
}
else
{
$page=0;
}
?>
Blogs
$offset=$page*10;
if(isset($_GET['q'])){
$q=$_GET['q'];
$sql="SELECT * from blog where name LIKE '%$q%' OR text LIKE '%$q%' ORDER BY id DESC LIMIT 10 OFFSET $offset";
}else{
$sql="SELECT * from blog ORDER BY id DESC LIMIT 10 OFFSET $offset";
}
$result=$conn->query($sql);
if ($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$id=$row['id'];
$name=$row['name'];
$text=$row['text'];
$datetime=$row['date'];
echo '
'.$name.'
'.substr($text,0,200).'';
}
}
?>