Archive for the ‘PHP’ Category
Date and time fields or what we call timestamps stored in our Mysql databases has a format of “YYYY-MM-DD HH:MM:SS” or “2011-04-15 11:30:00″ . It is awkward for the users to to see dates outputted to something in that format, so for user readability and friendly purposes, we must output the date into something more [...]
Sometimes, you need to get some information from your wordpress database and display it outside your WP application. Here are some useful custom queries that you can use to get data from your Wordpress database.
1. Get and display recent posts query.
//get recent posts function
$query = "Select * from wp_posts
WHERE post_type = 'post'
AND post_status = [...]
Sponsored Links
Categories
- CodeIgniter (2)
- CSS (2)
- Javascript/AJAX (10)
- JQuery (3)
- Others (13)
- PHP (16)
- Wordpress (7)
Recent Posts
- Importing large SQL files through command line when using PHPMyAdmin/XAMPP
- Date picker HTML select boxes with automatic date selection PHP snippet
- How to display PHP errors without altering php.ini file
- IP address restrictions to protect directories using .htaccess
- How to format MySQL Date and Time fields into user readable format
Archives
- September 2011 (1)
- August 2011 (1)
- July 2011 (1)
- June 2011 (1)
- April 2011 (1)
- March 2011 (1)
- November 2010 (1)
- September 2010 (1)
- August 2010 (2)
- March 2010 (1)
- February 2010 (1)
- January 2010 (1)
Comrades
Recent Comments
- anup: thanx it helped me alot…
- admin: try to look at window.location function of Javascript and place it under the success function of the AJAX...
- ana: it works for me, but after success, how can i forward the url to a certain page? thanks
- admin: Hello Don, do these steps again and again until the PSP reboots. Restore your PSP’s Default settings in SYstem...
- don sb: my psp was already hacked then i changed the screen cos it broke,so at one point the battery lost total...
PHP
- Importing large SQL files through command line when using PHPMyAdmin/XAMPP
- Date picker HTML select boxes with automatic date selection PHP snippet
- How to display PHP errors without altering php.ini file
- How to format MySQL Date and Time fields into user readable format
- Wordpress query hacks
- Configuring TinyMCE to allow embed tags
Others
- Importing large SQL files through command line when using PHPMyAdmin/XAMPP
- IP address restrictions to protect directories using .htaccess
- How hackers can hack your Facebook account
- Things to consider before website launch checklist
- How to hack PSP Brite 3000 tutorial
- Free Internet Explorer online emulator/simulator
