Codxplore.com

Latest news:

Quran ul karim is a free Quran application for android. This application is advertisement free application for android smartphone. Download from https://play.google.com/store/apps/details?id=com.akramhossain.quranulkarim&hl=en

1522
Views
 How to create virtual column using MySQL SELECT?

How to create virtual column using MySQL SELECT?

Virtual column in MySQL is generated column, this column data or value comes from expression or function or other columns. The difference between virtual column and normal column is normal table column value saved to disk but virtual column value generated dynamically from any expression or function or from other columns. So the virtual column has following characteristics Virtual column is
1933
Views
Yii2 joinWith(), innerJoinWith(), join(), leftJoin()

Yii2 joinWith(), innerJoinWith(), join(), leftJoin()

Yii2 active record has powerful built-in feature to join database table. In this post we will learn some of the useful features joinWith() innerJoinWith(), join() leftJoin() join using query builder Example of joinWith(): $model = Users::find()                ->joinWith('posts', false, 'INNER JOIN')                ->all(); Example of innerJoinWith(): $mod
1484
Views
Yii2 GridView sorting and pagination using pajax

Yii2 GridView sorting and pagination using pajax

In this article we will learn how to use Pjax for Yii2 grid view sorting and pagination. Pjax is a jquery plugin which progressively enhances website page loads and behave more like single-page web application. We need to these steps to enable Pjax in yii2 web page Import yii\widgets\Pjax class Begin Pjax widget using Pjax::begin() Code block which needs to be rendered using Pjax Close Pja
1046
Views
Yii2 Turning on Pretty URLs

Yii2 Turning on Pretty URLs

In this blog post i will discuss about Yii2's pretty URLs. Yii2 pretty URLs relies on mod_rewrite module on apache or httpd server. Without Yii2 pretty URLs if you click on any link for example About Us menu, the URL will be something like http://localhost/hello/web/index.php?r=site/about.  I'd like to change that to http://localhost/hello/web/site/about. The config subdirectory includes env
926
Views
Yii ajax form submit

Yii ajax form submit

In many cases we need to submit form using jQuery ajax. Yii has built-in support for this funtionality. In this blog post i will try to cover this topic. In the view form section at first we need to call form widget $form = $this->beginWidget('CActiveForm', array(    'id' => 'formId',    'enableAjaxValidation' => false,)); CActiveForm widget accepts multiple parameters, we will use two of
672
Views
jQuery ui date picker in Yii

jQuery ui date picker in Yii

In this blog post we will learn how to add jQuery UI date picker to Yii application. To display jQuery UI date picker in the view page we need to call Yii built-in function widget. This widget function accepts following parameters Widget Name Widget Options Widget options also accepts multiple parameters it depends on widget class like Model object Attribute Name Options htmlOption
663
Views
Yii load data into select box from database

Yii load data into select box from database

In this article we will learn how to load data into yii select box from database. We will follow below steps Create a function in model class Call that function to view page to get the data Lets say we have a table as pos_mac, now we will add a method named as getMacList() in POS_MAC model class. This method will load the all table data of pos_mac. Yii CHtml::listData function convert thi
804
Views
Yii oracle database connection in windows

Yii oracle database connection in windows

In this post we will learn how to connect oracle database using PHP Yii framework. Following steps we need to follow to accomplish this Enable php_oci8.dll extension Restart the apache server Add connection string DB username DB Password Adding charset(optional) At first we need to enable php_oci8.dll extension. This extension is used to connect our application to Oracle Database. We
883
Views
PHP convert datetime to selected timezone

PHP convert datetime to selected timezone

PHP DateTime class provides all the date and time processing functionality. The DateTimeZone class provides DateTime objects with all the required time zone information. DateTimeZone require the timezone name as string format and it will return an object representing datetime of that particular time zone. We need to follow these steps to convert any datetime to particular time zone: Create a
731
Views
MD5 encryption using java

MD5 encryption using java

In this tutorial we will learn how to create md5 hash in java. To create md5 hash in java we need follow below steps. Import java.math.BigInteger. Import java.security.MessageDigest. Import java.security.NoSuchAlgorithmException. Create MessageDigest object for MD5 Update input string in message digest Converts message digest value in base16 (hex) If md5 generated successfully return md5
719
Views
MySQL database connection using java

MySQL database connection using java

For connecting to MySQL database using java we need to do following. Java driver class name for MySQL: com.mysql.jdbc.Driver Database connection string or connection url: jdbc:mysql://localhost:3306/addressBook jdbc is the api name. mysql is the database managment software. localhost is the name of server where MySQL is installed. 3306 is the port port number. addressBook is the name of d
770
Views
how to export mysql data to csv in java

how to export mysql data to csv in java

In this article i will explain how to export MySQL table data to csv file. To export data to csv at first we need to connect our application to MySQL. You can follow this tutorial  to learn How to connect to MySQL database in java. We need to follow these steps in order to export data to csv. Connect to MySQL. Use FileWriter Class. Get Data from MySQL table. Append data to csv file Flash

Subscribe Us


Follow Us