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
You must be Connected before you can add a profile tab. Prompting the user before this will result in an error. Click the Login button on the top left to connect if you’re not already connected.
Continue reading Facebook – Add a profile tab
One of the strategic decisions that you need to make when you create your Facebook application is deciding whether to use FBML or an IFrame for your canvas page. The issue is more than just an implementation detail. In fact, it gets to the heart of the goals for your application.
FBML embraces the Facebook Platform and enables your application to become part of Facebook itself. IFrames, on the other hand, enable your Web application to function inside Facebook without coding an interface that works only inside a single context (Facebook).
Continue reading Facebook development: choosing FBML or iframe as your application type
With CSS (Cascading Style Sheets) you can use custom fonts on your website. Normally your visitors can only see the fonts that are already installed on their computers. So if you use a font that is not installed on your website visitor’s computer then his or her browser will show some other font that is there on the computer. That’s why when you are defining a font for an element (such as <p>) you often specify multiple fonts so that if your preferred font is not available your CSS file should use the available alternatives. Continue reading How To Use Custom Fonts On Your Website With CSS
Experience the web with Facebook friends.
Social plugins let you see what your friends have liked, commented on or shared on sites across the web. All social plugins are extensions of Facebook and are specifically designed so none of your data is shared with the sites on which they appear.
Add social plugins to your site with just one line of HTML:
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