PHP connects to MySQL database and adds records to the database_PHP tutorial

First you need to connect to the MySQL database through PHP:

#Connect to database

The following is the simplest PHP code to connect to the MySQL database:

The code is as follows

Copy code

代码如下	复制代码
$link=mysql_connect("localhost","root","password"); if (!$link) echo "connect error"; else echo "connect ok"; ?>

$link=mysql_connect("localhost","root","password");
if (!$link) echo "connect error";
else echo "connect ok";
?>

Among them, the mysql_connect() connection function, localhost represents the address of the database server, root is the MySql database user name, and password is the password of the MySql database. Just change it to your own when using it.

To make it easier to use in the future, standardize the connection code:

代码如下	复制代码
$link_host='localhost'; $link_user='root'; $link_pass='password'; $link=mysql_connect($link_host,$link_user,$link_pass); if ($link) { echo "connect ok!"; } else { echo "connect fail!"; } ?>

Use three variables to read the server address, username and password to facilitate future form reading and assignment.

#Create database code

代码如下	复制代码
include ("conn.php"); $link_db='link_system'; //设置要建立的数据库的名字，一定不能跟已有的数据库名称相同 if ($link) { echo "connect ok! ";  if (mysql_query("create database ".$link_db,$link))  {  echo "database created! ";  }  else {  echo "database create fail!";  }  }  else {  echo "connect error!";  }  ?>

After establishing the link_system database, you need to create a table.

#Create database table
//Set the table that needs to be built as link_table. The following is the name of the table that needs to be built to store different data. You can set it according to your own needs.
link_id data id
link_name Friendly link name
link_url Friendly link URL
link_detail Introduction
link_contact Contact information
link_show whether to display
link_order sort order
link_sort Category

//Because there are categories in our friend link list, we need to create a category table link_sorts. My idea is to save the location where the friend link is displayed, such as the homepage or channel page, inner page, etc.
sort_id data id
sort_name category name

The complete PHP code to create the table is as follows:

The code is as follows	Copy code
代码如下	复制代码
//选择操作的数据库  mysql_select_db($link_db,$link);     //建立表格  $link_table = "create table link_table  (  link_id int unsigned primary key not null auto_increment,  link_name varchar(20) not null,  link_url varchar(50) not null,  link_detail varchar(100) not null,  link_contact varchar(100) not null,  link_show int unsigned not null,  link_order int unsigned not null,  link_sort int unsigned not null  )";     $sort_table = "create table sort_table  (  sort_id int unsigned primary key not null auto_increment,  sort_name varchar(20) not null  )";     //执行建表操作  if(!mysql_query($link_table,$link)){  echo "Create link_table error :" . mysql_error() . " ";  }  else {  echo "link_table Created!" . " ";  }        if(!mysql_query($sort_table,$link)){  echo "Create sort_table error :" . mysql_error() . " ";  }  else {  echo "sort_table Created!" . " ";  }     //执行完毕关闭数据库连接  mysql_close($link);  ?>

//Select the database for operation

mysql_select_db($link_db,$link);

//Create a table

$link_table = "create table link_table

代码如下	复制代码
//insert.php 网站名称: 网站链接: 简介: 联系方式: 排序: 分类: 是否显示:

( link_id int unsigned primary key not null auto_increment, link_name varchar(20) not null, link_url varchar(50) not null, link_detail varchar(100) not null, link_contact varchar(100) not null, link_show int unsigned not null, link_order int unsigned not null, link_sort int unsigned not null )"; $sort_table = "create table sort_table ( sort_id int unsigned primary key not null auto_increment, sort_name varchar(20) not null )"; //Perform table creation operation if(!mysql_query($link_table,$link)){ echo "Create link_table error :" . mysql_error() . "
"; } else { echo "link_table Created!" . "
"; } if(!mysql_query($sort_table,$link)){ echo "Create sort_table error :" . mysql_error() . "
"; } else { echo "sort_table Created!" . "
"; } //Close the database connection after execution mysql_close($link); ?> First create a form to fill in the data that needs to be written to the MySQL database: #Write to database

The code is as follows	Copy code
//insert.php Website name: Website link: Introduction: Contact information: Sorting: Category: Whether to display:

Everything else in

is entered using text boxes, and whether to display or not is determined by using check boxes, which are selected by default.

Program page to execute writing

//insert_ok.php

The code is as follows

代码如下

复制代码

//insert_ok.php include ("conn.php"); //读取上个页面中表单中的数据 $link_name=$_POST[site_name]; $link_url=$_POST[site_url]; $link_contact=$_POST[site_contact]; $link_detail=$_POST[site_detail]; $link_order=$_POST[site_order]; $link_sort=$_POST[site_sort]; $link_show=$_POST[site_show]; if (!$link_show=="1") $link_show="0"; //复选框是否选中，如果没有选中则赋值为0 mysql_select_db("link_system", $link); //选择数据库link_system if($_POST) { $sql = "INSERT INTO link_table (link_name,link_url,link_contact,link_detail,link_order,link_sort,link_show) VALUES ('$link_name','$link_url','$link_contact','$link_detail','$link_order','$link_sort','$link_show')"; if(!mysql_query($sql,$link)) { echo "添加数据失败：".mysql_error(); } else { echo "添加数据成功！"; echo $_POST[site_name]." ".$_POST[site_url]." ".$_POST[site_contact]." ".$_POST[site_detail]." ".$_POST[site_order]." ".$_POST[site_sort]." ".$_POST[site_show];     } } ?>

Copy code

include ("conn.php");

//Read the data in the form on the previous page
$link_name=$_POST[site_name];
$link_url=$_POST[site_url];
$link_contact=$_POST[site_contact];
$link_detail=$_POST[site_detail];
$link_order=$_POST[site_order];
$link_sort=$_POST[site_sort];
$link_show=$_POST[site_show];

if (!$link_show=="1") $link_show="0";
//Whether the check box is selected, if it is not selected, the value is 0

mysql_select_db("link_system", $link); //Select database link_system

if($_POST)
{
$sql = "INSERT INTO link_table (link_name,link_url,link_contact,link_detail,link_order,link_sort,link_show) VALUES ('$link_name','$link_url','$link_contact','$link_detail','$link_order',' $link_sort','$link_show')";
If(!mysql_query($sql,$link))
{
echo "Failed to add data:".mysql_error();
}  
else
{
echo "Added data successfully!";
echo $_POST[site_name]."
".$_POST[site_url]."
".$_POST[site_contact]."
".$_POST[site_detail]."".$_POST[site_sort]."
".$_POST[site_show];
}  
}
?>

If the execution is successful, adding the friend link data is completed. As for the classification, it will not be added for the time being, and the classification will be added later. The next step is to implement displaying data, editing data and deleting data. http://www.bkjia.com/PHPjc/629011.htmlwww.bkjia.com

true

http: //www.bkjia.com/PHPjc/629011.html

TechArticleFirst you need to connect to the MySQL database through PHP: #Connect to the database The following is the simplest PHP code to connect to the MySQL database: Copy the code as follows?php $link=mysql_connect(localho...