Silva Tech Solutions LLC

Recently I had a project that needed to create and format a word document, based on data from a MySQL database. While the solution was on an MS platform that had Word available, I could only use PHP for the scripting language as it was a language that was used by the rest of the team. The system would call the Word com object, create a new word document and formatted a report, using the “word.application” COM object.

One issue I ran across was that that coloring a font object in any VBA Macro script often times used a simple built-in function called “RGB”. I translated a PERL version below that seems to work quite well in PHP. Hope this helps someone else. This can also be used in formated RGB values in Excel document manipulations.

function phpRGB ($r,$g,$b){ 
	return $r + (256*$g) + (65536*$b);
}
 
//example usage:
    $wobj->Selection->Font->Italic = 1;
    $wobj->Selection->Font->Color = phpRGB(153,204,255);

Here is a snippet of code that I wish I had when I needed to write a small routine to output a PHP RSS feed.
RSS Feeds are XML-like so they need to be carefully crafted.

1.) Setup the main header of the rss feed. Remember to carefully escape all of your text going into string
fields using htmlentities().

Read more…

Working with the client, Mr. Silva designed, developed and implemented a full web presence for a small travel agency start-up company. Mr. Silva was responsible for all graphics designs, logos, system architecture, server configuration and social media integration for the client. Mr. Silva setup web portal that allowed the client to monitor their web statistics on their own and provided guidance on a Google Adwords campaign and better Social Media integration.

“In February 2009 I decided to open up my own travel agency. Having worked in a travel agency for many years, I was familiar with the everyday duties that were needed to operate a travel agency. However, the agency I worked for lacked one important thing–a web site. I knew that the only way I could possibly survive in such a competetive market was to have a great web site. That is when I contacted Jeremy Silva of Silva Tech Solutions to do my site. With Jeremy’s guidance and knowledge of web site building, I am proud to display my agency name. From the format suggestions to the font decisions, and for the everyday maintance of the site, I can now provide up-to-the-minute information for all of my clients. Thank you, Jeremy, for making my dream of owning my own agency into a reality, because without your help in getting my name out there, I could never have even considered doing this.

Audrey Conaway
Away You Go Travel ”

Data integration. Integerated several commercial data sources into MSSQL server. Wrote data normalization schemes for each data source and built a custom search engine for new data. Authorize.net and Squirrel Cart ARB integration. Intrusion detection and resolution Virtual Private Server architecture, development and troubleshooting Website architecture conversions (ASP to PHP) Linux DNS and Mail server configuration/troubleshooting Apache and IIS setup. PHP and Classic ASP Software Development MSSQL Database installation (VPS) and management Legacy System Maintenance and troubleshooting (OsCommerce and proprietary ASP frameworks)

“When our web development company has a difficult project that requires really technical expertise, we pick up the phone and call Jeremy Silva. He is a master programmer and knows the intricate ins and outs of servers and networks. He is able to estimate and accurately code all manner of outrageous programming requests and makes very creative suggestions which ultimately save our customers time and money. He is the first person I go to when I have a tricky programming problem, and he always gets the job done in a creative way, under budget and on time. I’d recommend Jeremy to anyone!” — Susan McCrossin

Created a personalized Robot Agent, based on Silva Tech’s flexible data extraction, reporting and crawling framework (DERC Framework, a Silva Tech Solutions framework) that has saved Mr. Gordon countless hours of monitoring his target system himself and responding to the monotonous events. The agent was setup on a very specific schedule, authenticated into a third party application system, searched for a very specific criteria and automatically submitted data. The agent monitored and reacted differently to a certain set of resulting events that were returned from the application system. The Crawl Agent would then email Mr. Gordon and shut itself down. Mr. Gordon could easily control his personalized DERC Framework agent, from a custom built secure web interface. The DERC Framework is a very flexible proprietary data extraction, reporting and crawling framework that Mr. Silva has been building upon and refining for five years.