php编程语言中操作数据库的一些代码，记住的话非常有用~

以下代码都是以本地的数据库为例子，账号是root，密码是1234561.连接数据库的php语法<?php$dbhost = "localhost:3306"; // mysql服务器主机地址$dbuser = "root"; // mysql用户名$dbpass = "123456"; // mysql用户名密码$conn = mysqli_connect($dbhost, $dbuser, $dbpass);if(! $conn ){ die("Could not connect: " . mysqli_error());}echo "数据库连接成功！";mysqli_close($conn);?>2.创建一个名字为RUN的数据库<?php$dbhost = "localhost:3306"; // mysql服务器主机地址$dbuser = "root"; // mysql用户名$dbpass = "123456"; // mysql用户名密码$conn = mysqli_connect($dbhost, $dbuser, $dbpass);if(! $conn ){ die("连接错误: " . mysqli_error($conn));}echo "连接成功 ";$sql = "CREATE DATABASE RUN";$retval = mysqli_query($conn,$sql );if(! $retval ){ die("创建数据库失败: " . mysqli_error($conn));}echo "数据库 RUN 创建成功";mysqli_close($conn);?>3.删除名为RUN数据库<?php$dbhost = "localhost:3306"; // mysql服务器主机地址$dbuser = "root"; // mysql用户名$dbpass = "123456"; // mysql用户名密码$conn = mysqli_connect($dbhost, $dbuser, $dbpass);if(! $conn ){ die("连接失败: " . mysqli_error($conn));}echo "连接成功 ";$sql = "DROP DATABASE RUN";$retval = mysqli_query( $conn, $sql );if(! $retval ){ die("删除数据库失败: " . mysqli_error($conn));}echo "数据库 RUN 删除成功";mysqli_close($conn);?>4.在RUN中创建数据表<?php$dbhost = "localhost:3306"; // mysql服务器主机地址$dbuser = "root"; // mysql用户名$dbpass = "123456"; // mysql用户名密码$conn = mysqli_connect($dbhost, $dbuser, $dbpass);if(! $conn ){ die("连接失败: " . mysqli_error($conn));}echo "连接成功 ";$sql = "CREATE TABLE run_tbl( ". "run_id INT NOT NULL AUTO_INCREMENT, ". "run_title VARCHAR(100) NOT NULL, ". "run_author VARCHAR(40) NOT NULL, ". "submission_date DATE, ". "PRIMARY KEY ( run_id ))ENGINE=InnoDB DEFAULT CHARSET=utf8; ";mysqli_select_db( $conn, "RUN" );$retval = mysqli_query( $conn, $sql );if(! $retval ){ die("数据表创建失败: " . mysqli_error($conn));}echo "数据表创建成功";mysqli_close($conn);?>5.删除数据表<?php$dbhost = "localhost:3306"; // mysql服务器主机地址$dbuser = "root"; // mysql用户名$dbpass = "123456"; // mysql用户名密码$conn = mysqli_connect($dbhost, $dbuser, $dbpass);if(! $conn ){ die("连接失败: " . mysqli_error($conn));}echo "连接成功 ";$sql = "DROP TABLE run_tbl";mysqli_select_db( $conn, "RUN" );$retval = mysqli_query( $conn, $sql );if(! $retval ){ die("数据表删除失败: " . mysqli_error($conn));}echo "数据表删除成功";mysqli_close($conn);?>6.在数据表中插入数据<?php$dbhost = "localhost:3306"; // mysql服务器主机地址$dbuser = "root"; // mysql用户名$dbpass = "123456"; // mysql用户名密码$conn = mysqli_connect($dbhost, $dbuser, $dbpass);if(! $conn ){ die("连接失败: " . mysqli_error($conn));}echo "连接成功 ";// 设置编码，防止中文乱码mysqli_query($conn , "set names utf8");$run_title = "学习php";$run_author = "RUN.COM";$submission_date = "2016-03-06"; $sql = "INSERT INTO runoob_tbl ". "(run_title,run_author, submission_date) ". "VALUES ". "("$run_title","$run_author","$submission_date")";mysqli_select_db( $conn, "RUN" );$retval = mysqli_query( $conn, $sql );if(! $retval ){ die("无法插入数据: " . mysqli_error($conn));}echo "数据插入成功";mysqli_close($conn);?>

本文仅代表作者个人观点，不代表巅云官方发声，对观点有疑义请先联系作者本人进行修改，若内容非法请联系平台管理员，邮箱2522407257@qq.com。更多相关资讯，请到巅云www.yx10011.com学习互联网营销技术请到巅云建站www.yx10011.com。