$conn=mysql教程_connect("localhost","root","");
$db=mysql_select_db("gan");
mysql_query("set names 'gbk'");
?>
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">
<html xmlns="http://www.phprm.com/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
首页 >
PHP教程
php 把csv文件导入到mysql数据库
error_reporting(0);// 导入csv格式的文件
$connect=mysql_connect("localhost","root","") or die("could not connect to database");
mysql_select_db("gklqtzcx",$connect) or die (mysql_error());
mysql_query("set names 'gbk'");
$fname = $_files['myfile']['name'];
$handle=fopen("$fname","r");
while($data=fgetcsv($handle,10000,",")){
$q="insert into records (name,classes,a_time,college,notify,receiver,r_time,handler) values ('$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]')";
mysql_query($q) or die (mysql_error());
}
fclose($handle);
echo "<meta http-equiv="refresh" content="1;url=list.php">1秒钟转入列表页,请稍等."
读取mdb数据库例程
$conn = new com("adodb.connection");
$connstr = "driver={microsoft access driver (*.mdb)}; dbq=". realpath("data/db.mdb");
$conn->open($connstr);
$rs = new com("adodb.recordset");
$rs->open("select * from szd_t",$conn,1,1);
while(! $rs->eof)
$f = $rs->fields(1);
echo $f->value;
$rs->movenext();
php生成excel文件源代码
class excel{
/**
*头的excel文件（前缀的行）
*
*从excel复制的xml规格。
*
* @访问私有
* @无功串
*/
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实现远程文件下载代码
class download
{
var http://pic4.phprm.com/2010/07/22/http://pic4.phprm.com/2010/07/22/$url.jpg.jpg;//远程文件地址
var $file_name = "hdwiki.zip";//下载来的文件名称
php分页代码(下一页 上一页)
//分页代码二
?>
php连接mysql数据库
/*
* created on 2010-4-21
*
* the class for control mysql
*
* made by s71ence
*
* @$host
* @$user_name
* @$user_pwd
* @$data_base
* @$coding
*/
class mysql
{
private $host;//主机名
private $user_name;//用户名
private $user_pwd;//密码
private $data_base;//数据库名
private $coding;//编码
字符串截取代码
function my_sub_str($string, $sublen, $start)
{
$pa = "/fdddd";
preg_match_all($pa, $string, $t_string);
if(count($t_string[0]) - $start > $sublen) return join('', array_slice($t_string[0], $start, $sublen))."...";
return join('', array_slice($t_string[0], $start, $sublen));
}
php统计器代码（在线人数据统计程序源码）
$time = gettimeofday(void);
//文件初始化 start
if(@filesize("time.text")<=0){
php分页代码
class page extends mysql
{
public $page;
public $page_size;
private $table;
private $condition;
private $limit;
private $href;
private $action_value;
private $url_value;
//分页初始化
pdo连接access数据库代码
//php教程.ini需要开放:
//extension=php_pdo.dll
//extension=php_pdo_odbc.dll
//数据库为acc.mdb,为防止恶意下载，改为acc.php
try{
$db = new pdo("odbc:driver={microsoft access driver (*.mdb)};dbq=".getcwd()."acc.php",'aaa','123456'); //getcwd()函数是获取当前路径
//echo "connected ";
php+mysql数据库无限分类代码(1/2)
//连接数据库
$link = mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('class',$link)or die(mysql_error());
mysql_query("set names gbk");
//无限分类类库