PHP连接MYSQL数据库代码.docVIP

PHP连接MYSQL数据库代码 -------------------------------------------------------------------------------- ?php $mysql_server_name=localhost; //改成自己的mysql数据库服务器 $mysql_username=root; //改成自己的mysql数据库用户名 $mysql_password //改成自己的mysql数据库密码 $mysql_database=mycounter; //改成自己的mysql数据库名 $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!数据库mycounter已经成功建立！; ? PHP连接MS SQL数据库代码方法 -------------------------------------------------------------------------------- 1.安装SQL服务器并添加PHP的MSSQL扩展 2.使用以下代码连接并测试 ?php $myServer = localhost; //主机 $myUser = sa; //用户名 $myPass = password; //密码 $myDB = Northwind; //MSSQL库名 $s = @mssql_connect($myServer, $myUser, $myPass) or die(Couldnt connect to SQL Server on $myServer); $d = @mssql_select_db($myDB, $s) or die(Couldnt open database $myDB); $query = SELECT TitleOfCourtesy+ +FirstName+ +LastName AS Employee ; $query .= FROM Employees ; $query .= WHERE Country=USA AND Left(HomePhone, 5) = (206); $result = mssql_query($query); $numRows = mssql_num_rows($result); echo h1 . $numRows . Row . ($numRows == 1 ? : s) . Returned /h1; while($row = mssql_fetch_array($result)) { echo li . $row[Employee] . /li; } ? -------------------------------------------------------------------------------- 　通过PHP连接MYSQL数据库 　　 $conn = mysql_connect(localhost,root,password) or die(无法连接数据库);　　 mysql_select_db(table ,$conn) or die (找不到数据源); 　　通过PHP创建MYSQL数据库 　　$conn = mysql_connect(localhost,root,password) or die(无法连接数据库);　　mysql_create_db(webjx) or die(无法创建数据库);　　$sqlstr = create database other_webjx