Viewing file:  update_submit.php (2.85 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html>
<html lang="en">
<?php include 'head.php';?>
<style>
body {
font-family: Arial, sans-serif;
margin: 0;
padding: 20px;
}
h1, h2 {
text-align: center;
}
.branch-list {
list-style-type: none;
padding: 0;
text-align: center;
}
.branch-list li {
margin: 10px 0;
}
.branch-list a {
text-decoration: none;
color: #333;
font-weight: bold;
}
.branch-list a:hover {
color: #4CAF50;
}
/* Add more styling as needed */
table {
border-collapse: collapse;
border-spacing: 0;
width: 100%;
margin: 0 auto;
border:2;
}
th, td {
padding: 10px;
text-align: left;
}
th {
background-color: #04AA6D;
color: white;
}
label, input {
width: 200px;
}
</style>
<style>
body {
font-family: Arial, sans-serif;
margin: 0;
padding: 20px;
}
h1 {
text-align: center;
}
form {
max-width: 500px;
margin: 0 auto;
}
label {
display: block;
margin-top: 10px;
}
input[type="text"],
input[type="date"],
input[type="tel"],
input[type="number"],
textarea,
select {
width: 100%;
padding: 10px;
margin-bottom: 10px;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
}
input[type="submit"] {
background-color: #4CAF50;
color: white;
padding: 10px 20px;
border: none;
border-radius: 4px;
cursor: pointer;
float: right;
}
input[type="submit"]:hover {
background-color: #45a049;
}
</style>
<body>
<!-- ======= Header ======= -->
<?php include 'menubar.php';?>
<?php include 'sidebar.php';?>
<main id="main" class="main">
<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "tslibrary_user", "rb!tsl838", "tslibrary_data");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$name = $_POST["name"];
$father = $_POST["father"];
$mother = $_POST["mother"];
$dob = $_POST["dob"];
$address = $_POST["address"];
$mobile = $_POST["mobile"];
$mobile2 = $_POST["mobile2"];
$aadhar = $_POST["aadhar"];
$reg_date = $_POST["reg_date"];
$reg_month = $_POST["reg_month"];
$reg_year = $_POST["reg_year"];
$fees_amount = $_POST["fees_amount"];
$fees_deposit_date = $_POST["fees_deposit_date"];
$fees_mode = $_POST["fees_mode"];
$batch_time= $_POST["batch_time"];
$regno= $_POST["regno"];
// Attempt update query execution
$sql = "UPDATE student_registration
SET
father='$father',
mother='$mother'
WHERE student_id='$regno'";
if(mysqli_query($link, $sql)){
echo "Records were updated successfully.";
} else {
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>
</main><!-- End #main -->
<?php include 'footer.php';?>
</body>
</html>
|