websitedesignby.com

Thoughts, notes and ideas of a web developer.

Welcome, if you enjoy these posts please consider staying updated via RSS Feed.

Twitter Weekly Updates for 2009-06-07

Posted June 7th, 2009 by Ross Sabes | No Comments
  • @apgfx bleh me too (about twits no the toe). Too busy right now, but stay tuned as new projects under way to launch in coming weeks. #

Powered by Twitter Tools.

  • Share/Save/Bookmark

Posted in category: misc | Tags:

php and MySQL DATE_FORMAT quick reference

Posted June 5th, 2009 by Ross Sabes | No Comments

I know it’s lazy, but it’s handy…

date(”Y-m-d H:i:s”);

The following characters are recognized in the
format
parameter string
format

character

Description Example returned values
Day
d Day of the month, 2 digits with leading zeros 01 to 31
D A textual representation of a day, three letters Mon through Sun
j Day of the month without leading zeros 1 to 31
l (lowercase ‘L’) A full textual representation of the day of the week Sunday through Saturday
N ISO-8601 numeric representation of the day of the week (added in
PHP 5.1.0)
1 (for Monday) through 7 (for Sunday)
S English ordinal suffix for the day of the month, 2 characters st, nd, rd or
th. Works well with j

w Numeric representation of the day of the week 0 (for Sunday) through 6 (for Saturday)
z The day of the year (starting from 0) 0 through 365
Week
W ISO-8601 week number of year, weeks starting on Monday (added in PHP 4.1.0) Example: 42 (the 42nd week in the year)
Month
F A full textual representation of a month, such as January or March January through December
m Numeric representation of a month, with leading zeros 01 through 12
M A short textual representation of a month, three letters Jan through Dec
n Numeric representation of a month, without leading zeros 1 through 12
t Number of days in the given month 28 through 31
Year
L Whether it’s a leap year 1 if it is a leap year, 0 otherwise.
o ISO-8601 year number. This has the same value as
Y, except that if the ISO week number
(W) belongs to the previous or next year, that year
is used instead. (added in PHP 5.1.0)
Examples: 1999 or 2003
Y A full numeric representation of a year, 4 digits Examples: 1999 or 2003
y A two digit representation of a year Examples: 99 or 03
Time
a Lowercase Ante meridiem and Post meridiem am or pm
A Uppercase Ante meridiem and Post meridiem AM or PM
B Swatch Internet time 000 through 999
g 12-hour format of an hour without leading zeros 1 through 12
G 24-hour format of an hour without leading zeros 0 through 23
h 12-hour format of an hour with leading zeros 01 through 12
H 24-hour format of an hour with leading zeros 00 through 23
i Minutes with leading zeros 00 to 59
s Seconds, with leading zeros 00 through 59
u Microseconds (added in PHP 5.2.2) Example: 54321
Timezone
e Timezone identifier (added in PHP 5.1.0) Examples: UTC, GMT, Atlantic/Azores
I (capital i) Whether or not the date is in daylight saving time 1 if Daylight Saving Time, 0 otherwise.
O Difference to Greenwich time (GMT) in hours Example: +0200
P Difference to Greenwich time (GMT) with colon between hours and minutes (added in PHP 5.1.3) Example: +02:00
T Timezone abbreviation Examples: EST, MDT
Z Timezone offset in seconds. The offset for timezones west of UTC is always
negative, and for those east of UTC is always positive.
-43200 through 50400
Full Date/Time
c ISO 8601 date (added in PHP 5) 2004-02-12T15:19:21+00:00
r » RFC 2822 formatted date Example: Thu, 21 Dec 2000 16:01:07 +0200
U Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT) See also time()

MySQL DATE_FORMAT

Specifier Description
%a Abbreviated weekday name
(Sun..Sat)
%b Abbreviated month name (Jan..Dec)
%c Month, numeric (0..12)
%D Day of the month with English suffix (0th,
1st, 2nd,
3rd, …)
%d Day of the month, numeric (00..31)
%e Day of the month, numeric (0..31)
%f Microseconds (000000..999999)
%H Hour (00..23)
%h Hour (01..12)
%I Hour (01..12)
%i Minutes, numeric (00..59)
%j Day of year (001..366)
%k Hour (0..23)
%l Hour (1..12)
%M Month name (January..December)
%m Month, numeric (00..12)
%p AM or PM
%r Time, 12-hour (hh:mm:ss followed by
AM or PM)
%S Seconds (00..59)
%s Seconds (00..59)
%T Time, 24-hour (hh:mm:ss)
%U Week (00..53), where Sunday is the
first day of the week
%u Week (00..53), where Monday is the
first day of the week
%V Week (01..53), where Sunday is the
first day of the week; used with %X

%v Week (01..53), where Monday is the
first day of the week; used with %x
%W Weekday name (Sunday..Saturday)
%w Day of the week
(0=Sunday..6=Saturday)
%X Year for the week where Sunday is the first day of the week, numeric,
four digits; used with %V
%x Year for the week, where Monday is the first day of the week, numeric,
four digits; used with %v
%Y Year, numeric, four digits
%y Year, numeric (two digits)
%% A literal “%” character
%x x, for any
x” not listed
above
  • Share/Save/Bookmark

Posted in category: Uncategorized, sql | Tags:

Twitter Weekly Updates for 2009-05-10

Posted May 10th, 2009 by Ross Sabes | No Comments

Powered by Twitter Tools.

  • Share/Save/Bookmark

Posted in category: misc | Tags:

Twitter Weekly Updates for 2009-04-26

Posted April 26th, 2009 by Ross Sabes | No Comments
  • slowly resurfacing this week from deep in the salt mines. #

Powered by Twitter Tools.

  • Share/Save/Bookmark

Posted in category: misc | Tags:

FaceBook ToS

Posted April 20th, 2009 by Ross Sabes | No Comments

I wonder if this applies to my flickr feed or blog feed?

When you post User Content to the Site, you authorize and direct us to make such copies thereof as we deem necessary in order to facilitate the posting and storage of the User Content on the Site. By posting User Content to any part of the Site, you automatically grant, and you represent and warrant that you have the right to grant, to the Company an irrevocable, perpetual, non-exclusive, transferable, fully paid, worldwide license (with the right to sublicense) to use, copy, publicly perform, publicly display, reformat, translate, excerpt (in whole or in part) and distribute such User Content for any purpose, commercial, advertising, or otherwise, on or in connection with the Site or the promotion thereof, to prepare derivative works of, or incorporate into other works, such User Content, and to grant and authorize sublicenses of the foregoing. You may remove your User Content from the Site at any time. If you choose to remove your User Content, the license granted above will automatically expire, however you acknowledge that the Company may retain archived copies of your User Content. Facebook does not assert any ownership over your User Content; rather, as between us and you, subject to the rights granted to us in these Terms, you retain full ownership of all of your User Content and any intellectual property rights or other proprietary rights associated with your User Content.

http://www.facebook.com/terms.php?ref=pf

  • Share/Save/Bookmark

Posted in category: Uncategorized | Tags:

Twitter Weekly Updates for 2009-04-05

Posted April 5th, 2009 by Ross Sabes | No Comments
  • added google analytics to websitedesignby.com #
  • @dsundrum, yea that is my wordpress posting activity in twitter. Been experimenting with all the social gizmos lately :) #

Powered by Twitter Tools.

  • Share/Save/Bookmark

Posted in category: misc | Tags:

Twitter Weekly Updates for 2009-03-29

Posted March 29th, 2009 by Ross Sabes | No Comments
  • shredding paper #
  • @RonKadue hey buddy, welcome to twtiter! I am a total newbie too :) #
  • @RonKadue seriously though if you want to connect with old friends go to facebook and put in your highschool… omg they are all there! #
  • @beachinguy bill that’s an amazing article. you are a genius. #
  • took Joe to soccer practice, dinner, now playing a little WoW before bed. #
  • working on keyringthing.com updates. #
  • ted updated the new dev server with php 5.2.8, woohoo. #
  • slept in a tent in the backyard with Joe last night. He is proud of himself for sleeping all night in the tent. #

Powered by Twitter Tools.

  • Share/Save/Bookmark

Posted in category: misc | Tags:

WordPress

Posted March 21st, 2009 by Ross Sabes | No Comments

This site is currently running on word press blogging tool and publishing platform. I installed the Cleanmachine theme but that will likely change soon and often as I experiment with differnt looks and functionality. You might be wondering why I didn’t design my own site. Currently I am interested in learning about existing technology and how to increase efficiency for myself and clients. I am more intersted in learning how to use and integrate existing systems than to build new ones from scratch. The wheel has been invented.

Inevitably I will end up having to build new systems, but my experiences using existing ones will improve my skill at developing new ones.

  • Share/Save/Bookmark

Posted in category: Uncategorized | Tags:

Portfolio Section added

Posted March 21st, 2009 by Ross Sabes | No Comments

I added a new portfolio section to the site where I can show past works. I plan on posting past web sites, graphic design and other projects in this section in the coming weeks.

  • Share/Save/Bookmark

phpFlickr

Posted March 12th, 2009 by Ross Sabes | No Comments

I made a random flickr image loader using phpFlickr. It loads a random image from based on the search term entered in the text box. Search terms are saved in a database and reused randomly on each refresh.

  • Share/Save/Bookmark

Posted in category: APIs, Programming, php, sql | Tags: