|
|
| CURRENT PROJECT - ON SITE WORK |
| I am currently doing a conversion from a 32 bit hosting environment to a 64 bit hosting environment. The company uses Microsoft SQL for their data storage. PHP has changed how PHP interacts with MS SQL. The current functions that most developers use is mssql_query() but on the 64 bit operating system you must use sqlsrv_query(). This is the only thing (as far as I know) that has changes in PHP that interacts with a 64 bit system.
|
 |
|
| MY EXPERIENCE & WHAT I CAN DO FOR YOU |
|
| PHP |
| I have been programming using PHP for 11 years. I have learned many tricks using this language. My specialty is inventory systems and production control applications such as project managers. |
|
| AJAX |
I use AJAX to perform background operations that the user of a site does not see. AJAX allows a programmer to run background operations such as update a database record, create a file on the fly, etc. All of this can happen behind the scenes without the user knowing what is going on.
Other uses is populating a search field with suggestions based on the users input like you would see on Googles site when you start to enter search text in their search field. You can run querys and display them in your site after the site has loaded. |
|
| JavaScript |
| I use JavaScript to perform confirmations to actions, references areas of a page such as place focus in a table or container, capture informations, form input validation, auto-page reload, timers, etc. |
|
|
|
| MySQL, Microsoft SQL & Microsoft Access |
You can use these three methods of storing data for your applications. To choose the best option for your applications, view the below:
- MySQL can handle thousand of records in a single query with no problems. It is very easy to integrate into your existing sites. The only thing you need is PHP to communicate with the data storage. This is the best choice of storing data when using a web hosted site.
- Microsoft SQL is a preferred choice for intranet (internal) environments. It is very controllable and can handle millions of records in a single query. Using this data storage allows you to integrate with .NET applications, web pages and external files such as Excel sheets.
- Microsoft Access was designed to be used as a standalone data storage and application host. It is not very friendly when multiple users must query information. If you query the database using a direct path as a connection, multiple users can access this data storage but if you use a DSN connection only one user can access the database at a time.
|
|
|
|
|
|
| Microsoft Visual Basics 2005 .NET |
|
I have been using VB for about 3 years and have learned many things. The latest programs I have build are:
- Inventory System
This system used Microsoft SQL Server for data storage and Crystal Reports for output of purchase orders, pick list, product and shipment labels and more.
- Production Manager
This manager records production dates, links the users to production drawings and documentation, project details, time keeping, more.
- Laser Marking System
The company who built the laser provides methods you can integrate into your custom applications. The standard distributed application for the laser had about 10 steps to load and fire the laser. My task was to reduce this to two steps so there is no user input errors. I built the interface to use a barcode reader to load the information so there is no user input.
|
|
|
|
|
