Why wont this let me add more than 1 record?
 

So I have the basic CRUD setup but when it comes to adding a new domain (or several records) it will allow me to add the first record (ID=0) in the database, but then wont let me add anything additional, can anyone tell me why? :helpme

Been playing with this a few hours trying to figure out why and its driving me crazy, it isnt kicking out any errors, just isnt entering data into the table :(

Without knowing more about the table you are inserting into, it is hard to say. Could be duplicate entry on a unique index, not sure. Also not sure what level you are reporting errors. When I am in development mode I have all error reporting php and mysql turned on so I can see anything that goes wrong. I also put message s in the code so I can see exactly what is happening and when.

However, in what you posted, if it is the code that you are running there is a space in '$status' that should not be there, but that should blow it off every time not just on subsequent runs.

Thanks.

That 'Status' one just seems to be on GFY, its not on the server version, must have just been a FF issue.

Would you possibly be able to share the php code that I can use to check MySQL for errors? :D

This: https://www.w3schools.com/php/func_mysqli_error.asp

That would work.

.

Yeah, I dont see an "ID" field in the insert code.
The DB is set to "auto index"; but he has no field defined for the auto index.


// Insert user data into table
$result = mysqli_query($mysqli, "INSERT INTO DomainManagement(Registrar,DomainName,Registration ,Expiration,NameServer1,NameServer2,Status,Notes) VALUES('$Registrar','$DomainName','$Registration', '$Expiration','$NameServer1','$NameServer2','$Stat us','$Notes')");

The SQL table should have a record ID field. (You can do anything you want but ID is standard)
The ID will be "" in the data fields so that SQL will create the ID number on insert for you.

The code should look like this, I think.

// Insert user data into table
$result = mysqli_query($mysqli, "INSERT INTO DomainManagement(ID,Registrar,DomainName,Registration ,Expiration,NameServer1,NameServer2,Status,Notes) VALUES("", '$Registrar','$DomainName','$Registration', '$Expiration','$NameServer1','$NameServer2','$Stat us','$Notes')");


:2 cents:

Thank you all for the help, I fixed the issue.

It was a messed up AI/NULL setting in the table.

I recommend Mamp Pro/xDebug/Phpstorm. Using xDebug you can see what is happening at each step to help debug things.

I know for Xdebug, but it's nothing special - i for debugging using command php -l, and so far there was no need for anything else. There is also option to use IDE like netbeans which have integrated debugger.