PHP连接各种数据库代码
-
<?php
$mysl_server_name='localhost'; //改成自己的mysl数据库服务器
$mysl_username='root'; //改成自己的mysl数据库用户名 $mysl_password='12345678'; //改成自己的mysl数据库密码
$mysl_database='mycounter'; //改成自己的mysl数据库名
$conn=mysl_connect($mysl_server_name,$mysl_username,$mysl_password,$mysl_database);
$sl='CREATE DATABASE mycounter DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; ';
mysl_uery($sl);
$sl='CREATE TABLE `counter` (`id` INT(255) UNSIGNED NOT NULL AUTO_INCREMENT ,`count` INT(255) UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY ( `id` ) ) TYPE = innodb;';
mysl_select_db($mysl_database,$conn);
$result=mysl_uery($sl);
//echo $sl;
mysl_close($conn);
echo &uot;Hello!数据库mycounter已经成功建立!&uot;;
?>
--------------------------------------------------------------------------------
PHP连接ACCESS数据库代码方法
--------------------------------------------------------------------------------
<?
$conn = new com(&uot;ADODB.Connection&uot;);
$connstr = &uot;DRIVER={Microsoft Access Driver (*.mdb)}; DB=&uot;. realpath(&uot;data/db.mdb&uot;);
$conn->Open($connstr);
$rs = new com(&uot;ADODB.RecordSet&uot;);
$rs->Open(&uot;select * from szd_t&uot;,$conn,1,1);
while(! $rs->eof) {
$f = $rs->Fields(1);
echo $f->value;
$rs->MoveNext();