Jump to content

ACBMSE

New Members
  • Posts

    3
  • Joined

  • Last visited

Posts posted by ACBMSE

  1. 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.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.