class dbstuff {
var $querynum = 0;
var $link;
var $sqlid;
var $record;
var $dbcharset='utf-8';
var $charset='utf-8';
function connect($dbhost, $dbuser, $dbpw, $dbname = '', $pconnect = 0, $halt = true) {
if($pconnect) {
if(!$this->link = @mysql_pconnect($dbhost, $dbuser, $dbpw)) {
$halt && $this->halt('can not connect to mysql server');
}
} else {
if(!$this->link = @mysql_connect($dbhost, $dbuser, $dbpw, 1)) {
$halt && $this->halt('can not connect to mysql server');
}
}
首页 >
php与数据库
sqlite 数据库连接类
*/
class db_class {
var $conn=null;
var $querynum = 0;
/**
* 数据库连接，返回数据库连接标识符
*
* @param string $ 数据库服务器主机
* @param string $ 数据库服务器帐号
* @param string $ 数据库服务器密码
* @param string $ 数据库名
* @param bool $ 是否保持持续连接，1为持续连接，0为非持续连接
* @return link_identifier $dbuser, $dbpw, $dbname,
*/
function connect($dbhost, $pconnect = 0) {
$error = '';
$func = $pconnect == 1 ? 'sqlite_popen' : 'sqlite_open';
if (!$this -> conn = $func($dbhost, 0666, $error)) {
$this -> halt($error);
}
php导入excel经典实例
require_once 'excel/reader.php';
// excelfile($filename, $encoding);
$data = new spreadsheet_excel_reader();
php mysql 数据库备份程序
?>
<!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" />
<link type="text/css教程" rel="stylesheet" href="common/control.css">
<script type="text/网页特效" language="javascript" src="common/admin.otable.js"></script>
<script type="text/javascript" language="javascript" src="common/include.func.js"></script>
<title>数据管理</title>
<style type="text/css">
span {padding-left:8px;}
</style>
</head>
php 数据库连接的例子
/* database config */
$db_host = 'localhost';
$db_user = 'root';
$db_pass = '123';
$db_database = 'todo';
php输出excel格式文件
如果要利用了php输出excel格式文件就必须利用header content-type:application/vnd.ms-excel来实现。如下
再看一php输出excel实例
php 生成excel文件
class excel{
var $header = "<?xml version="1.0" encoding="utf-8"?>
<workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/tr/rec-html40">";
php pdo连接mysql数据查询数据
html代码
php mysql 导出csv excel格式文件并保存
$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>";
}
php连接mysql数据库的实用类
class mysql {
var $linkid=null;
function __construct($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = 'gbk', $connect = 1) {
$this -> connect($dbhost, $dbuser, $dbpw, $dbname, $dbcharset, $connect);
}
php连接mysql数据库类
//调用 方法
?>
php access 留言板程序
*/
error_reporting(0);
$conn = new com("adodb.connection");
$conn->open("driver={microsoft access driver (*.mdb)}; dbq=" . realpath("db.mdb "));
$rs=new com("adodb.recordset");