幾款常用mysql,access,mssql數據庫連接代碼

幾款常用mysql,access,mssql數據庫連接代碼

紹3種adodb連接mysql教程數據庫教程的方法
 //------------配置數據庫 ----------------
$databank       = 'mysql';
$mydbhost        = "localhost";                //配置主機
$mydbuser        = "root";                       //數據庫用戶
$mydbpw            = "123456";                //數據庫密碼
$mydbname        = "bianchen";             //數據庫密碼
$mydbcharset    = "utf8";

//方法一

$db           = adonewconnection($databank);
$db->debug = false;
$db->connect($mydbhost, $mydbuser, $mydbpw, $mydbname);         //指定adodb使用mysql數據庫
$db->execute('set names utf8');

//方法二

$db = newadoconnection($databank);
$db->connect($mydbhost, $mydbuser, $mydbpw, $mydbname);
$db->execute("set names 'utf8'");

//方法三

$db = newadoconnection($databank.'://'.$mydbuser.':'.$mydbpw.'@'.$mydbhost.'/'.$mydbname.'');

 

str = "dsn=mysql;driver={mysql odbc 3.51 driver};server=127.0.0.1;port=3307;uid=root;pwd=;database=vtigercrm502"   
set conn = server.createobject("adodb.connection")   
conn.open str

 

<%
set conn = server.createobject("adodb.connection")
conn.connectionstring = "driver={mysql odbc 3.51 driver};"_
& "server=localhost;"_
& " database=gaorui;"_
& "uid=root;pwd=luo; option=3;stmt=set names gbk"
conn.open
sql = "select * from user"
set rs = conn.execute(sql)
%>

 

<%
set conn = server.createobject("adodb.connection")
conn.open "driver={mysql odbc 3.51 driver};server=127.0.0.1;port=3306;database=gaorui;user=root;password=luo;stmt=set names gbk"
sql = "select * from user"
set rs = conn.execute(sql)
%>