View Single Post
Old 01-28-2022, 01:25 PM  
sarettah
see you later, I'm gone
 
Industry Role:
Join Date: Oct 2002
Posts: 14,091
Quote:
$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);
1. In the $sql= statement you are missing commas between the last 4 filednames: NameServer1 NameServer2 Status Notes)

2. In the same statement you only list 7 parameters but in the bind you list 8 vars:
(?, ?, ?, ?, ?, ?, ?)
$param_Registrar, $param_DomainName, $param_Registration, $param_Expiration, $param_NameServer1, $param_NameServer2, $param_Status, $param_Notes


I did not look any further than that.

.
__________________
All cookies cleared!
sarettah is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote