Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

About this user

Tracy Floyd http://www.coalescedesign.com

2 total

On This Page:

  1. 1 Return the MySQL-formatted date for 60 days from today (PHP)
  2. 2 Backup a single MySQL table

Return the MySQL-formatted date for 60 days from today (PHP)

to php mysql by tracyfloyd on Oct 04, 2006
// Get the date in MySQL date format for 60 days from today

$new_expiration_date = date('Y-m-d',mktime(0,0,0,date('m'),date('d')+60,date('Y')));

Backup a single MySQL table

to mysql by tracyfloyd on Sep 28, 2006
// Use this to take a single table backup, with elements in double quotes delimited with a comma: 

while ($row = mysql_fetch_array($query,MYSQL_NUM)) $output .= "\"" . implode("\",\"",str_replace("\r\n"," ",$row)) . "\"\r\n"; echo $output; // or write $output to a file
2 total

On This Page:

  1. 1 Return the MySQL-formatted date for 60 days from today (PHP)
  2. 2 Backup a single MySQL table