Posts Tagged ‘script’

Stuff I need to look-up every time

November 7, 2011 by marco · Leave a Comment
Filed under: Snippets, mySQL 
Social Tagging: •

You lost your leading zeros of your varchars importing/exporting your data. You have this example data in your table storagebins: area = L, row = 1, rack = 2, shelf = 3 and it is supposed to look like this area = L, row = 001, rack = 02, shelf = 03 Use this SQL [...]

VBA Macro to Convert Dates in a Range – the Dirty Way

November 1, 2011 by marco · Leave a Comment
Filed under: Snippets, VBA, mySQL 
Social Tagging: • •

I used this hacked Excel-Macro to convert all dates in a selected range from a manual data import using Excel to generate all required INSERTs for our MySql database from 03.08.2011 16:51:01 to 2011-08-03 16:51:01 In case you wonder, where you can find your Visual-Basic editor and execute your VBA-code… follow these instructions. Here is [...]

Clean your PHP4 Legacies using sed

October 19, 2010 by marco · Comments Off
Filed under: Linux, Snippets, Tools 
Social Tagging: • • •

If you have to deal with very old PHP4 legacy code containing every syntax crime you may know from the early years, how would you handle it? Give it to your junior people to fix it manually? I like to have at least some handy helpers for the first rough corrections. I found sed to [...]

Backup MySql-Database using only FTP

January 18, 2010 by marco · Comments Off
Filed under: Problems, Snippets 
Social Tagging: • •

We have just had the case of having ftp access to a site on a shared hosting LAMP webspace but needed also the database and mainly the database scheme to setup our own development-system for the app. This is actually very straight forward using the following snippet uploaded and executed on the webserver: <?php exec( ’mysqldump [...]

Add a PHP Post-Commit-Hook to your SVN

November 10, 2009 by marco · Comments Off
Filed under: Snippets, Software development, Tools, Tutorials 
Social Tagging: • • •

This is just a link to a very good tutorial on how to make your own SVN post-commit hook using a PHP script. It sends the following information via email: Committer name Commit message List of files edited Diff of changes made http://techchorus.net/writing-php-script-send-svn-commit-changeset-email-notification

A Simple PHP Google Sitemap Generator

February 26, 2009 by marco · Comments Off
Filed under: Read-Write-Web, Snippets, Tools, XML 
Social Tagging: • • •

I just hacked together a very simple class and CLI script to help me generate Google sitemap XML on a daily basis using PHP. If you have not yet heard of it: Google sitemaps help you promote your content if you have certain deep links that only show up if a visitor for example performs [...]

Use of MySql Variables

January 14, 2009 by marco · Comments Off
Filed under: Snippets, mySQL 
Social Tagging: • • • •

Case: I was building a CLI script to aggregate data from one MySql database and write results to another MySql database using 2 open db-connections. This way the script’s execution time was in the some-minutes-range… not good! I tried a more effective attempt: I let the CLI script output all necessary statements to drop and [...]