I am trying to update a edit profile in mysql. the first bit of code is when the submit button on forum is hit the data in my table users willl change. the secound bit code get the user info from the database it work fine you can select what person to update i just have to figer out how to display the detail in the forum. i don't seem to have any problems with it. the last bit doesn't do much yet outher then show the form and should show the info from the ger info.php i havent got that yet. ive been messing around trying to figure it all out for a while and can't seem to get it. at one point i tot i had it connecting but it still wouldn't update the database, so i have no idea. feel free to suggest anything.
<?php
if (!isset($_SESSION['id'])) {
}
include('db.php');
header("Access-Control-Allow-Origin: *");
if (!isset($_GET['id'])){
session_start();
$id = 1;
}else{
$id = $_GET['id'];
}
if (isset($_POST['UPDATE'])) {
$firstname = $_POST['firstname'];
$lastame= $_POST['lastname'];
$email= $_POST['email'];
$bio = $_POST['bio'];
$sql = mysql_query("UPDATE users SET firstname='$firstname',lastname='$lastname',email='$email', bio='$bio'WHERE id ='$id'");
echo 'Your account info has been updated, visitors to your profile will now see the new info.<br /><br />
To return to your profile edit area, <a href="profile.php">click here</a>';
exit();
} //close if post
?>
<?php
include('db.php');
header("Access-Control-Allow-Origin: *");
if (!isset($_GET['id'])){
session_start();
$id = 1;
}else{
$id = $_GET['id'];
}
$result = mysql_query("SELECT * FROM users WHERE id = ".$id.";");
if (mysql_num_rows($result) == 1){
$id = mysql_result($result, 0,"id");
$firstname = mysql_result($result, 0,"firstname");
$lastname = mysql_result($result, 0,"lastname");
$email = mysql_result($result, 0,"email");
$bio = mysql_result($result, 0,"bio");
$detailsArray = array ("status" => 1, "firstname" => $firstname,"lastname" => $lastname,"email" => $email,"bio" => $bio);
echo json_encode($detailsArray);
}else{
$detailsArray = array ("status" => 0);
echo json_encode($detailsArray);
}
mysql_close();
?>
<?php
include('db.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Edit Your Account Info</title>
<script type="text/javascript">
<!-- Form Validation -->
function validate_form ( ) {
valid = true;
if ( document.form.firstname.value == <?php echo $firstname; ?>" /> ) {
alert ( "firstname must not be blank." );
valid = false;
}
if ( document.form.lastname.value == <?php echo $lastname; ?>" /> ) {
alert ( "lastname must not be blank." );
valid = false;
}
if ( document.form.email.value == <?php echo $email; ?>" /> ) {
alert ( "email must not be blank." );
valid = false;
}
if ( document.form.bio.value == <?php echo $bio; ?>" /> ) {
alert ( "bio must not be blank." );
valid = false;
}
return valid;
}
<!-- Form Validation -->
</script>
</head>
<body>
<div align="center">
<h3><br />
Edit Account info
<br />
</h3>
</div>
<table align="center" cellpadding="8" cellspacing="8">
<form action="file:///C:\xampp\htdocs\Team Project\Web\PHP\edit_info.php" method="post" enctype="multipart/form-data" name="form" id="form" onsubmit="return validate_form ( );">
<tr>
<td><div align="right">Firstname:</div></td>
<td><input name="frist" type="text" id="name" value="<?php echo $firstname; ?>" size="30" maxlength="64" /></td>
</tr>
<tr>
<td><div align="right">lastname:</div></td>
<td><input name="secound" type="text" id="lastame" value="<?php echo $lastname; ?>" size="30" maxlength="64" /></td>
</tr>
<tr>
<td><div align="right">Email:</div></td>
<td><input name="email" type="text" id="email" value="<?php echo $email; ?>" size="30" maxlength="24" /></td>
</tr>
<tr>
<td class="style7"><div align="right">bio:</div></td>
<td><textarea name="bio" cols="42" rows="8" id="bio" value="<?php echo $bio; ?>" ></textarea></td>
</tr>
<tr>
<td><input name="Submit" type="submit" value="Submit Changes" /></td>
</tr>
</form>
</table>
</body>
</html>