Import data into Foxmail_PHP tutorial using PHP-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Import data into Foxmail_PHP tutorial using PHP

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 21, 2016 pm 04:08 PM

foxmailphpimportWilldataAdd touseOwn

Recently Xiaoyang made a PHP classmate directory, where students can add or modify their name, email, OICQ and other information, and save it in the mySQL database. One day, Xiaoyang suddenly thought that it would be great if PHP could be used to generate a file for students to download and import the information into their Foxmail address book!

Just do it, and soon Xiaoyang launched this function. How is that achieved? Here we only explain the export of name, email address and OICQ.

If you want information, you can import it into the Foxmail address book. Of course, you must first understand the content and format of the file imported into the Foxmail address book. Open the address book of an account in Foxmail4.2, and you can see in its menu bar "Tools" - "Import" that Foxmail supports the import of two external files: "CSV file" and "Wab file". We choose to generate a CSV file. So what is the content and format of CSV files that can be imported into Foxmail? Let's first export a CSV file from Foxmail and take a look. Select a folder with a non-empty record in the Foxmail address book, execute "Tools" - "Export" - "Text File", save the file name as "TEMP.CSV", and select the output field in "Next" "Select "Name", "Email Address" and "OICQ", and click "Finish" to generate the "TEMP.CSV" file in the specified path. If you have installed the Microsoft office series, you will find that this is a file that is opened by default with EXCEL. In fact, it is a comma-separated value file of EXCEL. After double-clicking to open it, the interface will be as shown in the figure.

　 Import data into Foxmail_PHP tutorial using PHP

　We still have no way of knowing its writing format in this case. Open the "TEMP.CSV" file with Notepad, and you will find that its format is very simple: as shown in the figure, the first line of the file is the field of the Foxmail address book, and the other lines are the values corresponding to the fields. Each field and value is Separated by English commas. So we generate CSV files in this format in PHP, and others can download and import them into their Foxmail!

　 Import data into Foxmail_PHP tutorial using PHP

However, there is still a problem that needs to be solved, that is, since commas are used as separated values in the file, if there are English commas in the database records (Note: The following symbols are not specified unless otherwise specified) What should I do if they all refer to English symbols)? Of course, you can first replace the commas in the data with Chinese commas, but there is actually another way, that is, if double quotes ("ie " "") are added to both ends of the corresponding fields in the CSV file to separate the values, the English commas in between Not as a separated value, and two consecutive English double quotes (i.e. "") in the field are only displayed as one, not as a separated value.

With these understandings, we can write and export CSV files The PHP file:

　

Run the above PHP file on the server, and open the downloaded "tofoxmail.csv" file with Notepad as shown in the figure. 🎜> Click "Tools" - "Import" - "CSV File" in the Foxmail address book... and a lot of data in the database will be imported at once. This is not a bad idea!

Import data into Foxmail_PHP tutorial using PHP 　(The above programs have been tested in Apache+PHP4+mySQL and IIS+PHP4+mySQL.)

http://www.bkjia.com/PHPjc/314834.html

Statement

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

How to calculate the total number of elements in a PHP multidimensional array?May 15, 2025 pm 09:00 PM

Calculating the total number of elements in a PHP multidimensional array can be done using recursive or iterative methods. 1. The recursive method counts by traversing the array and recursively processing nested arrays. 2. The iterative method uses the stack to simulate recursion to avoid depth problems. 3. The array_walk_recursive function can also be implemented, but it requires manual counting.

What are the characteristics of do-while loops in PHP?May 15, 2025 pm 08:57 PM

In PHP, the characteristic of a do-while loop is to ensure that the loop body is executed at least once, and then decide whether to continue the loop based on the conditions. 1) It executes the loop body before conditional checking, suitable for scenarios where operations need to be performed at least once, such as user input verification and menu systems. 2) However, the syntax of the do-while loop can cause confusion among newbies and may add unnecessary performance overhead.

How to hash strings in PHP?May 15, 2025 pm 08:54 PM

Efficient hashing strings in PHP can use the following methods: 1. Use the md5 function for fast hashing, but is not suitable for password storage. 2. Use the sha256 function to improve security. 3. Use the password_hash function to process passwords to provide the highest security and convenience.

How to implement array sliding window in PHP?May 15, 2025 pm 08:51 PM

Implementing an array sliding window in PHP can be done by functions slideWindow and slideWindowAverage. 1. Use the slideWindow function to split an array into a fixed-size subarray. 2. Use the slideWindowAverage function to calculate the average value in each window. 3. For real-time data streams, asynchronous processing and outlier detection can be used using ReactPHP.

How to use the __clone method in PHP?May 15, 2025 pm 08:48 PM

The __clone method in PHP is used to perform custom operations when object cloning. When cloning an object using the clone keyword, if the object has a __clone method, the method will be automatically called, allowing customized processing during the cloning process, such as resetting the reference type attribute to ensure the independence of the cloned object.

How to use goto statements in PHP?May 15, 2025 pm 08:45 PM

In PHP, goto statements are used to unconditionally jump to specific tags in the program. 1) It can simplify the processing of complex nested loops or conditional statements, but 2) Using goto may make the code difficult to understand and maintain, and 3) It is recommended to give priority to the use of structured control statements. Overall, goto should be used with caution and best practices are followed to ensure the readability and maintainability of the code.

How to implement data statistics in PHP?May 15, 2025 pm 08:42 PM

In PHP, data statistics can be achieved by using built-in functions, custom functions, and third-party libraries. 1) Use built-in functions such as array_sum() and count() to perform basic statistics. 2) Write custom functions to calculate complex statistics such as medians. 3) Use the PHP-ML library to perform advanced statistical analysis. Through these methods, data statistics can be performed efficiently.

How to use anonymous functions in PHP?May 15, 2025 pm 08:39 PM

Yes, anonymous functions in PHP refer to functions without names. They can be passed as parameters to other functions and as return values of functions, making the code more flexible and efficient. When using anonymous functions, you need to pay attention to scope and performance issues.

See all articles