Fatal error: Call to a member function bind_param() on a non-object [closed]
<?php

function dbConnect($database) {
    $host = 'localhost';
    $db = $database;
    $user = 'blackri_leads';
    $pwd = '**HIDDEN**';

    $result = new mysqli($host, $user, $pwd, $db) ;
    if (!$result) die ('Could not connect to database');
    return $result;

} // End dbConnect

?>

<?php

                        include 'mysqli-connect-inc.php';

                        if(!empty($_POST['search-submit'])) {

                        $conn = dbConnect('blackri_leads');
                        $sql = "SELECT * FROM leads WHERE CONCAT_WS(' ', lead_fname, lead_lname)='" . $_POST['search'] . "'";
                        $result = $conn->query($sql);

                            while ($row = $result->fetch_assoc()){

                                $id             = $row['id'];
                                $date_submitted     = $row['date_submitted'];
                                $email_submitted    = $row['email_submitted'];
                                $ip_submitted       = $row['ip_submitted'];
                                $rep_name       = $row['rep_name'];
                                $date           = $row['date'];
                                $source         = $row['source'];
                                $lead_fname     = $row['lead_fname'];
                                $lead_lname     = $row['lead_lname'];
                                $home_number        = $row['home_number'];
                                $work_number        = $row['work_number'];
                                $cell_number        = $row['cell_number'];
                                $fax_number     = $row['fax_number'];
                                $work_email     = $row['work_email'];
                                $home_email     = $row['home_email'];
                                $secretary_name     = $row['secretary_name'];
                                $secretary_email    = $row['secretary_email'];
                                $account_title      = $row['account_title'];
                                $social         = $row['social'];
                                $tax_id         = $row['tax_id'];
                                $dob            = $row['dob'];
                                $home_address1      = $row['home_address1'];
                                $home_address2      = $row['home_address2'];
                                $home_city      = $row['home_city'];
                                $home_state     = $row['home_state'];
                                $home_zip       = $row['home_zip'];
                                $work_address1      = $row['work_address1'];
                                $work_address2      = $row['work_address2'];
                                $work_city      = $row['work_city'];
                                $work_state     = $row['work_state'];
                                $work_zip       = $row['work_zip'];
                                $employer_name      = $row['employer_name'];
                                $job_title      = $row['job_title'];
                                $years_employed     = $row['years_employed'];
                                $bank_reference     = $row['bank_reference'];
                                $aba_number     = $row['aba_number'];
                                $routing_number     = $row['routing_number'];
                                $dl_number      = $row['dl_number'];
                                $dl_state       = $row['dl_state'];
                                $dl_issue_date      = $row['dl_issue_date'];
                                $dl_exp_date        = $row['dl_exp_date'];
                                $joint_name     = $row['joint_name'];
                                $joint_social       = $row['joint_social'];
                                $joint_tax_id       = $row['joint_tax_id'];
                                $joint_dob      = $row['joint_dob'];
                                $joint_employer_name    = $row['joint_employer_name'];
                                $joint_job_title    = $row['joint_job_title'];
                                $joint_years_employed   = $row['joint_years_employed'];
                                $equity_exp     = $row['equity_exp'];
                                $margin_exp     = $row['margin_exp'];
                                $options_exp        = $row['options_exp'];
                                $ipo_exp        = $row['ipo_exp'];
                                $private_placement_exp  = $row['private_placement_exp'];
                                $mutual_fund_exp    = $row['mutual_fund_exp'];
                                $annual_income      = $row['annual_income'];
                                $net_worth      = $row['net_worth'];
                                $liquid_income      = $row['liquid_income'];
                                $beneficiary        = $row['beneficiary'];
                                $notes          = $row['notes'];

                            }
                        $conn->close();
                        }
                        ?>

<?php include_once('header.php'); ?>
<?php include_once('classes/check.class.php'); ?>
<?php protect("2"); ?>
<div id="container">

<div class="clear">
  <div class="col1">
    <img src="./images/logo.png" />
  </div>
  <div class="col2">
    <form id="main" action="index.php" method="POST">
    <label for="rep_name">Rep Name</label>
    <input type="text" id="rep_name" value="<?php echo $rep_name; ?>" name="rep_name" />

    <label for="date">Date</label>
    <input type="text" id="date" value="<?php echo $date; ?>" name="date" />

    <label for="source">Source</label>
    <input type="text" id="source" value="<?php echo $source; ?>" name="source" />

  </div>
</div>

<h3 class="section_title">Personal Info</h3>

  <div class="col1">
    <label for="lead_fname">First Name</label>
    <input type="text" id="lead_fname" value="<?php echo $lead_fname; ?>" name="lead_fname" />

    <label for="home_number">Home Number</label>
    <input type="text" id="home_number" value="<?php echo $home_number; ?>" name="home_number" />

    <label for="fax_number">Fax Number</label>
    <input type="text" id="fax_number" value="<?php echo $fax_number; ?>" name="fax_number" />

    <label for="work_email">Work Email</label>
    <input type="text" id="work_email" value="<?php echo $work_email; ?>" name="work_email" />

    <label for="home_email">Home Email</label>
    <input type="text" id="home_email" value="<?php echo $home_email; ?>" name="home_email" />

  </div>
  <div class="col2">

    <label for="lead_lname">Last Name</label>
    <input type="text" id="lead_lname" value="<?php echo $lead_lname; ?>" name="lead_lname" />

    <label for="work_number">Work Number</label>
    <input type="text" id="work_number" value="<?php echo $work_number; ?>" name="work_number" />

    <label for="cell_number">Cell Number</label>
    <input type="text" id="cell_number" value="<?php echo $cell_number; ?>" name="cell_number" />

    <label for="secretary_name">Secretary Name</label>
    <input type="text" id="secretary_name" value="<?php echo $secretary_name; ?>" name="secretary_name" />

    <label for="secretary_email">Secretary Email</label>
    <input type="text" id="secretary_email" value="<?php echo $secretary_email; ?>" name="secretary_email" />

  </div>

<h3 class="section_title">New Account Information</h3>

  <div class="col1">
    <label for="account_title">Account Title</label>
    <input type="text" id="account_title" value="<?php echo $account_title; ?>" name="account_title" />

    <label for="social">Social Security Number</label>
    <input type="text" id="social" value="<?php echo $social; ?>" name="social" />

    <label for="home_address1">Home Address</label>
    <input type="text" id="home_address1" value="<?php echo $home_address1; ?>" name="home_address1" />

    <label for="home_city">Home City</label>
    <input type="text" id="home_city" value="<?php echo $home_city; ?>" name="home_city" />

    <label for="home_zip">Home Zip</label>
    <input type="text" id="home_zip" value="<?php echo $home_zip; ?>" name="home_zip" />

    <label for="work_address1">Work Address</label>
    <input type="text" id="work_address1" value="<?php echo $work_address1; ?>" name="work_address1" />

    <label for="work_city">Work City</label>
    <input type="text" id="work_city" value="<?php echo $work_city; ?>" name="work_city" />

    <label for="work_zip">Work Zip</label>
    <input type="text" id="work_zip" value="<?php echo $work_zip; ?>" name="work_zip" />

    <label for="employer_name">Employer Name</label>
    <input type="text" id="employer_name" value="<?php echo $employer_name; ?>" name="employer_name" />

    <label for="years_employed">Years Employed</label>
    <input type="text" id="years_employed" value="<?php echo $years_employed; ?>" name="years_employed" />

    <label for="bank_reference">Bank Reference</label>
    <input type="text" id="bank_reference" value="<?php echo $bank_reference; ?>" name="bank_reference" />

    <label for="aba_number">ABA Number</label>
    <input type="text" id="aba_number" value="<?php echo $aba_number; ?>" name="aba_number" />

    <label for="routing_number">Routing Number</label>
    <input type="text" id="routing_number" value="<?php echo $routing_number; ?>" name="routing_number" />

  </div>
  <div class="col2">

    <label for="dob">Date of Birth</label>
    <input type="text" id="dob" value="<?php echo $dob; ?>" name="dob" />

    <label for="tax_id">Tax ID Number</label>
    <input type="text" id="tax_id" value="<?php echo $tax_id; ?>" name="tax_id" />

    <label for="home_address2">Home Address Line 2</label>
    <input type="text" id="home_address2" value="<?php echo $home_address2; ?>" name="home_address2" />

    <label for="home_state">Home State</label>
    <input type="text" id="home_state" value="<?php echo $home_state; ?>" name="home_state" />

    <label for="blank1">&nbsp;</label>
    <input type="text" id="blank1" value="&nbsp;" class="blank" />

    <label for="work_address2">Work Address Line 2</label>
    <input type="text" id="work_address2" value="<?php echo $work_address2; ?>" name="work_address2" />

    <label for="work_state">Work State</label>
    <input type="text" id="work_state" value="<?php echo $work_state; ?>" name="work_state" />

    <label for="blank2">&nbsp;</label>
    <input type="text" id="blank2" value="&nbsp;" class="blank" />

    <label for="job_title">Job Title</label>
    <input type="text" id="job_title" value="<?php echo $job_title; ?>" name="job_title" />

    <label for="dl_number">Driver License Number</label>
    <input type="text" id="dl_number" value="<?php echo $dl_number; ?>" name="dl_number" />

    <label for="dl_state">State of Issue</label>
    <input type="text" id="dl_state" value="<?php echo $dl_state; ?>" name="dl_state" />

    <label for="dl_issue_date">Issue Date</label>
    <input type="text" id="dl_issue_date" value="<?php echo $dl_issue_date; ?>" name="dl_issue_date" />

    <label for="dl_exp_date">Expiration Date</label>
    <input type="text" id="dl_exp_date" value="<?php echo $dl_exp_date; ?>" name="dl_exp_date" />

  </div>

  <h3 class="section_title">Joint Account Only</h3>

  <div class="col1">
    <label for="joint_name">Spouse/Joint Name</label>
    <input type="text" id="joint_name" value="<?php echo $joint_name; ?>" name="joint_name" />

    <label for="joint_social">Social Security Number</label>
    <input type="text" id="joint_social" value="<?php echo $joint_social; ?>" name="joint_social" />

    <label for="joint_employer_name">Employer Name</label>
    <input type="text" id="joint_employer_name" value="<?php echo $joint_employer_name; ?>" name="joint_employer_name" />

    <label for="joint_years_employed">Years Employed</label>
    <input type="text" id="joint_years_employed" value="<?php echo $joint_years_employed; ?>" name="joint_years_employed" />

  </div>
  <div class="col2">

    <label for="joint_dob">Date of Birth</label>
    <input type="text" id="joint_dob" value="<?php echo $joint_dob; ?>" name="joint_dob" />

    <label for="joint_tax_id">Tax ID</label>
    <input type="text" id="joint_tax_id" value="<?php echo $joint_tax_id; ?>" name="joint_tax_id" />

    <label for="joint_job_title">Job Title</label>
    <input type="text" id="joint_job_title" value="<?php echo $joint_job_title; ?>" name="joint_job_title" />

    <label for="blank1">&nbsp;</label>
    <input type="text" id="blank1" value="&nbsp;" class="blank" />

  </div>

<h3 class="section_title">Experience</h3>

  <div class="col1">
    <label for="equity_exp">Years Investing Equity</label>
    <input type="text" id="equity_exp" value="<?php echo $equity_exp; ?>" name="equity_exp" />

    <label for="margin_exp">Years Investing Margin</label>
    <input type="text" id="margin_exp" value="<?php echo $margin_exp; ?>" name="margin_exp" />

    <label for="options_exp">Years Investing Options</label>
    <input type="text" id="options_exp" value="<?php echo $options_exp; ?>" name="options_exp" />

  </div>
  <div class="col2">

    <label for="ipo_exp">IPO Experience</label>
    <input type="text" id="ipo_exp" value="<?php echo $ipo_exp; ?>" name="ipo_exp" />

    <label for="private_placement_exp">Private Placement Exp.</label>
    <input type="text" id="private_placement_exp" value="<?php echo $private_placement_exp; ?>" name="private_placement_exp" />

    <label for="mutual_fund_exp">Mutual Fund Experience</label>
    <input type="text" id="mutual_fund_exp" value="<?php echo $mutual_fund_exp; ?>" name="mutual_fund_exp" />

  </div>
  <h3 class="section_title">SEC Questions</h3>
  <div class="col1">
    <label for="annual_income">Annual Income</label>
    <input type="text" id="annual_income" value="<?php echo $annual_income; ?>" name="annual_income" />

    <label for="liquid_income">Liquid Income</label>
    <input type="text" id="liquid_income" value="<?php echo $liquid_income; ?>" name="liquid_income" />

  </div>
  <div class="col2">

    <label for="net_worth">Net Worth</label>
    <input type="text" id="net_worth" value="<?php echo $net_worth; ?>" name="net_worth" />

    <label for="blank1">&nbsp;</label>
    <input type="text" id="blank1" value="&nbsp;" class="blank" />

  </div>
  <h3 class="section_title">Must Need for IRA Account</h3>
  <div class="col1">

    <label for="beneficiary">Beneficiary</label>
    <input type="text" id="beneficiary" value="<?php echo $beneficiary; ?>" name="beneficiary" />

  </div>
  <div class="col2">

    <input type="submit" value="Update Lead Sheet" name="update-submit" />

  </div>
  <div class="col1">
    <label for="notes">Notes</label>
    <textarea id="notes" name="notes" class="textarea"><?php echo $notes; ?></textarea>


  </div>
</form>

</div><!-- End Container -->


<?php

if(!empty($_POST['update-submit'])) {
$conn2 = dbConnect('blackri_leads');
$sql2 = "UPDATE leads SET (
    rep_name = ?,
    date = ?,
    source = ?,
    lead_fname = ?,
    lead_lname = ?,
    home_number = ?,
    work_number = ?,
    cell_number = ?,
    fax_number = ?,
    work_email = ?,
    home_email = ?,
    secretary_name = ?,
    secretary_email = ?,
    account_title = ?,
    social = ?,
    tax_id = ?,
    dob = ?,
    home_address1 = ?,
    home_address2 = ?,
    home_city = ?,
    home_state = ?,
    home_zip = ?,
    work_address1 = ?,
    work_address2 = ?,
    work_city = ?,
    work_state = ?,
    work_zip = ?,
    employer_name = ?,
    job_title = ?,
    years_employed = ?,
    bank_reference = ?,
    aba_number = ?,
    routing_number = ?,
    dl_number = ?,
    dl_state = ?,
    dl_issue_date = ?,
    joint_name = ?,
    joint_social = ?,
    joint_tax_id = ?,
    joint_dob = ?,
    joint_employer_name = ?,
    joint_job_title = ?,
    joint_years_employed = ?,
    equity_exp = ?,
    margin_exp = ?,
    options_exp = ?,
    ipo_exp = ?,
    private_placement_exp = ?,
    mutual_fund_exp = ?,
    annual_income = ?,
    net_worth = ?,
    liquid_income = ?,
    beneficiary = ?,
    notes = ?
    ) WHERE id='$id'";
$stmt2 = $conn2->prepare($sql2);
$stmt2->bind_param('ssssssssssssssssssssssssssssssssssssssssssssssssssssss',
$_POST['rep_name'],
$_POST['date'],
$_POST['source'],
$_POST['lead_fname'],
$_POST['lead_lname'],
$_POST['home_number'],
$_POST['work_number'],
$_POST['cell_number'],
$_POST['fax_number'],
$_POST['work_email'],
$_POST['home_email'],
$_POST['secretary_name'],
$_POST['secretary_email'],
$_POST['account_title'],
$_POST['social'],
$_POST['tax_id'],
$_POST['dob'],
$_POST['home_address1'],
$_POST['home_address2'],
$_POST['home_city'],
$_POST['home_state'],
$_POST['home_zip'],
$_POST['work_address1'],
$_POST['work_address2'],
$_POST['work_city'],
$_POST['work_state'],
$_POST['work_zip'],
$_POST['employer_name'],
$_POST['job_title'],
$_POST['years_employed'],
$_POST['bank_reference'],
$_POST['aba_number'],
$_POST['routing_number'],
$_POST['dl_number'],
$_POST['dl_state'],
$_POST['dl_issue_date'],
$_POST['joint_name'],
$_POST['joint_social'],
$_POST['joint_tax_id'],
$_POST['joint_dob'],
$_POST['joint_employer_name'],
$_POST['joint_job_title'],
$_POST['joint_years_employed'],
$_POST['equity_exp'],
$_POST['margin_exp'],
$_POST['options_exp'],
$_POST['ipo_exp'],
$_POST['private_placement_exp'],
$_POST['mutual_fund_exp'],
$_POST['annual_income'],
$_POST['net_worth'],
$_POST['liquid_income'],
$_POST['beneficiary'],
$_POST['notes']
); // 54 entries

$stmt2->execute();

    if($stmt2->affected_rows) {
        echo 'Success!';
        } else {
        echo 'Failure! Something went wrong...';
    } // End of if success

$stmt2->close();
$conn2->close();
} // End If
?>

<?php include_once('footer.php'); ?>

$stmt2 = $conn2->prepare($sql2);
$stmt2->bind_param('ssssssssssssssssssssssssssssssssssssssssssssssssssssss', ...

UPDATE leads SET (
 ...
) WHERE id='$id'

UPDATE leads SET
    ...
WHERE id='$id'