I'm new to coding and prepared statements.
I'm getting:
"Fatal error: Call to a member function bind_param() on a non-object in /home/content/01/3251001/html/Manage-Users/acc-files/updateRecord.php on line 17"
For this:
<?php
include "db_connect.php";
if(isset($_POST['UserID'])){
$stmt = $con -> prepare('UPDATE UserList
SET Status = ?,
FirstName = ?,
LastName = ?,
Username = ?,
Email = ?,
Department = ?,
Manager = ?,
WHERE UserID = ?');
$stmt -> bind_param('isssssss', /* Line 17 */
$_POST['Status'],
$_POST['FirstName'],
$_POST['LastName'],
$_POST['Username'],
$_POST['Email'],
$_POST['Department'],
$_POST['Manager'],
$_POST['UserID']);
$stmt->execute();
}
Thank you in advance for helping.