쇼핑몰 파싱(스크래핑,크롤링) 하여 고도몰에 넣는 방법 - create_table_temp.php

\n"; }else{ echo "Error dropping table: ".mysqli_error($conn); } $sql="create table $tbl_name_temp( srl varchar(50) ,goodsNm varchar(500) ,create_at timestamp null default null ,updated_at timestamp null default null )"; echo "
\n".$sql; if(mysqli_query($conn, $sql)){ echo "
\nTable $tbl_name_temp created successfully"; }else{ echo "
\nError creating table: ".mysqli_error($conn); } $sql = "ALTER TABLE $tbl_name_temp ADD PRIMARY KEY (`srl`)"; echo "
\n".$sql; if(mysqli_query($conn, $sql)){ echo "
\nTable $tbl_name_temp setting Key successfully"; }else{ echo "
\nError setting key table: ".mysqli_error($conn); } mysqli_close($conn);