国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Home Backend Development PHP Tutorial A simple automatic email sending system (2)_PHP tutorial

A simple automatic email sending system (2)_PHP tutorial

Jul 21, 2016 pm 04:06 PM
mysql php 。 two introduce send and practical yes of Simple combine automatic Mail system

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 "".

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.?

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/315419.htmlTechArticleHere 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 method greatly improves...
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

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

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

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to access a character in a string by index in PHP How to access a character in a string by index in PHP Jul 12, 2025 am 03:15 AM

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.

How to set and get session variables in PHP? How to set and get session variables in PHP? Jul 12, 2025 am 03:10 AM

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

How to prevent SQL injection in PHP How to prevent SQL injection in PHP Jul 12, 2025 am 03:02 AM

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.

How to get the current session ID in PHP? How to get the current session ID in PHP? Jul 13, 2025 am 03:02 AM

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.

PHP get substring from a string PHP get substring from a string Jul 13, 2025 am 02:59 AM

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.

How do you perform unit testing for php code? How do you perform unit testing for php code? Jul 13, 2025 am 02:54 AM

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

PHP prepared statement SELECT PHP prepared statement SELECT Jul 12, 2025 am 03:13 AM

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.

How to split a string into an array in PHP How to split a string into an array in PHP Jul 13, 2025 am 02:59 AM

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

See all articles