Comments for David Walsh :: Legendary scribbles about JavaScript, HTML5, AJAX, PHP, CSS, and ∞. Legendary scribbles about JavaScript, HTML5, AJAX, PHP, CSS, and ∞. Tue, 15 May 2012 09:32:30 +0000 hourly 1 http://wordpress.org/?v=3.3.2 Comment on jQuery Comment Preview by michael kors factory outlet/?p=3392#comment-32185 michael kors factory outlet Tue, 15 May 2012 09:32:30 +0000 http://davidwalsh.name/?p=3392#comment-32185 This articles helps me more.Thanks for your sharing,I will pay more attentions to your blog. Looking forward to your better and better articles.See you next time. michael kors factory :http://www.michaelkorsfactorystore.com/ This articles helps me more.Thanks for your sharing,I will pay more attentions to your blog. Looking forward to your better and better articles.See you next time.
michael kors factory :http://www.michaelkorsfactorystore.com/

]]> Comment on Detect DOM Node Insertions with JavaScript and CSS Animations by Daniel/?p=5425#comment-32184 Daniel Mon, 14 May 2012 17:25:03 +0000 http://davidwalsh.name/?p=5425#comment-32184 Yeah, this is just vanilla JS, it works all by itself, no framework required - and for the record, jQuery is not magical-unicorn-pixie code, it can't do a single thing JavaScript itself can't do...because it IS JavaScript. Yeah, this is just vanilla JS, it works all by itself, no framework required – and for the record, jQuery is not magical-unicorn-pixie code, it can’t do a single thing JavaScript itself can’t do…because it IS JavaScript.

]]> Comment on Backup Your MySQL Database Using PHP by Marcus/?p=336#comment-32183 Marcus Mon, 14 May 2012 16:01:31 +0000 http://davidwalsh.name/?p=336#comment-32183 Sharing my improvements: (sorry - my linefeeds got smashed-up, I am trying to improve) I programmed a small extension to handle numeric values explicitly. This leads to: - better standard conformity (no quotes for numeric values) - less file space required (removing quotes) - speedup (skip escaping for numeric values)HowTo: 1. Create an array with all numeric types. 2. Get attribute-types for actual table, strip redundant information (in brackets). 3. Setup an array $numflag indicating numeric datatype for each attribute 4. Assign numeric values without quotes.CODE Snippets: <code>//1..at the top of function $numtypes=array('tinyint','smallint','mediumint','int','bigint','float','double','decimal','real');//2.. at the top of table-loop $typesarr=mysql_fetch_array(mysql_query('SHOW COLUMNS FROM '.$table));//3.. below 2 for($i=0; $i<$num_fields; $i++) { $acttype=trim(preg_replace('/\s*\([^)]*\)/', '', $typesarr[$i]['Type']));// strip brackets from type if (is_numeric(array_search($acttype,$numtypes))){//numeric type false cannot be checked correctly $numflag[$i]=1;}else{$numflag[$i]=0;} }//4.. in the fields loop (innermost) if ($numflag[$j]==1){$return.= $row[$j] ; } else{ $row[$j] = addslashes($row[$j]); $row[$j] = preg_replace("/\r\n/","\\r\\n",$row[$j]); $return.= '"'.$row[$j].'"' ; } </code>Thanks to David and all other Contributors Marcus Sharing my improvements:
(sorry – my linefeeds got smashed-up, I am trying to improve)
I programmed a small extension to handle numeric values explicitly.
This leads to:
- better standard conformity (no quotes for numeric values)
- less file space required (removing quotes)
- speedup (skip escaping for numeric values)

HowTo:
1. Create an array with all numeric types.
2. Get attribute-types for actual table, strip redundant information (in brackets).
3. Setup an array $numflag indicating numeric datatype for each attribute
4. Assign numeric values without quotes.

CODE Snippets:

//1..at the top of function
$numtypes=array('tinyint','smallint','mediumint','int','bigint','float','double','decimal','real');

//2.. at the top of table-loop
$typesarr=mysql_fetch_array(mysql_query('SHOW COLUMNS FROM '.$table));

//3.. below 2
for($i=0; $i<$num_fields; $i++) {
$acttype=trim(preg_replace('/\s*\([^)]*\)/', '', $typesarr[$i]['Type']));// strip brackets from type
if (is_numeric(array_search($acttype,$numtypes))){//numeric type false cannot be checked correctly
$numflag[$i]=1;}else{$numflag[$i]=0;}
}

//4.. in the fields loop (innermost)
if ($numflag[$j]==1){$return.= $row[$j] ; } else{
$row[$j] = addslashes($row[$j]);
$row[$j] = preg_replace("/\r\n/","\\r\\n",$row[$j]);
$return.= '"'.$row[$j].'"' ;
}

Thanks to David and all other Contributors
Marcus

]]> Comment on Backup Your MySQL Database Using PHP by Marcus/?p=336#comment-32182 Marcus Mon, 14 May 2012 15:53:40 +0000 http://davidwalsh.name/?p=336#comment-32182 Sharing my improvements: I programmed a small extension to handle numeric values explicitly. This leads to: - better standard conformity (no quotes for numeric values) - less file space required (removing quotes) - speedup (skip escaping for numeric values)HowTo: 1. Create an array with all numeric types. 2. Get attribute-types for actual table, strip redundant information (in brackets). 3. Setup an array $numflag indicating numeric datatype for each attribute 4. Assign numeric values without quotes.CODE Snippets: <code>//1..at the top of function $numtypes=array('tinyint','smallint','mediumint','int','bigint','float','double','decimal','real');//2.. at the top of table-loop $typesarr=mysql_fetch_array(mysql_query('SHOW COLUMNS FROM '.$table));//3.. below 2 for($i=0; $i<$num_fields; $i++) { $acttype=trim(preg_replace('/\s*\([^)]*\)/', '', $typesarr[$i]['Type']));// strip brackets from type if (is_numeric(array_search($acttype,$numtypes))){//numeric type false cannot be checked correctly $numflag[$i]=1;}else{$numflag[$i]=0;} }//4.. in the fields loop (innermost) if ($numflag[$j]==1){$return.= $row[$j] ; } else{ $aarr[$j] = addslashes($row[$j]); $aarr[$j] = preg_replace("/\r\n/","\\r\\n",$row[$j]); $return.= '"'.$row[$j].'"' ; } </code>Thanks to David and all other Contributors Marcus Sharing my improvements:
I programmed a small extension to handle numeric values explicitly.
This leads to:
- better standard conformity (no quotes for numeric values)
- less file space required (removing quotes)
- speedup (skip escaping for numeric values)

HowTo:
1. Create an array with all numeric types.
2. Get attribute-types for actual table, strip redundant information (in brackets).
3. Setup an array $numflag indicating numeric datatype for each attribute
4. Assign numeric values without quotes.

CODE Snippets:

//1..at the top of function
$numtypes=array('tinyint','smallint','mediumint','int','bigint','float','double','decimal','real');

//2.. at the top of table-loop
$typesarr=mysql_fetch_array(mysql_query('SHOW COLUMNS FROM '.$table));

//3.. below 2
for($i=0; $i<$num_fields; $i++) {
$acttype=trim(preg_replace('/\s*\([^)]*\)/', '', $typesarr[$i]['Type']));// strip brackets from type
if (is_numeric(array_search($acttype,$numtypes))){//numeric type false cannot be checked correctly
$numflag[$i]=1;}else{$numflag[$i]=0;}
}

//4.. in the fields loop (innermost)
if ($numflag[$j]==1){$return.= $row[$j] ; } else{
$aarr[$j] = addslashes($row[$j]);
$aarr[$j] = preg_replace("/\r\n/","\\r\\n",$row[$j]);
$return.= '"'.$row[$j].'"' ;
}

Thanks to David and all other Contributors
Marcus

]]> Comment on 9 Signs You Shouldn’t Hire THAT Web Guy by kcmr/?p=173#comment-32181 kcmr Mon, 14 May 2012 13:36:29 +0000 http://davidwalsh.name/9-signs-not-to-hire-that-web-guy/#comment-32181 The article is not completely a copy: he has omitted the first point "He calls himself a webmasters" for obvious reasons XD The article is not completely a copy: he has omitted the first point “He calls himself a webmasters” for obvious reasons XD

]]> Comment on PHP Serialize() & Unserialize() Issues by Kasimir/?p=224#comment-32180 Kasimir Mon, 14 May 2012 13:21:11 +0000 http://davidwalsh.name/php-serialize-unserialize-issues#comment-32180 This not only solves problems serializing data with quotes and stuff, but also is a solution if you want to save an array with different kinds of data (text and binary, for instance) and don't want to worry about corruption somewhere along the way.Yes, the downside is your data increases in size when encoding, but serious amounts of data should not be stored in serialized format in a database anyway. For small amounts, it's really not a big issue and a great solution. This not only solves problems serializing data with quotes and stuff, but also is a solution if you want to save an array with different kinds of data (text and binary, for instance) and don’t want to worry about corruption somewhere along the way.

Yes, the downside is your data increases in size when encoding, but serious amounts of data should not be stored in serialized format in a database anyway. For small amounts, it’s really not a big issue and a great solution.

]]> Comment on Retrieve Your Gmail Emails Using PHP and IMAP by asd/?p=2351#comment-32179 asd Mon, 14 May 2012 12:23:28 +0000 http://davidwalsh.name/?p=2351#comment-32179 <code> /* output the email body */ $output.= ”.$message.”;}echo $output; }/* close the connection */ imap_close($inbox);#######my full code####david walsh codewindow.addEvent(‘domready’,function() { var togglers = $$(‘div.toggler’); if(togglers.length) var gmail = new Fx.Accordion(togglers,$$(‘div.body’)); togglers.addEvent(‘click’,function() { this.addClass(‘read’).removeClass(‘unread’); }); //togglers[0].fireEvent(‘click’); //first one starts out read });’; $output.= ”.$overview[0]->subject.’ ‘; $output.= ”.$overview[0]->from.”; $output.= ‘on ‘.$overview[0]->date.”; $output.= ”;/* output the email body */ $output.= ”.$message.”;}echo $output; }/* close the connection */ imap_close($inbox); </code>
/* output the email body */
$output.= ”.$message.”;

}

echo $output;
}

/* close the connection */
imap_close($inbox);

#######my full code####

david walsh code

window.addEvent(‘domready’,function() {
var togglers = $$(‘div.toggler’);
if(togglers.length) var gmail = new Fx.Accordion(togglers,$$(‘div.body’));
togglers.addEvent(‘click’,function() { this.addClass(‘read’).removeClass(‘unread’); });
//togglers[0].fireEvent(‘click’); //first one starts out read
});

’;
$output.= ”.$overview[0]->subject.’ ‘;
$output.= ”.$overview[0]->from.”;
$output.= ‘on ‘.$overview[0]->date.”;
$output.= ”;

/* output the email body */
$output.= ”.$message.”;

}

echo $output;
}

/* close the connection */
imap_close($inbox);

]]> Comment on Increase PHP Script Execution Time Limit Using ini_set() by Anon/?p=308#comment-32178 Anon Mon, 14 May 2012 09:20:25 +0000 http://davidwalsh.name/?p=308#comment-32178 No, 10 minutes is not maximum execution time. I tried it out and script ran 45+ minutes before I stopped it myself.Just use: <code>set_time_limit(0);</code> So there is no limit. No, 10 minutes is not maximum execution time. I tried it out and script ran 45+ minutes before I stopped it myself.

Just use:
set_time_limit(0);
So there is no limit.

]]> Comment on Detect DOM Node Insertions with JavaScript and CSS Animations by sasklacz/?p=5425#comment-32177 sasklacz Mon, 14 May 2012 09:08:16 +0000 http://davidwalsh.name/?p=5425#comment-32177 why shouldn't it be ? Whole javascript here is just adding event listeners. why shouldn’t it be ? Whole javascript here is just adding event listeners.

]]> Comment on Better onChange with Dijit’s intermediateChanges by Tas/?p=5211#comment-32172 Tas Sun, 13 May 2012 21:51:21 +0000 http://davidwalsh.name/?p=5211#comment-32172 Ah, thanks for this! I think intermediateChanges should be true by default, just like in Flex. I do not understand why it isn't. Ah, thanks for this! I think intermediateChanges should be true by default, just like in Flex. I do not understand why it isn’t.

]]>