xxxxxxxxxx
<?php
// Assuming you have already established a PDO database connection
// Prepare the update query
$stmt = $pdo->prepare( "UPDATE your_table SET column1 = :value1, column2 = :value2 WHERE id = :id" );
// Bind the values to the query parameters
$stmt->bindParam( ':value1', $newValue1 );
$stmt->bindParam( ':value2', $newValue2 );
$stmt->bindParam( ':id', $rowId );
// Set the new values and row id
$newValue1 = 'New value for column1';
$newValue2 = 'New value for column2';
$rowId = 1; // Assuming you want to update the row with id = 1
// Execute the update query
$stmt->execute();
// Check if the update was successful
if ($stmt->rowCount() > 0) {
echo "Update successful!";
} else {
echo "No rows updated.";
}
?>
xxxxxxxxxx
$query = "UPDATE `$table` SET column1 = '$value1', column2 = '$value2' WHERE $condition;";
xxxxxxxxxx
mysql_query("UPDATE blogEntry SET content = '$udcontent', title = '$udtitle' WHERE id = $id");
xxxxxxxxxx
<?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>
xxxxxxxxxx
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.