A simple automatic email sending system (2)_PHP tutorial-PHP Tutorial-php.cn

A simple automatic email sending system (2)_PHP tutorial

WBOY

Release： 2016-07-21 16:06:36

Original

910 people have browsed it

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.