Database Archives » The Code

jQuery Datatables sDom – Custom Elements

February 14, 2019 by Reedyseth

This post is the next part of Working with the jQuery Datatables plugin. Since this tutorial is written for those familiar with the plugin You might need to learn the basics of the plugin on the following link http://behstant.com/blog/jquery/datatables-jquery-implementation/. On this tutorial I am going to focus on how to manipulate the elements of the Datatables by using the sDom property. In the first place you need to know that the plugin jQuery Datatables have 4 visual core elements:

Number of items to Display.
The main table.
Number of records retrieved.
Paginator.

Since these elements are visual you can put them in different positions or perhaps you can decide to set them visible or not, however, remember that not adding information into this property will result in a working DataTable using the default settings.

jQuery Datatables Implementation

May 2, 2016November 11, 2015 by Reedyseth

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.

Installing Oracle 11g R2 on WIndows 7

November 20, 2015February 1, 2015 by Reedyseth

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 – PHP database Library

November 20, 2015December 12, 2014 by Reedyseth

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:

Search with Ajax and jQuery UI Autocomplete, PHP, MySQL and JSON

April 26, 2016September 10, 2014 by Reedyseth

I have been creating posts with scripts to do small stuff, but on this post I would like to show/teach you how to implement the jQuery UI Autocomplete Widget. I have to remark that for the style of the application I am using Bootstrap, so the most important thing is the html code of the form and the Javascript code. This is the Part 1 of the tutorial.

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.