SQL In Static Id Wise Record Skip After Show Result

-
Example

SELECT
    pr.*,
    sub_cat.name AS subcategoryname
FROM
    products AS pr
    JOIN product_sub_categories AS sub_cat    ON sub_cat.id = pr.sub_category_id
    JOIN product_categories AS cat         ON cat.id = sub_cat.category_id
WHERE 
     pr.`is_discontinued` = 0
    AND pr.`is_active` = 1
    AND pr.deleted_by IS NULL
    AND sub_cat.`is_active` = 1
    AND cat.`is_active` = 1
    AND cat.id NOT IN (1,5)
    AND cat.deleted_by IS NULL
ORDER BY pr.name ASC , cat.id;

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