Must I fill all for update

Started by guitarzRus, April 24, 2023, 03:35:41 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

guitarzRus

April 24, 2023, 03:35:41 PM
Quote
I want to update one field in a database table but with this code(which works now if I fill in all
fields). All fields left blank are cleared. I need a solution.

Code Select
<?php
$link = mysqli_connect("localhost", "root", "", "homedb"); 
// Check connection
if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); }

echo "<center>";echo date('m/d/y');echo "<br />";
   //Assign values to variables

$unit=$_POST['unit'];
$datereceived=$_POST['datereceived'];
$time=$_POST['time'];
$area=$_POST['area'];
$problem=$_POST['problem'];
$action=$_POST['action'];
$compday=$_POST['compday'];
$compmoyr=$_POST['compmoyr'];
$cost=$_POST['cost'];
$charge=$_POST['charge'];
$ordno=$_POST['ordno'];
$id = 'id';
 $sql = "UPDATE mainttbl SET 
datereceived = '$datereceived', time = '$time', area = '$area', problem = '$problem', action = '$action', 
compday = '$compday', compmoyr = '$compmoyr', cost = '$cost', charge = '$charge', 
ordno =  '$ordno' WHERE id = '$id' ";

 if(mysqli_query($link, $sql)){ echo "record was updated successfully."; } 
else { echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); }
 // Close connection
mysqli_close($link); 
?>
Print
Go Up Pages1
User actions