Advertisement

SQL

  • OpenCart
    Understand Registry and Loader Objects in OpenCartOpencart
    131 shares
    In this tutorial, we're going to look at the inner workings of OpenCart. Specifically, we'll look at the registry and loader objects. The registry object is used to store variables and objects in the common registry so that they can be used later on throughout the script execution. The loader is a very important utility object, as it's used to load the different components of the OpenCart framework.Read More…
  • Python
    Creating a Web App From Scratch Using Python Flask and MySQL: Part 8Python
    153 shares
    In the previous part of this tutorial series, we populated the dashboard page of our application with the wishes created by different users. We also attached a like button to each wish so that a user could like a particular wish. In this part of the series, we'll see how to toggle the like/unlike display and show the total number of likes received by a particular wish.Read More…
  • Python
    Creating a Web App From Scratch Using Python Flask and MySQL: Part 7Python
    136 shares
    In the previous part of this series, we implemented image upload functionality for the users while adding a wish. We also added a few more options related to a user's wish on the Add Wish page. In this tutorial, we'll take it to the next level by implementing the functionality to like a particular wish.Read More…
  • Python
    Creating a Web App From Scratch Using Python Flask and MySQL: Part 6Python
    212 shares
    In the previous part of this series, we implemented paging for the wish list on the user home page. In this part of the series, we'll implement an option for the user to upload an image representing a wish, an option to mark the wish as accomplished, and an option to set privacy.Read More…
  • Python
    Creating a Web App From Scratch Using Python Flask and MySQL: Part 5Python
    186 shares
    In the previous part of this series, we saw how to implement the Edit and Delete wish functionality for our Bucket List Application. In this part we'll implement the paging functionality for our user home list.Read More…
  • Python
    Creating a Web App From Scratch Using Python Flask and MySQL: Part 4Python
    319 shares
    In the previous part of this tutorial series, we implemented the required functionality for a logged-in user to add a wish. We also saw how to display the wishes entered by a user. In this part, we'll implement the functionality for editing and deleting the wishes entered by a user.Read More…
  • Python
    Creating a Web App From Scratch Using Python Flask and MySQL: Part 2Python
    278 shares
    In the previous part of this series, we saw how to get started with Python Flask and MySQL and implemented the user registration portion of our application. In this tutorial, we'll take this to the next level by implementing the sign-in and log-out functionality for our application.Read More…
  • WordPress
    Create a Simple CRM in WordPress: Extending WordPress Search to Include Custom FieldsUntitled%202
    261 shares
    We’ve been looking at how to create a simple CRM system in WordPress. In the last part of this series, we added code to our plugin which allowed us to display our Advanced Custom Fields in the WordPress List Table (WP_List_Table), and sort our data alphabetically by those new fields. Today we’ll cover how to extend the search functionality to include the data stored in our Custom Fields.Read More…
  • PHP
    Why you Should be using PHP's PDO for Database AccessPdo
    375 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
    27 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…
Advertisement
Suggested Tuts+ Course
Getting Started With Sequel$15
Advertisement