Client Client or Website Name Short Description Architectural website with file sharing for his clients. Launch Date 02/2004, or so. Categories & Tags Everything Else, Old custom design, Custom FTP Server, File Sharing, MySQL, PHP Description A local architect needed a website that he could use to advertise his services, show off his designs and …
Arista is a computer product developer founded in 1994 and headquartered in Fremont, CA, with operations in China, India and Taiwan. They came to me when they needed a developer who was responsive to their needs and could get the job done. That was in 2015-2016. Unfortunately, there was a marketing guy in between Arista …
Not a really complex thing, but something that comes in handy if you’re moving data around and need to quickly create MySQL db tables through PHP.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
<?php function create_table($file) { $file_content = file($file); $query = ""; foreach($file_content as $sql_line) { if(trim($sql_line) != "" && strpos($sql_line, "--") === false) { $query .= $sql_line; if (substr(rtrim($query), -1) == ';') { //echo $query; $result = mysql_query($query)or die(mysql_error()); $query = ""; } } } } ?> |
Pretty simple to use. Just place the function at the top of your page (or at least somewhere higher up the file than when you call …
Morning Glory Inn was a bed and breakfast way out in the country near Roseburg. Right on the Coos Bay Wagon Trail, actually. You could sit on the porch and practically hear the horse drawn wagons going by full of kids with cholera and stuff. (Just kidding on the cholera thing, but it was right …
Goin’ Postal and Copy Copy Shop is a locally owned franchise that does everything shipping related, like packing your packages, sending it by the best carrier, holding your mail, renting post office boxes… All that stuff. Copy Copy Shop, obviously, is a copy shop. Color copies, zillions of them? No problem. One pretty cool thing …
Atrio was a client of BBG Marketing, a local company I do a lot of maintenance and back end coding work for. They came to me with Atrio because the database was having some issues and they needed to be able to get the drug information for their plans to display properly on their website. …
So, I get this call one day. Mr. Swift needs a website to sell his dad’s model airplane engine collection. Apparently there’s a whole subculture out there of people who buy and sell model airplane engines. Whowouldathunkit? We had a coffee, he showed me a list of the engines he needs to sell. 440 of …
This was my first PHP-based site. Took me days and days to do what I can do in about 5 minutes now. Gotta learn somewhere though, right? The design is horribly dated by today’s standards, but back in 2003, or so, it was quite nice. The PHP included a small database that let them update …
The Douglas County Million Dollar Club is another long term client for me. I did their first website for them in about 2004, I think. Prior to that they were strictly print advertisers. A database driven website that gets all their names and contact info out there seems like a no brainer. 🙂 The site …
I took over development or The Neil Company in about 2005 or 2006. Since then I’ve done 3 total redesigns. Franchises like this are a challenge because you have to take the client’s wishes for design and make it work within the legal constraints of the marketing guidelines of the parent company. Along with all …
