PHP mysqli example – search MySQL database table using a function

In the following PHP program I have accessed the MySQL database (using PHP’s object oriented mysqli extension ) by a PHP function generated by me, and fetched a “MySQL database table” column value (Departments column) based on some key value in another column ( Serial ). To get the required value from database you have to just call a function like this : function getDepartmentName( $dbTableName, “Serial”, 2, “Departments”) where Serial and Departments are two columns of same database table, and 2 is the value in the Serial column in a record. If you dont know PHP MySQL – visit our PHP MySQL programming online coaching classes

Say if you pass the Serial = 2, you will get the corresponding column value of Departments column = ARCHITECTURE, which is located in the same record in the database table, but in different columns. Don’t worry whole table structure shown below.

You should have SQL query knowledge to understand the following code . To get it done you have to call the function like this mentioning column “Serial”, database table name $dbTableName & value in Serial column which is 2 here and $returnColumnName = Departments here Continue reading “PHP mysqli example – search MySQL database table using a function”

Install Java jdk8 in Ubuntu 14.04 from .tar.gz archive files

If you want to install JDK / JRE in Ubuntu 14.04 LTS version then just download the archive file jdk1.8.0_66.tar.gz. The file name will be of this type jdk1.8.0_66.tar.gz , after downloading you have to put it in /opt/ directory. Use the following steps to install java 8 manually in Ubuntu 14.04 LTS version from jdk1.8.0_66.tar.gz archive files. Continue reading “Install Java jdk8 in Ubuntu 14.04 from .tar.gz archive files”

Add custom menu, Add theme locations & register new menu

A WordPress developers guide / tutorial – for adding custom menu in new wordpress theme, add one or multiple new theme locations for the custom WordPress menus, so that menu can appear in those places. Register new menu items. Enable your new wordpress theme to add custom user defined nav menus from the admin dashboard. Continue reading “Add custom menu, Add theme locations & register new menu”