Hostingheaderbarlogoj
Join InMotion Hosting for $3.49/mo & get a year on Tuts+ FREE (worth $180). Start today.
Advertisement

SQL

  • PHP
    Why you Should be using PHP's PDO for Database AccessPdo
    319 shares
    Many PHP programmers learned how to access databases by using either the MySQL or MySQLi extensions. As of PHP 5.1, there's a better way. PHP Data Objects (PDO) provide methods for prepared statements and working with objects that will make you far more productive!Read More…
  • WordPress
    Quick Tip: "Popular Posts By Comment Count" SQL Query in WordPress200x200
    3 shares
    You might have noticed that the Tuts+ sites have a section on the home page where we list the most popular posts of the month, according to comment count. While there are numerous plugins available, it's always best to write the code yourself if you can. Too much abstraction is never a good thing! Luckily, once we learn how to query WordPress' database, tasks like this become a cinch! Read More…
  • Databases
    SQL for Beginners Part 2Preview
    6 shares
    It is important for every web developer to be familiar with database interactions. In part two of the series, we will continue exploring the SQL language and apply what we've learned on a MySQL database. We will learn about Indexes, Data Types and more complex query structures.Read More…
  • Databases
    SQL for BeginnersPreview
    28 shares
    Most modern web applications today interact with databases, usually with a language called SQL. Lucky for us, this language is quite easy to learn. In this article, we are going to start with some basic SQL queries and use them to interact with a MySQL database.Read More…
  • Web Development
    10 Essential SQL Tips for Developers200x200
    31 shares
    SQL is yet another essential language for developers wishing to create data-driven websites. However, many developers are unfamiliar with various aspects of SQL; so in this article, we'll analyze ten essential tips. Read More…
Advertisement
Suggested Tuts+ Course
Getting Started With Sequel$15
Advertisement