Jul 31

Insert csv file into mySQL

Uncategorized 3 Comments »
LOAD DATA LOCAL INFILE '/home/chris/members.csv' INTO TABLE members_new FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (lastname, firstname, dob);

Jul 28

Check if an element’s hidden or visible using mootools

Uncategorized 2 Comments »

OffsetHeight property returns the elements real width including borders, margin and padding.
This is a IE introduced property not in w3c but now implemented in almost all browsers. Maybe we should try using mootools new get calculated width/height?

We combined this with phatfusions validate to only validate visible fields on forms.

Element.implement(
{	isHidden: function()
{	var w = this.offsetWidth, h = this.offsetHeight,
force = (this.tagName === 'TR');
return (w===0 && h===0 && !force) ? true : (w!==0 && h!==0 && !force) ? false : this.getStyle('display') === 'none';
},

isVisible: function()
{	return !this.isHidden();
}
});