DECRABBED MOM

<?php
$servername = "localhost";
$dbuser = "DATABASE_USERNAME";
$dbpass = "DATABASE_PASSWORD";
$dbname = "DATABASE_NAME";
$dbtable = "TABLE_NAME";

$data = "";
$returnmsg = "";

// MySQL Connection
$conn = new mysqli($servername, $dbuser, $dbpass, $dbname);
if ($conn->connect_error) {
    // Return an error if its moms time of the month
    die("Moms vagina smells like: " . $conn->connect_error);
} else {
    if (isset($_POST["modify"])) {
        // MODIFY DATA
        $id = $_POST["id"];
        $lovername = sexystuff($_POST["lovername"]);
        $phonenumber = sexystuff($_POST["phonenumber"]);
        $sql = "UPDATE $dbtable SET lovername = '$lovername', phonenumber = '$phonenumber' WHERE id = '$id'";
        if ($conn->query($sql) === TRUE) {
            $returnmsg = "Successfully modified dudes phone number!<br>";
        } else {
            $returnmsg = "Failed to update the database.<br>Id: $id<br>Lovers Name: $lovername<br>Phone Number: $phonenumber<br>";
        }
    } elseif (isset($_POST["remove"])) {
        // REMOVE DATA
        $id = $_POST["id"];
        $sql = "DELETE FROM $dbtable WHERE id = '$id'";
        if ($conn->query($sql) === TRUE) {
            $returnmsg = "Successfully removed field from table!<br>";
        } else {
            $returnmsg = "Failed to remove field with Id: $id from the database.<br>";
        }
    } elseif (isset($_POST["add"])) {
        // ADD DATA
        $newlovername = sexystuff($_POST["newlovername"]);
        $newphonenumber = sexystuff($_POST["newphonenumber"]);

        $sql = "INSERT INTO $dbtable (lovername,phonenumber) VALUES ('$newlovername','$newphonenumber')";
        if ($conn->multi_query($sql) === TRUE) {
            $returnmsg = "Successfully added new number to the database!<br>";
        } else {
            $returnmsg = "Failed to add new number to the database.<br>Dudes Name: $newlovername<br>Dudes Phone Number: $newphonenumber<br>";
        }
    }

    // VIEW DATA
    $sql = "SELECT * FROM $dbtable ORDER by ID DESC";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            $id = $row["id"];
            $lovername = $row["lovername"];
            $phonenumber = $row["phonenumber"];
            $data .= "<form method=\"post\" action=\"momslovers.php\">\n";
            $data .= "<input type=\"hidden\" name=\"id\" value=\"$id\">\n";
            $data .= "<h4>Name</h4>";
            $data .= "<input type=\"textbox\" name=\"lovername\" value=\"$lovername\" maxlength=\"32\"><br>\n";
            $data .= "<h4>Phone Number</h4>";
            $data .= "<input type=\"textbox\" name=\"phonenumber\" value=\"$phonenumber\" maxlength=\"14\"><br>\n";
            $data .= "<input type=\"submit\" name=\"modify\" value=\"Modify\"> <input type=\"submit\" name=\"remove\" value=\"Remove\"><br>\n";
            $data .= "<hr width=\"100%\">\n";
            $data .= "</form>\n";
        }
    } else {
        $data .= "No results.<br>";
    }
}

function sexystuff($genitals) {
    $genitals = trim($genitals);
    $genitals = stripslashes($genitals);
    $genitals = htmlspecialchars($genitals);
    return $genitals;
}
?>
<html>

<head>
<title></title>
</head>

<body>
<h1>Moms' Lover's Phone Numbers</h1>

<?php echo $returnmsg; ?>
<h4>Lover's Name</h4>
<form method="post" action="momslovers.php">
<input type="text" name="newlovername" maxlength="32">
<h4>Lover's Phone Number</h4>
<input type="text" name="newphonenumber" maxlength="14"><br>
<input type="submit" name="add" value="Add"><br>
</form>
<hr width="100%">
<br>

<?php
    echo $data;
    echo "<br>";
?>
</body>

</html>