How to save an error to Database

Asked May 10 '16 at 13:43

Active May 10 '16 at 13:47

Viewed 54 times

I am basically looking to save an error to a MySql database.

So If a query fails the error will be saved to a MySQL table?

if ($conn->query($sql) === TRUE) {}
else
{      
$sql1 = "INSERT INTO audit_hr_employees 
(tab, employee, error_type, user, result, other)
VALUES ('4a', '$employee', 'warning', '$user', 'Error', '$sql')";
}

As you can see from the above example I have tried adding $sql into the database however it does not show anything.

This is not a duplicate of the last link that has been posted.

edited May 10 '16 at 13:47

asked May 10 '16 at 13:43

Shane

You made the same mistake again – John Conde May 10 '16 at 13:44
2

Who is upvoting this? I smell voter fraud – John Conde May 10 '16 at 13:44
Where you execute `$sql1` query??and where you define `$sql`?? – Saty May 10 '16 at 13:45
@JohnConde - It is not a duplicate? of the link you posted? Also i'm not sure how to see who has upvoted? – Shane May 10 '16 at 13:45
@saty - '$sql1 = "INSERT INTO audit_hr_employees' – Shane May 10 '16 at 13:46
Please display the results when you echo `sql1`. – user1032531 May 10 '16 at 13:53
No: You create a string with a query in it ___but you do not issue it to the database in a `$conn->query($sql1)`___ – RiggsFolly May 10 '16 at 13:53
Also what happens if the error you are reporting is `there is no connection to the database` do you recursively fail to write a row to the database _from here to eternity_ – RiggsFolly May 10 '16 at 13:54

How to save an error to Database

0 Answers0