Gallitin Blog

0

MySQL – find in set vs in

These are two different commands with different outputs when added to a SQL query. MySQL “in” command for example: select * from assets a left outer join assetInterests ai on a.id = ai.assetID where...

0

Simple Twitter Auto Poster

This is the first in what will end up being a several part tutorial on creating a Twitter posting program.  These tutorials will show how to create the bot using the PHP library that...

0

Select Data Date Attribute Value with jQuery

How can I just select the value of the data-date attribute. I need to get 2016-02-14 into a jQuery variable. <td class=”fc-day fc-widget-content fc-sun fc-past” data-date=”2016-02-14″> You can select it with jQuery using: $(...

0

Text-Transform CSS

Is there a way to text-transform an all caps dataset? Example data: THIS IS MY TEXT If I add text-transform:capitalize; on that text nothing happens. My desired output of the original text would be: This...

0

WordPress SQL Syntax Example

I have a couple of tables I’m joining and only want to return users that a field missing in the joined table. Users id fname lname userMeta id metaKey metaValue I’m trying to find...

0

PHP Date Formatting

A simple example of how to take a date and change it’s format using PHP. August, 3 2015 to YYYY-MM-DD Easily done with the below code: $old_date = ‘August 3, 2015’; $new_date = date(‘Y-m-d’,...