Skip to main content

Posts

Showing posts from 2022

How to Create table in database in wordpress?

Create table in database in wordpress <?php /*=====================Create table in wordpress database====================*/   /* ++++++ Created user_tbl table +++++++*/ function create_users(){     global $wpdb;     $create_cases_table_name = $wpdb->prefix . "users";     $create_cases_table_query = "CREATE TABLE $create_cases_table_name ( ID mediumint(9) NOT NULL AUTO_INCREMENT, status ENUM('0', '1') DEFAULT '1' COMMENT '1 = active 0 = not active', type ENUM('google', 'facebook', 'apple') NOT NULL  COMMENT 'google, facebook, apple', first_name Varchar(255) NULL, last_name Varchar(255) NULL, email Varchar(255) NULL,                   device_type LONGTEXT NOT NULL, created TIMESTAMP DEFAULT '0000-00-00 00:00:00', updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY ID (ID)     ) $charset_collate;";           require_once( ABSPATH .

How to add new rule in laravel validations in Laravel 8?

Add new rules in laravel validations in Laravel 8 //Rule use Illuminate\Validation\Rule;          $validator = Validator::make($request->all(), [             'email' => 'required|unique:users|max:255|email:rfc,dns', 'username' => [ 'required','min:4', Rule::unique('users')->where(function ($query) { $query->where('is_verified','=', '1'); return $query; }) ],             'displayname' => 'required',             'password' => 'required',         ],$messages = [], [             'email' => 'Email',             'username' => 'Username',             'displayname' => 'Display Name',             'password' => 'Password',         ]);

How to create search filter with ajax in Laravel 8?

Create search filter with ajax in Laravel 8 <?php function ajax_group_list(Request $request){ $group = DB::table('group'); $group->join('users', 'users.id', '=', 'group.userid_createdby'); if (!empty($request->search)) { $group->where('group.gg_name', 'Like', '%' . $request->search . '%'); $group->orWhere('users.displayname', 'Like', '%' . $request->search . '%'); $group->orWhere('users.email', 'Like', '%' . $request->search . '%'); } if (!empty($request->search_city)) { $group->where('group.gg_city', 'Like', '%' . $request->search_city . '%'); } if (!empty($request->search_state)) { $group->where('group.gg_state', 'Like', '%' . $request->search_state . '%'); } if (!empty($request->search_count

How to filter products With tags in Woo-Commerce in Wordpress?

Filter products With tags in Woo-Commerce in Wordpress. function product_filter_by_tag(){ ob_start(); ?> <style> .tag_swatch_button { transition: all .2s ease-in-out; -webkit-appearance: none; border-radius: 0; font-family: inherit; appearance: none; background: none; font-weight: 500; font-size: 18px; cursor: pointer; padding: 12px 15px; outline: none; opacity: 1; border: none; color: #000; } .tag_swatch_button:hover, .tag_swatch_button.active { background-color: #000; color: #fff; } .tag_swatch_item { border-radius: 4px; height: auto; width: 30.33%; float: left; margin: 0 1.5% 30px 1.5%; text-align: center; font-size: 20px; line-height: initial; font-family: 'Playfair Display', Georgia, "Times New Roman", serif; text-transform: capitalize; } .tag_swatch_hide { display: none; } </style> <script> function tag_checkClass() {   if ( $('.tag_swatch_item').hasClass('tag_swatch_hide

How to add form validation in multi step or role in laravel 8?

Add form validation in multi step or role in laravel 8  Add validation, If input is not empty.   if($role==2){ $bio = $res->bio; $working_profile = $res->working_profile; $experience = $res->experience; $validator_array = array( 'f_name' => 'required', 'l_name' => 'required', );  } else{ $validator_array = array( 'f_name' => 'required', 'l_name' => 'required', );  } if($res->file('user_img')) { $validator_array['user_img'] = 'required|image|mimes:jpeg,png,jpg,gif,svg'; } $validator = Validator::make($res->all(),$validator_array);   if($validator->fails()){ //$vald_errors = $validator->errors();  $vald_message_bag=$validator->getMessageBag(); $vald_errors= webErrors($vald_message_bag->toArray()); $status=403; $success=false; $message='Invalid..!';

How to add horizontality progress bar on vertical scroll in jQuery?

Add horizontality progress bar on vertical scroll in jQuery  <div id="scrollBar"></div>  <div class="on_scroll_bx"></div>  <script> (function($) {     $(document).ready(function(){         var winHeight = $(window).height();         var $scrollBar = $('#scrollBar');         //var $progressLabel = $('.et-progress-label p span');            var $postContent = $('.on_scroll_bx');         $scrollBar.css('width', 0);        // $progressLabel.html('0%');                  $(window).scroll(function(){             var postContentHeight = $postContent.height();                       var postContentStartPosition = $postContent.offset().top;             var winScrollTop = $(window).scrollTop();             var postScrollTop = postContentStartPosition - winScrollTop;             var postScrollableArea = postContentHeight - winHeight;             var postScrollPercentage = Math.abs((postScrollTop/post