pbootcms使用技巧
pbootcms是与aspcms一家公司开发的企业网站系统，非常完美的企业网站系统，功能齐全，方便灵活，支持sqlite/mysql数据库
模板中支持简单的php语句
{php}echo 111+222;{/php}
数据库快速操作类 类似THINKPHP框架的方式 比较容易上手
引入命名空间
use core\basic\Model;
use core\basic\Db;
$a = Db::table('ay_content')->where('id=1')->find();
var_dump($a);
$model = new Model();
$r = $model->table('ay_content')->where('id=1')->find();
var_dump($r);
以上两种是等价的，第一种Db通过__callstatic静态魔术方法来调用Model类的方法
pbootcms导入其它数据库的信息
public function importold()
{
exit('已經導入新聞');
set_time_limit(0);
$data = json_decode('{"acode":"cn","scode":"16","subscode":"","title":"\u6807\u9898","titlecolor":"#333333","subtitle":"","filename":"","author":"admin","source":"\u672c\u7ad9","outlink":"","date":"2018-12-30 10:45:46","ico":"\/static\/upload\/image\/20181230\/1546137994102175.png","pics":"\/static\/upload\/image\/20181230\/1546138005227320.png,\/static\/upload\/image\/20181230\/1546138006814526.png","content":"<p>\u5185\u5bb9<\/p>","enclosure":"","keywords":"","description":"\u5185\u5bb9","sorting":255,"status":"1","istop":0,"isrecommend":0,"isheadline":0,"visits":0,"likes":0,"oppose":0,"create_user":"admin","update_user":"admin"}',true);
//var_dump($data);die();
//对应关系数组 文章 产品 单页
$relation = array(
1 => 16,
3 => 12,
6 => 38,
8 => 35,
10 => 18,
13 => 25,
15 => 31,
18 => 13,
20 => 14,
31 => 22,
33 => 27,
34 => 33
);
$i = 0;
//php访问mdb 数据库
//成功导入数据1611条
$connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=#Database#.mdb";
$connid = @odbc_connect($connstr,"","",SQL_CUR_USE_ODBC ) or die ("数据库连接错误!");
$sql = "select * from jtbc_articles";
$exec = odbc_exec($connid,$sql);
while($row = odbc_fetch_array($exec))
{
//重置这些内容 以免下一个
$data['ico'] = '';
$data['pics'] = '';
if(isset($relation[$row['a_class']]) && $row['a_id'] != 540) {
//有相应的栏目对应关系的话
$data['scode'] = $relation[$row['a_class']];
$data['title'] = escape_string(iconv('gb2312', 'utf-8', $row['a_topic']));
$data['content'] = iconv('gb2312', 'utf-8', $row['a_content']);
$data['content'] = escape_string(str_replace('{$->>repath}articles/common/upload/', '/static/upload/', $data['content']));
$data['description'] = mb_substr(strip_tags($data['content']), 0, 150, 'utf-8');
$data['date'] = $row['a_time'];
$data['visits'] = $row['a_count'];
if ($row['a_content_images'] != '') {
if (strpos($row['a_content_images'], '|') !== false) {
$data['pics'] = str_replace('|', ',', $row['a_content_images']);
$data['pics'] = str_replace('common/upload/', '/static/upload/', $data['pics']);
$data['ico'] = explode(',', $data['pics'])[0];
} else {
$data['ico'] = $row['a_content_images'];
}
}
//var_dump($data);
//exit();
if (! ! $id = $this->model->addContent($data)) {
$i++;
}
}
}
echo "成功导入数据" . $i . '条';
}
先断点获取到输入文章时的数组，每条导入数据只需要赋值需要变更的部分，注意每次重置数据项为空
碰到的大坑
php odbc连接 查询显示不完整问题
在php.ini里找到[ODBC] 下面有odbc.defaultlrl = 4096 你改正你想要设置 的大小就ok
Kernel文件解密 仅供学习
<?php
/**
* @copyright (C)2016-2099 Hnaoyun Inc.
* @license This is not a freeware, use is subject to license terms
* @author XingMeng
* @email hnxsh@foxmail.com
* @date 2018-08-09 16:03:55
* 翱云科技版权所有，除本授权文件其余代码均开源，未经许可擅自破解本文件将依法追究法律责任。
*/
namespace core\basic;
class Kernel
{
private static $controllerPath;
public static function run()
{
//self::license();
self::loadCache();
$path_info = self::getPathInfo();
$path_info = self::urlBlind($path_info);
$path_info = self::urlRoute($path_info);
$access_path = self::getAccessPath($path_info);
self::regAppPath($access_path);
self::loadComm();
self::loadController();
}
private static function getPathInfo()
{
if (isset($_SERVER['PATH_INFO']) && !mb_check_encoding($_SERVER['PATH_INFO'], 'utf-8')) {
$_SERVER['PATH_INFO'] = mb_convert_encoding($_SERVER['PATH_INFO'], 'UTF-8', 'GBK');
}
if (isset($_SERVER['PATH_INFO'])) {
$path_info = $_SERVER['PATH_INFO'];
} elseif (isset($_SERVER["REDIRECT_URL"])) {
$path_info = str_replace('/' . basename($_SERVER['SCRIPT_NAME']), '', $_SERVER['REDIRECT_URL']);
$path_info = str_replace(SITE_DIR, '', $path_info);
$_SERVER['PATH_INFO'] = $path_info;
} elseif (isset($_GET['s'])) {
$path_info = $_GET['s'];
} else {
$path_info = '';
}
if ($path_info) {
$pattern = '{^\/?([\x{4e00}-\x{9fa5}\w-\/\.' . Config::get('url_allow_char') . ']+?)?\/?$}u';
if (preg_match($pattern, $path_info)) {
$path_info = preg_replace($pattern, '$1', $path_info);
$url_html_suffix = Config::get('url_suffix');
if (substr($path_info, -strlen($url_html_suffix)) == $url_html_suffix) {
$path_info = substr($path_info, 0, -strlen($url_html_suffix));
}
} else {
error('您访问路径含有非法字符，防注入系统提醒您请勿尝试非法操作！');
}
}
return $path_info;
}
private static function urlBlind($pathInfo)
{
$path = '';
if (!!$domains = Config::get('app_domain_blind')) {
$server_name = str_replace(':' . $_SERVER['SERVER_PORT'], '', $_SERVER['HTTP_HOST']);
if (isset($domains[$server_name])) {
$path = $domains[$server_name];
}
}
if (defined('URL_BLIND')) {
if ($path) {
if (strpos($path, URL_BLIND) === false && strpos(URL_BLIND, $path) === false) {
error('系统配置的域名地址绑定与入口文件地址绑定冲突，请核对！');
} elseif (strpos($path, URL_BLIND) === false && strpos(URL_BLIND, $path) !== false) {
$path = URL_BLIND;
}
} else {
$path = URL_BLIND;
}
}
if ($path) {
$path = trim_slash($path) . '/' . $pathInfo;
} else {
$path = $pathInfo;
}
return $path;
}
private static function urlRoute($pathInfo)
{
if (!!$route = Config::get('url_route')) {
if (!$pathInfo && isset($route['/'])) {
return $route['/'];
}
foreach ($route as $key => $value) {
$key = str_replace('/', '\\/', trim_slash($key));
$reg = "{(.*\/|^)" . $key . "(\/.*|$)}Ui";
if (preg_match($reg, $pathInfo)) {
$value = trim_slash($value);
$pathInfo = preg_replace($reg, "$1$value$2", $pathInfo);
break;
}
}
}
return $pathInfo;
}
private static function getAccessPath($pathInfo)
{
$apps = Config::get('public_app', true);
if ($pathInfo) {
$path_info = trim_slash($pathInfo);
$path_array = explode('/', $path_info);
$path_count = count($path_array);
if ($path_count >= 3) {
$access_path['m'] = $path_array[0];
$access_path['c'] = $path_array[1];
$access_path['f'] = $path_array[2];
for ($i = 3; $i < $path_count; $i = $i + 2) {
if (isset($path_array[$i + 1])) {
$_GET[$path_array[$i]] = $path_array[$i + 1];
} else {
$_GET[$path_array[$i]] = null;
}
}
} elseif ($path_count == 2) {
$access_path['m'] = $path_array[0];
$access_path['c'] = $path_array[1];
} elseif ($path_count == 1) {
$access_path['m'] = $path_array[0];
}
}
if (!isset($access_path['m'])) {
$access_path['m'] = $apps[0];
}
if (!isset($access_path['c'])) {
$access_path['c'] = 'Index';
}
if (!isset($access_path['f'])) {
$access_path['f'] = 'index';
}
if (!in_array(strtolower($access_path['m']), $apps)) {
error('您访问的模块' . $access_path['m'] . '未开放,请核对后重试！');
}
return $access_path;
}
private static function regAppPath($accessPath)
{
define('M', strtolower($accessPath['m']));
self::$controllerPath = self::adjustController($accessPath['c']);
if (!!$pos = strrpos(self::$controllerPath, '/')) {
define('C', ucfirst(substr(self::$controllerPath, $pos + 1)));
self::$controllerPath = substr(self::$controllerPath, 0, $pos + 1) . ucfirst(substr(self::$controllerPath, $pos + 1));
} else {
define('C', ucfirst(self::$controllerPath));
self::$controllerPath = ucfirst(self::$controllerPath);
}
define('F', $accessPath['f']);
if (isset($_SERVER["REQUEST_URI"])) {
define('URL', $_SERVER["REQUEST_URI"]);
} else {
define('URL', $_SERVER["ORIG_PATH_INFO"] . '?' . $_SERVER["QUERY_STRING"]);
}
define('CORE_VERSION', Config::get('core_version'));
define('APP_CONTROLLER_PATH', APP_PATH . '/' . M . '/controller');
define('APP_MODEL_PATH', APP_PATH . '/' . M . '/model');
if (($tpl_dir = Config::get('tpl_dir')) && array_key_exists(M, $tpl_dir)) {
if (strpos($tpl_dir[M], ROOT_PATH) === false) {
define('APP_VIEW_PATH', ROOT_PATH . $tpl_dir[M]);
} else {
define('APP_VIEW_PATH', $tpl_dir[M]);
}
} else {
define('APP_VIEW_PATH', APP_PATH . '/' . M . '/view');
}
}
private static function adjustController($string)
{
$string = str_replace('.', '/', $string);
$string_arr = explode('_', $string);
if (count($string_arr) > 1) {
$count = count($string_arr);
for ($i = 1; $i < $count; $i++) {
$string_arr[$i] = ucfirst($string_arr[$i]);
}
$string = implode($string_arr);
}
return $string;
}
private static function loadComm()
{
Config::get('debug') ? Check::checkAppFile() : '';
$app_config = APP_PATH . '/' . M . '/config/config.php';
if (file_exists($app_config)) {
Config::assign($app_config);
}
define('APP_VERSION', Config::get('app_version'));
define('RELEASE_TIME', Config::get('release_time'));
if (M == 'api') {
if (!!$sid = request('sid')) {
session_id($sid);
session_start();
}
header("Access-Control-Allow-Origin: *");
} else {
if (!ini_get('session.auto_start') && !isset($_SESSION)) {
session_start();
}
Check::checkBs();
Check::checkOs();
}
}
private static function loadController()
{
$class_file = self::$controllerPath . 'Controller.php';
$class_file_path = APP_CONTROLLER_PATH . '/' . $class_file;
$class_name = '\\app\\' . M . '\\controller\\' . str_replace('/', '\\', self::$controllerPath) . 'Controller';
$function = F;
if (!file_exists($class_file_path)) {
header('HTTP/1.1 404 Not Found');
header('status: 404 Not Found');
$file_404 = ROOT_PATH . '/404.html';
if (file_exists($file_404)) {
require $file_404;
exit();
} else {
error('对不起，您访问的页面不存在，请核对后再试！');
}
}
if (!class_exists($class_name)) {
error('类' . $class_name . '不存在！类文件' . $class_file_path . '中无法找到！');
}
$app_function = APP_PATH . '/' . M . '/function/function.php';
if (file_exists($app_function)) {
require $app_function;
}
if (file_exists(APP_PATH . '/common/function.php')) {
require APP_PATH . '/common/function.php';
}
if (file_exists(APP_PATH . '/common/' . ucfirst(M) . 'Controller.php')) {
$comm_class_name = '\\app\\common\\' . ucfirst(M) . 'Controller';
$comm_class = new $comm_class_name();
}
$controller = new $class_name();
if (method_exists($class_name, $function)) {
if (strtolower($class_name) != strtolower($function)) {
$return = $controller->$function();
} else {
$return = $controller;
}
} else {
if (method_exists($class_name, '_empty')) {
$return = $controller->_empty();
} else {
error('方法不存在！' . M . '模块下控制器文件' . $class_file . '中不存在您调用的方法' . $function . '，可能正在开发中，请耐心等待！');
}
}
if ($return !== null) {
Response::handle($return);
}
}
private static function loadCache()
{
if (!Config::get('tpl_html_cache') || URL_BLIND == 'api') {
return;
}
$lg = isset($_COOKIE['lg']) ? cookie('lg') : '';
Config::get();
$config_file = RUN_PATH . '/config/' . md5('config' . $lg) . '.php';
if (!Config::assign($config_file)) {
return;
}
$lg = $lg ?: Config::get('lgs.0.acode');
if (Config::get('open_wap') && (is_mobile() || Config::get('wap_domain') == get_http_host())) {
$wap = 'wap';
} else {
$wap = '';
}
$cache_file = RUN_PATH . '/cache/' . md5($_SERVER["REQUEST_URI"] . $lg . $wap) . '.html';
if (file_exists($cache_file) && time() - filemtime($cache_file) < Config::get('tpl_html_cache_time')) {
ob_start();
include $cache_file;
$content = ob_get_contents();
ob_end_clean();
if (Config::get('gzip') && !headers_sent() && extension_loaded("zlib") && strstr($_SERVER["HTTP_ACCEPT_ENCODING"], "gzip")) {
$content = gzencode($content, 6);
header("Content-Encoding: gzip");
header("Vary: Accept-Encoding");
header("Content-Length: " . strlen($content));
}
echo $content;
exit();
}
}
private static function license()
{
if (URL_BLIND == 'admin') {
return;
}
if (!!$sn = Config::get('sn', true)) {
$host = $_SERVER['HTTP_HOST'];
$key = strtoupper(substr(md5(substr(sha1($host), 0, 10)), 10, 10));
$sip = isset($_SERVER['LOCAL_ADDR']) ? $_SERVER['LOCAL_ADDR'] : $_SERVER['SERVER_ADDR'];
if ($sip != '::1' && substr($sip, 0, 6) != '127.0.' && !in_array($key, $sn)) {
error('未匹配到本域名有效授权码，请到<a href="http://www.pbootcms.com" target="_blank">PbootCMS</a>官网获取，并填写到后台"全局配置>>配置参数"中。');
}
} else {
error('配置文件中授权码为空，请到<a href="http://www.pbootcms.com" target="_blank">PbootCMS</a>官网获取，并填写到后台"全局配置>>配置参数"中。');
}
}
}有子分类调用子分类 没有子分类显示同级分类
修改标签解析控制器方法 ParserController.php中的 paseSortLabel,添加case分支
case 'soncount':
$content = str_replace($matches[0][$i], count($this->model->getSubScodes($sort->scode)), $content);
break;将apps\home\model\ParserModel.php中的getSubScodes方法改为public
public function getSubScodes($scode)模板标签写法
<!--没有子类-->
{pboot:if({sort:soncount} == 1)}
<div class="module-inner">
<div class="t3_nav1_t nav1_color1">
<dl>
<dt>{sort:parentname}</dt>
<dd>Zibo Central Hospital</dd>
</dl>
</div>
<div class="module-ct t3_nav1_b">
<ul>
{pboot:nav num=100 parent={sort:pcode}}
<li class="item-399 {pboot:2if('[nav:scode]'=='{sort:scode}')}current active{/pboot:2if}"><a href="[nav:link]">[nav:name]</a>
</li>
{/pboot:nav}
</ul>
</div>
</div>
{else}
<div class="module-inner">
<div class="t3_nav1_t nav1_color1">
<dl>
<dt>{sort:name}</dt>
<dd>Zibo Central Hospital</dd>
</dl>
</div>
<div class="module-ct t3_nav1_b">
<ul>
{pboot:nav num=100 parent={sort:scode}}
<li class="item-399"><a href="[nav:link]">[nav:name]</a>
</li>
{/pboot:nav}
</ul>
</div>
</div>
{/pboot:if}自带分页条及样式
{page:bar}
/* 分页样式 */
.paging { margin-top: 32px; font-size: 14px; }
.paging > span { margin: auto 16px; }
.paging .page-numbar { margin: auto 0; }
.paging .page-numbar .page-num,
.paging .page-index,
.paging .page-pre,
.paging .page-next,
.paging .page-last { display: inline-block; margin: auto 4px; padding: 2px 12px; border: 1px solid #EEE; border-radius: 2px; }
.paging .page-numbar .page-num-current,
.paging .page-numbar .page-num:hover { border-color: #8667F7; color: #8667F7; }多语言网站
系统管理>数据区域添加区域，切换数据区域，设置相应的模板目录，为不同的语言建立不同的模板文件，添加栏目版块，添加内容，前台语言切换导航添加
