this function is pure javascript, no ajax, no request to server.
function file_get_mimetype(filename) {
var mappings = {
'ez' : 'application/andrew-inset',
'atom' : 'application/atom',
'atomcat' : 'application/atomcat+xml',
'atomsrv' : 'application/atomserv+xml',
'cap' : 'application/cap', 'pcap' : 'application/cap',
'cu' : 'application/cu-seeme',
'tsp' : 'application/dsptype',
'spl' : 'application/x-futuresplash',
'hta' : 'application/hta',
'jar' : 'application/java-archive',
'ser' : 'application/java-serialized-object',
'class' : 'application/java-vm',
'hqx' : 'application/mac-binhex40',
'cpt' : 'image/x-corelphotopaint',
'nb' : 'application/mathematica',
'mdb' : 'application/msaccess',
'doc' : 'application/msword', 'dot' : 'application/msword',
'bin' : 'application/octet-stream',
'oda' : 'application/oda',
'ogg' : 'application/ogg', 'ogx' : 'application/ogg',
'pdf' : 'application/pdf',
'key' : 'application/pgp-keys',
'pgp' : 'application/pgp-signature',
'prf' : 'application/pics-rules',
'ps' : 'application/postscript', 'ai' : 'application/postscript', 'eps' : 'application/postscript',
'rar' : 'application/rar',
'rdf' : 'application/rdf+xml',
'rss' : 'application/rss+xml',
'rtf' : 'application/rtf',
'smi' : 'application/smil', 'smil' : 'application/smil',
'wpd' : 'application/wordperfect',
'wp5' : 'application/wordperfect5.1',
'xhtml' : 'application/xhtml+xml', 'xht' : 'application/xhtml+xml',
'xml' : 'application/xml', 'xsl' : 'application/xml',
'zip' : 'application/zip',
'cdy' : 'application/vnd.cinderella',
'kml' : 'application/vnd.google-earth.kml+xml',
'kmz' : 'application/vnd.google-earth.kmz',
'xul' : 'application/vnd.mozilla.xul+xml',
'xls' : 'application/vnd.ms-excel', 'xlb' : 'application/vnd.ms-excel', 'xlt' : 'application/vnd.ms-excel',
'cat' : 'application/vnd.ms-pki.seccat',
'stl' : 'application/vnd.ms-pki.stl',
'ppt' : 'application/vnd.ms-powerpoint', 'pps' : 'application/vnd.ms-powerpoint',
'odc' : 'application/vnd.oasis.opendocument.chart',
'odb' : 'application/vnd.oasis.opendocument.database',
'odf' : 'application/vnd.oasis.opendocument.formula',
'odg' : 'application/vnd.oasis.opendocument.graphics',
'otg' : 'application/vnd.oasis.opendocument.graphics-template',
'odi' : 'application/vnd.oasis.opendocument.image',
'odp' : 'application/vnd.oasis.opendocument.presentation',
'otp' : 'application/vnd.oasis.opendocument.presentation-template',
'ods' : 'application/vnd.oasis.opendocument.spreadsheet',
'ots' : 'application/vnd.oasis.opendocument.spreadsheet-template',
'odt' : 'application/vnd.oasis.opendocument.text',
'odm' : 'application/vnd.oasis.opendocument.text-master',
'ott' : 'application/vnd.oasis.opendocument.text-template',
'oth' : 'application/vnd.oasis.opendocument.text-web',
'docm' : 'application/vnd.ms-word.document.macroEnabled.12',
'docx' : 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
'dotm' : 'application/vnd.ms-word.template.macroEnabled.12',
'dotx' : 'application/vnd.openxmlformats-officedocument.wordprocessingml.template',
'potm' : 'application/vnd.ms-powerpoint.template.macroEnabled.12',
'potx' : 'application/vnd.openxmlformats-officedocument.presentationml.template',
'ppam' : 'application/vnd.ms-powerpoint.addin.macroEnabled.12',
'ppsm' : 'application/vnd.ms-powerpoint.slideshow.macroEnabled.12',
'ppsx' : 'application/vnd.openxmlformats-officedocument.presentationml.slideshow',
'pptm' : 'application/vnd.ms-powerpoint.presentation.macroEnabled.12',
'pptx' : 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
'xlam' : 'application/vnd.ms-excel.addin.macroEnabled.12',
'xlsb' : 'application/vnd.ms-excel.sheet.binary.macroEnabled.12',
'xlsm' : 'application/vnd.ms-excel.sheet.macroEnabled.12',
'xlsx' : 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
'xltm' : 'application/vnd.ms-excel.template.macroEnabled.12',
'xltx' : 'application/vnd.openxmlformats-officedocument.spreadsheetml.template',
'cod' : 'application/vnd.rim.cod',
'mmf' : 'application/vnd.smaf',
'sdc' : 'application/vnd.stardivision.calc',
'sds' : 'application/vnd.stardivision.chart',
'sda' : 'application/vnd.stardivision.draw',
'sdd' : 'application/vnd.stardivision.impress',
'sdf' : 'application/vnd.stardivision.math',
'sdw' : 'application/vnd.stardivision.writer',
'sgl' : 'application/vnd.stardivision.writer-global',
'sxc' : 'application/vnd.sun.xml.calc',
'stc' : 'application/vnd.sun.xml.calc.template',
'sxd' : 'application/vnd.sun.xml.draw',
'std' : 'application/vnd.sun.xml.draw.template',
'sxi' : 'application/vnd.sun.xml.impress',
'sti' : 'application/vnd.sun.xml.impress.template',
'sxm' : 'application/vnd.sun.xml.math',
'sxw' : 'application/vnd.sun.xml.writer',
'sxg' : 'application/vnd.sun.xml.writer.global',
'stw' : 'application/vnd.sun.xml.writer.template',
'sis' : 'application/vnd.symbian.install',
'vsd' : 'application/vnd.visio',
'wbxml' : 'application/vnd.wap.wbxml',
'wmlc' : 'application/vnd.wap.wmlc',
'wmlsc' : 'application/vnd.wap.wmlscriptc',
'wk' : 'application/x-123',
'7z' : 'application/x-7z-compressed',
'abw' : 'application/x-abiword',
'dmg' : 'application/x-apple-diskimage',
'bcpio' : 'application/x-bcpio',
'torrent' : 'application/x-bittorrent',
'cab' : 'application/x-cab',
'cbr' : 'application/x-cbr',
'cbz' : 'application/x-cbz',
'cdf' : 'application/x-cdf',
'vcd' : 'application/x-cdlink',
'pgn' : 'application/x-chess-pgn',
'cpio' : 'application/x-cpio',
'csh' : 'text/x-csh',
'deb' : 'application/x-debian-package', 'udeb' : 'application/x-debian-package',
'dcr' : 'application/x-director', 'dir' : 'application/x-director', 'dxr' : 'application/x-director',
'dms' : 'application/x-dms',
'wad' : 'application/x-doom',
'dvi' : 'application/x-dvi',
'rhtml' : 'application/x-httpd-eruby',
'flac' : 'application/x-flac',
'pfa' : 'application/x-font', 'pfb' : 'application/x-font', 'gsf' : 'application/x-font', 'pcf' : 'application/x-font',
'mm' : 'application/x-freemind',
'gnumeric' : 'application/x-gnumeric',
'sgf' : 'application/x-go-sgf',
'gcf' : 'application/x-graphing-calculator',
'gtar' : 'application/x-gtar', 'tgz' : 'application/x-gtar', 'taz' : 'application/x-gtar',
'hdf' : 'application/x-hdf',
'phtml' : 'application/x-httpd-php', 'pht' : 'application/x-httpd-php', 'php' : 'application/x-httpd-php',
'phps' : 'application/x-httpd-php-source',
'php3' : 'application/x-httpd-php3',
'php3p' : 'application/x-httpd-php3-preprocessed',
'php4' : 'application/x-httpd-php4',
'ica' : 'application/x-ica',
'ins' : 'application/x-internet-signup', 'isp' : 'application/x-internet-signup',
'iii' : 'application/x-iphone',
'iso' : 'application/x-iso9660-image',
'jnlp' : 'application/x-java-jnlp-file',
'js' : 'application/x-javascript',
'jmz' : 'application/x-jmol',
'chrt' : 'application/x-kchart',
'kil' : 'application/x-killustrator',
'skp' : 'application/x-koan', 'skd' : 'application/x-koan', 'skt' : 'application/x-koan', 'skm' : 'application/x-koan',
'kpr' : 'application/x-kpresenter', 'kpt' : 'application/x-kpresenter',
'ksp' : 'application/x-kspread',
'kwd' : 'application/x-kword', 'kwt' : 'application/x-kword',
'latex' : 'application/x-latex',
'lha' : 'application/x-lha',
'lyx' : 'application/x-lyx',
'lzh' : 'application/x-lzh',
'lzx' : 'application/x-lzx',
'frm' : 'application/x-maker', 'maker' : 'application/x-maker', 'frame' : 'application/x-maker', 'fm' : 'application/x-maker', 'fb' : 'application/x-maker', 'book' : 'application/x-maker', 'fbdoc' : 'application/x-maker',
'mif' : 'application/x-mif',
'wmd' : 'application/x-ms-wmd',
'wmz' : 'application/x-ms-wmz',
'com' : 'application/x-msdos-program', 'exe' : 'application/x-msdos-program', 'bat' : 'application/x-msdos-program', 'dll' : 'application/x-msdos-program',
'msi' : 'application/x-msi',
'nc' : 'application/x-netcdf',
'pac' : 'application/x-ns-proxy-autoconfig',
'nwc' : 'application/x-nwc',
'o' : 'application/x-object',
'oza' : 'application/x-oz-application',
'p7r' : 'application/x-pkcs7-certreqresp',
'crl' : 'application/x-pkcs7-crl',
'pyc' : 'application/x-python-code', 'pyo' : 'application/x-python-code',
'qtl' : 'application/x-quicktimeplayer',
'rpm' : 'application/x-redhat-package-manager',
'sh' : 'text/x-sh',
'shar' : 'application/x-shar',
'swf' : 'application/x-shockwave-flash', 'swfl' : 'application/x-shockwave-flash',
'sit' : 'application/x-stuffit', 'sitx' : 'application/x-stuffit',
'sv4cpio' : 'application/x-sv4cpio',
'sv4crc' : 'application/x-sv4crc',
'tar' : 'application/x-tar',
'tcl' : 'application/x-tcl',
'gf' : 'application/x-tex-gf',
'pk' : 'application/x-tex-pk',
'texinfo' : 'application/x-texinfo', 'texi' : 'application/x-texinfo',
'~' : 'application/x-trash', '%' : 'application/x-trash', 'bak' : 'application/x-trash', 'old' : 'application/x-trash', 'sik' : 'application/x-trash',
't' : 'application/x-troff', 'tr' : 'application/x-troff', 'roff' : 'application/x-troff',
'man' : 'application/x-troff-man',
'me' : 'application/x-troff-me',
'ms' : 'application/x-troff-ms',
'ustar' : 'application/x-ustar',
'src' : 'application/x-wais-source',
'wz' : 'application/x-wingz',
'crt' : 'application/x-x509-ca-cert',
'xcf' : 'application/x-xcf',
'fig' : 'application/x-xfig',
'xpi' : 'application/x-xpinstall',
'au' : 'audio/basic', 'snd' : 'audio/basic',
'mid' : 'audio/midi', 'midi' : 'audio/midi', 'kar' : 'audio/midi',
'mpga' : 'audio/mpeg', 'mpega' : 'audio/mpeg', 'mp2' : 'audio/mpeg', 'mp3' : 'audio/mpeg', 'm4a' : 'audio/mpeg',
'm3u' : 'audio/x-mpegurl',
'oga' : 'audio/ogg', 'spx' : 'audio/ogg',
'sid' : 'audio/prs.sid',
'aif' : 'audio/x-aiff', 'aiff' : 'audio/x-aiff', 'aifc' : 'audio/x-aiff',
'gsm' : 'audio/x-gsm',
'wma' : 'audio/x-ms-wma',
'wax' : 'audio/x-ms-wax',
'rm' : 'audio/x-pn-realaudio', 'ram' : 'audio/x-pn-realaudio',
'ra' : 'audio/x-realaudio',
'pls' : 'audio/x-scpls',
'sd2' : 'audio/x-sd2',
'wav' : 'audio/x-wav',
'alc' : 'chemical/x-alchemy',
'cac' : 'chemical/x-cache', 'cache' : 'chemical/x-cache',
'csf' : 'chemical/x-cache-csf',
'cbin' : 'chemical/x-cactvs-binary', 'cascii' : 'chemical/x-cactvs-binary', 'ctab' : 'chemical/x-cactvs-binary',
'cdx' : 'chemical/x-cdx',
'cer' : 'chemical/x-cerius',
'c3d' : 'chemical/x-chem3d',
'chm' : 'chemical/x-chemdraw',
'cif' : 'chemical/x-cif',
'cmdf' : 'chemical/x-cmdf',
'cml' : 'chemical/x-cml',
'cpa' : 'chemical/x-compass',
'bsd' : 'chemical/x-crossfire',
'csml' : 'chemical/x-csml', 'csm' : 'chemical/x-csml',
'ctx' : 'chemical/x-ctx',
'cxf' : 'chemical/x-cxf', 'cef' : 'chemical/x-cxf',
'emb' : 'chemical/x-embl-dl-nucleotide', 'embl' : 'chemical/x-embl-dl-nucleotide',
'spc' : 'chemical/x-galactic-spc',
'inp' : 'chemical/x-gamess-input', 'gam' : 'chemical/x-gamess-input', 'gamin' : 'chemical/x-gamess-input',
'fch' : 'chemical/x-gaussian-checkpoint', 'fchk' : 'chemical/x-gaussian-checkpoint',
'cub' : 'chemical/x-gaussian-cube',
'gau' : 'chemical/x-gaussian-input', 'gjc' : 'chemical/x-gaussian-input', 'gjf' : 'chemical/x-gaussian-input',
'gal' : 'chemical/x-gaussian-log',
'gcg' : 'chemical/x-gcg8-sequence',
'gen' : 'chemical/x-genbank',
'hin' : 'chemical/x-hin',
'istr' : 'chemical/x-isostar', 'ist' : 'chemical/x-isostar',
'jdx' : 'chemical/x-jcamp-dx', 'dx' : 'chemical/x-jcamp-dx',
'kin' : 'chemical/x-kinemage',
'mcm' : 'chemical/x-macmolecule',
'mmd' : 'chemical/x-macromodel-input', 'mmod' : 'chemical/x-macromodel-input',
'mol' : 'chemical/x-mdl-molfile',
'rd' : 'chemical/x-mdl-rdfile',
'rxn' : 'chemical/x-mdl-rxnfile',
'sd' : 'chemical/x-mdl-sdfile', 'sdf' : 'chemical/x-mdl-sdfile',
'tgf' : 'chemical/x-mdl-tgf',
'mcif' : 'chemical/x-mmcif',
'mol2' : 'chemical/x-mol2',
'b' : 'chemical/x-molconn-Z',
'gpt' : 'chemical/x-mopac-graph',
'mop' : 'chemical/x-mopac-input', 'mopcrt' : 'chemical/x-mopac-input', 'mpc' : 'chemical/x-mopac-input', 'dat' : 'chemical/x-mopac-input', 'zmt' : 'chemical/x-mopac-input',
'moo' : 'chemical/x-mopac-out',
'mvb' : 'chemical/x-mopac-vib',
'asn' : 'chemical/x-ncbi-asn1-spec',
'prt' : 'chemical/x-ncbi-asn1-ascii', 'ent' : 'chemical/x-ncbi-asn1-ascii',
'val' : 'chemical/x-ncbi-asn1-binary', 'aso' : 'chemical/x-ncbi-asn1-binary',
'pdb' : 'chemical/x-pdb', 'ent' : 'chemical/x-pdb',
'ros' : 'chemical/x-rosdal',
'sw' : 'chemical/x-swissprot',
'vms' : 'chemical/x-vamas-iso14976',
'vmd' : 'chemical/x-vmd',
'xtel' : 'chemical/x-xtel',
'xyz' : 'chemical/x-xyz',
'gif' : 'image/gif',
'ief' : 'image/ief',
'jpeg' : 'image/jpeg', 'jpg' : 'image/jpeg', 'jpe' : 'image/jpeg',
'pcx' : 'image/pcx',
'png' : 'image/png',
'svg' : 'image/svg+xml', 'svgz' : 'image/svg+xml',
'tiff' : 'image/tiff', 'tif' : 'image/tiff',
'djvu' : 'image/vnd.djvu', 'djv' : 'image/vnd.djvu',
'wbmp' : 'image/vnd.wap.wbmp',
'ras' : 'image/x-cmu-raster',
'cdr' : 'image/x-coreldraw',
'pat' : 'image/x-coreldrawpattern',
'cdt' : 'image/x-coreldrawtemplate',
'ico' : 'image/x-icon',
'art' : 'image/x-jg',
'jng' : 'image/x-jng',
'bmp' : 'image/x-ms-bmp',
'psd' : 'image/x-photoshop',
'pnm' : 'image/x-portable-anymap',
'pbm' : 'image/x-portable-bitmap',
'pgm' : 'image/x-portable-graymap',
'ppm' : 'image/x-portable-pixmap',
'rgb' : 'image/x-rgb',
'xbm' : 'image/x-xbitmap',
'xpm' : 'image/x-xpixmap',
'xwd' : 'image/x-xwindowdump',
'eml' : 'message/rfc822',
'igs' : 'model/iges', 'iges' : 'model/iges',
'msh' : 'model/mesh', 'mesh' : 'model/mesh', 'silo' : 'model/mesh',
'wrl' : 'model/vrml', 'vrml' : 'model/vrml',
'ics' : 'text/calendar', 'icz' : 'text/calendar',
'css' : 'text/css',
'csv' : 'text/csv',
'323' : 'text/h323',
'html' : 'text/html', 'htm' : 'text/html', 'shtml' : 'text/html',
'uls' : 'text/iuls',
'mml' : 'text/mathml',
'asc' : 'text/plain', 'txt' : 'text/plain', 'text' : 'text/plain', 'pot' : 'text/plain',
'rtx' : 'text/richtext',
'sct' : 'text/scriptlet', 'wsc' : 'text/scriptlet',
'tm' : 'text/texmacs', 'ts' : 'text/texmacs',
'tsv' : 'text/tab-separated-values',
'jad' : 'text/vnd.sun.j2me.app-descriptor',
'wml' : 'text/vnd.wap.wml',
'wmls' : 'text/vnd.wap.wmlscript',
'bib' : 'text/x-bibtex',
'boo' : 'text/x-boo',
'h++' : 'text/x-c++hdr', 'hpp' : 'text/x-c++hdr', 'hxx' : 'text/x-c++hdr', 'hh' : 'text/x-c++hdr',
'c++' : 'text/x-c++src', 'cpp' : 'text/x-c++src', 'cxx' : 'text/x-c++src', 'cc' : 'text/x-c++src',
'h' : 'text/x-chdr',
'htc' : 'text/x-component',
'c' : 'text/x-csrc',
'd' : 'text/x-dsrc',
'diff' : 'text/x-diff', 'patch' : 'text/x-diff',
'hs' : 'text/x-haskell',
'java' : 'text/x-java',
'lhs' : 'text/x-literate-haskell',
'moc' : 'text/x-moc',
'p' : 'text/x-pascal', 'pas' : 'text/x-pascal',
'gcd' : 'text/x-pcs-gcd',
'pl' : 'text/x-perl', 'pm' : 'text/x-perl',
'py' : 'text/x-python',
'etx' : 'text/x-setext',
'tcl' : 'text/x-tcl', 'tk' : 'text/x-tcl',
'tex' : 'text/x-tex', 'ltx' : 'text/x-tex', 'sty' : 'text/x-tex', 'cls' : 'text/x-tex',
'vcs' : 'text/x-vcalendar',
'vcf' : 'text/x-vcard',
'3gp' : 'video/3gpp',
'dl' : 'video/dl',
'dif' : 'video/dv', 'dv' : 'video/dv',
'fli' : 'video/fli',
'gl' : 'video/gl',
'mpeg' : 'video/mpeg', 'mpg' : 'video/mpeg', 'mpe' : 'video/mpeg',
'mp4' : 'video/mp4',
'ogv' : 'video/ogg',
'qt' : 'video/quicktime', 'mov' : 'video/quicktime',
'mxu' : 'video/vnd.mpegurl',
'lsf' : 'video/x-la-asf', 'lsx' : 'video/x-la-asf',
'mng' : 'video/x-mng',
'asf' : 'video/x-ms-asf', 'asx' : 'video/x-ms-asf',
'wm' : 'video/x-ms-wm',
'wmv' : 'video/x-ms-wmv',
'wmx' : 'video/x-ms-wmx',
'wvx' : 'video/x-ms-wvx',
'avi' : 'video/x-msvideo',
'movie' : 'video/x-sgi-movie',
'ice' : 'x-conference/x-cooltalk',
'sisx' : 'x-epoc/x-sisx-app',
'vrm' : 'x-world/x-vrml', 'vrml' : 'x-world/x-vrml', 'wrl' : 'x-world/x-vrml',
'xps' : 'application/vnd.ms-xpsdocument',
}
var filext = filename.split('.');
var extindex = filext.length-1;
for(var extention in mappings) {
if(filext[extindex]==extention){
return mappings[extention];
}
}
return 'application/octet-stream';
}
i use this in pentaho, anyone has better script? tell me!
Monday, October 3, 2011
Thursday, July 7, 2011
create slug using stringToSlug jQuery Plugin
hello mydevelovers.
I was confusing how to create a permalink for realtime, I was search on google and i found this plugin.
creating permalink using stringToSlug plugin is very easy. you just need jquery dan stringToSlug plugin
next create HTML:
next create Javascript:
try your self, this is the manual
I was confusing how to create a permalink for realtime, I was search on google and i found this plugin.
creating permalink using stringToSlug plugin is very easy. you just need jquery dan stringToSlug plugin
next create HTML:
<blockquote>
<h4>Demo</h4>
<input id="string" size="50" type="text" value="Altere o texto deste campo." />
<strong>Preview:</strong> <span id="permalink" style="color: #880000;">sdkuaghf-s-d98-sdsd-2-fsdjf-sdfnk</span></blockquote>
next create Javascript:
$(document).ready( function() {
$("#title").stringToSlug({
setEvents: 'keyup keydown blur',
getPut: '#permalink',
space: '-'
});
});
try your self, this is the manual
Thursday, April 28, 2011
[PHP] function get_file_extension(String file_name)
function get_file_extension($file) {
$extension = substr(strrchr($file, '.'), 1);
$mimes = array( 'hqx' => 'application/mac-binhex40',
'cpt' => 'application/mac-compactpro',
'csv' => array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel'),
'bin' => 'application/macbinary',
'dms' => 'application/octet-stream',
'lha' => 'application/octet-stream',
'lzh' => 'application/octet-stream',
'exe' => 'application/octet-stream',
'class' => 'application/octet-stream',
'psd' => 'application/x-photoshop',
'so' => 'application/octet-stream',
'sea' => 'application/octet-stream',
'dll' => 'application/octet-stream',
'oda' => 'application/oda',
'pdf' => array('application/pdf', 'application/x-download','application/force-download'),
'ai' => 'application/postscript',
'eps' => 'application/postscript',
'ps' => 'application/postscript',
'smi' => 'application/smil',
'smil' => 'application/smil',
'mif' => 'application/vnd.mif',
'xls' => array('application/excel', 'application/vnd.ms-excel', 'application/msexcel'),
'ppt' => array('application/powerpoint', 'application/vnd.ms-powerpoint'),
'wbxml' => 'application/wbxml',
'wmlc' => 'application/wmlc',
'dcr' => 'application/x-director',
'dir' => 'application/x-director',
'dxr' => 'application/x-director',
'dvi' => 'application/x-dvi',
'gtar' => 'application/x-gtar',
'gz' => 'application/x-gzip',
'php' => 'application/x-httpd-php',
'php4' => 'application/x-httpd-php',
'php3' => 'application/x-httpd-php',
'phtml' => 'application/x-httpd-php',
'phps' => 'application/x-httpd-php-source',
'js' => 'application/x-javascript',
'swf' => 'application/x-shockwave-flash',
'sit' => 'application/x-stuffit',
'tar' => 'application/x-tar',
'tgz' => 'application/x-tar',
'xhtml' => 'application/xhtml+xml',
'xht' => 'application/xhtml+xml',
'zip' => array('application/x-zip', 'application/zip', 'application/x-zip-compressed'),
'mid' => 'audio/midi',
'midi' => 'audio/midi',
'mpga' => 'audio/mpeg',
'mp2' => 'audio/mpeg',
'mp3' => array('audio/mpeg', 'audio/mpg'),
'aif' => 'audio/x-aiff',
'aiff' => 'audio/x-aiff',
'aifc' => 'audio/x-aiff',
'ram' => 'audio/x-pn-realaudio',
'rm' => 'audio/x-pn-realaudio',
'rpm' => 'audio/x-pn-realaudio-plugin',
'ra' => 'audio/x-realaudio',
'rv' => 'video/vnd.rn-realvideo',
'wav' => 'audio/x-wav',
'bmp' => 'image/bmp',
'gif' => 'image/gif',
'jpeg' => array('image/jpeg', 'image/pjpeg'),
'jpg' => array('image/jpeg', 'image/pjpeg'),
'jpe' => array('image/jpeg', 'image/pjpeg'),
'png' => array('image/png', 'image/x-png'),
'tiff' => 'image/tiff',
'tif' => 'image/tiff',
'css' => 'text/css',
'html' => 'text/html',
'htm' => 'text/html',
'shtml' => 'text/html',
'txt' => 'text/plain',
'text' => 'text/plain',
'log' => array('text/plain', 'text/x-log'),
'rtx' => 'text/richtext',
'rtf' => 'text/rtf',
'xml' => 'text/xml',
'xsl' => 'text/xml',
'mpeg' => 'video/mpeg',
'mpg' => 'video/mpeg',
'mpe' => 'video/mpeg',
'flv' => array('video/x-flv', 'application/octet-stream'),
'mp4' => 'video/mp4',
'3gp' => 'video/3gpp',
'3g2' => 'video/3gpp2',
'qt' => 'video/quicktime',
'mov' => 'video/quicktime',
'avi' => 'video/x-msvideo',
'movie' => 'video/x-sgi-movie',
'doc' => 'application/msword',
'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
'word' => array('application/msword', 'application/octet-stream'),
'xl' => 'application/excel',
'eml' => 'message/rfc822'
);
if (array_key_exists($extension, $mimes)){
if (is_array($mimes[$extension])){
// Multiple mime types, just give the first one
return current($mimes[$extension]);
}else{
return $mimes[$extension];
}
}
return $extension;
}
$extension = substr(strrchr($file, '.'), 1);
$mimes = array( 'hqx' => 'application/mac-binhex40',
'cpt' => 'application/mac-compactpro',
'csv' => array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel'),
'bin' => 'application/macbinary',
'dms' => 'application/octet-stream',
'lha' => 'application/octet-stream',
'lzh' => 'application/octet-stream',
'exe' => 'application/octet-stream',
'class' => 'application/octet-stream',
'psd' => 'application/x-photoshop',
'so' => 'application/octet-stream',
'sea' => 'application/octet-stream',
'dll' => 'application/octet-stream',
'oda' => 'application/oda',
'pdf' => array('application/pdf', 'application/x-download','application/force-download'),
'ai' => 'application/postscript',
'eps' => 'application/postscript',
'ps' => 'application/postscript',
'smi' => 'application/smil',
'smil' => 'application/smil',
'mif' => 'application/vnd.mif',
'xls' => array('application/excel', 'application/vnd.ms-excel', 'application/msexcel'),
'ppt' => array('application/powerpoint', 'application/vnd.ms-powerpoint'),
'wbxml' => 'application/wbxml',
'wmlc' => 'application/wmlc',
'dcr' => 'application/x-director',
'dir' => 'application/x-director',
'dxr' => 'application/x-director',
'dvi' => 'application/x-dvi',
'gtar' => 'application/x-gtar',
'gz' => 'application/x-gzip',
'php' => 'application/x-httpd-php',
'php4' => 'application/x-httpd-php',
'php3' => 'application/x-httpd-php',
'phtml' => 'application/x-httpd-php',
'phps' => 'application/x-httpd-php-source',
'js' => 'application/x-javascript',
'swf' => 'application/x-shockwave-flash',
'sit' => 'application/x-stuffit',
'tar' => 'application/x-tar',
'tgz' => 'application/x-tar',
'xhtml' => 'application/xhtml+xml',
'xht' => 'application/xhtml+xml',
'zip' => array('application/x-zip', 'application/zip', 'application/x-zip-compressed'),
'mid' => 'audio/midi',
'midi' => 'audio/midi',
'mpga' => 'audio/mpeg',
'mp2' => 'audio/mpeg',
'mp3' => array('audio/mpeg', 'audio/mpg'),
'aif' => 'audio/x-aiff',
'aiff' => 'audio/x-aiff',
'aifc' => 'audio/x-aiff',
'ram' => 'audio/x-pn-realaudio',
'rm' => 'audio/x-pn-realaudio',
'rpm' => 'audio/x-pn-realaudio-plugin',
'ra' => 'audio/x-realaudio',
'rv' => 'video/vnd.rn-realvideo',
'wav' => 'audio/x-wav',
'bmp' => 'image/bmp',
'gif' => 'image/gif',
'jpeg' => array('image/jpeg', 'image/pjpeg'),
'jpg' => array('image/jpeg', 'image/pjpeg'),
'jpe' => array('image/jpeg', 'image/pjpeg'),
'png' => array('image/png', 'image/x-png'),
'tiff' => 'image/tiff',
'tif' => 'image/tiff',
'css' => 'text/css',
'html' => 'text/html',
'htm' => 'text/html',
'shtml' => 'text/html',
'txt' => 'text/plain',
'text' => 'text/plain',
'log' => array('text/plain', 'text/x-log'),
'rtx' => 'text/richtext',
'rtf' => 'text/rtf',
'xml' => 'text/xml',
'xsl' => 'text/xml',
'mpeg' => 'video/mpeg',
'mpg' => 'video/mpeg',
'mpe' => 'video/mpeg',
'flv' => array('video/x-flv', 'application/octet-stream'),
'mp4' => 'video/mp4',
'3gp' => 'video/3gpp',
'3g2' => 'video/3gpp2',
'qt' => 'video/quicktime',
'mov' => 'video/quicktime',
'avi' => 'video/x-msvideo',
'movie' => 'video/x-sgi-movie',
'doc' => 'application/msword',
'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
'word' => array('application/msword', 'application/octet-stream'),
'xl' => 'application/excel',
'eml' => 'message/rfc822'
);
if (array_key_exists($extension, $mimes)){
if (is_array($mimes[$extension])){
// Multiple mime types, just give the first one
return current($mimes[$extension]);
}else{
return $mimes[$extension];
}
}
return $extension;
}
Wednesday, April 27, 2011
Insert data using select in sql
i has confuse how to insert data from another table. until i found this method by search in google.
this method can be used to copy table data
example:
you have table_a and table_b,
you want to copy data from table_a to table_b
this is the sql you can use:
you can use where if you want to copy data with specific condition.
and thanks for reading
this method can be used to copy table data
example:
you have table_a and table_b,
you want to copy data from table_a to table_b
this is the sql you can use:
insert into table_b (id, name, number)that will copy all data from table_a to table_b.
select id, name, number
from table_a
you can use where if you want to copy data with specific condition.
insert into table_b (id, name, number)try it yourself,
select id, name, number
from table_a
where id<10
and thanks for reading
Friday, February 25, 2011
javascript get JSON from URL like $_GET in PHP
hy guys, i really made this script by my self.
reference is from google.com (LOL)
this script is for get the url query string like $_GET in PHP
sorry i not posting it here coz blogger can not allow my javascript :D
see thsi script in my other blog klik here
nice to share with all of you.
thanks for comeback
reference is from google.com (LOL)
this script is for get the url query string like $_GET in PHP
sorry i not posting it here coz blogger can not allow my javascript :D
see thsi script in my other blog klik here
nice to share with all of you.
thanks for comeback
Subscribe to:
Posts (Atom)