{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 太酷不给撩 的问题《PHP issue: mysqli_error() expects exactly 1 parame》','https://www.manongdao.com/q-1198397.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I'm just working from some tutorials in a book, and I'm trying to put a 'Filter' option on my page. So when the page loads it should list all the values but if anything is selected from the dropdown list filter option then the list should change on the page. Here's my code:
<?php
require_once 'login.php';
$conn = new mysqli ($host, $user, $password, $database) or die("Connection Failed");
$col = 'Blue';
$sql = 'SELECT * FROM users ORDER BY user_creation_date desc';
$result = $conn->query($sql) or die(mysqli_error());
$columns = array('Blue', 'Pink', 'Yellow');
if (isset($_GET['column']) && in_array($_GET['column'], $columns)) {
$col = $_GET['column'];
// prepare the SQL query
$sql = "SELECT * FROM users
WHERE user_pref = $col";
// submit the query and capture the result
$result = $conn->query($sql) or die(mysqli_error());
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>Filter by User Pref</title>
</head>
<body>
<form id="form1" method="get" action="">
<label for="column">Order by:</label>
<select name="column" id="column">
<option <?php if ($col == 'Blue') echo 'selected'; ?>>Blue</option>
<option <?php if ($col == 'Pink') echo 'selected'; ?>>Pink</option>
<option <?php if ($col == 'Yellow') echo 'selected'; ?>>Yellow</option>
</select>
<input type="submit" name="change" id="change" value="Change">
</form>
<table>
<tr>
<th scope="col">User name</th>
<th scope="col">User pref</th>
<th> </th>
<th> </th>
</tr>
<?php while($row = $result ->fetch_assoc()) { ?>
<tr>
<td><?php echo $row['user_name']; ?></td>
<td><?php echo $row['user_pref']; ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>
The error I'm getting is
Warning: mysqli_error() expects exactly 1 parameter, 0 given on line 23.
This is line 23:
$result = $conn->query($sql) or die(mysqli_error());
You're mixing OOP and functional syntax.
should be:
As you can see on the manual http://php.net/manual/en/mysqli.error.php , you need to pass the connection to mysqli_error(), so that line should be