background preloader

13 Useful WordPress SQL Queries You Wish You Knew Earlier

13 Useful WordPress SQL Queries You Wish You Knew Earlier
WordPress WordPress is driven by a MySQL database. This is something active WordPress users would know. However, if you only just read about it here from us, here’s what you should know. MySQL is a free relational database management system available in most web hosting services. For example, if you needed to change some information across the board in WordPress, going through each record is very time consuming and prone to human error. Shown below are some SQL queries that can be of great assistance to you when using WordPress. Backup your WordPress Database Before you proceed with any changes, be sure to backup your database. You can download WP-DB-Backup or WP-DBManager plugin to backup your database through your WordPress admin panel. If you decide to backup your WordPress database manually, follow these steps: 13 SQL Queries for WordPress An easy way to run any of the queries below is to use phpMyAdmin. phpMyAdmin is one of the most common database look-up and editing tool. Solution:

WordPress 3.0 Multisite Settings - WordPress, After, Additionall Exclusively 2 Screenshots of the new WordPress 3.0 Multisite Settings. You can find them under Options->Network: After you set the settings, you receive in a second step the content for wp-config.php and .htaccess. Additionally you have to create the subfolder blogs.dir in wp-content , where you put the media-files for each blog. Since WordPress 3.0 is still in development, there might be many changes until the final release. How to Edit the Hosts File Mac OS X Snow Leopard | DotResults There are times during DNS changes or other testing that you may want to specify a particular IP for a domain name. To do this, you’ll need to edit your hosts file. This way you can “trick” your computer before DNS actually changes or point a domain to another IP, even a local one. Some of the instructions out there on how to do this are a little too bloated, so I tried to simplify them as much as possible here on DotResults. If you have any questions about this, please leave a comment and we’ll get back to you as soon as we read it. 1. 2. 3. 4. 5. 6.

Guide de Sécurité PHP How to organize your wordpress blogroll links? In 2008 when I launched my personal blog to share my experiences, I decided to call it Balkhis instead of using my full name (Syed Balkhi). As time passed on, I regretted that decision because it created a lot of confusion. People thought that my last name was Balkhis instead of Balkhi. I basically combined my last name with the first letter of my first name.I was @syedbalkhi across all social media platforms, so the brand wasn’t consistent.People didn’t know about my personal blog as much because they didn’t relate Balkhis with me. Well as I focus more on my personal brand in 2015, I made the crucial move of switching domain names. As you noticed with this change, I got a new site design. I didn’t want to spend too much time creating a custom theme, so I used my friend Michael Hyatt’s theme which you too can buy if you like: GetNoticed. I did customize it to give it a bit of personal touch. The main reason why I chose this theme is because of all the amazing functionality it comes with.

Storing form array data to MySQL using PHP Let's say that you've got a form with check boxes sort of like the one below. Here's the code... <form method="post" action="path to script"><input type="checkbox" id="colors[]" value="red" /> Red<input type="checkbox" id="colors[]" value="blue" /> Blue<input type="checkbox" id="colors[]" value="green" /> Green<input type="checkbox" id="colors[]" value="yellow" /> Yellow</form> Notice the [ and ] after "color." Now, let's say someone fills out the form. You want to store the information in that array to your database. $colors=$_POST['colors']; //takes the data from a post operation... But that doesn't work. Instead you'll need to use PHP's serialize() function. As the PHP documentation explains, the serialize function "[g]enerates a storable representation of a value." In other words, it takes arrays (and other data types), and converts the contents into data that can be stored. Let's re-do the above code using serialize(). Funky, ain't it? You should get "red, blue, green, yellow."

55+ Most Wanted WordPress Tips, Tricks, and Hacks There are times when you come across a feature in a blog, and you just start thinking to yourself: How can I get this in my WordPress blog/site as well. Everybody have experienced this feeling. Sometimes you know you want it, and don’t know where to look for, or even what to look for. In this article we will be sharing some of the most wanted WordPress Tips, Tricks, and Hacks that you will definitely find useful. These tutorials are classified under various skills level. For some tutorials, you will need to know basic HTML and some WordPress Knowledge. WordPress Theme Cheat Sheet for Beginners 1. This is one of the most wanted hacks that users want to know how to accomplish. You can change the template name. Once you have published this page go to Settings » Reading in your admin panel. And select your page to be the homepage. 2. Have you ever been to a site and saw this cool feature? You would need to follow the trick #1 in this article to create a custom page template. 3. 4. 5. 6. 7.

mysql date column type Using Date to sort data select e_id, birth_date from employee_per ORDER BY birth_date; +------+------------+ | e_id | birth_date | +------+------------+ | 11 | 1957-11-04 | | 16 | 1964-03-06 | | 21 | 1964-06-13 | | 14 | 1965-04-28 | | 15 | 1966-06-23 | | 7 | 1966-08-20 | | 10 | 1967-07-06 | | 20 | 1968-01-25 | | 12 | 1968-02-15 | | 2 | 1968-04-02 | | 9 | 1968-05-19 | | 13 | 1968-09-03 | | 3 | 1968-09-22 | | 6 | 1969-12-31 | | 17 | 1970-04-18 | | 1 | 1972-03-16 | | 4 | 1972-08-09 | | 19 | 1973-01-20 | | 18 | 1973-10-09 | | 5 | 1974-10-13 | | 8 | 1975-01-12 | +------+------------+ Selecting data using Dates Here is how we can select employees born in March. select e_id, birth_date from employee_per where MONTH(birth_date) = 3; +------+------------+ | e_id | birth_date | +------+------------+ | 1 | 1972-03-16 | | 16 | 1964-03-06 | +------+------------+ 2 rows in set (0.00 sec) Alternatively, we can use month names instead of numbers.

Free Dark and Clean WordPress Theme: Designpile - Smashing Magaz Advertisement In this post we are glad to release DesignPile WordPress Theme, a theme designed by Site 5 and released for Smashing Magazine and its readers. The theme comes with 3 color styles and a couple of jQuery-based goodies. It can be used for portfolios and blogs as well as corporate webAs usual, the theme is free to use in private and commerical projects. Download the theme for free! The theme is released under GPL. Features Here are some of the features of the theme: Widget ready (footer and sidebar), Easy to setup, the Theme Options Page has 3 color styles, Custom homepage, Simple Post Thumbnails Plugin,125×125 ads section with enable/disable option, using “WP125″ plugin,JQuery Lightbox,JQuery Forms,AJAX-based based contact form,Live form email validation,Theme Requirements: WordPress 2.9.1+ Sidebar Content, overview “About the author”-section Comments Categories archive section Thank you, Gabi Schiopu and the Site 5 design team! It's done. Leave a Comment Yay!

Wordpress Theme Development Frameworks - Smashing Magazine Advertisement If you build and develop WordPress themes often, you will probably be fed up of all the repetitive code writing, the constantly checking of your mark-up and all you really want to do is focus on the design and the project-specific features. The answer is a WordPress development framework. This post is not about finding the best framework, it is about finding the right framework that works for you. Which would you use? Thematic – WP Framework Thematic1 is a highly polished WordPress Theme Framework that is built upon the 960.gs. Thematic Features Optional 2 or 3 column layouts.Up to 13 widget ready areas.Modular CSS with pre-packaged resets and basic typography.Fully Search-Engine Optimized.Can be used as it is, or as a blank WordPress theme.Dynamic post and body classes make it a hyper-canvas for CSS artists.Options for multi-author blogs.Great support available from the customisation guide and forums.Child Themes are available for upgrading the theme. Thematic (child) Themes

How to make wordpress themes using 960 grid system « WordPress 9 Creating wordpress themes using 960 grid system is very easy because 960 grid systems has already fix width of containers and also you can easily manage the number of columns you want for your themes. below is the steps on how to create wordpress themes using 960 grid system. step 1 You must have the 960 grid css which you can download here step 2 Create the following files : header.phpindex.phpsidebar.phpfooter.php Header.php - these area were you call your css scripts and other info about the website. sample code below Index.php - this is the file were your content goes. <? Sidebar.php - your navigation and other links goes here. <div class=”grid_5 sidebar”> <ul> <? Footer.php – your footer goes here. </div> <div class=”grid_12 footer”> <p >Copyright &copy; <? This are the basic files you need to create the template, take a look on the classes of some of the “div” it use the class grid with an underscore and a number that’s indicates the width of the grid you use it is from the 960 grid css. <? <?

Related: