0

hi, i have placed a table between a web page which display details of a user dynamically. Here is the code for it

<?php
$con=mysqli_connect("abc.com","avc","abc","abc");
// Check connection
if (mysqli_connect_errno()) 
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM employee");
echo "<table class='table table-striped table-bordered table-hover'>
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Country</th>
<th> Email</th>
<th>Edit</th>
</tr>
</thead>";
while($row = mysqli_fetch_array($result)) 
{
echo "<tbody data-link='row' class='rowlink'>";
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['country'] . "</td>";
echo "<td>" . $row['email'] . "</td>";    
echo "<td><a href=\"admin_edit_property.php?id=".$row['id']."\">Edit</a></td>";
echo "</tr>";
echo "</tbody>"; 
}

the look of the page will be something like this

Id Name  Country Email          Edit
1  user  abc     abc@gmail.com  edit

when a user clicks on the edit link, the code on page admin_edit_property.php is executed. code for this page is

<?php
include('admin_session.php');

$con=mysqli_connect("abc.com","abc","abc","abc");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$name = mysqli_real_escape_string($con, $_POST['name']);
$country = mysqli_real_escape_string($con, $_POST['country']);
$email = mysqli_real_escape_string($con, $_POST['email']);

$sql = "UPDATE employee SET name='".$name."',country='".$country."',email='".$email."' WHERE id ='".$empid."'";

if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
header("Location: index.php");
exit;

mysqli_close($con);
?>

<form class="form-horizontal" role="form" action="<?php $_PHP_SELF ?>" enctype="multipart/form-data" method="post">

<div class="form-group">
<label class="col-lg-3 control-label">Name:</label>
<div class="col-lg-8">
<input class="form-control" value="" type="text" name="name">
</div>
</div>

<div class="form-group">
<label class="col-lg-3 control-label">:Country</label>
<div class="col-lg-8">
<input class="form-control" value="" type="text" name="country">
</div>
</div>

<div class="form-group">
<label class="col-lg-3 control-label">Email:</label>
<div class="col-lg-8">
<input class="form-control" value="" type="text" name="email">
</div>
</div>

<div class="form-group">
<label class="col-md-3 control-label"></label>
<div class="col-md-8">
<input class="btn btn-primary" value="Save Changes" type="submit" name="submit">

</div>   
</div>
</form>

I din't know why but this code does not seem to work. when i run it it simply redirects me to index.php page but does not update the value. would appreciate all help

2
Contributors
3
Replies
8
Views
2 Years
Discussion Span
Last Post by iamthwee
0

can you plz tell me how can i do it

Edited by learner001

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.