PHP - Create Text file on mysql Error

Question

Trying to Create a text file with MySQL database errors because I never get to see the page.

mysql_query(
"INSERT INTO cart (value1) VALUES ('value1')", $link) 
or die(mysql_error());

But I want to replace the mysql_error into a text file, any thoughts?

I see you're new to Stack Overflow. Be sure to give the about page a read if you haven't already, and be sure to select an answer to your question once you've found what you're looking for. — user1846065
– user1846065, Commented Dec 6, 2013 at 6:27

mehdi · Accepted Answer · 2013-12-06 06:23:52Z

2

you can put your function in die()

 or die(your_function(mysql_error()))

 function your_function(e){
    file_put_contents('log.txt', e);
 }

answered Dec 6, 2013 at 6:23

mehdi

1,7552 gold badges15 silver badges21 bronze badges

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

Comments

sravis · Accepted Answer · 2013-12-06 06:27:38Z

1

You can just create text file on MySQL error and log MySQL error in it.

$link = mysql_connect("localhost", "mysql_user", "mysql_password");

$db = mysql_select_db("nonexistentdb", $link);
if(!$db) {
  $err = mysql_errno($link) . ": " . mysql_error($link). "\n";
  $file = fopen('filename.txt', 'a');
  fwrite($file, $err);
}

answered Dec 6, 2013 at 6:27

sravis

3,6808 gold badges41 silver badges76 bronze badges

Comments

Kᴏɴsᴛᴀɴᴛɪɴ Sʜɪʟᴏᴠ · Accepted Answer · 2018-07-09 17:54:12Z

0

Here is a quick way to write the mysql_error() to a log file.

$file = fopen('mysql_error.log','a');
mysql_query($query)

or

die(fwrite($file1,"$query".mysql_error(). "\n"));

This will write the query and the error on the same line of the log file.

edited Jul 9, 2018 at 17:54

Kᴏɴsᴛᴀɴᴛɪɴ Sʜɪʟᴏᴠ

13.3k17 gold badges83 silver badges78 bronze badges

answered Jul 9, 2018 at 17:32

DJ_007

11 bronze badge

Collectives™ on Stack Overflow

PHP - Create Text file on mysql Error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related