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 :

<html>

<head>
<title>User Profile</title>
</head>
<body>

<?php
//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
$stmt->execute();

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

//TODO 6: fetch the result 
$stmt->fetch();

//TODO 7: close the statement
$stmt->close();

//TODO 8: close $mysqli
$mysqli->close();


?>

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

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

<h2>User Profile</h2>

<fieldset>
<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-->


<p>
<b>Password:</b>
<input type="password" name="password" size="15" maxlength="8" value=""/>
</p>


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

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

</p>


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


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

</body>
</html>
This article has been dead for over six months. Start a new discussion instead.