Web enabling business data is one of the key devices used to advertise and market products. This can be done with various technologies such as VB, ASP, JSP, ASP.Net and many others. This article shows how you may view data from a table on a MySQL database server on a web page using ASP.NET. The table used in this tutorial was the one described in the first article in this series on Exporting data from MS Access 2003 to MySQL.
This article by Dr. Jay Krishnaswamy explains how to populate a GridView on an ASP.NET web page by data retrieved from a MySQL Server. MySQL.Data.MySqlClient is a connector (provider) provided by MySQL which you can use with the .NET Framework applications whose details may be reviewed here. MySQL is well integrated with Visual Studio (MySQL Visual Studio Tools: MySQL.VisualStudio.dll).Read Displaying MySQL data on an ASP.NET Web Page in full
In this article by Alfonso Romero, we will learn how to configure NetBeans, VirtualBox and the Turnkey LAMP Appliance to develop complex PHP applications in a virtual environment. This article explains the process of creating a virtual machine, configuring the NetBeans PHP IDE, and managing a WordPress project with NetBeans in a step wise manner.Read Develop PHP Web Applications with NetBeans, VirtualBox and Turnkey LAMP Appliance in full
We are developing software for users, and we want to ensure that the software is really useful for the users. Over time, people working on this software have faced the same problem over and over again. Therefore, they have come up with a concept called agile development. In this article, we will explore the concepts of agile development and will also see how these can help us with the PHP projects.
In this article by Samisa Abeysinghe, we will cover the following:
- What is meant by agility and how it can help
- Extreme programming principles
- Advantages of agile process models
- Team agility
- Agile process models
- Agile principles for the PHP project team
In this article by Samisa Abeysinghe, we will look into a process model that we can use as a starting point for the PHP projects that we are working on. The process is designed with the MVC framework based design model in mind. It is assumed that the workload is broken down based on the Model-View-Controller pattern, and team members are assigned to work on each layer based on that breakdown.
The process model clearly depicts how the separate concerns such as the data layer, the business layer, and the presentation layer can be worked on in parallel, and at the same time, how those separate concerns fit with each other to form the entire system. If you carefully evaluate this process model, there is no activity for system integration. So one might question how the separate layers would be integrated with each other. However, if you pay attention to the design and implementation details of each layer, you will notice the dependencies mentioned in each layer, which lead to the integration. For example, business logic implementation requires the concrete database design, as well as the data access layer. The final user interface implementation would be done on top of the business logic implementation. Therefore, the integration of these independent layers happens seamlessly, along the way, in the process. If the team follows the process as it is, the integration would result in naturally.Read Simple process for PHP projects in full
There are a large number of posts on various difficulties experienced while transferring data from MySQL using Microsoft SQL Server Integration Services. While the transfer of data from MySQL to Microsoft SQL Server 2008 is not fraught with any blocking issues, transfer of data from SQL Server 2008 to MySQL has presented various problems. There are some workarounds suggested. In this article by Dr. Jay Krishnaswamy, data transfer to MySQL using SQL Server Integration Services will be described.Read MySQL Data Transfer using Sql Server Integration Services (SSIS) in full