Snipplr

(DOS Batch) Format Date In Batch File - kidmizere

Fri, 16 May 2014 03:45:00 UTC

Nice script for formatting dates in a batch file without having the system locale settings impact your format

(PHP) Session Timeout - kidmizere

Wed, 26 Mar 2014 05:32:02 UTC

This is a neat little process for setting a timer and ending a session - change time to reflect minutes for timeout, change redirect to your logout page

(SQL) Adding Linked Server to MSSQL - kidmizere

Fri, 28 Feb 2014 06:52:55 UTC

Adding a linked server to MSSQL account - particularly a MYSQL server

(SQL) MSSQL where date=today - kidmizere

Fri, 28 Feb 2014 03:56:56 UTC

This is the best method for querying a table to get data where a date column needs to equal today:

(PHP) PHP Print all server Variables - kidmizere

Wed, 12 Feb 2014 08:07:13 UTC

Prints all $_Server variables to table

(MySQL) fill dates MYSQL - kidmizere

Tue, 17 Dec 2013 08:48:53 UTC

Not Mine but nicely done

(SQL) Add dated records to MSSQL using while loop - kidmizere

Thu, 12 Dec 2013 07:16:57 UTC

This loop adds a bunch of records to your database with a date field pre-populated. Works well for pre-populating a table for filling out daily by a form

(Other) Veritas List All disk Groups even those not managed - kidmizere

Sat, 03 Aug 2013 22:09:02 UTC

Great for finding disk group names

(PHP) List only certain files in a folder with PHP - kidmizere

Sat, 27 Jul 2013 01:08:08 UTC

Lists only certain files extensions as links on a page from a defined folder

(SQL) Update trigger for datetime modified field - kidmizere

Fri, 28 Jun 2013 07:00:23 UTC

This will create a table, create an update trigger to add current datetime to modify_date field, do 2 inserts, 1 update and display the results.

(Other) Change Excel Cell Colors based on whether they contain data or not - kidmizere

Thu, 13 Jun 2013 00:23:58 UTC

This formula will automatically change a cell's background color if there is data in it. You can also change the formula to only fill cells where there is no data.

(Visual Basic) Convert Excel plain text links to hyperlinks - kidmizere

Wed, 07 Mar 2012 15:00:09 UTC

Save the following code as a macro and then apply it to the fields you want to convert

(Visual Basic) Highlight every other row - kidmizere

Tue, 14 Feb 2012 06:48:58 UTC

Awesome shortcut.

(PHP) Get Referring Page - kidmizere

Mon, 17 Oct 2011 00:52:14 UTC

(PHP) SMS TEXT FROM PHP - kidmizere

Sat, 01 Oct 2011 00:17:55 UTC

(PHP) MANTIS BUG TRACKER - kidmizere

Fri, 16 Sep 2011 00:05:37 UTC

(PHP) Display Errors in PHP without php.ini access - kidmizere

Mon, 11 Jul 2011 10:40:20 UTC

(MySQL) Add Leading zero to field (ZipCodes) - kidmizere

Sun, 10 Jul 2011 14:34:13 UTC

(PHP) Check Referer to force login - kidmizere

Sat, 11 Jun 2011 06:33:45 UTC

(MySQL) timestamp equals today - kidmizere

Thu, 09 Jun 2011 10:40:30 UTC

(PHP) CREATE INSERT FOR ALL FORM VARIABLES (POST /GET) INTO MYSQL USING PHP - kidmizere

Sun, 27 Mar 2011 01:40:14 UTC

This generates a simple insert statement for mysql based on all the variables in $_GET or $_POST using a simple page. It does not do the inserts although that is a simple addition - just builds and displays your insert statement.

(MySQL) Append Data to Field in MySql - kidmizere

Sat, 26 Mar 2011 07:33:33 UTC

Notice the space in the appended portion, otherwise you just tack right on with no separation. If your original value is null you can use this: CONCAT(IFNULL(email_data, ''),' $email_data') This will add it on to a null value as the first value in the entry

(PHP) See if record exists - php / mysql - kidmizere

Sat, 26 Mar 2011 01:26:44 UTC

(PHP) Trim Whitespace PHP - kidmizere

Sat, 26 Mar 2011 01:13:09 UTC

(PHP) show delete button in koolcontrols datagrid based on user - kidmizere

Fri, 04 Mar 2011 05:56:19 UTC

(MySQL) reset auto-increment in mysql - kidmizere

Fri, 04 Mar 2011 05:38:01 UTC

(PHP) Export MYSQL to EXCEL / CSV via PHP - kidmizere

Sun, 09 Jan 2011 10:04:41 UTC

Modify includes to connect and select to provide correct result set

(PHP) PHP MySql Config.php - kidmizere

Wed, 08 Dec 2010 12:52:35 UTC

(MySQL) Adding and testing AES encrypted password field - kidmizere

Wed, 08 Dec 2010 12:48:40 UTC

(PHP) PHP Display All Form Variables - kidmizere

Wed, 08 Dec 2010 12:47:20 UTC

(Windows Registry) Enable Passive FTP Server 2008 - kidmizere

Wed, 08 Dec 2010 12:44:30 UTC