$company_id = $_SESSION['compid'];
$sql="SELECT * FROM `movies` WHERE companyID = ? AND name LIKE '%$search%' OR description LIKE '%$search%' " ;
$stmt=mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($stmt,$sql)) {
header("location:main.php?error=stmt failed");
exit();
}
mysqli_stmt_bind_param($stmt,"i", $company_id);
mysqli_stmt_execute($stmt);
$result = $stmt->get_result();
Uperdominator 0 Newbie Poster
rproffitt 2,588 "Nothing to see here." Moderator
Let me share how I work such an issue. I open out a command line to MySQL and test my queries against the non-production table to see if my query is valid.
Back to PHP, I echo or dump vars along the way to see what is going on. Read https://www.php.net/manual/en/debugger.php
If it fails in MySQL I check it's error log. Read https://dev.mysql.com/doc/refman/8.0/en/error-log.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.