相關(guān)關(guān)鍵詞
關(guān)于我們
最新文章
使用PHP連接多種數(shù)據(jù)庫的實現(xiàn)代碼(mysql,access,sqlserver,Oracle)
1、PHP連接MYSQL數(shù)據(jù)庫的代碼
<?php $mysql_server_name='localhost'; //改成自己的mysql數(shù)據(jù)庫服務(wù)器 $mysql_username='root'; //改成自己的mysql數(shù)據(jù)庫用戶名 $mysql_password='12345678'; //改成自己的mysql數(shù)據(jù)庫密碼 $mysql_database='mycounter'; //改成自己的mysql數(shù)據(jù)庫名 $conn=mysql_connect($mysql_server_name, $mysql_username,$mysql_password, $mysql_database); $sql='CREATE DATABASE mycounter DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; '; mysql_query($sql); $sql='CREATE TABLE `counter` (`id` INT(255) UNSIGNED NOT NULL AUTO_INCREMENT ,`count` INT(255) UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY ( `id` ) ) TYPE = innodb;'; mysql_select_db($mysql_database,$conn); $result=mysql_query($sql); //echo $sql; mysql_close($conn); echo "Hello!數(shù)據(jù)庫mycounter已經(jīng)成功建立!"; ?>