$sql= "create temporary table yc_linshi (

                        img varchar(100) not null,

                         openid varchar(50) not null,

                          shopPrice decimal ,

                         goodsName varchar (100),

                         ptnum varchar (50))";

                $affected = Db::execute($sql);