php数据库连接创建

来源:互联网 发布:国服lol有mac版本吗 编辑:程序博客网 时间:2024/05/22 04:52
<?php$con=mysql_connect("127.0.0.1:3306","ken","123456");if(!$con){die('Could not connect: '.mysql_error()."<br />");}//创建数据库if(mysql_query("CREATE DATABASE my_db",$con)){echo "Database Created"."<br/>";}else{echo "Error Creating database:".mysql_error()."<br/>";}//选择数据库mysql_select_db("my_db",$con);//创建表$sql_table = "CREATE TABLE Persons (FirstName varchar(15),LastName varchar(15),Age int)";mysql_query($sql_table,$con);//获取数据$firstname=$_POST["firstname"];$lastname=$_POST["lastname"];$age=$_POST["age"];//sql语句$sql_insert="INSERT INTO Persons VALUES ( '$firstname', '$lastname' , '$age')";if(!mysql_query($sql_insert,$con)){die("Error:".mysql_error());}echo "1 recond added"."<br/>";//查询$result = mysql_query("SELECT * FROM Persons");echo "<table border='1'><tr><th>Firstname</th><th>Lastname</th><th>Age</th></tr>";while($row = mysql_fetch_array($result))  {  echo "<tr>";  echo "<td>" . $row['FirstName'] . "</td>";  echo "<td>" . $row['LastName'] . "</td>";  echo "<td>" . $row['Age'] . "</td>";  echo "</tr>";  }mysql_close($con);?>


原创粉丝点击