Creating a md5(base64) or sha1(base64) password has in PHP

Last week I was trying to figure out how to get a 28 character md5. An application I was trying to generate passwords required what looked to be a 28 char hash. First off I tried: echo base64_encode(md5($password)); This returned way too many characters. After doing some research I found out it needs to be […]

Loading CSV files in MySQL

Many times you will want to load a csv file into a database. If your table is the same structure as the csv file there are some very quick ways to load the file into the db with out having to load it into an array and do foreach loops for each row. The LOAD […]