Import CSV/Excel into MySQL via PHP

http://www.programmingfacts.com/import-csvexcel-data-mysql-database/

Comments

Post a Comment

Popular posts from this blog

Solution to Kindle stuck in USB Drive Mode even when Ejected

Very impressed with this device, it makes reading a joy again (after noticing that reading a lot on traditional mobile device screens was becoming very straining on the eyes very quickly after a while). With my Kindle I had the issue that I would connect it to a PC and it would switch into drive mode. The screen tells you that you can resume reading while charging by ejecting the device in Windows. I did it via the small icon next to the clock and the Kindle would stay in the USB drive mode. I then found the Kindle as a Drive when I opened "My Computer". I right clicked the Kindle in that window and chose "Eject" after which I was able to use the device while it was recharging on the PC.
Read more

Qubes OS 3.2 - clamav in untrusted and/or vault domain

Qubes 3.2 is great if you need to handle malicious files. Just create yourself a quarantine vm that has no network access and you're good to go - you could of course use a disposable VM, but that is a topic for another post. There is also a pre-installed (if you have chosen so during setup) "vault vm" that is  already configured for this purpose. To get clamav onto these vms I opened a terminal on the "fedora-23 template vm" and installed clam: sudo dnf -y install clamav clamav-update sudo vim /etc/freshclam.conf sudo vim /etc/sysconfig/freshclam The two config files will tell you what to do when you edit them, so just follow the instructions. Using freshclam on the template vm does not work, unless you allow it to access the internet for a while (in the vm settings, firewall tab). But since I'll only really need it in my quarantine vm I just started a terminal in the "quarantine vm" and did a "sudo freshclam" there. cl...
Read more

Input Numbers with Kindle Keyboard without using the Symbol key

I was a little annoyed by the Kindle keyboard not having dedicated number keys and so far I had to press the Sym key to bring up the window to enter numbers - but no more! To enter numbers quickly and painlessly with the hardware keyboard of the Kindle just keep the ALT key pressed and use the top row of keys to enter your letters (ALT + T to enter the number 5 for instance). I hope this helps some of you Kindle users to be less annoyed - I certainly am!
Read more