html代码
代码如下 | 复制代码 |
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>ansys教程</title> </head> <body> <img" width=100% src="/info.php教程" width="22" height="30" /> </body> </html> |
php代码
代码如下 | 复制代码 |
$db = new sqlite3('mysql教程itedb.db'); //获取文件2进制流 $stmt = $db->prepare("insert into person values ('41042119720101001x', '张三',?)"); |
<?php
代码如下 | 复制代码 |
$pdo = new sqlite3('mysqlitedb.db'); $results = $pdo->query('select * from person'); while ($row = $results->fetcharray()) { ob_start(); header("content-type: image/jpg"); echo $row['photo'] ; ob_end_flush(); } |
?>
本文章收藏了三款php 生成excel文件代码程序,第一款为比较全面的生成函数,后面二款很简单,但是不如第一款好,好了现在来看看生成excel的原理吧。代码如下 | 复制代码 |
class excel{ var $footer = "</workbook>"; ?> |
方法二
其实在做真正的应用的时候,大家可以将数据从数据库教程中取出,然后按照每一列数据结束后加t,每一行数据结束后加n的方法echo出来,在php的开头用header("content-type:application/vnd.ms-excel");表示输出的是excel文件,用header("content-disposition:filename=test.xls");表示输出的文件名为text.xls。这样就ok了。
代码如下 | 复制代码 |
<? header("content-type:application/vnd.ms-excel"); header("content-disposition:filename=test.xls"); echo "test1"; echo "test2"; echo "test1"; echo "test2"; echo "test1"; echo "test2"; echo "test1"; echo "test2"; echo "test1"; echo "test2"; echo "test1"; echo "test2"; ?> 方法三 <? echo "="411481198507150666""." "; |
代码如下 | 复制代码 |
class mysql { function __construct($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = 'gbk', $connect = 1) { function connect($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = 'gbk', $connect=1){ function select_db($dbname){ function query($sql){ function getall($sql, $type=mysql_assoc){ function getone($sql, $type=mysql_assoc){ function fetch_array($result,$type = mysql_assoc){ function affected_rows(){ function num_rows(){ function num_fields($result){ function insert_id(){ function free_result(){ function error(){ function errno(){ function close(){ function dbversion(){ function dbshow($msg){ } |
$times = time();
$filename = $times.".csv";
$a = "联系人,联系电话,申请时间 ";
$days = postget("days");
$mktime = daystomktime($days);
$sql = "select * from v_tugou where ($times-times)<$mktime";
$db = new db();
$result = $db->query( $sql );
$rs = $db->fetch($result,0);
foreach($rs as $v=>$vv)
{
$a.=$vv['name'].','. $vv['mo'].",";
$a.=date('y-m-d ',$vv['times'])." ";
}
//echo $a;
$hod = fopen ($filename,"w+");
if( fwrite($hod,$a) )
{
echo "生成excel文件成功,点击<a href=$filename target=_blank>右击另存为excel文档</a>";
}
/*
数据结构
--
-- 表的结构 `hn_tugou`
--
create table if not exists `v_tugou` (
`id` int(4) not null auto_increment,
`name` varchar(20) not null default '0',
`mo` varchar(20) not null default '0',
`times` int(4) default null,
`ip` varchar(20) not null default '0',
primary key (`id`)
) engine=myisam default charset=utf8 auto_increment=2 ;
--
-- 导出表中的数据 `hn_tugou`
--
insert into `hn_tugou` (`id`, `name`, `mo`, `times`, `ip`) values
(1, 'adsense', 'www.111cn.net', 1283241159, '192.168.0.119');
本站原创文章转载注明来自http://www.111cn.net/phper/php.html
*/
代码如下 | 复制代码 |
class database { var $dblink; function connect($dbhost, $dbuser, $dbpw, $dbname = "") { $this->dblink = mysql_connect($dbhost, $dbuser, $dbpw); mysql_query("set names 'utf8'"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); if($dbname) { mysql_select_db($dbname, $this->dblink); } } function query($sql) { $result = mysql_query($sql, $this->dblink); return $result; } function fetch_array($result) { return mysql_fetch_array($result); } function insert_id() { $id = mysql_insert_id(); return $id; } function getrow($sql) { $result = mysql_query($sql, $this->dblink); return mysql_fetch_assoc($result); } function getdetailrow($sql) { $result = mysql_query($sql, $this->dblink); return mysql_fetch_array($result); } //www.111cn.net function close() { mysql_close($this->dblink); } } |
//调用 方法
代码如下 | 复制代码 |
$db = new database; $db->connect($dbhost, $dbuser, $dbpw, $dbname); unset($dbhost, $dbuser, $dbpw, $dbname); |
?>