Archive | Databases RSS feed for this section
Integrating PHP and jQuery: New Plus Tutorial

Integrating PHP and jQuery: New Plus Tutorial

So you can work with PHP, and have a basic understanding of jQuery, but you haven’t yet figured out how to combine the two into your projects? If so, we’ve got you covered today! In this Plus tutorial, you’ll learn how to take advantage of PHP’s MySQL improved and prepared statements to query a database, how to request that returned data with jQuery, and then how to filter through the returned items and display them on the page, adding a touch of animations.

Read more
9 Tips For Working with MySQL Databases

9 Tips For Working with MySQL Databases

MySQL is one of the most popular relational database management systems (RDBMS) around, with over 6 million installations. It’s a fantastic choice for any new developer, because of its open source nature, wide support and abundance of tutorials available on the subject

Read more
Getting Started with XSL(T)

Getting Started with XSL(T)

In this tutorial, we will adventure into the world of XSL(T) and explain what it is, how to pull data from an XML document, basic iteration and basic login and conditional statements. Tutorial Details Program : Any Text Editor Version : 1 of 1 Difficulty: Medium Estimated Completion Time: 25min Overview Sometimes, you have huge datasets that are parsed out as XML that need to be formatted so that someone who doesn’t know how to read XML can read the data. In this tutorial, I will show you how that is done with the power of XSL(T)

Read more
SQL for Beginners: Part 3 – Database Relationships

SQL for Beginners: Part 3 – Database Relationships

Today, we continue our journey into the world of SQL and relational database systems. In this part three of the series, we’ll learn how to work with multiple tables that have relationships with each other. First, we will go over some core concepts, and then will begin working with JOIN queries in SQL

Read more