$query = "UPDATE `$table` SET column1 = '$value1', column2 = '$value2' WHERE $condition;"; <?php
include_once 'database.php';
if(count($_POST)>0) {
mysqli_query($conn,"UPDATE employee set userid='" . $_POST['userid'] . "', first_name='" . $_POST['first_name'] . "', last_name='" . $_POST['last_name'] . "', city_name='" . $_POST['city_name'] . "' ,email='" . $_POST['email'] . "' WHERE userid='" . $_POST['userid'] . "'");
$message = "Record Modified Successfully";
}
$result = mysqli_query($conn,"SELECT * FROM employee WHERE userid='" . $_GET['userid'] . "'");
$row= mysqli_fetch_array($result);
?>
<html>
<head>
<title>Update Employee Data</title>
</head>
<body>
<form name="frmUser" method="post" action="">
<div><?php if(isset($message)) { echo $message; } ?>
</div>
<div style="padding-bottom:5px;">
<a href="retrieve.php">Employee List</a>
</div>
Username: <br>
<input type="hidden" name="userid" class="txtField" value="<?php echo $row['userid']; ?>">
<input type="text" name="userid" value="<?php echo $row['userid']; ?>">
<br>
First Name: <br>
<input type="text" name="first_name" class="txtField" value="<?php echo $row['first_name']; ?>">
<br>
Last Name :<br>
<input type="text" name="last_name" class="txtField" value="<?php echo $row['last_name']; ?>">
<br>
City:<br>
<input type="text" name="city_name" class="txtField" value="<?php echo $row['city_name']; ?>">
<br>
Email:<br>
<input type="text" name="email" class="txtField" value="<?php echo $row['email']; ?>">
<br>
<input type="submit" name="submit" value="Submit" class="buttom">
</form>
</body>
</html>STEP 1:
If you want to update your php version.
Then go to php offical site https://www.php.net download your desire version from there.
STEP 2:
A zip file will be download, extract it.
STEP 3:
Then put it into your apache local server like (Xampp, Laragon, Wampp etc) in php folder.
STEP 4:
a) goto search bar of the window
b) search "environment variables"
c) goto "Enivronment Variables..."
d) In System Variables got "path" variable
e) Add your php folder path that you added before in apache local serve
NOTE !
If you are using multiple php versions at a time
then make sure that version you want use keep that version path at the top or first from other php versions
Boom!!!!!!
It's DONE.
| Code Example |
|---|
| Php :: php number formatter |
| Php :: remove php |
| Php :: laravel group concat values showing duplicate |
| Php :: sum of each group in laravel |
| Php :: php link |
| Php :: table laravel |
| Php :: if condtion in varibale value how to change in loop in php |
| Php :: php post not working |
| Php :: php keep input value after submit |
| Php :: debugbar:clear in laravel |
| Php :: get current month laravel |
| Php :: laravel update method |
| Php :: php header author |
| Php :: session variable |
| Php :: wp post view |
| Php :: php preg_replace function |
| Php :: php check string |
| Php :: php base58 decode |
| Php :: chunk_split (PHP 4, PHP 5, PHP 7, PHP 8) chunk_split — Split a string into smaller chunks |
| Php :: Merge Two Collection |
| Php :: sage theme |
| Php :: laraval routing |
| Php :: how to get private images in s3 laravel |
| Php :: displaying dates using php code |
| Php :: php array in variable |
| Php :: cakephp |
| Php :: laravel backpack |
| Php :: convert html to pdf php |
| Php :: API json data show in laravel |
| Php :: laravel 8 |