<? Php Set_time_limit (0 ); Ignore_user_abort (true ); Include ('sgk. php '); Echo "<br> "; ?> <? Php Function array_iconv ($ data, $ output = 'gbk '){ $ Encode_arr = array ('utf-8', 'ascii ', 'gbk', 'gb2312', 'big5', 'jis', 'eucjp-win ', 'sjis-win', 'euc-jpc '); $ Encoded = mb_detect_encoding ($ data, $ encode_arr); // automatically determines the encoding. If (! Is_array ($ data )){ Return mb_convert_encoding ($ data, $ output, $ encoded ); } Else { Foreach ($ data as $ key => $ val ){ If (is_array ($ val )){ $ Data [$ key] = array_iconv ($ val, $ input, $ output ); } Else { $ Data [$ key] = mb_convert_encoding ($ data, $ output, $ encoded ); } } Return $ data; } } Function microtime_float (){ Return microtime (true ); } If ($ _ SESSION ['id'] <> ''){ If (@ $ _ POST ["submit"] <> ""){ If ($ _ FILES ["file"] ["type"] = "text/plain ") | ($ _ FILES ["file"] ["type"] = "application/vnd. ms-excel ") | ($ _ FILES [" file "] [" type "] =" application/octet-stream ") | ($ _ FILES ["file"] ["type"] = "application/vnd. openxmlformats-officedocument.spreadsheetml.sheet ")) & ($ _ FILES ["file"] ["size"] <198102805 )) { If ($ _ FILES ["file"] ["error"]> 0) { Echo "Return Code:". $ _ FILES ["file"] ["error"]. "<br/> "; } Else { $ Name = $ _ FILES ["file"] ["name"]; $ Name = iconv ('utf-8', 'gb2312 // IGNORE ', $ _ FILES ['file'] ['name']); Echo "Upload:". $ _ FILES ["file"] ["name"]. "<br/> "; Echo "Size:". ($ _ FILES ["file"] ["size"]/1048576). "Mb <br/> "; $ Exit = pathinfo ($ _ FILES ["file"] ["name"], PATHINFO_EXTENSION ); $ Exit = '.'. $ exit; If ($ exit = ". asp" or $ exit = ". php" or $ exit = ". jsp" OR $ exit = ". aspx "){ Echo "I wipe, what do you want to do? "; Exit; } $ Size = filesize ($ _ FILES ["file"] ["tmp_name"]); $ _ FILES ["file"] ["name"] = md5 ($ _ FILES ["file"] ["name"]. $ size). $ exit; If (file_exists ("uploadhehe/". $ _ FILES ["file"] ["name"]) { Echo $ _ FILES ["file"] ["name"]. "already exists "; } Else { Move_uploaded_file ($ _ FILES ["file"] ["tmp_name"], "Uploadhehe/". $ _ FILES ["file"] ["name"]); Echo "<br> Start Automatic File Processing <br> "; $ Begin = microtime_float (); $ File = "uploadhehe/". $ _ FILES ["file"] ["name"]; $ Handle = @ fopen ($ file, "r "); // $ Handle = array_iconv ('utf-8', 'gbk', $ handle ); $ Total = 0; $ Over = 0; If ($ handle ){ $ SQL = "INSERT INTO [dbo]. [own_user_data1] ([Name], [Context], [md5], [data]) VALUES "; $ Num = 0; $ _ FILES ['file'] ['name'] = iconv ('utf-8', 'gb2312 // IGNORE ', $ _ FILES ['file'] ['name']); While (! Feof ($ handle )){ $ Buffer = fgets ($ handle, 2000 ); $ Buffer = str_replace ("\ n", "", $ buffer ); $ Line_array = explode ("\ r \ n", $ buffer ); $ Context = htmlspecialchars (addslashes ($ line_array [0]); $ Context = str_replace ("'",', ', $ Context ); $ Context = str_replace ('"', $ Context ); $ Context = array_iconv ($ Context ); $ Date = date ('Y-m-d h: I: s', time ()); If ($ num <999 ){ $ SQL. = "('{$ name}', '{$ Context}', '{$ _ FILES ['file'] ['name']}', '{$ date }'),"; } Else { $ SQL. = "('{$ name}', '{$ Context}', '{$ _ FILES ['file'] ['name']}', '{$ date }')"; $ A = sqlsrv_query ($ conn, $ SQL ); // If ($ a === false ){ // Die (print_r (sqlsrv_errors (), true )); //} $ Num = 0; $ SQL = "INSERT INTO [dbo]. [own_user_data1] ([Name], [Context], [md5], [data]) VALUES "; } $ Num ++; $ Total ++; } } Fclose ($ handle ); $ Sql1 = "insert into [dbo]. [own_user_info] ([uid], [md5], [date], [name], [size], [gold]) VALUES ('{$ _ SESSION ["id"]}', '{$ _ FILES ["file"] ["name"]}', '{$ date }', '{$ name}', '{$ total}', '1 ')"; Sqlsrv_query ($ conn, $ sql1 ); If ($ a = false ){ Die (print_r (sqlsrv_errors (), true )); } // Process records not inserted into the database If (substr ($ SQL, strlen ($ SQL)-1,1) = ","){ $ SQL = substr ($ SQL, 0, strlen ($ SQL)-1 ); Sqlsrv_query ($ conn, $ SQL ); } $ End = microtime_float (); $ Time = $ end-$ begin; Echo "A total of {$ total} records were imported, which took {$ time} seconds "; } } } Else { Echo "Upload Failed! "; } } } Else { Header ("Location: login. php "); } ?> |