我的语句如下:
$model = Taobaoke::model()->findByAttributes(
[left]$attributes = array('num_iid' => $_POST['num_iid']));
if ($model !== null)
{
$model->attributes=$item;[/left]
$model->attributes=$items;
$model->delist_time=strtotime($model->delist_time);
$model->list_time=strtotime($model->list_time);
$modle->typeid=$_POST['typeid'];
$modle->channel = $_POST['channel'];
$modle->arcrank=$_POST['arcrank'];
$modle->litpic=$_POST['pic_url'];
$modle->item_location=$item['item_location']['state'].'-'.$item['item_location']['city'];
if($model->save()){
echo $modle->typeid.$modle->channel.$_POST['channel']."商品更新成功!";
}
}
上面的数据, $modle->typeid=$_POST[‘typeid’];
$modle->channel = $_POST['channel'];
$modle->arcrank=$_POST['arcrank'];
$modle->litpic=$_POST['pic_url'];这几个变量插入是空白,其他的内容都成功。
数据库数据如下:
CREATE TABLE IF NOT EXISTS `taobaoke` (
`aid` int(11) NOT NULL auto_increment,
`typeid` int(11) NOT NULL default '0',
`channel` smallint(6) NOT NULL default '0',
`arcrank` smallint(6) NOT NULL default '0',
`mid` mediumint(<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='8)' /> unsigned NOT NULL default '0',
`click` int(10) unsigned NOT NULL default '0',
`title` varchar(250) NOT NULL,
`senddate` int(11) NOT NULL default '0',
`litpic` varchar(250) NOT NULL default '',
`userip` varchar(15) NOT NULL default '',
`num_iid` varchar(20) NOT NULL default '0',
`price` float NOT NULL default '0',
`num` int(11) NOT NULL default '0',
`post_fee` float NOT NULL default '0',
`express_fee` float NOT NULL default '0',
`ems_fee` float NOT NULL default '0',
`click_url` varchar(250) NOT NULL default '',
`item_location` varchar(250) NOT NULL default '',
`nick` varchar(250) NOT NULL default '',
`desc` mediumtext,
`stuff_status` varchar(250) NOT NULL default '',
`list_time` int(11) NOT NULL default '0',
`delist_time` int(11) NOT NULL default '0',
`shop_click_url` varchar(250) NOT NULL,
PRIMARY KEY (`aid`),
KEY `typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- 导出表中的数据 `taobaoke`
--
INSERT INTO `taobaoke` (`aid`, `typeid`, `channel`, `arcrank`, `mid`, `click`, `title`, `senddate`, `litpic`, `userip`, `num_iid`, `price`, `num`, `post_fee`, `express_fee`, `ems_fee`, `click_url`, `item_location`, `nick`, `desc`, `stuff_status`, `list_time`, `delist_time`, `shop_click_url`) VALUES
(1, 0, 0, 0, 0, 0, '麦包包新款正品DUDU女包 韩版百搭包包头层牛皮两用包 粉蓝色包邮', 0, '', '', '7647011442', 198, 46, 20, 6, 20, 'http://s.click.taobao.com/t_8?e=7HZ6jHSTard0s17k%2Bc8pLA6%2B2avwIp5M%2B32gXOMdw8h5KWrQyaj0xKuxXUxMiOxHQX1bqB4bGscbTEERtjR7FUdDdWHQt3AW%2B37whWU%2BQ%2BUhBqzV7Nw%3D&p=mm_21577010_0_0&n=19&u=12141293', '', 'zjhsg1', '<p align="center">粉蓝色<img src="http://www.baobao178.com/apps/get_stock_image.php?goods_id=1101006814" align="middle"></p>\n<p align="center">桃红色<img src="http://www.baobao178.com/apps/get_stock_image.php?goods_id=1101006816" align="middle"></p>\n<p align="center"> 浅黄色<img src="http://www.baobao178.com/apps/get_stock_image.php?goods_id=1101006807" align="middle"></p>\n<p align="center">橘红色<img src="http://www.baobao178.com/apps/get_stock_image.php?goods_id=1101006813" align="middle"></p>\n<p align="center"> </p>\n<div style="margin-top: 20.0px;">\n<div>商品细节展示 浅黄色</div>\n<div>\n<table height="7356" cellspacing="0" cellpadding="0" width="700" align="center" border="0">\n\n<tr>\n<td><img height="839" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_01.gif" width="700"></td></tr>\n<tr>\n<td><img height="593" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_02.gif" width="700"></td></tr>\n<tr>\n<td><img height="480" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_03.gif" width="700"></td></tr>\n<tr>\n<td><img height="470" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_04.gif" width="700"></td></tr>\n<tr>\n<td><img height="490" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_05.gif" width="700"></td></tr>\n<tr>\n<td><img height="485" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_06.gif" width="700"></td></tr>\n<tr>\n<td><img height="742" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_07.gif" width="700"></td></tr>\n<tr>\n<td><img height="799" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_08.gif" width="700"></td></tr>\n<tr>\n<td><img height="695" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_09.gif" width="700"></td></tr>\n<tr>\n<td><img height="1340" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_10.gif" width="700"></td></tr>\n<tr>\n<td><img height="423" alt="" src="http://img.mbaobao.com/dudu/201001/06/11010068/14/1101006814_11.gif" width="700"></td></tr></table>\n<p>【名称】:[DUDU]浪漫之约系列头层牛皮两用包<br>【产地】:中国<br>【材料】:头层牛皮<br>【颜色】:浅黄色、粉红色、粉兰色、桃红色<br>【产地】:中国<br>【品质】:一等品<br>【重量】:0.84KG <br>【内部结构】:3个外袋,1个拉链夹层袋,1个内拉链袋,1个手机袋,1个证件袋<br>【尺寸】:包体宽:35cm,高:24cm,厚:12cm,肩带高约:20cm,斜挎带长约:133cm(可拆卸,可调节)<br>【实物点评】:图片仅做款式参考,产品说明为您了解此包的辅助说明,请以实物为准。<br></p>\n<p></p>\n<p></p></div></div>', 'new', 1287394388, 1287999188, 'http://s.click.taobao.com/t_8?e=7HZ5x%2BOzdZdCoWu4OmITpGre%2FVoVOxC5ccZTy6Zj0RzEAcqOOW3u3oPjDrtsqlwTNIIb0DcU5F%2BcC414tVsS%2F3WlHviOrRcT1Q%3D%3D&p=mm_21577010_0_0&n=19&u=12141293'),
(2, 0, 0, 0, 0, 0, '红贝伊人 时尚精品 灰色呢绒 秋款七分裤 望穿秋水 包邮8108', 0, '', '', '7083907714', 69, 16, 0, 0, 0, 'http://s.click.taobao.com/t_8?e=7HZ6jHSTarHavXoZZj6%2F7s2r0E0LY2rOY97Xt7O%2BsGxzqXPEPNdnCnsrQ8QnDkEQNck5dnKKF%2BbNVbfKX3gq3QZEs9TaZOdSs8JZrHXHCgU%2FQjrslU4%3D&p=mm_21577010_0_0&n=19&u=12141293', '', '红贝伊人hber', '<span style="userid: 446128337;rcid: 2496;">\n<div align="center">\n<table style="font-size: 12.0px;" cellspacing="0" align="center">\n\n<tr>\n<td style="border-right: #cccccc 1.0px solid;overflow: hidden;line-height: 26.0px;zoom: 1;height: 26.0px;" background="http://img.wonbao.net/markettool/layout/aaa7a3.gif" colspan="2"><span style="padding-left: 12.0px;font-weight: bold;font-size: 14.0px;float: left;color: #ffffff;">同类宝贝推荐</span><span style="padding-right: 2.0px;float: right;"><a href="http://app.taobao.com/app/detail.htm?platform_id=81&tadget_id=22006&type=88" target="_blank"><img title="谢谢亲给予我们的支持" style="vertical-align: bottom;" src="http://img.wonbao.net/markettool/wonbao.gif" border="0"></a></span><span style="padding-right: 2.0px;float: right;"><a href="http://shop62177902.taobao.com/" target="_blank">更多宝贝>></a></span></td></tr>\n<tr>\n<td style="border-right: #aaa7a3 1.0px solid;border-top: #aaa7a3 1.0px solid;border-left: #aaa7a3 1.0px solid;border-bottom: #aaa7a3 1.0px solid;" align="middle" colspan="2">\n<table style="border-collapse: separate;border-spacing: 10.0px 10.0px;" cellspacing="5">\n\n<tr valign="center">\n<td style="background-color: #ffffff;" valign="top" align="middle" width="162">\n<table style="text-align: center;">\n\n<tr>\n<td style="border-right: #cccccc 1.0px solid;border-top: #cccccc 1.0px solid;vertical-align: middle;border-left: #cccccc 1.0px solid;border-bottom: #cccccc 1.0px solid;" width="162" height="162"><a href="http://item.taobao.com/item.htm?id=6681677212" target="_blank"><img alt="" src="http://img06.taobaocdn.com/bao/uploaded/i6/T1gBlIXcFMXXcezgk3_050114.jpg_160x160.jpg" border="0"></a></td></tr>\n<tr style="font-size: 12.0px;height: 47.0px;" valign="top">\n<td><a title="点击查看宝贝详情" href="http://item.taobao.com/item.htm?id=6681677212" target="_blank">亏本秒杀 女裤 女生 七分裤 休闲裤 红贝伊人 正品 免运费1080-2</a></td></tr>\n<tr>\n<td>\n<div style="font-size: 12.0px;color: #4a4a4a;">原价:<strike>279.00元</strike></div>\n<div style="font-size: 12.0px;padding-top: 5.0px;"><strong style="font-weight: 700;color: #ff6600;"><img style="vertical-align: middle;" alt="" src="http://img.wonbao.net/markettool/itemPriceKind/1.gif" border="0"> 79.00元</strong></div></td></tr>\n<tr>\n<td><a href="http://item.taobao.com/item.htm?id=6681677212" target="_blank"><img alt="点击立刻购买" src="http://img.wonbao.net/markettool/buy/21.gif" border="0"></a></td></tr></table></td>\n<td style="background-color: #ffffff;" valign="top" align="middle" width="162">\n<table style="text-align: center;">\n\n<tr>\n<td style="border-right: #cccccc 1.0px solid;border-top: #cccccc 1.0px solid;vertical-align: middle;border-left: #cccccc 1.0px solid;border-bottom: #cccccc 1.0px solid;" width="162" height="162"><a href="http://item.taobao.com/item.htm?id=7060135416" target="_blank"><img alt="" src="http://img03.taobaocdn.com/bao/uploaded/i3/T1mlhIXlNNXXXfl_U3_051356.jpg_160x160.jpg" border="0"></a></td></tr>\n<tr style="font-size: 12.0px;height: 47.0px;" valign="top">\n<td><a title="点击查看宝贝详情" href="http://item.taobao.com/item.htm?id=7060135416" target="_blank">精品特卖 精致绣花蓝色牛仔裤 正品包邮1082-2</a></td></tr>\n<tr>\n<td>\n<div style="font-size: 12.0px;color: #4a4a4a;">原价:<strike>279.00元</strike></div>\n<div style="font-size: 12.0px;padding-top: 5.0px;"><strong style="font-weight: 700;color: #ff6600;"><img style="vertical-align: middle;" alt="" src="http://img.wonbao.net/markettool/itemPriceKind/1.gif" border="0"> 79.00元</strong></div></td></tr>\n<tr>\n<td><a href="http://item.taobao.com/item.htm?id=7060135416" target="_blank"><img alt="点击立刻购买" src="http://img.wonbao.net/markettool/buy/21.gif" border="0"></a></td></tr></table></td></tr></table>\n<div style="font-size: 12.0px;padding-bottom: 5.0px;"><a href="http://shop62177902.taobao.com/?search=y" target="_blank">查看所有宝贝</a></div></td></tr></table></div>\n<div style="rcid: 2496;"></div></span>\n<p style="font-size: 12.0pt;"><font style="font-size: 24.0pt;color: #f8dddd;font-family: 宋体;background-color: #ffffff;"><font face="幼圆"><font style="font-size: 14.0pt;color: #800000;font-family: 幼圆;background-color: #ffffff;"><strong> <font style="font-size: 14.0pt;color: #7f003f;font-family: 幼圆;background-color: #ffffff;">爱上灵感爱上你———红贝伊人</font> </strong><font style="font-size: 14.0pt;color: #7f003f;font-family: 幼圆;background-color: #ffffff;"></font><span style="font-size: 10.5pt;font-family: times new roman;mso-bidi-font-size: 12.0pt;mso-fareast-font-family: 宋体;mso-font-kerning: 1.0pt;mso-ansi-language: en-us;mso-fareast-language: zh-cn;mso-bidi-language: ar-sa;"><font style="font-size: 14.0pt;color: #7f003f;font-family: 幼圆;background-color: #ffffff;"><font color="#000000"> </font><br></font></span></font></font></font></p><strong></strong>\n<p style="font-size: 12.0pt;"><strong><span style="font-size: 10.5pt;font-family: times new roman;mso-bidi-font-size: 12.0pt;mso-fareast-font-family: 宋体;mso-font-kerning: 1.0pt;mso-ansi-language: en-us;mso-fareast-language: zh-cn;mso-bidi-language: ar-sa;"><strong><font face="楷体_GB2312" color="#cc33ff" size="5">全场包邮!买就送; 红贝伊人2010年秋冬季新款即将进店,实体店、网店同步,更多优惠,欢迎光临!</font></strong></span><br></strong></p>\n<p style="font-size: 12.0pt;" align="center"><font style="font-size: 12.0pt;"><strong></strong></font></p>\n<p style="font-size: 12.0pt;" align="center"><font style="font-size: 12.0pt;"><strong></strong></font></p>\n<p style="font-size: 12.0pt;" align="center"><font style="font-size: 12.0pt;"><strong><img style="border-right: #000000 0.0px solid;border-top: #000000 0.0px solid;border-left: #000000 0.0px solid;border-bottom: #000000 0.0px solid;" src="http://i847.photobucket.com/albums/ab40/Survivor_king/Photo/8108/_MG_9873.jpg" align="absMiddle"><img style="border-right: #000000 0.0px solid;border-top: #000000 0.0px solid;border-left: #000000 0.0px solid;border-bottom: #000000 0.0px solid;" src="http://i847.photobucket.com/albums/ab40/Survivor_king/Photo/8108/_MG_9875.jpg" align="absMiddle"><img style="border-right: #000000 0.0px solid;border-top: #000000 0.0px solid;border-left: #000000 0.0px solid;border-bottom: #000000 0.0px solid;" src="http://i847.photobucket.com/albums/ab40/Survivor_king/Photo/8108/_MG_9876.jpg" align="absMiddle"><img style="border-right: #000000 0.0px solid;border-top: #000000 0.0px solid;border-left: #000000 0.0px solid;border-bottom: #000000 0.0px solid;" src="http://i847.photobucket.com/albums/ab40/Survivor_king/Photo/8108/_MG_9877.jpg" align="absMiddle"><img style="border-right: #000000 0.0px solid;border-top: #000000 0.0px solid;border-left: #000000 0.0px solid;border-bottom: #000000 0.0px solid;" src="http://i847.photobucket.com/albums/ab40/Survivor_king/Photo/8108/_MG_9878.jpg" align="absMiddle"><img style="border-right: #000000 0.0px solid;border-top: #000000 0.0px solid;border-left: #000000 0.0px solid;border-bottom: #000000 0.0px solid;" src="http://i847.photobucket.com/albums/ab40/Survivor_king/Photo/8108/_MG_9879.jpg" align="absMiddle"><img style="border-right: #000000 0.0px solid;border-top: #000000 0.0px solid;border-left: #000000 0.0px solid;border-bottom: #000000 0.0px solid;" src="http://i847.photobucket.com/albums/ab40/Survivor_king/Photo/8108/1.jpg" align="absMiddle"><img style="border-right: #000000 0.0px solid;border-top: #000000 0.0px solid;border-left: #000000 0.0px solid;border-bottom: #000000 0.0px solid;" src="http://i847.photobucket.com/albums/ab40/Survivor_king/Photo/8108/2.jpg" align="absMiddle"></strong></font></p>\n<p style="font-size: 12.0pt;" align="center"><font style="font-size: 12.0pt;"><strong></strong></font></p>\n<p style="font-size: 12.0pt;" align="center"><font style="font-size: 12.0pt;"><strong></strong></font></p>\n<p style="font-size: 12.0pt;"><br></p>\n<p style="font-size: 12.0pt;" align="center"><img src="http://img07.taobaocdn.com/imgextra/i7/446128337/T2aa8lXoVbXXXXXXXX_!!446128337.jpg"></p>\n<p style="font-size: 12.0pt;" align="center"><img height="387" src="http://img05.taobaocdn.com/imgextra/i5/446128337/T2Hq4lXcXcXXXXXXXX_!!446128337.jpg" width="728"></p>\n<div align="center"><img src="http://img5.wal8.com/img5/hber123/s/1286692280_1744097846.gif" align="middle"></div>\n<div align="center"><img src="http://img5.wal8.com/img5/hber123/s/1286692280_587087041.gif" align="middle"></div>\n<div align="center"><img src="http://img5.wal8.com/img5/hber123/s/1286692280_371320250.gif" align="middle"></div>\n<div align="center"><img src="http://img5.wal8.com/img5/hber123/s/1286692280_1935084596.gif" align="middle"></div>\n<div align="center"><img src="http://img5.wal8.com/img5/hber123/s/1286692281_772189203.gif" align="middle"></div>\n<div align="center"> </div>\n<div align="center"> </div><font style="color: #bf00bf;">红贝伊人女裤是香港九都服饰旗下著名女裤品牌,2002年通过ISO9001:2000质量管理体系认证,2006年4月“九都”荣获中国著名品牌。红贝伊人女裤源于“中国女裤之都”郑州二七,中国女裤看郑州。红贝伊人与世界女裤十大品牌中的梦舒雅M?SUYA 、 娅丽达、逸阳ESEY 同为郑州十大品牌女裤、专业女裤品牌。红贝伊人女裤承诺以优质的产品和精美的设计面向全球女裤消费者。</font><br><br><br>\n<p></p>。', 'new', 1284975188, 1285579988, 'http://s.click.taobao.com/t_8?e=7HZ5x%2BOzcB3FXdwrMAlc3SzO86F8%2FSJttGk61eQmmpYjdogtUlFs8%2BKd1oYSQOr1PEQ%2FQu%2FgddUKnsYEiXSJCFMmRG6Rhm6NgQ%3D%3D&p=mm_21577010_0_0&n=19&u=12141293'),
(3, 0, 0, 0, 0, 0, '【两件包邮】2010秋装新品清纯淑女泡泡袖时尚短外套w959#', 0, '', '', '7252037826', 49.9, 195, 6, 6, 13, 'http://s.click.taobao.com/t_8?e=7HZ6jHSTarOhbhHDFWopVW931EeV94QrZaxuYgqzBszNba5KIWnLyPPv0zx1bMbh38sAFt9y6cLXs5ikdX7Mr5jBT6tft0R2BEyGmx9FKWJp4rR3xg%3D%3D&p=mm_21577010_0_0&n=19&u=12141293', '', '靠近鱼de猫', '<img src="http://m2.wangdian8.com/l/s.gif"> \n<p>简要介绍 <br> <br>泡泡袖 单排扣 无里衬 <br> <br>详细说明 <br> <br>颜色:图色</p>\n<p><br>面料:棉,均码</p>\n<p><br>单件重量:0.15kG</p>\n<p><br>尺码: 肩宽:26。胸围:89。衣长:44。袖长:51CM</p>\n<p><br>*以上均为平铺测量,如有微差 实属正常* <br> <br> </p>\n<p style="text-align: center;"><img alt="" src="http://img.maifou.net/ica/13/2759/8880_1281511428718580165_gallery_38759_789.jpg" border="1"></p>\n<p style="text-align: center;"> </p>\n<p style="text-align: center;"><img alt="" src="http://img.maifou.net/ica/13/2759/8880_1281511428858736265_gallery_38759_789.jpg" border="1"></p>\n<p style="text-align: center;"> </p>\n<p style="text-align: center;"><img alt="" src="http://img.maifou.net/ica/13/2759/8880_1281511428602362000_gallery_38759_789.jpg" border="1"></p>\n<p style="text-align: center;"> </p>\n<p style="text-align: center;"><img alt="" src="http://img.maifou.net/ica/13/2759/8880_1281511428726676745_gallery_38759_789.jpg" border="1"></p>\n<p style="text-align: center;"><img alt="" src="http://img.maifou.net/ica/13/2759/8880_1281511428870642891_gallery_38759_789.jpg" border="1"></p>\n<p> </p>\n<p> </p>', 'new', 1284370388, 1284975188, 'http://s.click.taobao.com/t_8?e=7HZ5x%2BOzfPtsmEpef%2BbuPnqJLZV%2FV9iSHPYnZkhhs9uU6DTafcr24t7E3P4MPgZwsdfC0x1Io0FVjLpq20pjW6uLnQ4RobYm&p=mm_21577010_0_0&n=19&u=12141293');