I’m an avid user of mind maps, and recently found a google chrome app, that also is an iPhone and Droid app which allows you to create and share Mind Maps.
I’ve used xFreeMind for a long time, along with so many others, however, MindMesiter.com, is far, far, far superior,.. it’s everywhere with me, it’s something I can share with clients or work with employees on.
Enjoy
Today begins the refresher course in Spanish of the Latin American variety. We are getting ready to go back to Mexico and what better to help in those tough negotiations than being able to speak the language.
Lesson 1: remember the basics.,..
I’ll check back later
Ok, so the other day I did a php script to export any table to csv,. well I was thinking it sure would be sweet to also be able to import from csv to any table.
function csv2talbe($sourceFile,$tableName,$maxLine=1000){
global $errors;
$fileHeadings = array();
$tableHeadings = array("fields","from","import","table");
if( ($handle = fopen("$sourceFile","r") ) !== false ){
$columns = fgetcsv($handle, $maxLine, ",");
foreach( $columns as $col ){
$fileHeadings[] .= $col;
}
$qPrefix = "insert into $targetTable (" .join(",",$tableHeadings).")\n VALUES";
while(( $data = fgetcsv($handle, $maxLine, ",")) !== false ){
while( count($data) < count($columns) )
array_push($data, NULL);
$query = "$qPrefix (".join(",",quote_all_array($data)).");";
mysql_query($query);
if( mysql_error() != '' ){
$errors = true;
$error_txt .= "<p>" . mysql_error() . "</p>";
}
}
fclose($handle);
}
if( $errors === false ){
$q = mysql_query("truncate {table to be updated}");
$q = mysql_query("insert into {table to be inserted} (dateUpdated,success,failure) values(curdate(),'Success','');
if( mysql_error() != '' ){
$errors = true;
$error_txt .= "<p>" . mysql_error() . "</p>";
} else {
$q = mysql_query("insert into {updatetable} (dateUpdated,success,failure) values(curdate(),'success','');
if( mysql_error() != '' ){
$errors = true;
$error_txt .= "<p>" . mysql_error() . "</p>";
}
}
}
if( $errors === true ){
mail("youremail@yourdomain.com","your name","subject","message . $error_txt");
} else {
mail("youremail@yourdomain.com","your name","subject","message success");
}
function quote_all_array($values){
foreach($values as $key=>$value)
if( is_array($value) )
$values[$key] = quote_all_array($value);
else
$values[$key] = quote_all($value);
return $values;
}
function quote_all($value){
if( is_null($value))
return "NULL";
$value = "'" . mysql_real_escape_string($value) . "'";
return $value;
}
// and that pretty much does it...
This is a great little mysql table to csv script I use to create a backup file of any table within a db.
$headings = array();
$q = mysql_query("select * from {table_name} where {conditions} );
for( $f=0; $f<mysql_num_fields($q); $f++ ){
$headings[] .= mysql_field_name($q,$f);
}
$tableFile = "/path/to/bak/files/" . "filename_" . date("ymd") . ".csv", 'w');
while( $row = mysql_fetch_array( $q ) ){
$vals = array();
foreach( $headings as $h ){
$vals[] .= $row[($h)];
}
fputcsv($tableFile,$vals);
unset($vals);
}
fclose($tableFile);
Basically you just decide on the path, and the table to export, then you can set a nice crons sript to run it via php, or grab it from the web whenever you need.
After cruising around the new Tyler Chevy Cadillac website, I have noticed that they have three Chevrolet Volt’s available, I thought these where sold out everywhere.
Looking for a Chevy Volt, take a look at Tyler http://www.TylerChevroletCadillac.com/chevrolet-volt.html
Tyler Automotive has done more to help consumers in their area find the right vehicle.
They’ve worked hard to develop another website, this time for New Cadillac Cars trucks and suvs, along with Chevrolet Vehicles.
So if you need a new Chevy Spark, Volt or Corvette take a look at the beautiful new site http://www.tylerChevroletCadillac.com you will not be disappointed.
Looking for a new chrysler, new dodge, new jeep or a used car, truck or suv; you’ve found the right place.
Recently I had the opportunity to work with Tyler Chrysler, Dodge, Jeep, Ram and I have to say they are a great dealership to work with.
There is a great selection of new and used vehicles, and they’ve just launched a new website.
Who can say how this all started, and when, but the feud goes back for generations.
For as long as I can remember, Dunning Toyota and I have been discussing the possibility of buying a car. Of course, I have since purchased a new Scion FR-S from Spartan Toyota in Lansing, MI but the feud continues.
Really I want to see this post on page one, but we will see where we can get. If you are looking for new or used cars including Used Toyota in Ann Arbor, or a New Toyota in Michigan then you should make the drive to Spartan Toyota in Lansing.