Posts Tagged ‘SQL’

We are pleased to present below all posts tagged with ‘SQL’.

WordPress Essentials: Interacting With The WordPress Database

While many functions you already use in WordPress communicate with the database there is an easy and safe way to do this directly using the $wpdb class. Built on the great ezsql class by Justin Vincent, $wpdbwill allow you to address queries to any table in your database, and it will also help you handle the return data. Since this is built in WP functionality, there is no need to open a separate database connection (you would be duplicating code in this case), and there is no need to do hacks, like modifying a result set after it has been queried.

$wpdb class

In this article I will show you how to get started with the $wpdb class, how to retrieve data from your WordPress database and how to run more advanced queries which update or delete something in the db. The techniques here will remove some of the contraints that you run into with functions like get_posts() or wp_list_categories(), allowing you to tailor the queries you make to your specific needs. This method can also make your website more efficient by only getting the needed data, nothing more, nothing less.

Read more...

YQL: Using Web Content For Non-Programmers

Building a beautiful design is a great experience. Seeing the design break apart when people start putting in real content, though, is painful. That's why testing it as soon as possible with real information to see how it fares is so important. To this end, Web services provide us with a lot of information with which to fill our products. In recent years, this has been a specialist's job, but the sheer amount of information available and the number of systems to consume it makes it easier and easier to use Web services, even for people with not much development experience.

Screenshot

[fblike]

The problem with APIs is that access to them varies in simplicity, from just having to load data from a URL all the way up to having to authenticate with the server and give all kinds of information about the application you want to build before getting your first chunk of information.

Read more...

MySQL Admin and Development Tools Round-Up

The most popular and best open source database is MySQL. Simple as that. It is consistently fast , reliabile and very, very easy to use. One of MySQLs main features is its cross-platform support, it will run on almost all operating systems, including Windows, OSX, Linux and many more. So, MySQL is the best database, and we all use it. The question now is which is the best MySQL Admin and Development Tool?

MySql Tools Screenshot

In the overview below we present some of the most useful and most popular MySQL Admin and Development Tools for Mac, Windows and Linux, for beginners and for professionals. Among other tools we feature phpMyAdmin, MySQL Workbench, HeidiSQL and SequelPro. Please let us know if some useful MySQL-tool is missing in the list by commenting upon this article.

You may be interested in the following related posts:

Read more...

Ask SM [PHP]: Form Validation, Converting MySQL to XML

PHP and other server-side programming languages are tricky. The manual can be tough to decipher, and there isn’t really a way to “validate” a PHP script. If you’re new to programming, you may lost and not know where to look for help. When I first started programming, I spent hours pulling my hair out, digging through manuals, and poring over books. It wasn’t until I found a great online community that I really started to get in the swing with PHP and felt like I was actually accomplishing something.

PHP-questions

Here at Smashing Magazine, we want to help out PHP programmers who are just getting started or who want to improve their programming chops. Our goal is to support our community by answering their questions and trying to find solutions to their problems.

While Chris Coyier takes care of CSS and JavaScript-related questions, from now on me, Jason Lengstorf, will take care of your PHP- and MySQL-related questions. Posts focused on Ruby, Python, Photoshop and Illustrator are coming as well.

Read more...

8 Useful WordPress SQL Hacks

Over the past 10 years, the MySQL database has become incredibly popular on the Web. Every WordPress blog is driven by a MySQL database, which contains the blog's posts, settings, comments and much more.

Screenshot

While plug-ins and even coding hacks can solve some problems and achieve some tasks, sometimes you don't have any other choice than to execute SQL commands in phpMyAdmin or directly to the database via SSH. Let’s take a look at 8 useful SQL hacks for WordPress. Each section of this post presents a problem, suggests a solution and provides an explanation to help you understand the solution.

Read more...

↑ Back to top