Archive for the 'PHP' Category
Employee Contacts (Part 5) - Building the Presentation Layer with PHP and HTML
Filed under: Database, HTML, Internet, MySQL, PHP | Tags: data abstraction, Database, HTML, MySQL, PHP
Comments(0) Part 1 of this series covered building the MySQL database. In Part2, we built the data abstraction layer. With Part 3, we built our data access layer. At the data access layer, we made generated the queries to execute through the data abstraction layer. Part 4 of our series dealt with the business object layer and implementing one of our business rules. Finally, in Part 5, we are ready to begin our presentation layer. We will not be dealing with how to properly format the page, or creating forms. Our goal is to show you how to move data between the presentation layer and the business layer. Read more »
Employee Contacts (Part 4) - Building the Business Object Layer with PHP
Filed under: Database, HTML, Internet, MySQL, PHP, Programming | Tags: css, HTML, MySQL, PHP
Comments(0) Part 1 of this series covered building the MySQL database. In Part2, we built the data abstraction layer. With Part 3, we built our data access layer. At the data access layer, we made generated the queries to execute through the data abstraction layer. Part 4 of our series will cover the business object layer.
With the business layer, often times it will seem like we are simply making calls to the data access layer. And yes, that is true but remember that we are planning for future growth. A little extra time now can save you hours later down the road, and lead to far less headaches. As you will see when we build our presentation level, we should never make a direct call to the data access layer, those calls should be handled through our business layer.
Employee Contacts (Part 3) - Building the Data Access Layer with PHP
Filed under: Database, Internet, MySQL, PHP | Tags: data abstraction, Database, HTML, MySQL, PHP
Comments(1) Part 1 of this series covered building the MySQL database. In Part2, we built the data abstraction layer. With Part 3, we will begin to build our data access layer. The data abstraction layer provided basic database calls. At the data access layer, we will start interacting with the database through the data abstraction layer. Read more »
Employee Contacts (Part 2) - Building a Data Abstraction Layer with PHP
Filed under: Database, Internet, MySQL, PHP | Tags: data abstraction, Database, HTML, MySQL, PHP
Comments(1) Part 1 of this series covered building the MySQL database. If you are following along with us, you may want to go back and create the database from part 1. In Part2, we will be building the data abstraction layer. This will allow you to make yor basic database calls from a central location. Back when I created my first PHP application, I was using the PEAR DB class. The tutorial that I read had you make all of the calls from each function. Everything worked fine until I changed to using PEAR MDB2. Some of the calls are different, so I had to go back to all 8 class files and change about 100 functions. This was very time consuming and should have been avoidable. If I would have created my own data abstraction layer that referenced the PEAR DB class, I could have just made a few minor changes there and the rest of the application would have been fine. Read more »
Employee Contacts (Part 1) - Building the MySQL database.
Filed under: Internet, MySQL, PHP | Tags: data abstraction, Database, HTML, MySQL, PHP
Comments(0) I remember back when I built my very first web application. The company I was working for hired me to be desktop support. But there were only 2 of us in the IT department. They had an intranet site where they would keep all the contact information for their employees. It also had all the details for every construction site they had worked on. The receptionist would enter the details into an excel spreadsheet then save it as an HTML file. It wasn’t pretty and it wasn’t very useful. I had never done any programming, database development, or even basic HTML, but I was determined to provide a more dynamic and user friendly environment. I was able to find a book on ASP that basically led you through building an entire ASP website that provided the basic functionality I was looking for. I learn best by seeing a real working example, so this made it extremely easy for me to pick up ASP and to get the site up in only a matter of a couple of weeks. Read more »
