聯(lián)系官方銷(xiāo)售客服
1835022288
028-61286886
火車(chē)頭數(shù)據(jù)太多。使用官方和小黃人的發(fā)布接口太慢 找人開(kāi)發(fā)了一個(gè)新的直接入庫(kù)MYSQL的PHP 有BUG。
集思廣益,寫(xiě)個(gè)PHP直接入庫(kù)MYSQL 到xunruicms的mysql 我測(cè)試速度還可以一秒250+ 但是老ID對(duì)不上 和自動(dòng)建立分表的時(shí)候 發(fā)布錯(cuò)誤。。
下面這個(gè)是我寫(xiě)的MYSQL直接來(lái)的還可以就是太麻煩
使用火車(chē)頭采集大量數(shù)據(jù)發(fā)布走后臺(tái)實(shí)在非常慢。我找人寫(xiě)了一個(gè)數(shù)據(jù)庫(kù)。http://223987.com/wenda/55485.html
我吧PHP源碼發(fā)在下面大家?guī)兔纯础?/p>
源碼丟到本地環(huán)境 或者你網(wǎng)站下面。接入到
目前遇到問(wèn)題就是發(fā)布的4個(gè)表 對(duì)不齊。。。。
自動(dòng)建內(nèi)容分表 報(bào)錯(cuò) 如果有大牛 可以在下面留言
<?php
/***
* @Date 2021/06/01 3:07:00
* @Author qq 123
* @Copyright 本接口插件,未經(jīng)作者許可,禁止盜用,否則引起的任何不良后果請(qǐng)自行負(fù)責(zé)~
* @Ad 承接各種采集、發(fā)布、接口、插件等制作、開(kāi)發(fā)和教學(xué),以及網(wǎng)站建設(shè)優(yōu)化等,歡迎合作~
**/
error_reporting(E_ALL^E_WARNING^E_NOTICE);
header("Content-type: text/html; charset=utf-8");
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "123";
$dbname = "123";
$conn = mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
if(!$conn){
die("connection failed: ".mysqli_connect_error($conn));
}
$catid = $_POST['catid']; //分類(lèi)
$title = $_POST['title']; //標(biāo)題
$thumb = $_POST['thumb']; //縮略圖
$keywords = $_POST['keywords']; //關(guān)鍵詞
$description = $_POST['description']; //描述
$url = $_POST['url']; //url地址
$content = $_POST['content']; //內(nèi)容
$addtime = time(); //[系統(tǒng)時(shí)間戳
//$wz = isset($_POST['wz'])?$_POST['wz']:'wz';
$f = fopen('./num.txt', 'r');
$num = fread($f, '10');
fclose($f);
$table = 'dr_1_wz_data_'.$num;
if(!$title){die('標(biāo)題不得為空');}
#if (!is_numeric($catid)){die('分類(lèi)必須為數(shù)字');}
#if (!is_numeric($catid)){$catid = 12);}
// 1
$sql = "INSERT INTO dr_1_wz (id, catid, title, thumb, keywords, description, hits, uid, author, status, url, link_id, tableid, inputip, inputtime, updatetime, displayorder) VALUES (NULL, '$catid', '$title', '$thumb', '$keywords', '$description', '0', '1', 'admin', '9', '$url', '0', '$num', '127.0.0.1', '$addtime', '$addtime', '0')";
if(!db($conn, $sql, 'insert')){die("failed:1");}
// 2
$anid = mysqli_insert_id($conn);
# 建表
if ($anid%99999 == 0){
$num += 1;
$table = 'dr_1_wz_data_'.$num;
$sql = 'create table $table like dr_1_wz_data_0';
$f = fopen('./num.txt', 'w');
fwrite($f, $num);
fclose($f);
}
$sql = "INSERT INTO ".$table." (id, uid, catid, content) VALUES ($anid, '1', '$catid', '$content')";
if(!db($conn, $sql, 'insert')){die("failed:2");}
// 3
$sql = "INSERT INTO dr_1_share_index (id, mid) VALUES (NULL, 'wz')";
if(!db($conn, $sql, 'insert')){die("failed:3");}
// 4
$sql = "INSERT INTO dr_1_wz_index (id, uid, catid, status, inputtime) VALUES (NULL, '1', '$catid', '9', '$addtime')";
if(!db($conn, $sql, 'insert')){die("failed:4");}
echo("perfect");
//db function
function db($conn,$sql,$type){
$resource = mysqli_query($conn,$sql);
if($type == 'select'){
$row = mysqli_fetch_array($resource,MYSQLI_ASSOC);
return $row;
}else{
return $resource;
}
}
mysqli_close($conn);