<?php
$rowsPerPage =2;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$link = mysqli_connect( "localhost", "root", "password" ) or die(mysqli_error($link));
mysqli_query("SET names 'UTF8' ");
mysqli_select_db( "test" );
$sql = ("SELECT * FROM news ORDER BY id DESC ");
$sql .= ("LIMIT $offset, $rowsPerPage");
if ( $search != "" )
{
$sql = $sql . " WHERE subject LIKE '%$search%' OR description LIKE '%$search%' ";
}
$result = mysqli_query( $sql, $link) or die ("Error Query [".$sql."]");
while ($line = mysqli_fetch_array($result, MYSQL_ASSOC)) {
?>
This website show the below error message,
Warning: mysqli_query() expects at least 2 parameters, 1 given in C: on line 20
mysqli_query("SET names 'UTF8' ");
Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C: on line 21
mysqli_select_db( "test" );
Warning: mysqli_query() expects parameter 1 to be mysqli, string given in C:p on line 28
$result = mysqli_query( $sql, $link) or die ("Error Query [".$sql."]");
Error Query [SELECT * FROM news ORDER BY id DESC LIMIT 0, 2]
After I used the search function, This website show the below error message,
Warning: mysqli_query() expects at least 2 parameters, 1 given in C: on line 20
mysqli_query("SET names 'UTF8' ");
Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C: on line 21
mysqli_select_db( "test" );
Warning: mysqli_query() expects parameter 1 to be mysqli, string given in C:p on line 28
$result = mysqli_query( $sql, $link) or die ("Error Query [".$sql."]");
Error Query [SELECT * FROM news ORDER BY id DESC LIMIT 0, 2 WHERE subject LIKE '%%' OR description LIKE '%%' ]
I want my website, the news, order by id DESC, have limit page and Search function. Only 2 of 3 functions could work.