<span style="color:#333333;font-family:''Helvetica, Arial, sans-serif'';">$query = "INSERT INTO users(name , email , address , phone) VALUES('$name' , '$email' , '$address' , '$phone')";
$db->query($query); //call to mysqli_query()</span>
<span style="color:#333333;font-family:''Helvetica, Arial, sans-serif'';">function insert_record($table_name , $data)
{
foreach($data as $key => $value)
{
//mysqli_real_escape_string
$data[$key] = $db->mres($value);
}
$fields = implode(',' , array_keys($data));
$values = "'" . implode("','" , array_values($data)) . "'";
//Final query
$query = "INSERT INTO {$table}($fields) VALUES($values)";
return $db->query($query);
}
$data = array('name' => $name , 'email' => $email , 'address' => $address , 'phone' => $phone);
insert_record('users' , $data);</span>
<head> <base href="http://www.domain.com/store/"> </head> <body> <img src="happy.jpg" /> </body> </html>
<a href="home.php">Home</a> <a href="products/ipad.php">Ipad</a>
<span style="color:#333333;font-family:''Helvetica, Arial, sans-serif'';"><a href="../home.php">Home</a> <a href="ipad.php">Ipad</a></span>
<span style="color:#333333;font-family:''Helvetica, Arial, sans-serif'';"><head> <base href="http://www.domain.com/store/"> </head> <body> <a href="home.php">Home</a> <a href="products/ipad.php">Ipad</a> </body> </html></span>
<span style="color:#333333;font-family:'Helvetica, Arial, sans-serif';">ini_set('display_errors', 1);
error_reporting(~E_WARNING & ~E_NOTICE & ~E_STRICT);</span>
<span style="color:#333333;font-family:''Helvetica, Arial, sans-serif'';">$ php -a
Interactive shell
php > echo strtotime("0000-00-00 00:00:00");
-62170005200
php > echo strtotime('1000-01-30');
-30607739600
php > echo strtotime('2100-01-30');
4104930600</span>
<span style="color:#333333;font-family:''Helvetica, Arial, sans-serif'';">set_time_limit(30); //Rest of the code</span>
$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : 0;
define('yourPage',1);
if (!defined('yourPage')) die('Access Denied');
public function dbExec($query)
{
$result = $this->db->exec($query);
if (PEAR::isError($result))
errorRedirect($result->getMessage(), true);
else
return $result;
}
// checks if arguments given are integer values not less than 0 - has multiple arguments
function sanitizeInput()
{
$numargs = func_num_args();
$arg_list = func_get_args();
for ($i = 0; $i < $numargs; $i++) {
if (!is_numeric($arg_list[$i]) || $arg_list[$i] < 0)
errorRedirect("Unexpected variable value", true);
}
}
require_once PROJECTROOT.'libs/messages.class.php';
$message = new Message();
switch ($action)
{
case 'display':
$message->display();
break;
...
private function getSentMessages($id)
{
$this->util->sanitizeInput($id);
$pm_table = $GLOBALS['config']['privateMsg'];
$users = $GLOBALS['config']['users'];
$sql = "SELECT PM.*, USR.username as name_sender FROM $pm_table PM, $users USR
WHERE id_sender = '$id' AND sender_purge = FALSE AND USR.id = PM.id_receiver AND is_read = TRUE
ORDER BY date_sent DESC";
$result = $this->dbQueryAll($sql);
return $result;
}
function smartyObject()
{
if ($GLOBALS['config']['SmartyObj'] == 0)
{
$smarty = new SmartyGame();
$GLOBALS['config']['SmartyObj'] = $smarty;
}
else
$smarty = $GLOBALS['config']['SmartyObj'];
return $smarty;
}
functionbrowse_infor()
{
$browser="";$browserver="";
$Browsers=array("Lynx","MOSAIC","AOL","Opera","JAVA","MacWeb","WebExplorer","OmniWeb");
$Agent=$GLOBALS["HTTP_USER_AGENT"];
for($i=0;$i<=7;$i++)
{
if(strpos($Agent,$Browsers[$i]))
{
$browser=$Browsers[$i];
$browserver="";
}
}
if(ereg("Mozilla",$Agent)&&!ereg("MSIE",$Agent))
{
$temp=explode("(",$Agent);$Part=$temp[0];
$temp=explode("/",$Part);$browserver=$temp[1];
$temp=explode("",$browserver);$browserver=$temp[0];
$browserver=preg_replace("/([\d\.]+)/","\1",$browserver);
$browserver="$browserver";
$browser="NetscapeNavigator";
}
if(ereg("Mozilla",$Agent)&&ereg("Opera",$Agent))
{
$temp=explode("(",$Agent);$Part=$temp[1];
$temp=explode(")",$Part);$browserver=$temp[1];
$temp=explode("",$browserver);$browserver=$temp[2];
$browserver=preg_replace("/([\d\.]+)/","\1",$browserver);
$browserver="$browserver";
$browser="Opera";
}
if(ereg("Mozilla",$Agent)&&ereg("MSIE",$Agent))
{
$temp=explode("(",$Agent);$Part=$temp[1];
$temp=explode(";",$Part);$Part=$temp[1];
$temp=explode("",$Part);$browserver=$temp[2];
$browserver=preg_replace("/([\d\.]+)/","\1",$browserver);
$browserver="$browserver";
$browser="InternetExplorer";
}
if($browser!="")
{
$browseinfo="$browser$browserver";
}
else
{
$browseinfo="Unknown";
}
return$browseinfo;
}
//调用方法$browser=browseinfo();直接返回结果
functionosinfo(){
$os="";
$Agent=$GLOBALS["HTTP_USER_AGENT"];
if(eregi('win',$Agent)&&strpos($Agent,'95')){
$os="Windows95";
}
elseif(eregi('win9x',$Agent)&&strpos($Agent,'4.90')){
$os="WindowsME";
}
elseif(eregi('win',$Agent)&&ereg('98',$Agent)){
$os="Windows98";
}
elseif(eregi('win',$Agent)&&eregi('nt5\.0',$Agent)){
$os="Windows2000";
}
elseif(eregi('win',$Agent)&&eregi('nt',$Agent)){
$os="WindowsNT";
}
elseif(eregi('win',$Agent)&&eregi('nt5\.1',$Agent)){
$os="WindowsXP";
}
elseif(eregi('win',$Agent)&&ereg('32',$Agent)){
$os="Windows32";
}
elseif(eregi('linux',$Agent)){
$os="Linux";
}
elseif(eregi('unix',$Agent)){
$os="Unix";
}
elseif(eregi('sun',$Agent)&&eregi('os',$Agent)){
$os="SunOS";
}
elseif(eregi('ibm',$Agent)&&eregi('os',$Agent)){
$os="IBMOS/2";
}
elseif(eregi('Mac',$Agent)&&eregi('PC',$Agent)){
$os="Macintosh";
}
elseif(eregi('PowerPC',$Agent)){
$os="PowerPC";
}
elseif(eregi('AIX',$Agent)){
$os="AIX";
}
elseif(eregi('HPUX',$Agent)){
$os="HPUX";
}
elseif(eregi('NetBSD',$Agent)){
$os="NetBSD";
}
elseif(eregi('BSD',$Agent)){
$os="BSD";
}
elseif(ereg('OSF1',$Agent)){
$os="OSF1";
}
elseif(ereg('IRIX',$Agent)){
$os="IRIX";
}
elseif(eregi('FreeBSD',$Agent)){
$os="FreeBSD";
}
if($os=='')$os="Unknown";
return$os;
}
//调用方法$os=os_infor();
$mime_types=array(
'gif'=>'image/gif',
'jpg'=>'image/jpeg',
'jpeg'=>'image/jpeg',
'jpe'=>'image/jpeg',
'bmp'=>'image/bmp',
'png'=>'image/png',
'tif'=>'image/tiff',
'tiff'=>'image/tiff',
'pict'=>'image/x-pict',
'pic'=>'image/x-pict',
'pct'=>'image/x-pict',
'tif'=>'image/tiff',
'tiff'=>'image/tiff',
'psd'=>'image/x-photoshop',
'swf'=>'application/x-shockwave-flash',
'js'=>'application/x-javascript',
'pdf'=>'application/pdf',
'ps'=>'application/postscript',
'eps'=>'application/postscript',
'ai'=>'application/postscript',
'wmf'=>'application/x-msmetafile',
'css'=>'text/css',
'htm'=>'text/html',
'html'=>'text/html',
'txt'=>'text/plain',
'xml'=>'text/xml',
'wml'=>'text/wml',
'wbmp'=>'image/vnd.wap.wbmp',
'mid'=>'audio/midi',
'wav'=>'audio/wav',
'mp3'=>'audio/mpeg',
'mp2'=>'audio/mpeg',
'avi'=>'video/x-msvideo',
'mpeg'=>'video/mpeg',
'mpg'=>'video/mpeg',
'qt'=>'video/quicktime',
'mov'=>'video/quicktime',
'lha'=>'application/x-lha',
'lzh'=>'application/x-lha',
'z'=>'application/x-compress',
'gtar'=>'application/x-gtar',
'gz'=>'application/x-gzip',
'gzip'=>'application/x-gzip',
'tgz'=>'application/x-gzip',
'tar'=>'application/x-tar',
'bz2'=>'application/bzip2',
'zip'=>'application/zip',
'arj'=>'application/x-arj',
'rar'=>'application/x-rar-compressed',
'hqx'=>'application/mac-binhex40',
'sit'=>'application/x-stuffit',
'bin'=>'application/x-macbinary',
'uu'=>'text/x-uuencode',
'uue'=>'text/x-uuencode',
'latex'=>'application/x-latex',
'ltx'=>'application/x-latex',
'tcl'=>'application/x-tcl',
'pgp'=>'application/pgp',
'asc'=>'application/pgp',
'exe'=>'application/x-msdownload',
'doc'=>'application/msword',
'rtf'=>'application/rtf',
'xls'=>'application/vnd.ms-excel',
'ppt'=>'application/vnd.ms-powerpoint',
'mdb'=>'application/x-msaccess',
'wri'=>'application/x-mswrite',
);
5、php生成excel文档
<?
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls");
echo"test1\t";
echo"test2\t\n";
echo"test1\t";
echo"test2\t\n";
echo"test1\t";
echo"test2\t\n";
echo"test1\t";
echo"test2\t\n";
echo"test1\t";
echo"test2\t\n";
echo"test1\t";
echo"test2\t\n";
?>
//改动相应文件头就可以输出.doc.xls等文件格式了
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有