|
Server IP : 103.191.208.227 / Your IP : 18.191.235.143 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/mhmsfzcs/vflyorions.com/.well-known/../../www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// multiple_update.php
include('db.php');
if (isset($_POST['hidden_id'])) {
try {
$username = $_POST['username'];
$password = $_POST['password'];
$stat_us = $_POST['stat_us'];
$permission = $_POST['permission'];
$targetdate = $_POST['targetdate'];
$id = $_POST['hidden_id'];
for ($count = 0; $count < count($id); $count++) {
$data = array(
':username' => $username[$count],
':password' => $password[$count],
':stat_us' => $stat_us[$count],
':permission' => $permission[$count],
':targetdate' => $targetdate[$count],
':id' => $id[$count]
);
$query = "
UPDATE demo1
SET username = :username, password = :password, stat_us = :stat_us, permission = :permission, targetdate = :targetdate
WHERE id = :id
";
$statement = $conn->prepare($query);
$result = $statement->execute($data);
if (!$result) {
throw new Exception("Update query failed for ID: " . $id[$count]);
}
}
// Redirect or display success message after updates
header("Location: success.php");
exit();
} catch (Exception $e) {
echo "Error: " . $e->getMessage();
}
}
?>
<?php
//its my written
//multiple_update.php
// include('db.php');
// if(isset($_POST['hidden_id']))
// {
// $username = $_POST['username'];
// $password = $_POST['password'];
// $stat_us = $_POST['stat_us'];
// $permission = $_POST['permission'];
// $targetdate = $_POST['targetdate'];
// $id = $_POST['hidden_id'];
// for($count = 0; $count < count($id); $count++)
// {
// $data = array(
// ':username' => $username[$count],
// ':password' => $password[$count],
// ':stat_us' => $stat_us[$count],
// ':permission' => $permission[$count],
// ':targetdate' => $targetdate[$count],
// ':id' => $id[$count]
// );
// $query = "
// UPDATE demo1
// SET username = :username, password = :password, stat_us = :stat_us, permission = :permission, targetdate = :targetdate
// WHERE id = :id
// ";
// $statement = $conn->prepare($query);
// $statement->execute($data);
// }
// }
?>