MattKendrick.com

I’ve been working on a new PHP script to help people restore individual MySQL tables from a MySQL Dump file. You may recall my post on having a backup plan. This tool works great with another great tool called BigDump.

PHP MySQLDump Browser
Version 0.01 Beta
Author: Matt Kendrick (yeah! that’s me)

DESCRIPTION:
PHP MySQLDump Browser allows users/system admins to browse through MySQL Database Backups (Dump Files).
Users can view and extract individual table structures and or data from MySQL database dumps.
Use this script to avoid restoring entire backups to recover individual tables.
Database dumps complied by mysqldump and phpMyAdmin are compatible with this tool.
Note: This is an unofficial tool released under the GNU General Public License.
PHP MySQLDump Browser creators have no affiliation with Sun Microsystems.

INSTRUCTIONS:
1. Place the script on your webserver or webhost in the same directory as your MySQL backup dumps.
2. Run the script.
3. Choose which backup file you want to search. The script will search through the
dump file for table structures and data. Depending on the size of the dump, this may take some time.

4. Once the script has finished indexing the dump file, you may choose which table you wish to extract or
view. By default the results of your query will display in the iframe at the bottom of the page. However
you may download the results to file by clicking the download link above the iframe.

IMPORTANT: Remove PHP MySQLDump Browser as soon as you are finished.

COPYRIGHT AND DISCLAIMER:
THIS SCRIPT IS PROVIDED AS IS, WITHOUT ANY WARRANTY OR GUARANTEE OF ANY KIND
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General
Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option)
any later version. If you change this script or add any features please tell me.

PHP MySQLDump Browser (1379)

About: This plugin watches your Twitter RSS Feed for user-defined “launch codes” to trigger user-defined script URLs.

Have you ever needed a script or task run on your blog and you were not near a computer with internet access? Well look no further than “Tweet My Script.” This plugin allows you to simply use your cell-phone to text a short tweet to Twitter with a “launch code.” When someone accesses your Word Press blog, Tweet My Script will check to see if you’ve left any new launch codes to activate. After each successful launch, the plugin records the previous tweet. This insures that the script being launched will only be launched once, unless the launch code is used again in a new tweet. This plugin can be used to launch any public accessible script.

Updates

Version 0.75 – March 7th 2010: Offset feature added. Allows for bloggers to set an offset on the number of times your blog checks Twitter to keep from exceeding API limits. This is ideal for blogs with high traffic or blogs hosted on high traffic shared hosting. Default offset is set to 0.

Installation

1. Upload `tweet_my_script.php` and `tweet_my_script_options.php` to the `/wp-content/plugins/` directory

2. Activate the plugin through the ‘Plugins’ menu in WordPress

3. Configure plugin settings from the dashboard settings option `Tweet My Script`

Download

Tweet My Script WordPress Plugin (1037)

This is my first official plugin for WordPress! If you find it helpful or would like to help further push development, please donate!

Here’s a quick script I wrote to display random quotes.


<?php

//Random Quotes Script
//Matt Kendrick – Aug. 2009
//mattkendrick.com

//Displays random quotes from a MySQL Table

//database server
$db_server = “localhost”;

//database user
$db_user = “user”;

//database password
$db_pass = “password”;

//database name
$database = “quote_db”;

//connect to database
mysql_connect($db_server,$db_user,$db_pass);

//select database
mysql_select_db($database);

//query database for random quote
$sql = “SELECT quote_text,author FROM quotes ORDER BY RAND() LIMIT 1″;
$result = mysql_query($sql);

while($row = mysql_fetch_array($result,MYSQL_NUM))
{

//display result – format however you like
echo “<i>’$row[0]‘</i> – <b>$row[1]</b>”;

}

//close database connection
mysql_close();

?>

Below is the table structure needed.

–
– Table structure for table `quotes`
–

CREATE TABLE IF NOT EXISTS `quotes` (
`quote_id` int(11) NOT NULL auto_increment,
`quote_text` text NOT NULL,
`author` varchar(50) NOT NULL,
PRIMARY KEY (`quote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

–
– Dumping data for table `quotes`
–

INSERT INTO `quotes` (`quote_id`, `quote_text`, `author`) VALUES
(1, ‘I think it”s fair to say that personal computers have become the most empowering tool we”ve ever created. They”re tools of communication, they”re tools of creativity, and they can be shaped by their user.’, ‘Bill Gates’),
(2, ‘Never trust a computer you can”t throw out a window.’, ‘Steve Wozniak’),
(3, ‘The Internet is not just one thing, it”s a collection of things – of numerous communications networks that all speak the same digital language. ‘, ‘Jim Clark’),
(4, ‘What do we want our kids to do? Sweep up around Japanese computers?’, ‘Walter F. Mondale’);

You can download the complete script and database table here: Random Quote Generator (506)