gw1500se

As I said, post your schema and we will be better able to help you. In the meantime this should be moved to the MySQL forum.

This is really a MySQL question not PHP. You can let MySQL create the ID for you. Create a join table that associates the customer with the invoice ID and make that field auto increment. Each customer can then have multiple invoice IDs.

Put them wherever you want to check the values of variables. Like maybe just before the 'if' statements. Perhaps you will find this useful.

Use 'echo' for individual variables. Use '<pre><?php var_dump($arrayorobject); ?></pre>' for arrays or objects.

Did you printout each variable to make sure it contains what you expect? As ginerjm said, your code is really too tedious to compare. You may need to spend some time rethinking all your 'if's to simplify them somehow.

We need to know what error message you are getting on which line or which line is not producing the results you expect?

Solve it by fixing the bug.

Post your code here (use the code icon <>). You will likely get a quicker response.

Have you read this?

Use absolute path names in all scripts. You can even set a global variable with the absolute path name and use that in all scripts.

Agree but perhaps the default is missing. That the OP can do this with CLI, implies that the PHP script is not accessing the same host as the CLI. That seems unlikely so I am clutching at straws.

I would expect a different error but you are missing the 'dbname=...' parameter in the connect.

This is really a MySQL question and should be moved to the MySQL forum. You need to make sure your 'GRANT's are correct. From a CLI connection run "SHOW GRANTS FOR 'root'@'localhost'".

I don't understand what you are trying to do. Where is the input (-i) file in that command.

Use E.164 format.