I'm trying to put together a simple domain managament database.
Its telling me that something went wrong when I try to add a new domain name record, yet it isnt highlighting any form fields with an error:
Quote:
<?php
// Include config file
require_once "config.php";
// Define variables and initialize with empty values
$Registrar = $DomainName = $Registration = $Expiration = $NameServer1 = $NameServer2 = $Status = $Notes = "";
$Registrar = $DomainName_err = $Registration_err = $Expiration_err = $NameServer1_err = $NameServer2_err = $Status_err = $Notes_err = "";
// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){
// Validate registrar
$input_Registrar = trim($_POST["Registrar"]);
if(empty($input_Registrar)){
$Registrar_err = "Please enter Registrar.";
} else{
$Registrar = $input_Registrar;
}
// Validate domainname
$input_DomainName = trim($_POST["DomainName"]);
if(empty($input_DomainName)){
$DomainName_err = "Please enter DomainName.";
} else{
$DomainName = $input_DomainName;
}
// Validate registration
$input_Registration = trim($_POST["Registration"]);
if(empty($input_Registration)){
$Registration_err = "Please enter Registration Date.";
} else{
$Registration = $input_Registration;
}
// Validate expiration
$input_Expiration = trim($_POST["Expiration"]);
if(empty($input_Expiration)){
$Expiration_err = "Please enter Expiration Date.";
} else{
$Expiration = $input_Expiration;
}
// Validate nameserver1
$input_NameServer1 = trim($_POST["NameServer1"]);
if(empty($input_NameServer1)){
$NameServer1_err = "Please enter NS1.";
} else{
$NameServer1 = $input_NameServer1;
}
// Validate nameserver2
$input_NameServer2 = trim($_POST["NameServer2"]);
if(empty($input_NameServer2)){
$NameServer2_err = "Please enter NS2.";
} else{
$NameServer2 = $input_NameServer2;
}
// Validate status
$input_Status = trim($_POST["Status"]);
if(empty($input_Status)){
$Status_err = "Please enter Domain Status.";
} else{
$Status = $input_Status;
}
// Validate notes
$input_Notes = trim($_POST["Notes"]);
if(empty($input_Notes)){
$Notes_err = "Please enter Notes.";
} else{
$Notes = $input_Notes;
}
// Check input errors before inserting in database
if(empty($Registrar_err) && empty($DomainName_err) && empty($Registration_err) && empty($Expiration_err) && empty($NameServer1_err) && empty($NameServer2_err) && empty($Status_err) && empty($Notes_err)){
// Prepare an insert statement
$sql = "INSERT INTO DomainManagement (Registrar, DomainName, Registration, Expiration, NameServer1 NameServer2 Status Notes) VALUES (?, ?, ?, ?, ?, ?, ?)";
if($stmt = mysqli_prepare($link, $sql)){
// Bind variables to the prepared statement as parameters
mysqli_stmt_bind_param($stmt, "sss", $param_Registrar, $param_DomainName, $param_Registration, $param_Expiration, $param_NameServer1, $param_NameServer2, $param_Status, $param_Notes);
// Set parameters
$param_Registrar = $Registrar;
$param_DomainName = $DomainName;
$param_Registration = $Registration;
$param_Expiration = $Expiration;
$param_NameServer1 = $NameServer1;
$param_NameServer2 = $NameServer2;
$param_Status = $Status;
$param_Notes = $Notes;
// Attempt to execute the prepared statement
if(mysqli_stmt_execute($stmt)){
// Close statement
mysqli_stmt_close($stmt);
}
// Records created successfully. Redirect to landing page
header("location: index.php");
exit();
} else{
echo "Oops! Something went wrong. Please try again later.";
}
}
// Close connection
mysqli_close($link);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<base href="https://gfy.com/" /><!--[if IE]></base><![endif]-->
<base href="https://gfy.com/" /><!--[if IE]></base><![endif]-->
<meta charset="UTF-8">
<title>Create Record</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<style>
.wrapper{
width: 600px;
margin: 0 auto;
}
</style>
</head>
<body>
<div class="wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-md-12">
<h2 class="mt-5">Create Record</h2>
<p>Please fill this form and submit to add new domain to the database.</p>
<form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
<div class="form-group">
<label>Registrar</label>
<textarea name="Registrar" class="form-control <?php echo (!empty($Registrar_err)) ? 'is-invalid' : ''; ?>"><?php echo $Registrar; ?></textarea>
<span class="invalid-feedback"><?php echo $Registrar_err;?></span>
</div>
<div class="form-group">
<label>Domain</label>
<input type="text" name="DomainName" class="form-control <?php echo (!empty($DomainName_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $DomainName; ?>">
<span class="invalid-feedback"><?php echo $DomainName_err;?></span>
</div>
<div class="form-group">
<label>Registration</label>
<input type="text" name="Registration" class="form-control <?php echo (!empty($Registration_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Registration; ?>">
<span class="invalid-feedback"><?php echo $Registration_err;?></span>
</div>
<div class="form-group">
<label>Expiration</label>
<input type="text" name="Expiration" class="form-control <?php echo (!empty($Expiration_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Expiration; ?>">
<span class="invalid-feedback"><?php echo $Expiration_err;?></span>
</div>
<div class="form-group">
<label>NameServer1</label>
<input type="text" name="NameServer1" class="form-control <?php echo (!empty($NameServer1_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $NameServer1; ?>">
<span class="invalid-feedback"><?php echo $NameServer1_err;?></span>
</div>
<div class="form-group">
<label>NameServer2</label>
<input type="text" name="NameServer2" class="form-control <?php echo (!empty($NameServer2_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $NameServer2; ?>">
<span class="invalid-feedback"><?php echo $NameServer2_err;?></span>
</div>
<div class="form-group">
<label>Status</label>
<input type="text" name="Status" class="form-control <?php echo (!empty($Status_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Status; ?>">
<span class="invalid-feedback"><?php echo $Status_err;?></span>
</div>
<div class="form-group">
<label>Notes</label>
<input type="text" name="Notes" class="form-control <?php echo (!empty($Notes_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Notes; ?>">
<span class="invalid-feedback"><?php echo $Notes_err;?></span>
</div>
<input type="submit" class="btn btn-primary" value="Submit">
<a href="index.php" class="btn btn-secondary ml-2">Cancel</a>
</form>
</div>
</div>
</div>
</div>
</body>
</html>
|
Yet I'm about 90% certain everything is coded how it should be (although I may have messed up with the validation rules perhaps?).
Everything in the config.php is 100% correct.
Can anyone see where the error above is and, if so, could you point me in the right direction to fixing it?
