使用php更新数据库

Question

This code looks horrible and I know. I don't know how to fix it though. When I try and update the table using the edit web page, only the first row in the first column updates but the subtitle is not updating in the second column, first row. Is there a way to change this? Sorry for the terrible explanation.

Update Page

 //Home Title
    $homeTitleUpdate = $_POST["homeTitleChange"];
    $editRow = $_POST["rowID"];
    $query = " UPDATE Home SET title = '$homeTitleUpdate' WHERE homeID = '$editRow'  ";
    $result = mysqli_query($conn, $query) or die(mysqli_error($conn));

    if ($result) {
        echo "<p> - Title updated succesfully to $homeTitleUpdate.</p>";
    }   else {
        echo "<p> - Title did not update. Something went wrong</p>";
    }


   //Home Subtitle
   $homeSubtitleUpdate = $_POST["homeSubtitleChange"]; 
   $query1 = " UPDATE Home SET subtitle = '$homeSubtitleUpdate' ";
   $result1 = mysqli_query($conn, $query) or die(mysqli_error($conn));

   if ($result) {
        echo "<p> - Subtitle updated successfully to $homeSubtitleUpdate.</p>";
    }   else {
        echo "<p> - Subtitle did not update. Something went wrong</p>";
    }

Edit Page

                <?php

                echo  "<h2 style='color:black'>";
                echo  "<input type'text' name='homeTitleChange' value=$homeTitle>";
                echo  "<input type='hidden' name='rowID' value=$getID>";
                echo  "</h2>";

                echo "<h4 style='color:black'>";
                echo  "<input type'text' name='homeSubtitleChange' value=$homeSubtitle>";
                echo  "<input type='hidden' name='rowID' value=$getID>";
                echo "</h4>";

                ?>



                <input type="submit" value="save" />

Answer 1

   <?php

            echo  "<h2 style='color:black'>";
echo "<form action="change to your file" method="post">
            echo  "<input type'text' name='homeTitleChange' value=$homeTitle>";
            echo  "<input type='hidden' name='rowID' value=$getID>";
            echo  "</h2>";

            echo "<h4 style='color:black'>";
            echo  "<input type'text' name='homeSubtitleChange' value=$homeSubtitle>";
            echo  "<input type='hidden' name='rowID' value=$getID>";
            echo "</h4>";

            ?>



            <input type="submit"  name="submit" value="save" />
</form>

You did not have a form

 //Home Title
if(isset($_POST['submit'])){
if
(
!empty($_POST["homeTitleChange"])
&& 
!empty($_POST["homeSubtitleChange"]) &&  
!empty($_POST["rowID"])
)
{
$homeTitleUpdate = $_POST["homeTitleChange"];
  $homeSubtitleUpdate = $_POST["homeSubtitleChange"]; 
    $editRow = $_POST["rowID"];
    $query = "UPDATE Home SET title = '$homeTitleUpdate', subtitle ='$homeSubtitleUpdate' WHERE homeID = '$editRow' ";
    $result = mysqli_query($conn, $query) or die(mysqli_error($conn));

    if ($result) {
        echo "<p> - Title/Subtitle updated succesfully to $homeTitleUpdate.</p>";
    }   else {
        echo "<p> - Title/Subtitle did not update. Something went wrong</p>";
    }
}
}

You can change your php and do it all within one query