Mysql can query and cannot add or modify-php Tutorial

Mysql can query and cannot add or modify the environment win2003 iis6.0 php5.2
The mysql account has the write and modification permission, but cannot write and modify on the php page. it can only be queried.
Please kindly advise

Reply to discussion (solution)

We recommend that you paste the code together with the error message.

We recommend that you paste the code together with the error message.
No error. on my local machine, I can go to the server to find out which php module or database file permission is not possible.

Open the php error prompt.
Display_errors = On in php. ini

Try another local server.

Open the php error prompt.
Display_errors = On in php. ini
This is open.

Open the php error prompt.
Display_errors = On in php. ini
I don't think it's an error. Do I have to have permission to write mysql files?

Yes locally. it indicates that the program is normal. Therefore, the server is not allowed. check whether the server has permissions first.

The program runs successfully.
All databases need to escape special characters. if you do not do this, problems may occur.

Yes locally. it indicates that the program is normal. Therefore, the server is not allowed. check whether the server has permissions first.

The program runs successfully.
All databases need to escape special characters. if you do not do this, problems may occur.
Other mysql account permissions do not know what permissions to check.
It can also be determined that it is not a special character.

Mysql account permissions are available
So please post the mysql. user table related records.

You can also determine whether it is not a special character.
Post the escape code.

Mysql account permissions are available
So please post the mysql. user table related records.

You can also determine whether it is not a special character.
Post the escape code.
You should have the permission to add and modify data in phpmyadmin.
I am using the most earthy template. php is actually a bit unintelligible.

static public function &Instance(){if ( null == self::$mInstance ){ $class = __CLASS__;self::$mInstance = new $class;}return self::$mInstance;}

I think this is the problem.

Insert into 'table'
SET 'email '= 'Email @ msn.com ',

Will it be [']?

What do you guess?
Echo mysql_error ();
Don't you know if there is a problem?

Output the inserted SQL statement in the browser and run it in the MySQL manager to check whether there are any problems or what errors are reported.

What do you guess?
Echo mysql_error ();
Don't you know if there is a problem?
Is not familiar with php

What do you guess?
Echo mysql_error ();
Don't you know if there is a problem?
The table is read-only.
Thank you for helping me solve the problem again. The admiration for you is like the endless rivers and rivers