php - a mysql request, nothing happen? -


in php; got mysql request:

$q=@mysql_query("insert personnes(login,pass,user_email,logged_ip,created,user_first_name,user_last_name,user_organization,user_address1,user_address2,user_city,              user_country,user_zip,user_phone,userer_fax) values ('".mysql_escape_real_string($login)."', '".mysql_escape_real_string($pass)."', '".mysql_escape_real_string($user_mail)."',              '".mysql_escape_real_string($ip)."', '".mysql_escape_real_string( $dates)."', '".mysql_escape_real_string($first_name)."', '".mysql_escape_real_string($last_name)."',              '".mysql_escape_real_string($organisation)."', '".mysql_escape_real_string($address1)."', '".mysql_escape_real_string($address2)."', '".mysql_escape_real_string($city)."',              '".mysql_escape_real_string('france')."', '".mysql_escape_real_string($zip)."', '".mysql_escape_real_string($phone)."', '".mysql_escape_real_string($fax)."')"); 

well; use got troubles request, because of types ..etc; when have no error; nothing happens. put echo after request, never reached thank you

code should

$q=mysql_query("insert personnes(login,pass,user_email,logged_ip,created,user_first_name,user_last_name,user_organization,user_address1,user_address2,user_city,              user_country,user_zip,user_phone,userer_fax) values ('".mysql_real_escape_string($login)."', '".mysql_real_escape_string($pass)."', '".mysql_real_escape_string($user_mail)."',              '".mysql_real_escape_string($ip)."', '".mysql_real_escape_string( $dates)."', '".mysql_real_escape_string($first_name)."', '".mysql_real_escape_string($last_name)."',              '".mysql_real_escape_string($organisation)."', '".mysql_real_escape_string($address1)."', '".mysql_real_escape_string($address2)."', '".mysql_real_escape_string($city)."',              '".mysql_real_escape_string('france')."', '".mysql_real_escape_string($zip)."', '".mysql_real_escape_string($phone)."', '".mysql_real_escape_string($fax)."')"); 

note : mysql_* functions deprecated in 5.6 , removed in 7!!

deprecated of php 5.5 , removed in php 7


Comments

Popular posts from this blog

wireshark - USB mapping with python -

c++ - nodejs socket.io closes connection before upgrading to websocket -

Deploying Qt Application on Android is really slow? -