[ad_1]
My syntax however seems to be wrong. Can someone please advise?
I’m using the sender_details column name as an “id”. The issue seems to be around the ‘weight’ column name entered. The table name within the database is ‘deliveries’.
My PHP code is below:
$connect = mysqli_connect($hostname, $username, $password, $databaseName);
// get values form input text and number
$SenderDetails = $_POST['txt_SenderDetails'];
$ReceiverDetails = $_POST['txt_ReceiverDetails'];
$ParcelDetails = $_POST['txt_ParcelDetails'];
$Weight = $_POST['txt_Weight'];
$Quantity = $_POST['txt_Quantity'];
// mysql query to Update data
$query = "UPDATE `deliveries` SET `receiver_details`='".$ReceiverDetails."',`weight`='".$Weight."',`quantity`= $Quantity WHERE `sender_details` = $SenderDetails";
$result = mysqli_query($connect, $query);
if($result)
{
echo 'Data Updated';
}else{
echo 'Data Not Updated';
}
mysqli_close($connect);
}
My html code:
<!DOCTYPE html>
<html>
<head>
<title> PHP UPDATE DELIVERIES </title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<form action="UpdateDeliveriesForm.php" method="post">
Enter Senders Details To Update: <input type="text" name="txt_SenderDetails" required><br><br>
New Receiver Details:<input type="text" name="txt_ReceiverDetails" required><br><br>
New Parcel Details:<input type="number" name="txt_ParcelDetails" required><br><br>
New Weight Details:<input type="text" name="txt_Weight" required><br><br>
New Quantity:<input type="text" name="txt_Quantity" required><br><br>
<input type="submit" name="Update" value="Update Data">
</form>
</body>
</html>
The error message received:
Parse error: syntax error, unexpected single-quoted string ",`weight`=" in C:\xampp\htdocs\ParcelManagementSystem\UpdateDeliveriesForm.php on line 24
[ad_2]