幾款常用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)
%>
