PHP connects to mysql database and writes data_PHP tutorial-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

PHP connects to mysql database and writes data_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 13, 2016 pm 05:05 PM

mysql php No and use write data database friend of Know program connect

Friends who use PHP programs know that PHP and MySQL are a very good pair. We often use it for WEB development. Now I will introduce the simplest PHP method to connect to the MySQL database and write data. Friends in need can refer to.

Principle steps

1. PHP uses mysql_connect to connect to the mysql database

2. Open the MySQL database

3. Accept page data and enter it into the specified table with PHP

4. Then use mysql_query to execute and save the sql into the database.

Connecting to mysql database is super simple as follows

The code is as follows

代码如下	复制代码
mysql_connect("localhost","root","");//连接MySQL mysql_select_db("hello");//选择数据库 ?>

Copy code

mysql_connect("localhost","root","");//Connect MySQL

mysql_select_db("hello");//Select database

代码如下

复制代码

require_once("conn.php");//引用数据库链接文件

$uname = $_GET['n'];//GET方法为URL参数传递
$psw = $_GET['p'];
$psw=md5($psw);//直接使用MD5加密

$sql = "insert into members(username,password) values ('$uname','$psw')";
mysql_query($sql);//借SQL语句插入数据

mysql_close();//关闭MySQL连接
echo "成功录入数据";
?>

代码如下	复制代码
$uname = $_GET['n'];//GET方法为URL参数传递 $psw=md5($_GET['p']);//直接使用MD5加密 $conn=mysql_connect("localhost","root","");//连接MySQL $sql = "insert into members set username='uname',password='$psw'"; mysql_db_query("hello",$sql,$conn);//借SQL语句插入数据 ?>

Example 1

The code is as follows

Copy code

require_once("conn.php");//Reference database link file $uname = $_GET['n'];//GET method passes URL parameters $psw = $_GET['p']; $psw=md5($psw);//Use MD5 encryption directly $sql = "insert into members(username,password) values ('$uname','$psw')"; mysql_query($sql);//Insert data using SQL statements mysql_close();//Close the MySQL connection

echo "Data entered successfully"; ?>

Combined with simpler

The code is as follows

Copy code

$uname = $_GET['n'];//GET method passes URL parameters <🎜> $psw=md5($_GET['p']);//Use MD5 encryption directly<🎜> $conn=mysql_connect("localhost","root","");//Connect to MySQL<🎜> $sql = "insert into members set username='uname',password='$psw'";<🎜> mysql_db_query("hello",$sql,$conn);//Insert data using SQL statements<🎜> ?> http://www.bkjia.com/PHPjc/630728.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630728.htmlTechArticleFriends who use php programs all know that php and mysql are a very good pair. We often use it for WEB Development, let me introduce the simplest PHP method to connect to mysql database and write data, if necessary...

Statement of this Website

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

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Best Graphic Settings

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Assassin's Creed Shadows: Seashell Riddle Solution

2 weeks ago By DDD

R.E.P.O. How to Fix Audio if You Can't Hear Anyone

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

WWE 2K25: How To Unlock Everything In MyRise

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Where is the login entrance for gmail email?

7478

CakePHP Tutorial

1377

What is the format of the account name of steam

win11 activation key permanent

nyt connections hints and answers

Related knowledge

MySQL: The Ease of Data Management for Beginners Apr 09, 2025 am 12:07 AM

MySQL is suitable for beginners because it is simple to install, powerful and easy to manage data. 1. Simple installation and configuration, suitable for a variety of operating systems. 2. Support basic operations such as creating databases and tables, inserting, querying, updating and deleting data. 3. Provide advanced functions such as JOIN operations and subqueries. 4. Performance can be improved through indexing, query optimization and table partitioning. 5. Support backup, recovery and security measures to ensure data security and consistency.

How to create navicat premium Apr 09, 2025 am 07:09 AM

Create a database using Navicat Premium: Connect to the database server and enter the connection parameters. Right-click on the server and select Create Database. Enter the name of the new database and the specified character set and collation. Connect to the new database and create the table in the Object Browser. Right-click on the table and select Insert Data to insert the data.

MySQL: Simple Concepts for Easy Learning Apr 10, 2025 am 09:29 AM

MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.

Navicat cannot connect to MySQL/MariaDB/PostgreSQL and other databases Apr 08, 2025 pm 11:00 PM

Common reasons why Navicat cannot connect to the database and its solutions: 1. Check the server's running status; 2. Check the connection information; 3. Adjust the firewall settings; 4. Configure remote access; 5. Troubleshoot network problems; 6. Check permissions; 7. Ensure version compatibility; 8. Troubleshoot other possibilities.

How to execute sql in navicat Apr 08, 2025 pm 11:42 PM

Steps to perform SQL in Navicat: Connect to the database. Create a SQL Editor window. Write SQL queries or scripts. Click the Run button to execute a query or script. View the results (if the query is executed).

How to create a new connection to mysql in navicat Apr 09, 2025 am 07:21 AM

You can create a new MySQL connection in Navicat by following the steps: Open the application and select New Connection (Ctrl N). Select "MySQL" as the connection type. Enter the hostname/IP address, port, username, and password. (Optional) Configure advanced options. Save the connection and enter the connection name.

The Future of PHP: Adaptations and Innovations Apr 11, 2025 am 12:01 AM

The future of PHP will be achieved by adapting to new technology trends and introducing innovative features: 1) Adapting to cloud computing, containerization and microservice architectures, supporting Docker and Kubernetes; 2) introducing JIT compilers and enumeration types to improve performance and data processing efficiency; 3) Continuously optimize performance and promote best practices.

What is the difference between syntax for adding columns in different database systems Apr 09, 2025 pm 02:15 PM

不同数据库系统添加列的语法为：MySQL：ALTER TABLE table_name ADD column_name data_type;PostgreSQL：ALTER TABLE table_name ADD COLUMN column_name data_type;Oracle：ALTER TABLE table_name ADD (column_name data_type);SQL Server：ALTER TABLE table_name ADD column_name data_

See all articles