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. All rights reserved.</td>
</tr>
</table>
</form>
</body>
</html>