TP5 save语句保存不了
$goods->data($data, true);
$goods->save();
dump( $goods->getLastSql() );
打印sql语句
UPDATE tp_goods
SET goods_name
=‘男生手表1’,goods_country
=‘意呆利’,goods_sn
=‘TP0000238’,cat_id
=581,brand_id
=0,suppliers_id
=0,shop_price
=1000,market_price
=10000,original_img
=’’,weight
=0,volume
=0,template_id
=0,store_count
=100,keywords
=‘表’,virtual_indate
=0,virtual_limit
=0,virtual_sales_sum
=0,virtual_collect_sum
=0,goods_content
=’<p>拉拉</p>’,goods_type
=0,give_integral
=0,exchange_integral
=0 WHERE goods_id
= 238 AND goods_remark
= ‘防守打法’"
发现是where后面要改的值变成条件了,当然改不成功了
后来发现是数据库中goods_remark字段设置为主键了(可能是看数据库时不小心点上的),我这里把字段的主键直接取消了就好了