报错:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '08022394106','PM000064' ,'0187-25', 'HDMI - micro HDMI (2.5M) ', '1', '福田 ' at line 1
$sql_sale=" INSERT INTO `amazonnew`.`1_sale_orders` ";
$sql_sale.="(`number` ,`order_id` ,`order_item_id`,`shipments` ,";
$sql_sale.=" `payments_date` ,`buyer_email` ,`buyer_name` ,`buyer_phone_number` ,";
$sql_sale.="`sku`,`item_code`,`product_name`,`quantity_purchased`,`recipient_name`,";
$sql_sale.="`ship_address_1`,`ship_address_2`,`ship_address_3`,`ship_state`,";
$sql_sale.="`ship_postal_code`,`ship_country`,`account`,`ship_city`,";
$sql_sale.="`delivery_areas`,`package_area`,`upload_date`)";
$sql_sale.=" VALUES ";
$sql_sale.="('$maxnum','$order_id','$or_it_id', '$shipments',";
$sql_sale.=" '$payments_date','$buyer_email', '$buyer_name','$buyer_phone',";
$sql_sale.="'$sku' ,'$item_code', '$product_name', '$quantity',";
$sql_sale.=" '$recipient_name', '$ship_address1', '$ship_address2','$ship_address3',";
$sql_sale.="'$ship_state' , '$ship_postal', '$ship_country', '$zhanghao',";
$sql_sale.=" '$ship_city','$delivery_areas','$package_area',now())";
要插入的内容
249-0810342-5892861 65494678305574 2013-10-13T13:12:31+00:00 2013-10-13T13:12:31+00:00 2013-10-13T13:43:13+00:00 2013-10-16T14:59:59+00:00 -3 [email protected] 福田 圭 08022394106 PM000064 XPERIA arc / acro / acroHD 対応 HDMI (Aタイプ) To micro HDMI (Dタイプ) ハイスピードイーサーネットケーブル 2.5m Ver 1.4 1 0 1 Standard 福田 圭 石垣市真栄里 261-4 KAIシーブリーズ2-C 沖縄県 907-0002 JP
就是那个“福田 圭”的原因,我改成123之后就正,报错显示"福田 "后面有两个乱码
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '08022394106','PM000064' ,'0187-25', 'HDMI - micro HDMI (2.5M) ', '1', '福田 ' at line 1
$sql_sale=" INSERT INTO `amazonnew`.`1_sale_orders` ";
$sql_sale.="(`number` ,`order_id` ,`order_item_id`,`shipments` ,";
$sql_sale.=" `payments_date` ,`buyer_email` ,`buyer_name` ,`buyer_phone_number` ,";
$sql_sale.="`sku`,`item_code`,`product_name`,`quantity_purchased`,`recipient_name`,";
$sql_sale.="`ship_address_1`,`ship_address_2`,`ship_address_3`,`ship_state`,";
$sql_sale.="`ship_postal_code`,`ship_country`,`account`,`ship_city`,";
$sql_sale.="`delivery_areas`,`package_area`,`upload_date`)";
$sql_sale.=" VALUES ";
$sql_sale.="('$maxnum','$order_id','$or_it_id', '$shipments',";
$sql_sale.=" '$payments_date','$buyer_email', '$buyer_name','$buyer_phone',";
$sql_sale.="'$sku' ,'$item_code', '$product_name', '$quantity',";
$sql_sale.=" '$recipient_name', '$ship_address1', '$ship_address2','$ship_address3',";
$sql_sale.="'$ship_state' , '$ship_postal', '$ship_country', '$zhanghao',";
$sql_sale.=" '$ship_city','$delivery_areas','$package_area',now())";
要插入的内容
249-0810342-5892861 65494678305574 2013-10-13T13:12:31+00:00 2013-10-13T13:12:31+00:00 2013-10-13T13:43:13+00:00 2013-10-16T14:59:59+00:00 -3 [email protected] 福田 圭 08022394106 PM000064 XPERIA arc / acro / acroHD 対応 HDMI (Aタイプ) To micro HDMI (Dタイプ) ハイスピードイーサーネットケーブル 2.5m Ver 1.4 1 0 1 Standard 福田 圭 石垣市真栄里 261-4 KAIシーブリーズ2-C 沖縄県 907-0002 JP
就是那个“福田 圭”的原因,我改成123之后就正,报错显示"福田 "后面有两个乱码
set names utf8;
再插入试试?
set names utf8