PHP添加MySQL数据记录代码-php手册-php.cn

Home

php教程

php手册

PHP添加MySQL数据记录代码

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 pm 12:28 PM

bodyheadhtmlmysqlphpcodecopyEstablishdataInquireAdd toRecordpagefirst

首先建立查询页面：

复制代码代码如下:

添加记录

大家应该还记得，在之前的专题中已经介绍过PHP页面之间如何传值的技术。同样，在这个页面里，当我们单击提交后，我们将把ename与pcname这两个参数通过post的方法传递给add_finish.php页面。

接下来是最重要的，让我们来看看如何用PHP编写添加MySQL数据的语句：

复制代码代码如下:

$link =mysql_connect("localhost","root","管理员密码");
mysql_select_db("infosystem", $link);
$exec="insert into info (ename,pcname) values ('".$_POST["ename"]."','".$_POST["pcname"]."')";
mysql_query("SET NAMES GB2312");
mysql_query($exec, $link);
mysql_close($link);
echo "添加成功！";
?>

    其中红色部分就是PHP添加MySQL数据的关键SQL语句。然后用mysql_query来执行这句SQL语句。

    要提醒大家的是，一定要注意程序中的任何一个符号，因为这段程序是经过我测试正常通过的，大家在复制时只要全部复制就可以了，但在大家自己编写时一定要注意每一个细节。

    还有一点就是，大家要根据自己的数据库结构对程序进行细微的修改来满足大家的特定需要。
    今天的专题比较简略，大致介绍了如何用PHP添加MySQL数据记录。更详细的介绍我会在以后的专题中补充说明。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Assassin's Creed Shadows: Seashell Riddle Solution

4 weeks agoByDDD

What's New in Windows 11 KB5054979 & How to Fix Update Issues

3 weeks agoByDDD

Where to find the Crane Control Keycard in Atomfall

4 weeks agoByDDD

Roblox: Dead Rails - How To Complete Every Challenge

1 months agoByDDD

Atomfall guide: item locations, quest guides, and tips

1 months agoByDDD

Hot Tools

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.