php - MySQL I can not write data into the database -


hello guys have problem inserting data in mysql database.i accepted project friend worked.

i make simple php test file , try insert in table _content_city. query executed bu no records in database column when check in phpmyadmin.

$handler = mysql_connect($server, $user, $pass); $database = mysql_select_db($dbname);  if(!$handler) :     die("faild connect mysql :" . mysql_error()); endif;  if(!$database) :    die("db name ". $dbname . " no exists " . mysql_error()); endif;   mysql_query("insert _content_grad (wishlist) values('blablabla') ") or die(mysql_error());     printf ("inserterd records: %d\n", mysql_affected_rows());

when execute code in browser have message inserterd records: 1 when check in phpmyadmin data no exist in column. dont know whay.

you guys can see image , u see column wishlist empty.

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

i check foreign_keys , remove foreign_keys , again dont work.

like test make new database name new_test_base , make table albums , column title , test execute php code , data inserted when check in phpmyadmin. problem in database, have full access , privilegies use root (all)

any solution fix this. thanks

the mysql_* range of functions have been depreciated , no longer reccomened use. use mysqli_* range of functions instead.

in code, put following line echo mysql_errno($handler) , should display latest error retuned mysql, mysqli version of function available.


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more