Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Design
/
fileman
/
Fusion
/
CRUD03
:
updatecode.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php //$connection = mysqli_connect("localhost","root",""); //$db = mysqli_select_db($connection, 'phpcrud'); $connection = mysqli_connect("analogdepat.mysql.db","analogdepat","Un92pac007"); $db = mysqli_select_db($connection, 'analogdepat'); if(isset($_POST['updatedata'])) { $id = $_POST['update_id']; $fname = $_POST['fname']; $lname = $_POST['lname']; $course = $_POST['course']; $contact = $_POST['contact']; $query = "UPDATE student SET fname='$fname', lname='$lname', course='$course', contact=' $contact' WHERE id='$id' "; $query_run = mysqli_query($connection, $query); if($query_run) { echo '<script> alert("Data Updated"); </script>'; header("Location:index.php"); } else { echo '<script> alert("Data Not Updated"); </script>'; } } ?>