Hi
I am new, Pls help me the following issue. When click the update button, ID should be to another page to process the update function. Below is my entire code
index.php
<?php
include_once '../../inc/config.inc.php';
$sql="SELECT * FROM demo order by id";
try {
$result = mysqli_query($con,$sql);
include 'view.html.php';
}
catch (PDOException $e)
{
echo $e->getMessage() . "\n";
file_put_contents('PDOErrors.txt', $e->getMessage(), FILE_APPEND);
// $output = 'Error fetching authors from database!';
// include '../../notification/errormsg.php';
exit();
}
view.html.php
<Script Language="javascript">
function change_action()
{
var frm_obj=document.getElementById("frm");
frm_obj.action="data.php";
}
</Script>
<h3>User Details</h3>
<form action="" method="POST" id="frm" >
<table width="100%" align="center" cellpadding="4" cellspacing="1">
<tr>
<td>ID</td>
<td>ID</td>
<td>NAME</td>
<td>FIRST NAME</td>
<td>AGE</td>
<td></td>
</tr>
<?php
if(isset($result)){
while($row = mysqli_fetch_array($result)){ ?>
<tr>
<td><input type="text" name="vid" value="<?php echo $row['id'];?>"/></td>
<td><?php echo $row['id'];?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['firstname'];?></td>
<td><?php echo $row['age'] ;?></td>
<td><input type="submit" value="update" name="update" onclick="change_action()">
<input type="submit" value="delete" name="delete" onclick="change_action()">
</td>
</tr>
<?php
}
}
mysqli_close($con);
?>
</table>
</FORM>
<?php
include '../../inc/footer.php';
data.php
<?php
include_once '../../inc/config.inc.php';
if (isset($_POST['update']) && $_POST['update'] != "" )
{
$id = $_POST['vid'];
$sql="SELECT * FROM demo where id='$id'";
$result = mysqli_query($con,$sql);
include 'edit.php';
}
edit.php
<?php
echo 'edit.php';
if(isset($result))
{
while($row = mysqli_fetch_array($result))
{
echo $row['id'];'<br>';
echo $row['name'];'<br>';
echo $row['firstname'];'<br>';
echo $row['age'];'<br>';
}
}
Thank you
maideen