Timestamp Field Snippets


PHP code to convert MySQL date to UNIX timestamp

14 March, 2013   

PHP code example to process MySQL Timestamp

21 September, 2011   

Allows you to add a string to end or start of a field to use when comparing or selecting data. The second argument is added to the end of the first

Demonstrates to select all the Birthdays that will occur as of today, 15 days

Select all the Birthdays that will occur as of today, 15 days

Oracle 10G has enhanced the flashback feature further and has turned it into a much more powerful feature by introducing a number of additional function. Some of the more common ones are discussed here. - Flashback Table - Flashback Drop - Flashback Database

30 April, 2016   

So better not to do, because the invisible fields are not needed for the binding form of validation of input data, etc.

Example code to update or convert the field to UPPERCASE.

MySQL code to find all duplicates in a database column(s)n.

15 February, 2015   

Move field position while still retaining its content.

14 September, 2013   

An example for MySQL Results To Array

29 December, 2012   

Example MySql code to append Data to Field in MySql

Mysql code example to SELECT based on a field that can have a NULL value.

14 May, 2011   

This is a general code to use when deleting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. A variation of the code would be not to delete the record (as you tend to always need to restore or retrieve it sooner or later) you can add a 'status' field. If status='d' then it is...

30 March, 2013   

The characters in a password field are masked (shown as asterisks or circles).

Note that to add a new column to the query, just add in an input box to the HTML, the PHP generates an insert for each field.

14 June, 2015   

This function helps you checking a UNIX timestamp with human readable time formats like 1m, 2d or 4y.

23 March, 2011   

When using forms within your web site, there may be times when you will want to include an example of what you'd like your visitors to fill in your form field. Although you could place some default text within your form field, your users would need to delete the default text in order to type in their own information.

When using forms within your web site, there may be times when you will want to include an example of what you'd like your visitors to fill in your form field. Although you could place some default text within your form field, your users would need to delete the default text in order to type in their own information.

14 May, 2011   

This is a general code to use when updating an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match.