When accessing a database in PHP, we have two choices: MySQLi and PDO. So what should you know before choosing one? The differences, database support, stability, and performance concerns will be outlined in this article.
(Continue)
Learn to Create Interactive Drill-Down Dashboards with PHP and FusionCharts
This tutorial will teach you how to easily create drill-down charts in PHP using the LinkedCharts feature of FusionCharts.
(Continue)
Quick Tip: Working with MySQL and SUM
In today’s quick tip screencast, we’re going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. We will be combining them to come up with some useful queries. This can reduce the number of queries you need to run for fetching certain types of summary data, and also provide a performance improvement.
(Continue)
A Deeper Look at Advanced Select Queries: New Premium Tutorial
To a SQL novice, JOINs can be intimidating and somewhat frustrating. Even when you think you have the query nailed, along comes an unexpected result which make you throw up your arms in surrender to the SQL gods. In this tutorial, we are going to build upon the excellent quick tip of working with MySQL and INNER JOIN recently posted and crack open the real power of a SELECT statement. Become a Premium member to access this tutorial, and all of the other fantastic articles and screencasts across all of the Tuts sites.
(Continue)
How to Create Blog Excerpts with PHP
Ever visited a blog, and noticed that each posting’s overview only contained a hundred characters or so, which is then followed by “…”? Ever wondered how to do that yourself? It’s not quite as easy as you might think. What if character number 100 occurs in the middle of a word? Do you want to display half of a word on the page? Of course not. In this video tutorial, I’ll show you how to compensate for this, as well as a host of other neat little things, like working with MySQL’s LEFT() function, using PHP’s strrpos, and substr, creating the beginning’s of an actual blog, and more.
(Continue)
Quick Tip: Working with MySQL and INNER JOIN
In today’s video quick tip, we’ll go over when and why to use JOINs when working with your databases.
(Continue)
An Introduction to MySQL 5: Views
The MySQL 5 series introduced quite a few changes. Triggers and stored procedures were two of the big ticket items. One of the lesser known additions, at least from the amount of writing on the subject, is the introduction of views. While after a quick look at MySQL views, you might not see the obvious advantages, they’re there if you dig into them just a bit.
(Continue)
Profiling MySQL Queries with phpMyAdmin: New Premium Tutorial
I’ve used phpMyAdmin for over a decade. In my early years with the tool, I simply needed something that could show me table structure and quickly give me the data inside. As my needs have grown, so have the tools included with phpMyAdmin which keeps me coming back as my primary MySQL tool, even with optimization. Become a Premium member.
(Continue)
Quick Tip: A Fast Overview of Querious (MySQL Manager)
In today’s video quick tip, we’ll have a quick (not sponsored) overview of a Mac database manager for MySQL that I came across yesterday, called Querious. As I mention in the screencast, I particularly like this one, because it just works — without being too complicated or overwhelming in the way that PHPMyAdmin might be for some.
(Continue)
Introduction to MySQL Triggers
Chances are, you know what a database trigger is, at least in conceptual terms. Chances are even greater that you know that MySQL supports triggers and has supported them for quite some time. I would guess, even armed with this knowledge, that a good many of you are not taking advantage of triggers with MySQL. They’re one of those things which should absolutely be in your development toolbox, as they can really change the way that you look at your data.
(Continue)
Join our newsletter!
Freelance Jobs
Create a Tutorial, Get Paid!
Have something to teach the world? Want to earn money doing it? Tutorials, screencasts, and articles published here on Nettuts+ are largely contributed by readers just like you! We'll pay you great money for good content. Find Out More
Follow Nettuts+ and Tuts+ on Twitter