mysql数据库连接代码入门例子
代码如下
复制代码
$cn = mysql_connect('localhost','root','root');if( $cn ){ die('数据库连接成功');}else{ die('连接失败');}
阅读全文
首页 >
php与数据库
php留言板程序（适合php初学者）(1/4)
<!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=gbk" />
<title>所有留言</title>
<link rel="stylesheet" type="text/css教程" href="style.css" media="all" />
</head>
php通用分页类代码
class dividepage{//分页类
private $total;//要显示的总记录数
private $url;//请求的url地址
private $displaypg;//每页显示的记录数，默认为每页显示10条记录
private $page;//当前页码
private $lastpg;//总页数，即最后一页的页码
private $prepg;//前一页
private $nextpg;//后一页
private $firstcount;//记录条数开始的序号从0开始
private $startd;//记录条数开始的记录号.
private $stopd;//记录条数结束的记录号.
数据库添加、修改、删除基础操作代码(1/4)
require_once('common.php');
$action = $_get['action'];
?>
<!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>
<link href="style.css教程" type="text/css" rel="stylesheet" />
</head>
<body>
<div id="wrap">
<div id="main">
<?php
if($action=='add'){
?>
<form action="?action=save" method="post" name="form1">
<table width="300" border="0" cellspacing="0" cellpadding="0" class="post">
<tr>
<td colspan="2">添加人员</td></tr>
<tr><td width="78">登陆账号</td>
<td width="220"><input name="login" type="text" id="login" /></td>
</tr>
<tr>
<td>登陆密码</td>
<td><input name="pws" type="text" id="pws" /></td>
</tr>
<tr>
<td>问题</td>
<td><input name="question" type="text" id="question" /></td>
</tr>
<tr>
<td>答案</td>
<td><input name="answer" type="text" id="answer" /></td>
</tr>
<tr>
<td colspan="2"><input name="button" type="submit" id="button" value=" 添加 " /></td>
</tr>
</table>
</form>
<?php
}
elseif($action=='save'){
$login = isset($_post['login']) ? $_post['login'] : '';
$pws = isset($_post['pws']) ? $_post['pws'] : '';
$question = isset($_post['question']) ? $_post['question'] : '';
$answer = isset($_post['answer']) ? $_post['answer'] : '';
$sql = "insert into person (login,pws,question,answer)
values('$login','$pws','$question','$answer')";
$db->query($sql);
forward('发布成功','href','personlist.php');
}
二款PostgreSQL连接数据的方法和操作实例
$pg=@pg_connect("host=localhost user=postgres password=sa dbname=employes")
or die("can't connect to database.");
$query="select * from employes order by serial_no";
mysql数据库连接类
class mysql {
public $sqlserver = 'localhost';
public $sqluser = 'root';
public $sqlpassword = '';
public $database;
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连接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;//编码
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");
//无限分类类库