How can I load an .xls file to a mysql database in php? -

I want exact opposite

I want to load an .xls file filled with emails in a database column Am

What is the easiest way to do this?

As Ponce said, you will upload it first for "Save As> CSV" and Whatever the permissions, the permissions that often do not allow the SQL statement will be allowed to use my personal favorites because it will take heavy loads and will give you SQL to execute the execution, although you can use that which will be more secure, and something you Can be implemented in the script.

With fgetcsv, you can do something that assumed you found a column file with an email address:

  $ row = 1; If (($ $ handle = fopen ("test.csv", "r")! == FALSE) {while ($ data = fgetcsv ($ handle, 1000, ","))! == FALSE {$ Num = count ($ data); // line in the line row & quot; & Lt; P & gt; $ Num field resonant: & lt; Br / & gt; & Lt; / P & gt; \ N "; $ line ++; ($ C = 0; $ c & lt; $ num; $ c ++) {if ($ c == 0) {// This is the first column // Just a normal mys Run the SQL insert command here (see link below for more information on this)}}} fclose ($ handle);}  

Enter a tutorial on PHP MySQL: