Database-Based Authentication for PHP Apps, Part 2
In Part 2, you will expand on the example authentication and user entry solution constructed previously. Whereas the current solution treats all users as equals, the idea of users accessing all things equally is unusual in real applications. Rather, your users probably have roles and privileges limiting their access to data based on their position [...]
Database-Based Authentication for PHP Apps, Part 1
Managing secure access to Web pages and applications is a common problem. You want to enable those you trust to access data while preventing unauthorized ones from gaining access to it. In most cases, database-based authentication is the solution. Authentication systems contain an Access Control List (ACL) that lists your user credentials and matches them [...]
Migrating Web-Based PHP Applications to Ajax
Web development is messy. Over the years, our toolbox has filled up with odd implements that are hard to use and don't fit well together. Web code has become a legacy problem. A typical web page is a tangle of HTML, JavaScript, and server-side scripts. User interface logic is interwoven with business rules and client-server [...]
Creating Sortable Lists With PHP And Ajax
You might have been in a situation before where you had a list of items in your database that needed to be output in a specific order. These items could be anything: perhaps a listing of your favourite movies or your favourite books. For whatever reason, you want them ordered in a custom way that [...]
Introduction to Legacy Modernization in Oracle
In this article by Tom Laszewski and Jason Williamson, we have outlined five methods of modernization: SOA Integration, Re-architecture, Platform Migration, Replacement, and Data Modernization as well as some key factors to be considered for each option.
Introducing SQL Developer Data Modeler: Part 2
Working with diagrams and their components You can waste away many hours laying out the elements on a diagram. Therefore, this aspect of modeling can be time consuming. However, a model serves as documentation and a communication device. Therefore, taking the time to make sure it is well annotated and clearly designed is important. Most [...]
Introducing SQL Developer Data Modeler: Part 1
Oracle SQL Developer Data Modeler is available as an independent product, providing a focused data modeling tool for data architects and designers. There is also a Data Modeler Viewer extension to SQL Developer, which allows users to open previously created data models and to create read-only models of their database schemas. SQL Developer Data Modeler [...]
Working with the Report Builder in Microsoft SQL Server 2008: Part 2
In the previous part of the article, we had a look at the Report Builder overview and described the Report Builder 2.0 interface. In this part by Jayaram Krishnaswamy, we will discuss about Enabling and reviewing My Reports, and will see how to Modify a basic report.
Working with the Report Builder in Microsoft SQL Server 2008: Part 1
Report Builder 2.0 is feature-rich reporting tool with the latest Microsoft Office look and feel. In this two part article by Jayaram Krishnaswamy, we will see how the Report Builder 2.0 provides an extremely flexible GUI with user friendly wizards for creating the Tablix data regions, a versatile construct that includes tables, matrix, and charts [...]
Introduction to database design
This article/tutorial will teach the basis of relational database design and explains how to make a good database design. It is a rather long text, but we advise to read all of it. Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know [...]