Author Archives: J.D. H.

Reverse order of individual items in a delimited string

Topic: Reversing the order of individual items in a string. Specifics: I had a date contained in a GET query string that was formatted as follows: 01/27/2013 and I needed it reversed to 2013/01/27 Here is a simple method to do the reversing in PHP: $toDate = htmlentities($_GET[‘to’]); $toDateNew = implode(“/”,(array_reverse(explode(“/”,$toDate)))); Explanation of code: First you explode the $toDate variable, then reverse the resulting array, finally you implode that array back into a string. Of course there are other date

Set your own date format in MySQL

Use DATE_FORMAT in MySQL to create your date strings formatted however you like: SELECT CONCAT(YEAR(res_hotel_booking_bookings.created),’-‘,DATE_FORMAT(res_hotel_booking_bookings.created,’%m’) ,’-‘,DATE_FORMAT(res_hotel_booking_bookings.created,’%d’)) AS creationDate, Count(res_hotel_booking_bookings.id) As reservationsMade FROM res_hotel_booking_bookings WHERE res_hotel_booking_bookings.created >= ‘2013-10-15 00:00:00’ AND res_hotel_booking_bookings.created <= ‘2013-10-17 24:00:00’ GROUP BY YEAR(res_hotel_booking_bookings.created), MONTH(res_hotel_booking_bookings.created), DAY(res_hotel_booking_bookings.created) ORDER BY creationDate DESC There are more concise ways to do this, but this was adapted from an earlier method that used CONCAT so I stuck with that… 🙂

Link aggregation / NIC teaming [Windows 7]

Some tips for link aggregation/NIC teaming in Windows 7 using Intel NICs and drivers: Intel NIC’s 802.3ad Link Aggregation in Windows 7? – [H]ard|Forumhttp://hardforum.com/showthread.php?t=1762818If anyone else is trying to do this, I figured it out. Follow these directions for Intel NIC’s. The feature is not included in Windows 7, so the NIC drivers have to support it. You have to be logged… Network Connectivity — How do I use Teaming with Advanced Networking Services (ANS)?http://www.intel.com/support/network/sb/cs-009747.htmAdapter teaming with Intel® Advanced Network

Estimating the cost of building a new house

We are planning on building a new house next Spring 🙂 As such, I have been trying to get a feel for cost per finished square ft. So far, after talking to other people that have built homes in the area and a number of builders, it looks like our area is generally $75-$125 per finished square foot. We live in an aera with bountiful timber and fairly low wages, quite ideal for house construction. So, that figure it likely

NAS that supports SSDs with TRIM? [SOLVED]

Q. I am looking for a NAS that will let me use SSDs and supports TRIM. That is very important to me because I want the SSDs to last a long time. I like Intel or Samsung drives if possible and I only need 100GB to 200GB or so. FYI I am looking for a two bay RAID1 mirrored solution. Thank you! -Sergio Kan A. Hi Sergio, I think you are in luck 🙂 Synology is a well respected NAS brand

5% Cashback with Chase Freedom: Amazon, department stores

Signup for 5% Cashback at Amazon and many department stores, promotion lasts from Oct 1st-Dec 31st:   activation link Qualifying department stores include: JCPenney® Kohl’s® Macy’s® NORDSTROM Sears® And many more: BASKINS® BEALLS BEITER’S BELK The Big Store bloomingdale’s Bon-Ton®, including Bergner’s® Boston Store® Carson’s® Elder-Beerman® Herbergers® PARISIAN Younkers® Boscov’s Bradley’s burke’s® Cayman’s® Cee & Cee Department Store CHARLES christensen’s CONWAY Cook Brothers Dillard’s FLEMINGTON DEPARTMENT STORE Getz’s® HUDSON’S JC’S 5 Star1 Jeffery JOE BRAND LOEHMANN’S Lord & Taylor Magic

Help, I have a new user profile in Chrome! [solved]

Q. Hiya, last time I started up Chrome I got a weird icon in the window and it had a user name Bluesy?! Did I get hacked?! How do I remove this user?! Please Help! -Joelle A. Hi Joelle, do not worry. 🙂 Thankfully you are just seeing one of the many built in names that Chrome automatically give to a new user profile. Here is a complete list of the possible Chrome user profile names: You can also edit