i nd help in php cos i met error- Fatal error: Call to a member function bind_param() on a non-object in C:\xampp\htdocs\WAD_Project\userprofile.php on line 19.
which i dun uds n cant solve after tryin. plz reply n help ty. if thr any other info u nd frm me to solve my problem, feel free to reply to tis thread too. below r sum of my codings for my userprofile.php :


<title>User Profile</title>

//TODO 0: get user's email
$email = $_GET['email'];

//TODO 1: Connect to kagdbdb database
$mysqli = new mysqli("localhost", "root", null, "kagdb");

//TODO 2: Prepare the statement to select user
$stmt = $mysqli->prepare("Select password, address, contactno, from user where email=?");

//TODO 3: Bind the values 
$stmt->bind_param("s", $email);

//TODO 4: Execute the statement

//TODO 5: bind results into $password, $address ,$contactno and $email
$stmt->bind_result($password, $address, $contactno, $email);

//TODO 6: fetch the result 

//TODO 7: close the statement

//TODO 8: close $mysqli


<form action="userupdate.php" method="post">
<table cellpadding="0" cellspacing="0" style="width: 100%; height: 100px;">
<td style="width: 100%; height: 20%;">

<td style="width: 100%; height: 70%;">

<h2>User Profile</h2>

<legend>Edit your profile in the form below:</legend>

<!--TODO 9: Fill in the values for each of the input fields so that data is displayed-->

<input type="password" name="password" size="15" maxlength="8" value=""/>

<input type="text" name="address" size="50" maxlength="50" value="<?php if (isset($_POST['address'])) echo $address; ?>" />

<b>Contact Number:</b>
<input type="text" name="contactno" size="15" maxlength="8" value="<?php if (isset($_POST['contactno'])) echo $contactno; ?>" />


<div align="center">
<input type="submit" name="submit" value="Update!" />
<input type="reset" value="Reset" />

<td style="width: 100%; height: 10%;">
Copyright 2008 by The KAG Group.&nbsp; All rights reserved.</td>

8 Years
Discussion Span
Last Post by blocblue
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.