MySQL我无法将数据写入数据库

Question

Hello guys i have problem with inserting data in mysql database.I accepted a project that my friend worked.

I make simple php test file and try to insert in table _content_city. query is successfully executed bu no records in database column when i check in phpmyadmin.

$handler = mysql_connect($server, $user, $pass);
$database = mysql_select_db($dbname);

if(!$handler) :
    die("Faild connect to MySQL :" . mysql_error());
endif;

if(!$database) :
   die("DB with name ". $dbname . " no exists " . mysql_error());
endif;

 mysql_query("INSERT INTO _content_grad (wishlist) VALUES('BlaBlaBla') ") or die(mysql_error());  

 printf ("Inserterd records: %d
", mysql_affected_rows());

When i execute this code in browser i have message Inserterd records: 1 But when i check in phpmyadmin that data no exist in column. I dont know whay.

You guys can see image and u will see column wishlist is empty.

http://img710.imageshack.us/img710/1852/5hfw.png

I check foreign_keys and remove all foreign_keys and again dont work.

Like test i make new database with name new_test_base and make table albums and column title and like test i execute my php code and all data is successfully inserted when i check in phpmyadmin. So problem is only in that database, i have full access and privilegies i use root (ALL)

Any solution to fix this. Thanks

Answer 1

The MySQL_* range of functions have been depreciated and are no longer reccomened for use. Use the MySQLi_* range of functions instead.

In your code, put the following line echo mysql_errno($handler) and it should display the latest error retuned by MySQL, a MySQLi version of this function is also available.