如何在PHP中一次更新不同表中的数据 - how to update data in diffrent table at php at once

how to update data in diffrent table at php at once

本文关键字：更新数据一次 PHP | 更新日期: 2023-09-27

我有一个名为tyneevents 3表的数据库。
te_category有catID(用于类别id)和catDesc(用于类别描述)。
te_venue，它有venueID, venueName和location。
te_events具有evententid, eventTitle, eventDescription, venueID, catID, eventStartDate, eventEndDatae和eventPrice。
我有一个名为allDetails.php的页面来编辑eventDetails.
编辑后，它传递到另一个名为updateEventDetail.php的页面
下面是updateEventDetail.php代码。

<?php   
    include "database_conn.php";

    //get all data submited
        $id         = $_GET ["eventID"];
        $title      = $_GET ["eventTitle"];
        $desc       = $_GET ["eventDescription"];
        $venue      = $_GET ["venueName"];
        $location   = $_GET ["location"];
        $category   = $_GET ["catDesc"];
        $eStart     = $_GET ["eventStartDate"];
        $eEnd       = $_GET ["eventEndDate"];
        $ePrice     = $_GET ["eventPrice"];
        $sqlUpdateEvent             = " UPDATE te_events SET
                 eventTitle         = '$title' ,
                 eventDescription   = '$desc' ,
                 catDesc            = '$category' ,
                 venueName          = '$venue' ,
                 location           = '$location' ,
                 eventStartDate     = '$eStart' ,
                 eventEndDate       = '$eEnd' , 
                 eventPrice         = '$ePrice' 
                 WHERE eventID      =  $id";
        mysqli_query ($conn , $sqlUpdateEvent)
            or die ("SQL ERROR :".mysqli_error($conn));
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>update mvie comfirmmation</title>
<meta charset="utf-8">
</head>
<body>
<h1>update mvoie detials</h1>
<?php 
    echo "Title : $eventTitle 'n";
    echo "Category : $catDesc 'n";
    echo "Description : $eventDescription 'n";
    echo "Venue : $venueName 'n";
    echo "Location : $location 'n";
    echo "Start Date : $eventStartDate 'n";
    echo "End Date : $eventEndDate 'n";
    echo "Price : $eventPrice 'n";
    if(mysqli_affected_rows($conn)>0)
        echo "<p> Event update successfully </p>'n";
    else
        echo "<p> Update Fail</p>'n";
?>
<a href = "admin.php">Choose Event</a>
</body>
</html>
<?php
    mysqli_close($conn);
?>

问题表明

SQL错误:未知列'catDesc'，'venue' 'location'字段列表'

te_events仅包含evententid、eventTitle、eventDescription、venueID、catID、eventStartDate、eventEndDatae和eventPrice。catDesc'，'venue'，' location'在另外两个表中