开源信息发布页面:
复制内容到剪贴板
代码:
<?php
//PHP开源大全开源信息发布页面
require_once("./Sys_Config.inc.php");
require_once(SYS_PATH."/comm/lib_comm.inc.php");
$conn->debug = FALSE;
$smarty->caching = FALSE;
/*
if(!isset($_SESSION["userid"]) or $_SESSION["userid"]==""){
echo "<script>window.open('Administrator_Login.php','_self')</script>";
exit;
}
*/
// Display List Content
if (!isset($_REQUEST['id']) && empty($_REQUEST['id'])){
$arr = array();
$page = isset($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? $_REQUEST['page'] : 1;
$size = 25;
@require_once(SYS_PATH."/comm/Class.Page.inc.php");
NaviPage_cM('phpres_open', $size, 5, "1");
$sql = "SELECT * FROM `phpres_open` ORDER BY `id` DESC";
$res = $conn->SelectLimit($sql, $size, ($page - 1) * $size ) or die($conn->ErrorMsg());
while ($row = $res->FetchRow()){
$arr[$row['id']]['id'] = $row['id'];
$arr[$row['id']]['class'] = $row['class'];
$arr[$row['id']]['subject'] = substrgb($row['subject'], 0, 70);
$arr[$row['id']]['pubtime'] = $row['pubtime'];
}
$smarty->assign("SuperList", $arr);
}
if(isset($_REQUEST['submit']) || isset($_REQUEST['modify'])){
if(isset($_FILES['epic'])){
if($_FILES['epic']['name'][0] != ""){
/* 引入文件上传处理类 */
require_once(SYS_PATH."/comm/Class.FileUpLoad.inc.php");
/* 设置文件上传路径 */
$savePath = 'photos/';
$preFix = "phpres_php_open_project_".date('YmdHis'); //<--这里加长文件名
/* 序列化存储文件名 */
$_FILES['epic']['name'][0] = $preFix.$_FILES['epic']['name'][0];
$fileFormat = array('gif','jpg','jpge','png');
/* 无限上传/重写有效 */
$maxSize = 0;
$overwrite = 1;
/* 实例化文件上传类 */
$PreFix = new clsUpload( $savePath, $fileFormat, $maxSize, $overwrite);
$PreFix->setThumb(0);
/* 如果错误抛出异常 */
if (!$PreFix->run('epic',0))
echo $PreFix->errmsg()."<br>\n";
/* 得到存储路径 */
$epic_info = $PreFix->getInfo();
$pic_path = $epic_info[0]['saveName'];
}
/* 没有文件上传就空值 */
else
$pic_path = "";
}
$subject = $conn->qstr($_REQUEST['subject']);
$content = $_REQUEST['content'];
if (isset($_REQUEST['submit']) && !empty($_REQUEST['submit'])){
$html_path = date("YmdHis").".html";
$sql = 'INSERT INTO `phpres_open` (`class`, `subject`, `content`, `logo`, `homepage`, `download`, `license`, `pubtime`) VALUES (\''.$_REQUEST['class'].'\', '.$subject.', \''.$content.'\', \''.$pic_path.'\', \''.$_REQUEST[homepage].'\', \''.$_REQUEST[download].'\', \''.$_REQUEST[license].'\', NOW())';
$conn->Execute($sql) or die($conn->ErrorMsg());
$sql = "SELECT * FROM `phpres_open` ORDER BY `id` DESC LIMIT 1";
$res = $conn->GetRow($sql) or die($conn->ErrorMsg());
}
if (isset($_REQUEST['modify']) && !empty($_REQUEST['modify'])){
$ext = $pic_path == ""? "": ",`logo` = '$pic_path'";
$sql = "UPDATE `phpres_open` SET `class` = '".$_REQUEST['class']."', `subject` = $subject, `content` = '$content', `homepage` = '{$_REQUEST[homepage]}', `download` = '{$_REQUEST[download]}', `license` = '{$_REQUEST[license]}' $ext WHERE `id` = '$_REQUEST[id]' LIMIT 1";
$conn->Execute($sql) or die($conn->ErrorMsg());
$sql = "SELECT * FROM `phpres_open` WHERE `id` = '$_REQUEST[id]' LIMIT 1";
$res = $conn->GetRow($sql) or die($conn->ErrorMsg());
}
}
if(isset($_REQUEST['delete']) && $_REQUEST['delete'] != "" ){
foreach($ChinaShoes as $key=>$value) {
$sql = "DELETE FROM `phpres_open` WHERE `id` = '$value' LIMIT 1";
$res = $conn->Execute($sql) or die($conn->ErrorMsg());
}
if ($res) ShowMsg(PRE_RT, "Multifarious_open.php");
}
if(isset($_REQUEST['action']) && $_REQUEST['action'] == "delete" ){
$sql = "DELETE FROM `phpres_open` WHERE `id` = '$_REQUEST[id]' LIMIT 1";
$res = $conn->Execute($sql) or die($conn->ErrorMsg());
if ($res) ShowMsg(PRE_RT, "Multifarious_open.php");
}
// Update / Modify Res Std
if(isset($_REQUEST['id']) && !empty($_REQUEST['id'])){
$sql = "SELECT * FROM `phpres_open` WHERE `id` = '$_REQUEST[id]'";
$row = $conn->GetRow($sql) or die ($conn->ErrorMsg);
$smarty->assign("class", $row['class']);
$smarty->assign("subject", $row['subject']);
$smarty->assign("content", $row['content']);
$smarty->assign("homepage", $row['homepage']);
$smarty->assign("download", $row['download']);
$smarty->assign("license", $row['license']);
}
$smarty->display('administrator/Multifarious_open.tpl');
?>