PHP database connection steps

We have organized the database connection into the eight most important steps for everyone. I jokingly call it: "The eight steps of database connection".

The eight steps are as follows, and the functions used in each step are explained:

Step one: Connect to the database server

##Parameter 4Name of the databaseParameter 5If the database server port is not filled in, the default is 3306

Type	Description
Function	mysqli_connect
Function	Connect to mysql database server
Parameter 1	Host
Parameter 2	Database server login name
Parameter 3	Password

If parameter 4, the database name is in this step Already filled in and selected, no need to perform the third step.

Step Two: Judgment Error

TypeExplanationFunctionmysqli_errnoFunctionReturns the connection error number, no error returns 0Parameter 1Pass in the resource returned by mysqli_connect##TypeFunctionFunctionParameter 1Step 3: Select the database

Description
mysqli_error
Return connection error string
Pass in the resource returned by mysqli_connect

TypeFunctionFunctionParameter 1Parameter 2If the database has been filled in in the first step, there is no need to change it to another database. Then there is no need to perform the third step.

Description
mysqli_select_db
Select the database in this connection
Pass in the resource returned by mysqli_connect
The name of the database to be connected

Step 4: Set character set

TypeFunctionFunctionParameter 1Parameter 2

For more notes, please pay attention to the book "13.6 The Ultimate Solution to Garbled Data Display"

Step 5: Prepare the SQL statement

is actually a string of SQL statements.

For example:

<?php
$sql = "insert into user(username,password) values('$username','$password')";
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }

// some code

?>

We usually assign variables for use in SQL statements. However, there is an error in the variable or SQL statement, which is very difficult to troubleshoot.

We have added this step based on actual work experience.

If an error is reported when executing this step, we can print out the SQL statement and paste it into phpMyAdmin or related tools.

When debugging, if the execution is successful, it means that the problem is not with the SQL statement. If execution fails, double check the SQL statement.

Step 6: Send SQL statement

Description
mysqli_set_charset
Set the connection with the mysql server, result, verify character set
Pass in the resource returned by mysqli_connect
Character set type

##Parameter 1Pass in the resource returned by mysqli_connectParameter 2Pass in the SQL statement sent

Type	Description
Function	mysqli_query
Function	Send SQL statement

The SQL statement is prepared and needs to be sent to the MySQL server through mysqli_query.

The MySQL server will execute the SQL statement sent.

Step 7: Determine whether the execution is normal or traverse the data

Read

In step 6, the statement of the select category is sent, and the results usually need to be output and displayed. come out. You need to use the function that traverses the display data.

TypeDescription##FunctionFunctionParameter 1Parameter 2

mysqli_fetch_array
Get the data in the result set and return the array for convenience
Pass Enter the result variable from the query
Pass in MYSQLI_NUM to return the index array, MYSQLI_ASSOC to return the associative array, MYSQLI_BOTH to return the index and association

Type##Function mysqli_fetch_assocGet the data in the result set and return the associative array for convenience Pass in the result variable from the query

Description
	##Function
	Parameter 1

TypeDescriptionFunctionmysqli_fetch_row##FunctionGet the data in the result set and return the index array for convenienceParameter 1The result variable passed in from the queryType Descriptionmysqli_fetch_object

	##Function
Function	Get the data in the result result set and return the object for traversal
Parameter 1	Pass in the result variable from the query
##Functionmysqli_num_rowsFunctionReturn the total number of results from the queryParameter 1Pass in the result variable from the query Type Description TypeDescriptionFunctionmysqli_num_rowsFunctionReturn the total number of query resultsParameter 1Pass in the result variable from the queryNoteIt is rarely used in actual work, understand# #Write In step 6, if the insert statement is sent, you usually need to get whether the execution is successful, or get the auto-incremented ID at the same time. Type##Functionmysqli_fetch_fieldFunctionTraverse data rowsParameter 1Pass in the result variable from the queryModification and deletion Description In step 6, if the statements of update and delete categories are sent. Just need to determine whether the execution is successful. We list the data tables of these commonly used functions for everyone to check. Step 8: Close the database TypeDescriptionFunctionmysqli_closeFunctionClose the database connectionParameter 1Pass in the resource returned by mysqli_connectThe database connection is a resource type. We told you about it when we explained resource types in the previous chapter. All resource types involved are either opened or closed. This ensures that PHP processes and recycles resources more efficiently. Therefore, after the database connection is successful, there is no need to use it. We can close this connection. Others: Display server information function TypeDescriptionFunctionmysqli_get_server_infoFunctionReturn server informationParameter 1Pass in the resource returned by mysqli_connect##TypeDescriptionFunctionmysqli_get_server_version##FunctionReturn server versionParameter 1Pass in the resource returned by mysqli_connectNote: mysqli only learns the procedural method. In the actual work of the object-oriented stage, the object usage of mysqli was completely abandoned, and instead the PDO object was used to connect to the database. Continuing Learning || new file <?php $con = mysql_connect("localhost","peter","abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } // some code ?> submitReset Code Automatic operation Previous section Next Section Tutorial List get help Course Recommendations Courseware download ElementaryImperial CMS enterprise imitation website tutorial 3048 people are watching ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites 6743 people are watching ElementaryUltimate CMS zero-based website building instruction video 2724 people are watching ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice] 3117 people are watching IntermediateVue3.0 from 0 to build a universal backend management system project practice 5351 people are watching ElementaryZero-based front-end course [Vue advanced learning and practical application] 2821 people are watching ElementaryWEB front-end tutorial [HTML5+CSS3+JS] 3506 people are watching ElementaryQuick introduction to apipost 2161 people are watching IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice 3208 people are watching ElementaryLet's briefly talk about starting a business in PHP 17423 people are watching IntermediateVUE e-commerce project (front-end & back-end dual project actual combat) 3828 people are watching ElementaryApipost practical application [api, interface, automated testing, mock] 2265 people are watching The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~ Students who have watched this course are also learning  492396 plays Let's briefly talk about starting a business in PHP Quick introduction to web front-end development Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum] Login verification and classic message board Computer network knowledge collection Quick Start Node.JS Full Version The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original] Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance) notes X