MySQL: Logging SQL Statements for Debugging PHP Apps

  • Thread starter Thread starter rdx
  • Start date Start date
  • Tags Tags
    Mysql Sql
AI Thread Summary
The discussion centers on the challenge of logging SQL statements into a MySQL table for debugging PHP applications. The main issue arises from MySQL interpreting the SQL statements, leading to syntax errors during insertion. A suggested solution involves addressing the presence of apostrophes in the SQL statements by doubling them (replacing ' with ''). Participants express interest in exploring this workaround to effectively log the SQL data without encountering errors.
rdx
Messages
50
Reaction score
0
Goal: I seek to log the SQL statements into a MySQL table, with the time they were executed as an aid to debugging problems with PHP apps I am writing.

Problem: MySQL seems to try to interpret the statement, meant to simply be data in a field. When I try to "INSERT" the values, I get MySQL syntax errors.

Solution: Does anyone have a way around this problem?
 
Technology news on Phys.org
Do your inserts have apostrophes? You'll need to double them (replace ' with '').
 
verty said:
Do your inserts have apostrophes? You'll need to double them (replace ' with '').

Hmmm, I see what you mean.. I will look into it. Thanks.
 
Thread 'Is this public key encryption?'

Thread 'Is this public key encryption?'

I've tried to intuit public key encryption but never quite managed. But this seems to wrap it up in a bow. This seems to be a very elegant way of transmitting a message publicly that only the sender and receiver can decipher. Is this how PKE works? No, it cant be. In the above case, the requester knows the target's "secret" key - because they have his ID, and therefore knows his birthdate.
View full post »

Thread 'Who is responsible for the software when AI takes over programming?'

I tried a web search "the loss of programming ", and found an article saying that all aspects of writing, developing, and testing software programs will one day all be handled through artificial intelligence. One must wonder then, who is responsible. WHO is responsible for any problems, bugs, deficiencies, or whatever malfunctions which the programs make their users endure? Things may work wrong however the "wrong" happens. AI needs to fix the problems for the users. Any way to...
View full post »

Similar threads

Python Query runs fine in MySQL, but returns empty list in Python
Replies
7
Views
4K
Mysqld command does not start the MySQL Server
Replies
12
Views
11K
MySQL: Best way to warehouse older data
Replies
9
Views
2K
How has SQL Server not gone the way of the dinosaur?
Replies
3
Views
2K
Why are tables not showing up in Object explorer in database
Replies
5
Views
7K
PHP How Can I Replace My Static Website with a Dynamic Website Using PHP & MySQL?
Replies
4
Views
3K
How to install Cheerio in Visual Studio Code v 1.87.1
Replies
2
Views
2K
Why Isn't My PHP Comment System Saving Data to MySQL Database?
Replies
1
Views
4K
Fortran Density of state of a linear lattice
Replies
16
Views
2K
PHP Limiting Output from Unmaintainable PHP Code
Replies
7
Views
2K

Hot Threads

Recent Insights

Back
Top