empty(trim($str))报错原因

本文介绍了在使用PHP进行编程时,遇到的一个关于empty()和trim()函数组合使用的陷阱。通过对比两种不同的if条件语句,解释了为什么直接将trim()函数的结果作为empty()函数的参数会导致致命错误。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

最近写程序的时候发现一个这样的问题,一个if判断如下:

[php]
if (!empty(trim($ch_url))) { ... }
[/php]

执行程序报出如下错误:

[code]
Fatal error: Can't use function return value in write context in ...
[/code]


调整为如下形式则不报错误

[php]
$ch_url = trim($ch_url);
if (!empty($ch_url)) { ... }
[/php]

经过查询php手册,发现两个函数的使用方法为:

[php]
bool empty( mixed var );
string trim( string str [, string charlist] );
[/php]

错误就出现在这里了,原来empty()接收的是参数是一个变量,而trim()返回值为字符串,所以报错
看来手册还要多看啊.细节决定成败

转自:http://blog.zol.com.cn/2344/article_2343549.html
<?php /** * 鸿宇多用户商城 模版类 * ============================================================================ * 版权所有 2005-2010 鸿宇多用户商城科技有限公司,并保留所有权利。 * 网站地址: http://bbs.hongyuvip.com; * ---------------------------------------------------------------------------- * 仅供学习交流使用,如需商用请购买正版版权。鸿宇不承担任何法律责任。 * 踏踏实实做事,堂堂正正做人。 * ============================================================================ * $Author: liuhui $ * $Id: cls_template.php 17063 2010-03-25 06:35:46Z liuhui $ */ class cls_template { var $template_dir = ''; var $cache_dir = ''; var $compile_dir = ''; var $cache_lifetime = 3600; // 缓存更新时间, 默认 3600 秒 var $direct_output = false; var $caching = false; var $template = array(); var $force_compile = false; var $_var = array(); var $_echash = '554fcae493e564ee0dc75bdf2ebf94ca'; var $_foreach = array(); var $_current_file = ''; var $_expires = 0; var $_errorlevel = 0; var $_nowtime = null; var $_checkfile = true; var $_foreachmark = ''; var $_seterror = 0; var $_temp_key = array(); // 临时存放 foreach 里 key 的数组 var $_temp_val = array(); // 临时存放 foreach 里 item 的数组 function __construct() { $this->cls_template(); } function cls_template() { $this->_errorlevel = error_reporting(); $this->_nowtime = time(); if (defined('EC_CHARSET')) { $charset = EC_CHARSET; } else { $charset = 'utf-8'; } header('Content-type: text/html; charset='.$charset); } /** * 注册变量 * * @access public * @param mix $tpl_var * @param mix $value * * @return void */ function assign($tpl_var, $value = '') { if (is_array($tpl_var)) { foreach ($tpl_var AS $key => $val) { if ($key != '') { $this->_var[$key] = $val; } } } else { if ($tpl_var != '') { $this->_var[$tpl_var] = $value; } } } /** * 显示页面函数 * * @access public * @param string $filename * @param sting $cache_id * * @return void */ function display($filename, $cache_id = '') { $this->_seterror++; error_reporting(E_ALL ^ E_NOTICE); $this->_checkfile = false; $out = $this->fetch($filename, $cache_id); if (strpos($out, $this->_echash) !== false) { $k = explode($this->_echash, $out); foreach ($k AS $key => $val) { if (($key % 2) == 1) { $k[$key] = $this->insert_mod($val); } } $out = implode('', $k); } error_reporting($this->_errorlevel); $this->_seterror--; echo $out; } /** * 处理模板文件 * * @access public * @param string $filename * @param sting $cache_id * * @return sring */ function fetch($filename, $cache_id = '') { if (!$this->_seterror) { error_reporting(E_ALL ^ E_NOTICE); } $this->_seterror++; if (strncmp($filename,'str:', 4) == 0) { $out = $this->_eval($this->fetch_str(substr($filename, 4))); } else { if ($this->_checkfile) { if (!file_exists($filename)) { $filename = $this->template_dir . '/' . $filename; } } else { $filename = $this->template_dir . '/' . $filename; } if ($this->direct_output) { $this->_current_file = $filename; $out = $this->_eval($this->fetch_str(file_get_contents($filename))); } else { if ($cache_id && $this->caching) { $out = $this->template_out; } else { if (!in_array($filename, $this->template)) { $this->template[] = $filename; } $out = $this->make_compiled($filename); if ($cache_id) { $cachename = basename($filename, strrchr($filename, '.')) . '_' . $cache_id; $data = serialize(array('template' => $this->template, 'expires' => $this->_nowtime + $this->cache_lifetime, 'maketime' => $this->_nowtime)); $out = str_replace("\r", '', $out); while (strpos($out, "\n\n") !== false) { $out = str_replace("\n\n", "\n", $out); } $hash_dir = $this->cache_dir . '/' . substr(md5($cachename), 0, 1); if (!is_dir($hash_dir)) { mkdir($hash_dir); } if (file_put_contents($hash_dir . '/' . $cachename . '.php', '<?php exit;?>' . $data . $out, LOCK_EX) === false) { trigger_error('can\'t write:' . $hash_dir . '/' . $cachename . '.php'); } $this->template = array(); } } } } $this->_seterror--; if (!$this->_seterror) { error_reporting($this->_errorlevel); } return $out; // 返回html数据 } /** * 编译模板函数 * * @access public * @param string $filename * * @return sring 编译后文件地址 */ function make_compiled($filename) { $name = $this->compile_dir . '/' . basename($filename) . '.php'; if ($this->_expires) { $expires = $this->_expires - $this->cache_lifetime; } else { $filestat = @stat($name); $expires = $filestat['mtime']; } $filestat = @stat($filename); if ($filestat['mtime'] <= $expires && !$this->force_compile) { if (file_exists($name)) { $source = $this->_require($name); if ($source == '') { $expires = 0; } } else { $source = ''; $expires = 0; } } if ($this->force_compile || $filestat['mtime'] > $expires) { $this->_current_file = $filename; $source = $this->fetch_str(file_get_contents($filename)); if (file_put_contents($name, $source, LOCK_EX) === false) { trigger_error('can\'t write:' . $name); } $source = $this->_eval($source); } return $source; } /** * 处理字符串函数 * * @access public * @param string $source * * @return sring */ function fetch_str($source) { if (!defined('ECS_ADMIN')) { $source = $this->smarty_prefilter_preCompile($source); } return preg_replace_callback("/{([^\}\{\n]*)}/", function($matches) { return $this->select($matches[1]); }, $source); } /** * 判断是否缓存 * * @access public * @param string $filename * @param sting $cache_id * * @return bool */ function is_cached($filename, $cache_id = '') { $cachename = basename($filename, strrchr($filename, '.')) . '_' . $cache_id; if ($this->caching == true && $this->direct_output == false) { $hash_dir = $this->cache_dir . '/' . substr(md5($cachename), 0, 1); if ($data = @file_get_contents($hash_dir . '/' . $cachename . '.php')) { $data = substr($data, 13); $pos = strpos($data, '<'); $paradata = substr($data, 0, $pos); $para = @unserialize($paradata); if ($para === false || $this->_nowtime > $para['expires']) { $this->caching = false; return false; } $this->_expires = $para['expires']; $this->template_out = substr($data, $pos); foreach ($para['template'] AS $val) { $stat = @stat($val); if ($para['maketime'] < $stat['mtime']) { $this->caching = false; return false; } } } else { $this->caching = false; return false; } return true; } else { return false; } } /** * 处理{}标签 * * @access public * @param string $tag * * @return sring */ function select($tag) { $tag = stripslashes(trim($tag)); if (empty($tag)) { return '{}'; } elseif ($tag{0} == '*' && substr($tag, -1) == '*') // 注释部分 { return ''; } elseif ($tag{0} == '$') // 变量 { return '<?php echo ' . $this->get_val(substr($tag, 1)) . '; ?>'; } elseif ($tag{0} == '/') // 结束 tag { switch (substr($tag, 1)) { case 'if': return '<?php endif; ?>'; break; case 'foreach': if ($this->_foreachmark == 'foreachelse') { $output = '<?php endif; unset($_from); ?>'; } else { array_pop($this->_patchstack); $output = '<?php endforeach; endif; unset($_from); ?>'; } $output .= "<?php \$this->pop_vars();; ?>"; return $output; break; case 'literal': return ''; break; default: return '{'. $tag .'}'; break; } } else { /* 代码修改_start By bbs.hongyuvip.com */ //$tag_sel = array_shift(explode(' ', $tag)); $tag_arr_www_ecshop68_com = explode(' ', $tag); $tag_sel = array_shift($tag_arr_www_ecshop68_com); /* 代码修改_end By bbs.hongyuvip.com */ switch ($tag_sel) { case 'if': return $this->_compile_if_tag(substr($tag, 3)); break; case 'else': return '<?php else: ?>'; break; case 'elseif': return $this->_compile_if_tag(substr($tag, 7), true); break; case 'foreachelse': $this->_foreachmark = 'foreachelse'; return '<?php endforeach; else: ?>'; break; case 'foreach': $this->_foreachmark = 'foreach'; if(!isset($this->_patchstack)) { $this->_patchstack = array(); } return $this->_compile_foreach_start(substr($tag, 8)); break; case 'assign': $t = $this->get_para(substr($tag, 7),0); if ($t['value']{0} == '$') { /* 如果传进来的值是变量,就不用用引号 */ $tmp = '$this->assign(\'' . $t['var'] . '\',' . $t['value'] . ');'; } else { $tmp = '$this->assign(\'' . $t['var'] . '\',\'' . addcslashes($t['value'], "'") . '\');'; } // $tmp = $this->assign($t['var'], $t['value']); return '<?php ' . $tmp . ' ?>'; break; case 'include': $t = $this->get_para(substr($tag, 8), 0); return '<?php echo $this->fetch(' . "'$t[file]'" . '); ?>'; break; case 'insert_scripts': $t = $this->get_para(substr($tag, 15), 0); return '<?php echo $this->smarty_insert_scripts(' . $this->make_array($t) . '); ?>'; break; case 'create_pages': $t = $this->get_para(substr($tag, 13), 0); return '<?php echo $this->smarty_create_pages(' . $this->make_array($t) . '); ?>'; break; case 'insert' : $t = $this->get_para(substr($tag, 7), false); $exported_t = var_export($t, true); $exported_t = preg_replace_callback("/(\'\\$[^,]+)/", function($matches) { return stripslashes(trim($matches[1], '\'')); }, $exported_t); $out = "<?php \n" . '$k = ' . $exported_t . ";\n"; $out .= 'echo $this->_echash . $k[\'name\'] . \'|\' . serialize($k) . $this->_echash;' . "\n?>"; return $out; break; $out .= 'echo $this->_echash . $k[\'name\'] . \'|\' . serialize($k) . $this->_echash;' . "\n?>"; return $out; break; case 'literal': return ''; break; case 'cycle' : $t = $this->get_para(substr($tag, 6), 0); return '<?php echo $this->cycle(' . $this->make_array($t) . '); ?>'; break; case 'html_options': $t = $this->get_para(substr($tag, 13), 0); return '<?php echo $this->html_options(' . $this->make_array($t) . '); ?>'; break; case 'html_select_date': $t = $this->get_para(substr($tag, 17), 0); return '<?php echo $this->html_select_date(' . $this->make_array($t) . '); ?>'; break; case 'html_radios': $t = $this->get_para(substr($tag, 12), 0); return '<?php echo $this->html_radios(' . $this->make_array($t) . '); ?>'; break; case 'html_select_time': $t = $this->get_para(substr($tag, 12), 0); return '<?php echo $this->html_select_time(' . $this->make_array($t) . '); ?>'; break; default: return '{' . $tag . '}'; break; } } } /** * 处理smarty标签中的变量标签 * * @access public * @param string $val * * @return bool */ function get_val($val) { if (strrpos($val, '[') !== false) { $val = preg_replace("/\[([^\[\]]*)\]/eis", "'.'.str_replace('$','\$','\\1')", $val); } if (strrpos($val, '|') !== false) { $moddb = explode('|', $val); $val = array_shift($moddb); } if (empty($val)) { return ''; } if (strpos($val, '.$') !== false) { $all = explode('.$', $val); foreach ($all AS $key => $val) { $all[$key] = $key == 0 ? $this->make_var($val) : '['. $this->make_var($val) . ']'; } $p = implode('', $all); } else { $p = $this->make_var($val); } if (!empty($moddb)) { foreach ($moddb AS $key => $mod) { $s = explode(':', $mod); switch ($s[0]) { case 'escape': $s[1] = trim($s[1], '"'); if ($s[1] == 'html') { $p = 'htmlspecialchars(' . $p . ')'; } elseif ($s[1] == 'url') { $p = 'urlencode(' . $p . ')'; } elseif ($s[1] == 'decode_url') { $p = 'urldecode(' . $p . ')'; } elseif ($s[1] == 'quotes') { $p = 'addslashes(' . $p . ')'; } elseif ($s[1] == 'u8_url') { if (EC_CHARSET != 'utf-8') { $p = 'urlencode(ecs_iconv("' . EC_CHARSET . '", "utf-8",' . $p . '))'; } else { $p = 'urlencode(' . $p . ')'; } } else { $p = 'htmlspecialchars(' . $p . ')'; } break; case 'nl2br': $p = 'nl2br(' . $p . ')'; break; case 'default': $s[1] = $s[1]{0} == '$' ? $this->get_val(substr($s[1], 1)) : "'$s[1]'"; $p = 'empty(' . $p . ') ? ' . $s[1] . ' : ' . $p; break; case 'truncate': $p = 'sub_str(' . $p . ",$s[1])"; break; case 'strip_tags': $p = 'strip_tags(' . $p . ')'; break; default: # code... break; } } } return $p; } /** * 处理去掉$的字符串 * * @access public * @param string $val * * @return bool */ function make_var($val) { if (strrpos($val, '.') === false) { if (isset($this->_var[$val]) && isset($this->_patchstack[$val])) { $val = $this->_patchstack[$val]; } $p = '$this->_var[\'' . $val . '\']'; } else { $t = explode('.', $val); $_var_name = array_shift($t); if (isset($this->_var[$_var_name]) && isset($this->_patchstack[$_var_name])) { $_var_name = $this->_patchstack[$_var_name]; } if ($_var_name == 'smarty') { $p = $this->_compile_smarty_ref($t); } else { $p = '$this->_var[\'' . $_var_name . '\']'; } foreach ($t AS $val) { $p.= '[\'' . $val . '\']'; } } return $p; } /** * 处理insert外部函数/需要include运行的函数的调用数据 * * @access public * @param string $val * @param int $type * * @return array */ function get_para($val, $type = 1) // 处理insert外部函数/需要include运行的函数的调用数据 { $pa = $this->str_trim($val); foreach ($pa AS $value) { if (strrpos($value, '=')) { list($a, $b) = explode('=', str_replace(array(' ', '"', "'", '"'), '', $value)); if ($b{0} == '$') { if ($type) { eval('$para[\'' . $a . '\']=' . $this->get_val(substr($b, 1)) . ';'); } else { $para[$a] = $this->get_val(substr($b, 1)); } } else { $para[$a] = $b; } } } return $para; } /** * 判断变量是否被注册并返回值 * * @access public * @param string $name * * @return mix */ function &get_template_vars($name = null) { if (empty($name)) { return $this->_var; } elseif (!empty($this->_var[$name])) { return $this->_var[$name]; } else { $_tmp = null; return $_tmp; } } /** * 处理if标签 * * @access public * @param string $tag_args * @param bool $elseif * * @return string */ function _compile_if_tag($tag_args, $elseif = false) { preg_match_all('/\-?\d+[\.\d]+|\'[^\'|\s]*\'|"[^"|\s]*"|[\$\w\.]+|!==|===|==|!=|<>|<<|>>|<=|>=|&&|\|\||\(|\)|,|\!|\^|=|&|<|>|~|\||\%|\+|\-|\/|\*|\@|\S/', $tag_args, $match); $tokens = $match[0]; // make sure we have balanced parenthesis $token_count = array_count_values($tokens); if (!empty($token_count['(']) && $token_count['('] != $token_count[')']) { // $this->_syntax_error('unbalanced parenthesis in if statement', E_USER_ERROR, __FILE__, __LINE__); } for ($i = 0, $count = count($tokens); $i < $count; $i++) { $token = &$tokens[$i]; switch (strtolower($token)) { case 'eq': $token = '=='; break; case 'ne': case 'neq': $token = '!='; break; case 'lt': $token = '<'; break; case 'le': case 'lte': $token = '<='; break; case 'gt': $token = '>'; break; case 'ge': case 'gte': $token = '>='; break; case 'and': $token = '&&'; break; case 'or': $token = '||'; break; case 'not': $token = '!'; break; case 'mod': $token = '%'; break; default: if ($token[0] == '$') { $token = $this->get_val(substr($token, 1)); } break; } } if ($elseif) { return '<?php elseif (' . implode(' ', $tokens) . '): ?>'; } else { return '<?php if (' . implode(' ', $tokens) . '): ?>'; } } /** * 处理foreach标签 * * @access public * @param string $tag_args * * @return string */ function _compile_foreach_start($tag_args) { $attrs = $this->get_para($tag_args, 0); $arg_list = array(); $from = $attrs['from']; if(isset($this->_var[$attrs['item']]) && !isset($this->_patchstack[$attrs['item']])) { $this->_patchstack[$attrs['item']] = $attrs['item'] . '_' . str_replace(array(' ', '.'), '_', microtime()); $attrs['item'] = $this->_patchstack[$attrs['item']]; } else { $this->_patchstack[$attrs['item']] = $attrs['item']; } $item = $this->get_val($attrs['item']); if (!empty($attrs['key'])) { $key = $attrs['key']; $key_part = $this->get_val($key).' => '; } else { $key = null; $key_part = ''; } if (!empty($attrs['name'])) { $name = $attrs['name']; } else { $name = null; } $output = '<?php '; $output .= "\$_from = $from; if (!is_array(\$_from) && !is_object(\$_from)) { settype(\$_from, 'array'); }; \$this->push_vars('$attrs[key]', '$attrs[item]');"; if (!empty($name)) { $foreach_props = "\$this->_foreach['$name']"; $output .= "{$foreach_props} = array('total' => count(\$_from), 'iteration' => 0);\n"; $output .= "if ({$foreach_props}['total'] > 0):\n"; $output .= " foreach (\$_from AS $key_part$item):\n"; $output .= " {$foreach_props}['iteration']++;\n"; } else { $output .= "if (count(\$_from)):\n"; $output .= " foreach (\$_from AS $key_part$item):\n"; } return $output . '?>'; } /** * 将 foreach 的 key, item 放入临时数组 * * @param mixed $key * @param mixed $val * * @return void */ function push_vars($key, $val) { if (!empty($key)) { array_push($this->_temp_key, "\$this->_vars['$key']='" .$this->_vars[$key] . "';"); } if (!empty($val)) { array_push($this->_temp_val, "\$this->_vars['$val']='" .$this->_vars[$val] ."';"); } } /** * 弹出临时数组的最后一个 * * @return void */ function pop_vars() { $key = array_pop($this->_temp_key); $val = array_pop($this->_temp_val); if (!empty($key)) { eval($key); } } /** * 处理smarty开头的预定义变量 * * @access public * @param array $indexes * * @return string */ function _compile_smarty_ref(&$indexes) { /* Extract the reference name. */ $_ref = $indexes[0]; switch ($_ref) { case 'now': $compiled_ref = 'time()'; break; case 'foreach': array_shift($indexes); $_var = $indexes[0]; $_propname = $indexes[1]; switch ($_propname) { case 'index': array_shift($indexes); $compiled_ref = "(\$this->_foreach['$_var']['iteration'] - 1)"; break; case 'first': array_shift($indexes); $compiled_ref = "(\$this->_foreach['$_var']['iteration'] <= 1)"; break; case 'last': array_shift($indexes); $compiled_ref = "(\$this->_foreach['$_var']['iteration'] == \$this->_foreach['$_var']['total'])"; break; case 'show': array_shift($indexes); $compiled_ref = "(\$this->_foreach['$_var']['total'] > 0)"; break; default: $compiled_ref = "\$this->_foreach['$_var']"; break; } break; case 'get': $compiled_ref = '$_GET'; break; case 'post': $compiled_ref = '$_POST'; break; case 'cookies': $compiled_ref = '$_COOKIE'; break; case 'env': $compiled_ref = '$_ENV'; break; case 'server': $compiled_ref = '$_SERVER'; break; case 'request': $compiled_ref = '$_REQUEST'; break; case 'session': $compiled_ref = '$_SESSION'; break; default: // $this->_syntax_error('$smarty.' . $_ref . ' is an unknown reference', E_USER_ERROR, __FILE__, __LINE__); break; } array_shift($indexes); return $compiled_ref; } function smarty_insert_scripts($args) { static $scripts = array(); $arr = explode(',', str_replace(' ', '', $args['files'])); $str = ''; foreach ($arr AS $val) { if (in_array($val, $scripts) == false) { $scripts[] = $val; if ($val{0} == '.') { $str .= '<script type="text/javascript" src="' . $val . '"></script>'; } else { $str .= '<script type="text/javascript" src="js/' . $val . '"></script>'; } } } return $str; } function smarty_prefilter_preCompile($source) { $file_type = strtolower(strrchr($this->_current_file, '.')); $tmp_dir = 'themes/' . $GLOBALS['_CFG']['template'] . '/'; // 模板所在路径 /** * 处理模板文件 */ if ($file_type == '.dwt') { /* 将模板中所有library替换为链接 */ $pattern = '/<!--\s#BeginLibraryItem\s\"\/(.*?)\"\s-->.*?<!--\s#EndLibraryItem\s-->/se'; $replacement = "'{include file='.strtolower('\\1'). '}'"; class ShopLoader { public function renderPage($ html) { return preg_replace_callback( '/\{shop_(\d+)\}/', function($ matches) use ($ this) { // ✅ 关键修复:传递 $ this $ shopId = (int)$ matches[1]; return $ this->fetchShopHtml($ shopId); }, $ html ); } private function fetchShopHtml($ id) { // 从数据库或API获取店铺数据 return "<div class='shop'>店铺 #$ id</div>"; } } /* 检查有无动态库文件,如果有为其赋值 */ $dyna_libs = get_dyna_libs($GLOBALS['_CFG']['template'], $this->_current_file); if ($dyna_libs) { foreach ($dyna_libs AS $region => $libs) { $pattern = '/<!--\\s*TemplateBeginEditable\\sname="'. $region .'"\\s*-->(.*?)<!--\\s*TemplateEndEditable\\s*-->/s'; if (preg_match($pattern, $source, $reg_match)) { $reg_content = $reg_match[1]; /* 生成匹配字串 */ $keys = array_keys($libs); $lib_pattern = ''; foreach ($keys AS $lib) { $lib_pattern .= '|' . str_replace('/', '\/', substr($lib, 1)); } $lib_pattern = '/{include\sfile=(' . substr($lib_pattern, 1) . ')}/'; /* 修改$reg_content中的内容 */ $GLOBALS['libs'] = $libs; $reg_content = preg_replace_callback($lib_pattern, 'dyna_libs_replace', $reg_content); /* 用修改过的内容替换原来当前区域中内容 */ $source = preg_replace($pattern, $reg_content, $source); } } } /* 在头部加入版本信息 */ $source = preg_replace('/<head>/i', "<head>\r\n<meta name=\"Generator\" content=\"" . APPNAME .' ' . VERSION . "\" />", $source); /* By bbs.hongyuvip.com 代码增加_start */ $source = preg_replace('/<head>/i', "<head>\r\n<base href=\"". $GLOBALS['ecs']->url() ."\" />", $source); /* By bbs.hongyuvip.com 代码增加_end */ /* 修正css路径 */ $source = preg_replace('/(<link\shref=["|\'])(?:\.\/|\.\.\/)?(css\/)?([a-z0-9A-Z_]+\.css["|\']\srel=["|\']stylesheet["|\']\stype=["|\']text\/css["|\'])/i','\1' . $tmp_dir . '\2\3', $source); /* 修正js目录下js的路径 */ $source = preg_replace('/(<script\s(?:type|language)=["|\']text\/javascript["|\']\ssrc=["|\'])(?:\.\/|\.\.\/)?(js\/[a-z0-9A-Z_\-\.]+\.(?:js|vbs)["|\']><\/script>)/', '\1' . $tmp_dir . '\2', $source); /* 更换编译模板的编码类型 */ $source = preg_replace('/<meta\shttp-equiv=["|\']Content-Type["|\']\scontent=["|\']text\/html;\scharset=(?:.*?)["|\'][^>]*?>\r?\n?/i', '<meta http-equiv="Content-Type" content="text/html; charset=' . EC_CHARSET . '" />' . "\n", $source); } /** * 处理库文件 */ elseif ($file_type == '.lbi') { /* 去除meta */ $source = preg_replace('/<meta\shttp-equiv=["|\']Content-Type["|\']\scontent=["|\']text\/html;\scharset=(?:.*?)["|\']>\r?\n?/i', '', $source); } /* 替换文件编码头部 */ if (strpos($source, "\xEF\xBB\xBF") !== FALSE) { $source = str_replace("\xEF\xBB\xBF", '', $source); } $pattern = array( '/<!--[^>|\n]*?({.+?})[^<|{|\n]*?-->/', // 替换smarty注释 '/<!--[^<|>|{|\n]*?-->/', // 替换不换行的html注释 '/(href=["|\'])\.\.\/(.*?)(["|\'])/i', // 替换相对链接 '/((?:background|src)\s*=\s*["|\'])(?:\.\/|\.\.\/)?(images\/.*?["|\'])/is', // 在images前加上 $tmp_dir '/((?:background|background-image):\s*?url\()(?:\.\/|\.\.\/)?(images\/)/is', // 在images前加上 $tmp_dir '/([\'|"])\.\.\//is', // 以../开头的路径全部修正为空 ); $replace = array( '\1', '', '\1\2\3', '\1' . $tmp_dir . '\2', '\1' . $tmp_dir . '\2', '\1' ); return preg_replace($pattern, $replace, $source); } function insert_mod($name) // 处理动态内容 { list($fun, $para) = explode('|', $name); $para = unserialize($para); $fun = 'insert_' . $fun; return $fun($para); } function str_trim($str) { /* 处理'a=b c=d k = f '类字符串,返回数组 */ while (strpos($str, '= ') != 0) { $str = str_replace('= ', '=', $str); } while (strpos($str, ' =') != 0) { $str = str_replace(' =', '=', $str); } return explode(' ', trim($str)); } function _eval($content) { ob_start(); eval('?' . '>' . trim($content)); $content = ob_get_contents(); ob_end_clean(); return $content; } function _require($filename) { ob_start(); include $filename; $content = ob_get_contents(); ob_end_clean(); return $content; } function html_options($arr) { $selected = $arr['selected']; if ($arr['options']) { $options = (array)$arr['options']; } elseif ($arr['output']) { if ($arr['values']) { foreach ($arr['output'] AS $key => $val) { $options["{$arr[values][$key]}"] = $val; } } else { $options = array_values((array)$arr['output']); } } if ($options) { foreach ($options AS $key => $val) { $out .= $key == $selected ? "<option value=\"$key\" selected>$val</option>" : "<option value=\"$key\">$val</option>"; } } return $out; } function html_select_date($arr) { $pre = $arr['prefix']; if (isset($arr['time'])) { if (intval($arr['time']) > 10000) { $arr['time'] = gmdate('Y-m-d', $arr['time'] + 8*3600); } $t = explode('-', $arr['time']); $year = strval($t[0]); $month = strval($t[1]); $day = strval($t[2]); } $now = gmdate('Y', $this->_nowtime); if (isset($arr['start_year'])) { if (abs($arr['start_year']) == $arr['start_year']) { $startyear = $arr['start_year']; } else { $startyear = $arr['start_year'] + $now; } } else { $startyear = $now - 3; } if (isset($arr['end_year'])) { if (strlen(abs($arr['end_year'])) == strlen($arr['end_year'])) { $endyear = $arr['end_year']; } else { $endyear = $arr['end_year'] + $now; } } else { $endyear = $now + 3; } $out = "<select name=\"{$pre}Year\">"; for ($i = $startyear; $i <= $endyear; $i++) { $out .= $i == $year ? "<option value=\"$i\" selected>$i</option>" : "<option value=\"$i\">$i</option>"; } if ($arr['display_months'] != 'false') { $out .= "</select> <select name=\"{$pre}Month\">"; for ($i = 1; $i <= 12; $i++) { $out .= $i == $month ? "<option value=\"$i\" selected>" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>" : "<option value=\"$i\">" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>"; } } if ($arr['display_days'] != 'false') { $out .= "</select> <select name=\"{$pre}Day\">"; for ($i = 1; $i <= 31; $i++) { $out .= $i == $day ? "<option value=\"$i\" selected>" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>" : "<option value=\"$i\">" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>"; } } return $out . '</select>'; } function html_radios($arr) { $name = $arr['name']; $checked = $arr['checked']; $options = $arr['options']; $out = ''; foreach ($options AS $key => $val) { $out .= $key == $checked ? "<input type=\"radio\" name=\"$name\" value=\"$key\" checked> {$val} " : "<input type=\"radio\" name=\"$name\" value=\"$key\"> {$val} "; } return $out; } function html_select_time($arr) { $pre = $arr['prefix']; if (isset($arr['time'])) { $arr['time'] = gmdate('H-i-s', $arr['time'] + 8*3600); $t = explode('-', $arr['time']); $hour = strval($t[0]); $minute = strval($t[1]); $second = strval($t[2]); } $out = ''; if (!isset($arr['display_hours'])) { $out .= "<select name=\"{$pre}Hour\">"; for ($i = 0; $i <= 23; $i++) { $out .= $i == $hour ? "<option value=\"$i\" selected>" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>" : "<option value=\"$i\">" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>"; } $out .= "</select> "; } if (!isset($arr['display_minutes'])) { $out .= "<select name=\"{$pre}Minute\">"; for ($i = 0; $i <= 59; $i++) { $out .= $i == $minute ? "<option value=\"$i\" selected>" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>" : "<option value=\"$i\">" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>"; } $out .= "</select> "; } if (!isset($arr['display_seconds'])) { $out .= "<select name=\"{$pre}Second\">"; for ($i = 0; $i <= 59; $i++) { $out .= $i == $second ? "<option value=\"$i\" selected>" . str_pad($i, 2, '0', STR_PAD_LEFT) . "</option>" : "<option value=\"$i\">$i</option>"; } $out .= "</select> "; } return $out; } function cycle($arr) { static $k, $old; $value = explode(',', $arr['values']); if ($old != $value) { $old = $value; $k = 0; } else { $k++; if (!isset($old[$k])) { $k = 0; } } echo $old[$k]; } function make_array($arr) { $out = ''; foreach ($arr AS $key => $val) { if ($val{0} == '$') { $out .= $out ? ",'$key'=>$val" : "array('$key'=>$val"; } else { $out .= $out ? ",'$key'=>'$val'" : "array('$key'=>'$val'"; } } return $out . ')'; } function smarty_create_pages($params) { extract($params); if (empty($page)) { $page = 1; } if (!empty($count)) { $str = "<option value='1'>1</option>"; $min = min($count - 1, $page + 3); for ($i = $page - 3 ; $i <= $min ; $i++) { if ($i < 2) { continue; } $str .= "<option value='$i'"; $str .= $page == $i ? " selected='true'" : ''; $str .= ">$i</option>"; } if ($count > 1) { $str .= "<option value='$count'"; $str .= $page == $count ? " selected='true'" : ''; $str .= ">$count</option>"; } } else { $str = ''; } return $str; } } ?> class ShopLoader { public function renderPage($ html) { return preg_replace_callback( '/\{shop_(\d+)\}/', function($ matches) use ($ this) { // ✅ 关键修复:传递 $ this $ shopId = (int)$ matches[1]; return $ this->fetchShopHtml($ shopId); }, $ html ); } private function fetchShopHtml($ id) { // 从数据库或API获取店铺数据 return "<div class='shop'>店铺 #$ id</div>"; } } 前端报错 1068行 Fatal error: Class declarations may not be nested in /www/wwwroot/szrengjing.com/includes/cls_template.php on line 1068
最新发布
07-15
/** * @notes 京东收派服务费明细导入(优化版本) * @notes 技术核心优势在于通过分块读取和分批处理,将原本可能导致内存溢出的大数据导入任务,转化为多个小而可控的操作单元,从而在处理超大型 Excel 文件时保持稳定性 * @notes 几十上百万的excel表格可能导入效率会慢 但是很稳定 不至于报错502或者超时等错误... * @notes 如果遇到上百万的excel表格请同步设置nginx的如下配置: * 代理相关超时配置(2个小时或者更长) * proxy_connect_timeout 7200; * proxy_read_timeout 7200; * proxy_send_timeout 7200; * fastcgi相关超时配置(2个小时或者更长) * fastcgi_connect_timeout 7200; * fastcgi_read_timeout 7200; * fastcgi_send_timeout 7200; * 可以确保虽然慢但是稳定的导入! * @return Json * @author 胡军 */ public function importExcel(): Json { // 设置脚本执行时间无限制,避免大数据处理超时 set_time_limit(0); // 设置脚本最大内存使用量为2GB,处理大文件时避免内存溢出 ini_set('memory_limit', '2048M'); // 获取请求参数(包含上传的文件信息) $params = $this->request->param(); // 验证文件是否上传 if (empty($params["file"])) { return $this->fail('请上传要导入文件'); } // 定义Excel表头与数据库字段的映射关系 $titleArr = [ '商家编号' => 'merchant_code', '业务单号' => 'business_order_number', '平台订单号' => 'platform_order_number', '商家订单号' => 'merchant_order_number', '退回件关联运单号' => 'return_waybill_number', '店铺名称' => 'shop_name', '下单时间' => 'order_time', '始发省' => 'origin_province', '始发市' => 'origin_city', '目的省' => 'destination_province', '目的市' => 'destination_city', '计费重量' => 'billing_weight', '实际重量(kg)' => 'actual_weight_kg', '实际体积(cm3)' => 'actual_volume_cm3', '首重单价' => 'first_weight_price', '续重单价' => 'continued_weight_price', '包裹/耗材数量' => 'package_material_quantity', '销售平台订单号' => 'sales_platform_order_number', '费用类型' => 'fee_type', '原始金额' => 'original_amount', '折扣/促销金额' => 'discount_promotion_amount', '计费时间' => 'billing_time', '结算金额' => 'settlement_amount', '签收时间' => 'sign_time', '商品编码' => 'product_code', '商品名称' => 'product_name' ]; try { // 构建上传文件的完整路径 $path = app()->getRootPath() . "public/" . $params['file']; // 1. 创建Excel读取器并设置为只读取数据模式(优化内存) $reader = IOFactory::createReaderForFile($path); $reader->setReadDataOnly(true); // 2. 获取工作表基本信息(总行数和最大列字母),避免加载整个文件 $worksheetInfo = $reader->listWorksheetInfo($path); $totalRows = $worksheetInfo[0]['totalRows']; $highestColumn = $worksheetInfo[0]['lastColumnLetter']; // 3. 读取表头行(仅加载第一行数据) $chunkFilter = new ChunkReadFilter(); $chunkFilter->setRows(1, 1); $reader->setReadFilter($chunkFilter); $spreadsheet = $reader->load($path); $sheet = $spreadsheet->getSheet(0); $title = $sheet->rangeToArray('A1:' . $highestColumn . '1', null, true, true, true)[1]; // 释放不再使用的Spreadsheet对象,减少内存占用 $spreadsheet->disconnectWorksheets(); unset($spreadsheet); // 检查表头是否存在 if (empty($title)) { throw new \Exception('Excel表头为空'); } // 初始化数据库模型和计数器 $model = new DeliveryPrimaryRegionsItemizationModel(); //TODO:根据自身mysql所在服务的性能来控制批量插入大小 不然报错或者导入很慢 该值需要反复测验找到最合适的大小 $insertBatchSize = 2000; // 数据库插入批次大小 $total = 0; // 总记录数 $success = 0; // 成功处理记录数 $failedBatches = []; // 失败批次记录 $batchData = []; // 批次数据临时存储 $processedRows = 0; // 已处理行数 // 4. 分块处理Excel数据,每次处理$chunkSize行 //TODO:根据自身服务器性能来决定每次分块读取excel表格数据的条数 不然报错或者导入很慢 该值需要反复测验找到最合适的大小 $chunkSize = 5000; // 每次加载5000行 $chunkFilter = new ChunkReadFilter(); $reader->setReadFilter($chunkFilter); // 循环处理每个数据块 for ($startRow = 2; $startRow <= $totalRows; $startRow += $chunkSize) { $endRow = min($startRow + $chunkSize - 1, $totalRows); $chunkFilter->setRows($startRow, $chunkSize); // 5. 加载当前数据块 $spreadsheet = $reader->load($path); $sheet = $spreadsheet->getSheet(0); // 6. 处理当前块中的每一行数据 for ($row = $startRow; $row <= $endRow; $row++) { // 获取当前行数据 $rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, null, true, true, true)[$row]; $item = []; // 将Excel列名映射为数据库字段名 // 将Excel列名映射为数据库字段名 foreach ($rowData as $colIndex => $value) { $colName = $title[$colIndex] ?? ''; if ($colName && isset($titleArr[$colName])) { $field = $titleArr[$colName]; $rawValue = trim($value ?? ''); // 原始值去除首尾空格 // 处理decimal类型字段 $decimalFields = [ 'billing_weight', 'theoretical_weight', 'weight_rounded', 'weight_difference', 'actual_weight_kg', 'actual_volume_cm3', 'first_weight_price', 'continued_weight_price', 'original_amount', 'discount_promotion_amount', 'settlement_amount', 'verification_difference', 'theoretical_billing', 'theoretical_difference', 'non_cross_warehouse_fee', 'cross_warehouse_difference', 'continued_weight_price2' ]; if (in_array($field, $decimalFields)) { // 空值处理:空字符串/空格 → 转为null(需数据库允许null)或0 if ($rawValue === '') { $item[$field] = null; // 若数据库不允许null,可改为0 } // 非数值处理:过滤为0(或记录错误日志) elseif (!is_numeric($rawValue)) { // 可选:记录错误行号和内容,方便排查 // $this->recordError($row, $colName, "非数值内容: {$rawValue}"); $item[$field] = 0; } // 数值格式化:保留2位小数(根据数据库字段定义调整) else { $item[$field] = round((float)$rawValue, 2); } } // 其他字段保持原处理(如字符串、整数等) else { $item[$field] = $rawValue; } } } // print_r($item);die; // 如果行数据不为空,则添加到批次数据中 if (!empty($item)) { $batchData[] = $item; $processedRows++; } // 7. 当批次数据达到插入批次大小时,执行数据库插入操作 if (count($batchData) >= $insertBatchSize) { $this->processBatch($model, $batchData, $success, $failedBatches, $total); $batchData = []; // 清空批次数据 } $total++; // 总记录数递增 } // 8. 释放当前数据块占用的内存 $spreadsheet->disconnectWorksheets(); unset($spreadsheet); gc_collect_cycles(); // 触发垃圾回收 // 9. 输出处理进度信息 $progress = round(($endRow / $totalRows) * 100, 2); echo "处理进度: {$progress}% | 已处理: {$processedRows} 行\n"; } // 10. 处理剩余不足一个批次的数据 if (!empty($batchData)) { $this->processBatch($model, $batchData, $success, $failedBatches, $total); } // 返回处理结果 if (empty($failedBatches)) { $resultMsg = "导入成功,共{$total}条数据,成功导入{$success}条"; return $this->success($resultMsg); } else { $errorCount = $total - $success; $errorMsg = "失败 {$errorCount} 条,第一个错误: {$failedBatches[0]['error']}"; return $this->fail('导入失败', ['remark' => $errorMsg]); } } catch (\Exception $e) { // 异常处理,返回错误信息 return $this->fail('导入过程中出错: ' . $e->getMessage()); } } /** * 处理数据批次(优化SQL构建) */ private function processBatch($model, &$batchData, &$success, &$failedBatches, &$total) { // 如果批次数据为空则直接返回 if (empty($batchData)) return; try { // 使用参数绑定构建SQL语句,防止SQL注入 $tableName = $model->getTable(); $fields = array_keys($batchData[0]); $fieldList = '`' . implode('`, `', $fields) . '`'; $placeholders = '(' . implode(',', array_fill(0, count($fields), '?')) . ')'; $sql = "INSERT INTO {$tableName} ({$fieldList}) VALUES "; $values = []; $params = []; // 构建批量插入的SQL语句和参数数组 foreach ($batchData as $row) { $values[] = $placeholders; foreach ($fields as $field) { $params[] = $row[$field] ?? null; } } $sql .= implode(',', $values); // 执行带参数绑定的SQL语句 // 一定不要使用模型去操作数据库 不然效率很低 原生的最好! Db::execute($sql, $params); // 更新成功记录数 $success += count($batchData); // 清空批次数据 $batchData = []; } catch (\Exception $e) { // 记录失败批次信息 $failedBatches[] = [ 'startRow' => $total - count($batchData) + 1, 'endRow' => $total, 'error' => $e->getMessage() ]; // 出错时清空批次数据,避免重复处理 $batchData = []; } } /** * 分块读取过滤器 * 用于控制只读取Excel文件中的指定行范围 * common.php代码不规范导致本地git有差异直接还原 直接写在控制器里算了! */ class ChunkReadFilter implements \PhpOffice\PhpSpreadsheet\Reader\IReadFilter { private $startRow = 0; private $endRow = 0; // 设置要读取的起始行和行数 public function setRows($startRow, $chunkSize) { $this->startRow = $startRow; $this->endRow = $startRow + $chunkSize; } // 判断当前单元格是否应该被读取 public function readCell($column, $row, $worksheetName = '') { // 只读取指定范围内的行 if ($row >= $this->startRow && $row <= $this->endRow) { return true; } return false; } } 我需要导入100万的数据,并且excel表格当中26个字段 每个字段都特别的长,导入的时候总是报错502,字段少的时候就没事,请为我分析具体原因,另外请帮我针对问题进行代码优化,要求提供完整的代码哈 不要忘记注释信息
07-09
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值