Servage Magazine

  We’re going to cover quite a lot of ground in this section. It’s not too difficult, but I recommend that you work your way through it carefully, as it sets the foundation for everything else in this set of articles. As always, there are some useful questions at the end of the article that you can use to test how much you’ve learned. Using Comments There are two ways in which you can add comments to your PHP code. The first turns a single line into a comment by preceding it with a pair of forward slashes, like this: // This is a comment This version of the comment feature is a great way to temporarily ...

So far, we’ve changed only one property at a time, but it is possible to transition several properties at once. I want the text color to change to black, but more slowly than the other animations. One way to do this is to list all of the values for each property separated by commas, as shown in this example. a.smooth { … transition-property: background-color, color, letter-spacing; transition-duration: 0.3s, 2s, 0.3s; transition-timing-function: ease-out, ease-in, ease-out; } a:hover, a:focus { background-color: red; letter-spacing: 3px; color: black; } The values are matched up according to their position in the list. For example, the transition of the color property (second in the list) has a duration of two seconds (2s) and uses the ease-in timing function. If ...

What about Sorting? What if I want to sort my data? Do I have to write some customized sorting script to sort the data after I get it out? Thankfully, no. SQL has already done that work for you. Here's an example of how you would retrieve and sort all of the last names in our "contacts" table that we created way back in Parts 1 and 2:   SELECT *   FROM table   ORDER BY last_name; How's that for easy? The ORDER BY clause tells the DBMS to perform a sort on the data using the "last_name" column. Now the data that you get out will be pre-sorted by last name from A to Z. So, ...

Welcome to the modern computing period, otherwise known as the mobile era. Market surveys support this designation, by reporting $70 billion in global sales revenue for smartphones and $134 billion for tablets. Each is estimated to more than double within the next 5 years with figures of $173 billion and a walloping $453 billion respectively. With this growth in mind, many businesses look to establish a mobile presence with their own online applications. Yet, native apps are expensive to develop and keep up to date with ever-changing technologies. Therefore, small to mid-sized businesses are continually looking to responsive designing. Not only is responsive designing cost effective over the long term, ...

A WHERE clause allows you to filter out any unwanted data so that the data you do get is exactly what you are looking for. Let's look for all of the people named "Paul" in our table.     SELECT first_name, email     FROM contacts     WHERE first_name = 'Paul'; Using the WHERE clause tells the DBMS you are only interested in data that has "Paul" in the "first_name" column. In our case we will get only one result because there is only one person in our "contacts" table with the name of "Paul". So, what if I want to filter my data using a number like in the "contact_id" column? Can I do that? Absolutely. To search ...

Now we have tables with stuff in them. The next logical step is getting stuff back out. In this lesson you will learn about the most used statement in SQL, the SELECT. What is a SELECT statement?   So, what does SELECT do? Very simply, it tells the DBMS that you want to get some data out of the database. So, how does it work? SELECT can range from very simple to painfully complex. With SELECT there are a whole host of different options available to you that will allow you specify, calculate and arrange your data in an infinite number of ways. Using a SELECT statement obviously begins with the SELECT command. Next, you will ...

Have you ever noticed the release patterns for iPhone or iOS versions? Do you see any similarity with the release for Windows versions? Both platforms are clearly withdrawing support for previous versions, or offering maintenance for just one or two of the recently released versions. Why do they do this? Is it purely profit driven or is there other factors? Sure, some of it can be attributed to say greed, but really it is driven more by technical responsibility. Anytime you see a new version of software or OS, it always arrives with new features and functionality. Plus developers are keeping up with changes in hardware, so they are relevant ...