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:
Continue reading »
The jQuery plugin Datatable is a plugin that will allow you to have many features on a HTML table. This plugin is so simple to use, but if you need more complex thing you can also achieve them since the plugin is full of features that can be customize, it also includes an event listener for the action on the table.
Among the features of the Datatable plugin you can have:
- Pagination, instant search and multi-column ordering
Supports almost any data source:
- Easily theme-able: DataTables, jQuery UI, Bootstrap, Foundation
- Wide variety of extensions inc. Editor, TableTools, FixedColumns and more
- Extensive options and a beautiful, expressive API
- Fully internationalisable
- Professional quality: backed by a suite of 2900+ unit tests
- Free open source software (MIT license)! Commercial support available.
- Scrolling options for table viewport
- Smart handling of column widths
- State saving
- Hidden columns
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.
Giving answer to one comments that ask about a question mark in one of my tutorials ( http://behstant.com/blog/?p=662 ) I have created this small answer.