Posts Tagged ‘Database
The jQuery Plugin Datatable will help you to keep those huge database results into a better and organize table. I have spoke of the jQuery Datatables plugin into this entry, so I will no use much time in the introduction of the plugin. I will focus and how you can get you database results into that Datatable.
For this Example I will be using a database, the employee table that I have been using in previous tutorials, so if you don't remember the file structure of the table I present it again.
As many of you know Oracle is the top leader on Database Performance and Management, there are many databases on the market but believe me at my Job I work with thousands of records on Oracle, I mean thousands. I will not take away the credit on the other Databases though. On this tutorial I will guide you through the installation process on Windows 7.
I am creating a PHP library to work with different databases, right now it includes connections for MySQL and Oracle, and this is why I am making this tutorial because before you connect to Oracle you must have it on you system.
I let you know that if you have installed Oracle before then this tutorial will help you only as a reference, otherwise keep reading a follow the steps.
1.- DOWNLOADING ORACLE
2.- Selecting the Windows Version.
Here you will select the version for your Operating System on this time we are selecting the 32 Bits version.
kokoroDB is library that I have created to interact with the Database. This library will free the developers from the tedious work of prepare statements, binding variables and more. So far the library allows you to select and insert information, works with PHP PDO, and store the error messages on an array.
More settings and capabilities will be added on the future like:
Read the rest of this entry »
I would like to show you a diagram of the application flow so click it to enlarge.
As you can see the application will load the information when the page loads, this is why the tutorial is Part 1, on further tutorial the information will not be loaded until the user type the information to search. Now, the code.
I have created a few post about how to Search, Update and Delete data from a MySQL Database with PHP and PDO. Those tutorials are quite simple (but not dynamically enough, they don't use Ajax), but they are very important to catch the flow of this tutorial if you have never worked with this technologies. The tutorials are in Spanish so if you really need them in English I will be glad to translate them.
Something that I would like to remark is that you can get the scripts at the end of the tutorial.
In order to create a nice look and feel to the page I have implemented the framework Boostrap, but if you don't want to focus on the look and feel you only have to focus on the Form, the event to Fire the Ajax request and the server to process your request.
The next flow chart will show the path that we are going to cover to complete our Ajax search:
Read the rest of this entry »