function createThread($title, $description)
{
require 'config.php';
$showId = getShowId($_GET['showTitle']);
$channelId = getChannelId($_GET['showTitle']);
$sql = $connect->query("INSERT INTO `topics` values('', '{$title}', '{$username}', '{$now}', '{$description}', '{$channelId}', '{$showId}', '')");
}
$count--;
}
//作业执行完毕，对结果进行入库
if ($content) {
$db = new MyDB();
if ($key == 'total') {
$valArr = explode("\t", $content);
$sql = "update xxx set detailpv={$valArr['0']},detailuv={$valArr['1']} where analysisdate='{$yesterday}' and xxx=0 and xxx=0";
//echo $sql . "\n";
$res = $db->query($sql);
} else {
if ($key == 'category') {
$lineArr = explode("\n", $content);
foreach ($lineArr as $line) {
$valArr = explode("\t", $line);
$channelId = getChannelId($valArr[0]);
if (-1 != $channelId) {
$sql = "update xxx set detailpv={$valArr['1']},detailuv={$valArr['2']} where analysisdate='{$yesterday}' and xxx={$channelId} and xxx=0";
//echo $sql . "\n";
$res = $db->query($sql);
}
}
}
}
$db->close();
}
}
$transport->close();
//返回频道对应的id号
function getChannelId($channel)
{
function createThread($title)
{
require 'config2.php';
$showId = getShowId($_GET['showTitle']);
$channelId = getChannelId($_GET['showTitle']);
$title = strip_tags($title);
$now = date('Y-m-d H:i:s');
//$title = mysqli_real_escape_string($connect, $title);
$username = $_SESSION['username'];
//$sql = $connect->query("INSERT INTO `topics` values('', '$title', '$username', '$now', '', '$channelId', '$showId', '', '0')");
//pdo
$sql = "INSERT INTO `topics` values('', :title, :username, :now, '', :channelId, :showId, '', '0')";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(":title", $title);
//more flexible then bindValue;
$stmt->bindParam(":username", $username);
$stmt->bindParam(":now", $now);
$stmt->bindParam(":channelId", $channelId);
$stmt->bindParam(":showId", $showId);
$stmt->execute();
}
function createPost($message)
{
require 'config2.php';
$username = $_SESSION['username'];
$dateTime = date('Y-m-d h:i:s');
$topicId = $_GET['threadId'];
$showId = getShowId(strip_tags($topicId));
$channelId = getChannelId($showId);
$message = strip_tags($message);
//pdo
$sql = "INSERT INTO `posts` VALUES('', :channelId, :topicId, :showId, :username, :message, :dateTime)";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(":channelId", $channelId);
//more flexible then bindValue;
$stmt->bindParam(":topicId", $topicId);
$stmt->bindParam(":username", $username);
$stmt->bindParam(":dateTime", $dateTime);
$stmt->bindParam(":message", $message);
$stmt->bindParam(":showId", $showId);
$stmt->execute();
}
