01-28-2022, 08:46 PM
|
|
|
Confirmed User
Industry Role:
Join Date: Oct 2018
Location: New Orleans, Louisiana. / Newcastle, England.
Posts: 1,183
|
Meh :/
Now i'm having an issue with it not writing to the database, any suggestions on where the issue may lay?
It's not throwing any errors and appears to be working how it is supposed to, it's just not storing the data in SQL 
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>Add New Domain Name | Admin Management System</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">Add New Domain Name</h2>
<p>Complete the form below to add a new domain name to the system.</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 Name</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>Reg Date</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>Exp Date</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>NS1 Record</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>NS2 Record</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>Domain 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>
|
|
|
|