MySQL

Rex Price Architecture

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 …

Rex Price Architecture Read More »

Arista Corporation

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 …

Arista Corporation Read More »

Create DB Table from .SQL (dump) file

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.   <?php function create_table($file) { $file_content = file($file); $query = “”; foreach($file_content as $sql_line) { if(trim($sql_line) != “” &amp;&amp; strpos($sql_line, “–“) === false) { $query .= $sql_line; if (substr(rtrim($query), …

Create DB Table from .SQL (dump) file Read More »

SwiftEngines.com

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 …

SwiftEngines.com Read More »

All State Real Estate

All State Real Estate called me in a bit of a panic.  They had had two different local web guys work on a new design for their website.  Between the two, it had been almost a year.  Then, suddenly, their email was down and they couldn’t search listings, or even show their own.  Big problem …

All State Real Estate Read More »

Luckiamute Valley Pheasants

LVP is actually a client of a local marketing company.  They had already created the website, but needed a custom reservations system.  That’s when they called me.  I was able to give them a calendar that shows available hunting pods for specific days, an email reservations request form and a database that kept it all …

Luckiamute Valley Pheasants Read More »