1. PHP code to import from CSV file to MySQL
By: Nate : 2014-10-06
Description: After playing a while, I'm confident the following replacement function works in all cases, including the ones for which the native fputcsv function fails. If fputcsv fails to work for you (particularly with mysql csv imports), try this function as a drop-in replacement instead.
Read the full article
 
2. PHP code to write to a CSV file from MySQL query
By: Jamie : 2014-10-06
Description: Utility function to output a mysql query to csv with the option to write to file or send back to the browser as a csv attachment.
Read the full article
 
3. PHP code to write to a CSV file for Microsoft Applications
By: Soapergem @ gmail . com : 2014-10-06
Description: I've created a function for quickly generating CSV files that work with Microsoft applications. In the field I learned a few things about generating CSVs that are not always obvious. First, since PHP is generally *nix-based, it makes sense that the line endings are always \n instead of \r\n. However, certain Microsoft programs (I'm looking at you, Access 97), will fail to recognize the CSV properly unless each line ends with \r\n. So this function changes the line endings accordingly. Secondly, if the first column heading / value of the CSV file begins with uppercase ID, certain Microsoft programs (ahem, Excel 2007) will interpret the file as being in the SYLK format rather than CSV, as described here: http://support.microsoft.com/kb/323626
Read the full article
 
4. Convert XML to CSV in PHP
By: David Thomas : 2014-10-06
Description: Output XML string as CSV with first row as column headers
Read the full article
 
5. Password must include both numeric and alphabetic characters - Magento
By: Emiley J : 2014-02-08
Description: While installing a fresh Magento installation, some users are stuck at the 'Create Admin Account' step, with this error: 'Password must include both numeric and alphabetic characters.'. Follow this simple step to resolve this issue.
Read the full article
 
6. PHP file upload (Large Files)
By: xmontero : 2012-12-05
Description: It may happen that your outgoing connection to the server is slow, and it may timeout not the "execution time" but the "input time", which for example in our system defaulted to 60s. In our case a large upload could take 1 or 2 hours.
Read the full article
 
7. PHP file upload prompts authentication for anonymous users
By: Phil Ciebiera : 2012-12-05
Description: On a Microsoft platform utilizing IIS, you may run into a situation where, upon moving the uploaded file, anonymous web users can't access the content without being prompted to authenticate first...
Read the full article
 
8. PHP file upload with IIS on windows XP/2000 etc
By: jedi_aka@yahoo.com : 2012-12-05
Description: For those of you trying to make the upload work with IIS on windows XP/2000/XP Media and alike here is a quick todo.
Read the full article
 
9. Error: Length parameter must be greater than 0
By: capitanqueso : 2012-12-05
Description: If you ever try to upload an empty file using fread(), php may show a nasty warning (according to your "error_reporting") about "Length parameter must be greater than 0" especially if you are parsing this as xml. So in order to handle this error from here you may do the next:
Read the full article
 
10. Multiple File Upload in PHP using IFRAME
By: Tom @ nono . be : 2012-12-05
Description: Handling multiple uploads can be a lot more user friendly with a little help of javascript and form posting to iFrame... To make it all a little bit more edible, you can use AJAX and divs to provide loader gifs etc...
Read the full article
 

     Next