Getting "Array to string conversion" error when trying to insert into MSSQL using PHP

Question

I am receiving the above error when trying to insert into a SQL Server DB. The error is line 25, which is the $logQuery line but I am pretty sure that it has something to do with the insert statement, which is line 24. Here is the insert statement:

$logInsert = "INSERT into log (id, title, description, dateTime) VALUES ('', 'In', 'ADMIN: Todd Thelin logged into site.', GETDATE())";

And here is the query:

$logQuery = sqlsrv_query($conn, $logInsert) or die("Could not add to log: " . sqlsrv_errors());

How do I fix this error? I have tried multiple things but none of them are working. Thank you

Coneone · Accepted Answer · 2013-11-08 21:45:12Z

2

I believe sqlsrv_errors() is returning an array. That makes the die function to fail.

answered Nov 8, 2013 at 21:45

Coneone

3321 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Phaxmohdem · Accepted Answer · 2015-06-12 15:30:58Z

1

Old thread but it helped me realize the following solution for this... wrapping print_r() around the sqlsrv_errors() function:

$logQuery = sqlsrv_query($conn, $logInsert) or die("Could not add to log: " . print_r(sqlsrv_errors()));

answered Jun 12, 2015 at 15:30

Phaxmohdem

5416 silver badges6 bronze badges

Collectives™ on Stack Overflow

Getting "Array to string conversion" error when trying to insert into MSSQL using PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related