The headers look like so, substituting filename.csv for the name you would like:
header('Content-Disposition: attachment; filename="filename.csv"'); Continue reading Sending a CSV file to the web browser with PHP
To dump all the records from a table into the file /tmp/[tabelname].csv as a CSV file, use the following SQL query: Continue reading Export data to CSV from MySQL
Mostly, a dump of a db is wanted in SQL. In case of emergency import file. But some people do not comprehend SQL or their SQL doesn’t like your SQL and everything goes down the drain. So there is the CSV or Comma-separated values file. As the name says, it separates the values by commas (and more if needed). Since it’s so dead simple, you will get a lot of different tools and program languages that will make life easy for you to re-import or just search in it. Microsoft Excel and Openoffice Calc both can handle the format as well, so for a quick look, this will do very nicely. Continue reading Creating a MySQL dump in CSV format
Many WordPress themes, especially those with “magazine-like” layouts, use an image to represent each post. It might just be on the front page. It might be alone, or alongside an excerpt. Until now, there was no standardized way to do this. Many themes would require you to tediously enter a Custom Field with the value being the URL you wanted to use. Often you had to do cropping yourself. With WordPress 2.9, theme authors can easily enable Post Thumbnail selection UI and call those image using simple template tags.
and call those image using simple template tags.
Continue reading New in WordPress 2.9: Post Thumbnail Images
Whether you’re developing WordPress plugins, WordPress themes, or rolling out a new site based on a customized version of WordPress, it’s often helpful to be able to mirror your live site on your local system for development. This is common for commercial sites, where you have a live production server but you also need a development and/or staging server, which is run locally to test plugins, mods, themes, and everything else that you don’t want to do on the live production server. For example, your live site could be http://www.example.com/blog and your development site might be http://localhost/example.com/blog. However, WordPress serves pages with embedded absolute URLs based on the absolute site URL configured in your database, so none of the links on your development site will work.
Continue reading Running_a_Development_Copy_of_WordPress