A simple automatic email sending system (2)_PHP tutorial
Jul 21, 2016 pm 04:06 PM
Here we introduce the practical combination of php and mysql.
Basically, it can be said that php is an intermediate layer between the backend database and the frontend browser, passing commands between them. This approach greatly increases the possibility of interaction and can be easily used in voting systems, other dynamic user input and personalized websites.
To achieve this interaction, you must first connect to the mysql database. You can use this command:
Syntax: int mysql_connect(string hostname, string username, string password);
·hostname - The name of the host where the database server is running.
·username - the username to connect to the database server.
·Password - user password. the password set to connect to the MySQL database.
If the connection is successful, the function returns a positive integer, if it fails, it returns a negative number.
All commands, as usual, must be placed between "" and "?>".
Let us continue our project, let us assume that we have created the following data table using MySQL:
------------------ ---------
mysql> CREATE TABLE information (
-> name VARCHAR (25),
-> email VARCHAR (25),
-> ; choice VARCHAR (8) );
-------------------------------
Now let Let's assume that we want to insert the user's information into this database. We can do this by modifying the email.php3 script as follows:
---------------- ------------
/* This script will use the variables passed from the moreinfo.html file. */
/* Declare some related variables*/
$hostname = "devshed";
$username = "myusername";
$password = "mypassword";
$dbName = "mydbname";
/* Use the data table created by MySQL to access information */
$userstable = "information";
/* Website administrator Email address*/
$adminaddress = "administration@buycorn.com";
/* Connect to database*/
MYSQL_CONNECT($hostname,$username,$password) OR DIE(" Unable to connect to database");
@mysql_select_db("$dbName") or die("Unable to select database");
PRINT "
PRINT "Hello, $name.";
PRINT "
";
PRINT "Thank you for your interest.
";
PRINT " We will send information to $email, and have noted that you like $preference";
PRINT "
";
/* Send related emails* /
mail("$email", "Your request for information",
"$namenThank you for your interest!n
We sell fresh corn daily over the Internet!
Place your order at http ://www.buycorn.com,
and receive a free package of $preference!");
mail("$adminaddress",
"Visitor request for info.",
"$name requested for information.n
The email address is $email. n The visitor prefers $preference.");
/* Insert data into the data table*/
$query = "INSERT INTO $userstable VALUES('$name','$email', '$preference')";
$result = MYSQL_QUERY($query);
PRINT "Your information has also been inserted into our database, for future reference.";
/* Close the connection to the database*/
MYSQL_CLOSE();
?>
-- -----------------------------
Some things to note:
1. Statement at the beginning of the script The variables are for the function MYSQL_CONNECT(). We can also give these values ????directly in the function. However, considering the development of the project, these values ????should be placed in a separate file and loaded with (#include).
2. Syntax: int mysql_select_db(string database_name, int link_identifier);
·database_name must be the database name on the server.
·link_identifier (optional) specifies the connection and makes a request to the database server based on this.
·The return value is true/false
3. Syntax: int mysql_query(string query, int link_identifier);
·query Send the sql command to the mysql server.
·link_identifier (optional) specifies the connection and sends sql commands to the database server based on this.
·The return value is an integer, a positive number indicates success, and a negative number indicates failure.
4. Syntax: int mysql_close(int link_identifier);
·link_indentifier Same as above
·The return value is an integer, a positive number indicates success, and a negative number indicates failure.
In the next article, I will explain to you how to output data from mysql.?

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

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

Hot Article

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

In PHP, you can use square brackets or curly braces to obtain string specific index characters, but square brackets are recommended; the index starts from 0, and the access outside the range returns a null value and cannot be assigned a value; mb_substr is required to handle multi-byte characters. For example: $str="hello";echo$str[0]; output h; and Chinese characters such as mb_substr($str,1,1) need to obtain the correct result; in actual applications, the length of the string should be checked before looping, dynamic strings need to be verified for validity, and multilingual projects recommend using multi-byte security functions uniformly.

To set and get session variables in PHP, you must first always call session_start() at the top of the script to start the session. 1. When setting session variables, use $_SESSION hyperglobal array to assign values ??to specific keys, such as $_SESSION['username']='john_doe'; it can store strings, numbers, arrays and even objects, but avoid storing too much data to avoid affecting performance. 2. When obtaining session variables, you need to call session_start() first, and then access the $_SESSION array through the key, such as echo$_SESSION['username']; it is recommended to use isset() to check whether the variable exists to avoid errors

Key methods to prevent SQL injection in PHP include: 1. Use preprocessing statements (such as PDO or MySQLi) to separate SQL code and data; 2. Turn off simulated preprocessing mode to ensure true preprocessing; 3. Filter and verify user input, such as using is_numeric() and filter_var(); 4. Avoid directly splicing SQL strings and use parameter binding instead; 5. Turn off error display in the production environment and record error logs. These measures comprehensively prevent the risk of SQL injection from mechanisms and details.

The method to get the current session ID in PHP is to use the session_id() function, but you must call session_start() to successfully obtain it. 1. Call session_start() to start the session; 2. Use session_id() to read the session ID and output a string similar to abc123def456ghi789; 3. If the return is empty, check whether session_start() is missing, whether the user accesses for the first time, or whether the session is destroyed; 4. The session ID can be used for logging, security verification and cross-request communication, but security needs to be paid attention to. Make sure that the session is correctly enabled and the ID can be obtained successfully.

To extract substrings from PHP strings, you can use the substr() function, which is syntax substr(string$string,int$start,?int$length=null), and if the length is not specified, it will be intercepted to the end; when processing multi-byte characters such as Chinese, you should use the mb_substr() function to avoid garbled code; if you need to intercept the string according to a specific separator, you can use exploit() or combine strpos() and substr() to implement it, such as extracting file name extensions or domain names.

UnittestinginPHPinvolvesverifyingindividualcodeunitslikefunctionsormethodstocatchbugsearlyandensurereliablerefactoring.1)SetupPHPUnitviaComposer,createatestdirectory,andconfigureautoloadandphpunit.xml.2)Writetestcasesfollowingthearrange-act-assertpat

Execution of SELECT queries using PHP's preprocessing statements can effectively prevent SQL injection and improve security. 1. Preprocessing statements separate SQL structure from data, send templates first and then pass parameters to avoid malicious input tampering with SQL logic; 2. PDO and MySQLi extensions commonly used in PHP realize preprocessing, among which PDO supports multiple databases and unified syntax, suitable for newbies or projects that require portability; 3. MySQLi is specially designed for MySQL, with better performance but less flexibility; 4. When using it, you should select appropriate placeholders (such as? or named placeholders) and bind parameters through execute() to avoid manually splicing SQL; 5. Pay attention to processing errors and empty results to ensure the robustness of the code; 6. Close it in time after the query is completed.

In PHP, the most common method is to split the string into an array using the exploit() function. This function divides the string into multiple parts through the specified delimiter and returns an array. The syntax is exploit(separator, string, limit), where separator is the separator, string is the original string, and limit is an optional parameter to control the maximum number of segments. For example $str="apple,banana,orange";$arr=explode(",",$str); The result is ["apple","bana
