聯(lián)系官方銷售客服
1835022288
028-61286886
火車頭數(shù)據(jù)太多。使用官方和小黃人的發(fā)布接口太慢 找人開發(fā)了一個新的直接入庫MYSQL的PHP 有BUG。
集思廣益,寫個PHP直接入庫MYSQL 到xunruicms的mysql 我測試速度還可以一秒250+ 但是老ID對不上 和自動建立分表的時候 發(fā)布錯誤。。
下面這個是我寫的MYSQL直接來的還可以就是太麻煩
使用火車頭采集大量數(shù)據(jù)發(fā)布走后臺實在非常慢。我找人寫了一個數(shù)據(jù)庫。http://www.zbshanke.com/wenda/55485.html
我吧PHP源碼發(fā)在下面大家?guī)兔纯础?/p>
源碼丟到本地環(huán)境 或者你網(wǎng)站下面。接入到
目前遇到問題就是發(fā)布的4個表 對不齊。。。。
自動建內(nèi)容分表 報錯 如果有大牛 可以在下面留言
<?php
/***
* @Date 2021/06/01 3:07:00
* @Author qq 123
* @Copyright 本接口插件,未經(jīng)作者許可,禁止盜用,否則引起的任何不良后果請自行負(fù)責(zé)~
* @Ad 承接各種采集、發(fā)布、接口、插件等制作、開發(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']; //分類
$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)時間戳
//$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('分類必須為數(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);