How to Use Sub Query In SQL

-
SELECT 
    od.`product_id`,
    SUM(od.`origianl_quantity`) AS total_quantity,
    (SELECT pro.`name` FROM products AS pro WHERE pro.`id` = od.`product_id`) 
        AS product_name 
FROM order_details AS od 
        GROUP BY od.`product_id`  ORDER BY total_quantity DESC

Popular posts from this blog

Yii Framework In Update Time View Image In Form

-
Example [                 'attribute'=>'Image',                 'label'=>'image',                 'format'=>'html',                 'value'=>function($data)                 {                     return Html::img(Yii::$app->params['imageuploadurl'].$data['Image'],                     ['width'=>'100','height'=>'50'],['alt'=>'yii']);                 },  ],   --- Form In----  <?= $form->field($model, 'file')->fileInput() ?> <?= Html::img(Yii::$app->params['imageuploadurl'].$model->Image,['width'=>'100','height'=>'50'],['alt'=>'yii']); ?> NOTE : (...
Read more

Add a new column to existing table in a migration

-
To create a migration, you may use the migrate:make command on the Artisan CLI. Use a specific name to avoid clashing with existing models for Laravel 3: php artisan migrate : make add_paid_to_users for Laravel 5+: php artisan make : migration add_paid_to_users_table -- table = users You then need to use the  Schema::table()  method (as you're accessing an existing table, not creating a new one). And you can add a column like this: public function up () { Schema:: table ( 'user_master_transational' , function (Blueprint $table ) { $table ->string( 'vFirstName' , 25 )-> collation ( 'utf8mb4_unicode_ci' )-> nullable () -> after ( 'iUserId' );           $table ->string( 'vLastName' , 25 )-> collation ( 'utf8mb4_unicode_ci' )-> nullable () -> after ( 'iUserId' ); }); } and don't forget to add the rollback option: public function down () { Schema :: table ( 'users' ...
Read more

Ajax Toggle(on/off) on-click Update

-
example  Index : < td > < a href= "javascript:void(0)" data-toggle= "tooltip" onclick= " toggleProductStaple({{ $item -> id }},{{ $item -> is_staple }}) " > @if ( $item -> is_staple === 1 ) < i data-toggle= "tooltip" data-original-title= "Active" class= "fa fa-toggle-on text-inverse m-r-10" ></ i > @else < i data-toggle= "tooltip" data-original-title= "Inactive" class= "fa fa-toggle-off text-inverse m-r-10" ></ i > @endif </ a > </ td > function: < script > function toggleProductStaple (product_id, is_staple) { $ . ajaxSetup ({ headers : { 'X-CSRF-TOKEN' : $ ( ' meta [name="_token"]' ). attr ( 'content' ) } }); $ . ajax ({ type : "post...
Read more