PHP初学-mysql的基本操作

来源：互联网发布：用记事本c语言写hello 编辑：程序博客网时间：2024/05/01 08:21
php操作mysql的基本操作，只是简单的增删改查。
<span style="font-size:18px;"><?php/***mysql的操作*dong*/class MysqlOperation{//连接数据库static function getConMysql(){//mysql_connect(servername,username,password);/**servername 可选。规定要连接的服务器。默认是 "localhost:3306"。username 可选。规定登录所使用的用户名。默认值是拥有服务器进程的用户的名称。password 可选。规定登录所用的密码。默认是 ""。*/$con = mysql_connect("localhost","root","tiger");//打开var_dump($con); echo '<br/>';return $con;}//关闭数据库function close($con){echo '<br/>';var_dump('close:'.mysql_close($con));}//创建数据库表function creatData($dbName,$con){echo "create <br/>";$sql = "CREATE DATABASE $dbName ";$result = mysql_query($sql,$con);var_dump('crdb result'.$result); }//创建数据库表function creatDataTabe($con){$sql = "CREATE TABLE Persons (personID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(personID),FirstName varchar(15),LastName varchar(15),Age int)";$result = mysql_query($sql,$con);var_dump('cdbtable result'.$result); }function selectDb($dbName,$con){echo 'selectDb---';var_dump(mysql_select_db($dbName, $con));}//创建数据库表function insertTabe($con){$sql = "INSERT INTO Persons (FirstName, LastName, Age) VALUES ('zhou','dong',27)";$result = mysql_query($sql,$con);echo '<br/>';var_dump('insert result'.$result); }//查询数据库表function selectTabe($con){$result = mysql_query("SELECT * FROM Persons",$con);//mysql_query("DELETE FROM Persons WHERE LastName='Griffin'"); //删除数据//mysql_query("UPDATE Persons SET Age = '36' WHERE FirstName = 'Peter' AND LastName = 'Griffin'");//修改数据echo "<br/>  selectRe:";var_dump($result);while($row = mysql_fetch_array($result))  {  echo "<br />";  echo $row['FirstName'] . " " . $row['LastName'].' '.$row['Age'];  echo "<br />";  }}}     function mysqlTest()     {     $mysqlOperation = new MysqlOperation();     $mySql = MysqlOperation::getConMysql();//连接数据库     $dbName = 'php_test';     //$mysqlOperation->creatData($dbName,$mySql);//创建数据库     $mysqlOperation->selectDb($dbName,$mySql);//选择数据库     //$mysqlOperation->creatDataTabe($mySql);//创建数据库表     //$mysqlOperation->insertTabe($mySql);//向表中插入数据     $mysqlOperation->selectTabe($mySql);//向表中插入数据     $mysqlOperation->close($mySql);//关闭连接     }     mysqlTest();//调用函数?></span>
随风飘！
winter的世界
0 0