Nov.18

Prakash Bhandari 0 Php Mysql

Sep.14

Prakash Bhandari 0 Php Mysql

WordPress Custom query to set new username and password to get others site login

We can inset from new row or run query as exampled below to insert new user to existing site. The md5 method of user registration can’t be decrypted. So we need to create new user from query.

INSERT INTO wp_users (ID, user_login, user_pass, user_nicename, user_email)
VALUES (‘2’, ‘prakash’, MD5(‘password’), ‘Prakash’, ‘akash2046@gmail.com’);

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value)
VALUES (NULL, ‘2’, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, ‘2’, ‘wp_user_level’, ’10’);

Download (INSERT Query File)Download

Jan.07

Prakash Bhandari 0 Php Mysql

How to clear Config by url request laravel

//Clear route cache:
Route::get(‘/route-cache’, function() {
$exitCode = Artisan::call(‘route:cache’);
return ‘Routes cache cleared’;
});

//Clear config cache:
Route::get(‘/config-cache’, function() {
$exitCode = Artisan::call(‘config:cache’);
return ‘Config cache cleared’;
});

// Clear application cache:
Route::get(‘/clear-cache’, function() {
$exitCode = Artisan::call(‘cache:clear’);
return ‘Application cache cleared’;
});

// Clear view cache:
Route::get(‘/view-clear’, function() {
$exitCode = Artisan::call(‘view:clear’);
return ‘View cache cleared’;
});

Dec.10

Prakash Bhandari 0 Php Mysql

Change need to Laravel site when hosting in to cpanel

Step 1:

We need to clear the config file at first. It has previous configuration on that file. delete or name that file.

<site_folder>/bootstrap/cache/config.php

 

Step 2:

Rename server.php in your Laravel root folder to index.php

 

Step 3:

Copy the .htaccess file from /public directory to your Laravel root folder.

Add Code into Htacces file:

RewriteEngine On

RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)/$ /$1 [L,R=301]

RewriteCond %{REQUEST_URI} !(\.css|\.js|\.png|\.jpg|\.gif|robots\.txt)$ [NC]
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [L]

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_URI} !^/public/
RewriteRule ^(css|js|images)/(.*)$ public/$1/$2 [L,NC]

 

Sep.12

Prakash Bhandari 0 Php Mysql,Drupal

How to Ignore Local Changes to Your settings.php File in Drupal 7/ Drupal 8 with Git

Why not just use the .gitignore file?

 

As many of you know, I am a huge Pantheon hosting fanboy and can still remember the days during the beta launch of being blown away that I have three different environments out of the box, with dev, test and live. Another great service they added recently is that all sites receive SSL certificates automatically and all you have to do is redirect all traffic to use HTTPS. In Drupal 8 they suggest doing this in your settings.php file.

After adding the redirect code everything works great until you fire up your local environment (I am currently using Lando) and you are getting a blank screen. After further investigation, you notice it’s the redirect to HTTPS that is causing the issue. My first thought was to make sure my settings.local.php file was correctly being used but for the life of me, I could not get that file to override the redirect code in my settings.php file. If you are reading this and have a better idea on to how to accomplish this then let me know in the comments 🙂

My next thought was to simply add the settings.php file to my .gitignore file but when I went to my production website I was prompted to reinstall my Drupal site. When adding a file to .gitignore the repo pretends it doesn’t exist so therefore Drupal was telling me to reinstall. Whoooops, my production site kind of needs this file hahahah. So I thought to myself,

How can I ignore my settings.php file in my local repo but still have the original file on production?

After attending Google University for 10 minutes, I stumbled upon a medium post by Ian Gloude regarding the git update-index command. In their article “Git skip-worktree and how I used to hate config files,” there is a great explanation of the concept, but for me the lightbulb really went off when reading the Git documentation hint, “see also git-add[1] for a more user-friendly way to do some of the most common operations on the index.” Basically git update-index tells Git what to watch in your repo.

Now that we understand what git update-index does, the real magic happens with the options that you can add to the command. In this case, the option that Ian Gloude suggested is the --skip-worktreeoption. The Git documentation explains that the skip worktree bit tells the git index to assume the file is unchanged from this point on regardless if there is an actual change. So what does this mean for us? It means you can change your file on your local environment while the original file on your production server remains unchanged.

Here is the command I use prior to uncommenting out the pantheon redirect code.

git update-index –skip-worktree /sites/default/settings.php

When I need to make some changes to the production settings.php file I can tell Git to watch the file again with this command.

git update-index —-no-skip-worktree web/sites/default/settings.php

Anyway, I hope this helps you keep your local and production environments running smoothly while maintaining your settings differently.

 

Sep.01

Prakash Bhandari 0 Php Mysql

How to Send Bulk SMS with Twilio and Laravel PHP

There are times when you have a large number of users and you need to update or notify them simultaneously via SMS. Maybe you run a membership site or personal blog. Whatever the case this tutorial will provide an efficient and easy way to achieve sending bulk SMS via your web app.

Technical Requirements

For this tutorial we’ll assume you already know or have the following:

  • A Terminal (Command Line)
  • Composer installed
  • Are familiar with PHP
  • Are familiar with Laravel (5+)
  • You have an existing Laravel (5+) project
  • You have a Twilio account and your credentials ready

Just in case you don’t have a Laravel project setup, this guide will help you to create a new Laravel project locally.

Install and Configure the Twilio Laravel SDK

The first thing we need to do is install the Twilio Laravel SDK which will provide the needed functions to get our bulk SMS app started. We’ll use the command line to achieve that. So in the command line type:

$ composer require twilio/sdk

Now that we have the SDK installed, we need to configure it to recognize our Twilio account. Open up your .env file and paste in the following code. Be sure to replace the variables with your Twilio credentials. TWILIO_FROM is your Twilio Number.

TWILIO_SID=ACXXXXXXXXXXXXXXXXXXX
TWILIO_TOKEN=XXXXXXXXXXXXXXXXXXXXX
TWILIO_FROM=APXXXXXXXXXXXXXXXXXXX

Setup the Controller and View

We need a controller specially for our BulkSMS app, so paste in the command below to create a controller using Laravel’s artisan console.

$ php artisan make:controller BulkSmsController

Open the controller and include the Twilio class at the top:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Twilio\Rest\Client;
use Validator;

Next we will create a view file called bulksms.blade.php to make an HTML form to create the necessary fields for our bulk SMS app.

$ touch resources/views/bulksms.blade.php

Open up the newly created file located at resources/views/bulksms.blade.php and paste in the code below:

<html>
      <body>
         <form action='' method='post'>
              @csrf
                      @if($errors->any())
              <ul>
             @foreach($errors->all() as $error)
            <li> {{ $error }} </li>
             @endforeach
        @endif

        @if( session( 'success' ) )
             {{ session( 'success' ) }}
        @endif

             <label>Phone numbers (seperate with a comma [,])</label>
             <input type='text' name='numbers' />

            <label>Message</label>
            <textarea name='message'></textarea>

            <button type='submit'>Send!</button>
      </form>
    </body>
</html>

 

Sep.01

Prakash Bhandari 0 Php Mysql

Hide public url from laravel project

Laravel will run <domain-name>/public folder but we can remove this public path from our site with

  1. Rename server.php in your Laravel root folder to index.php
  2. Copy the .htaccess file from /public directory to your Laravel root folder.

It will run site in <domain-name> with out /public but some assets js, css will not work properly we need little bit htacess changes.

these changes are :

 

Sep.01

Prakash Bhandari 0 Php Mysql,Laravel

Laravel clear cache file manually if command not supported

When we migrate local file to online server. Laravel cache stored on local cached file also migrated. So this cache will look over the cache defined file but would not get local file location and gets an error like.

 

 

If server allow us to run command

the commad for clear cache is:

$php artisan config:cache

$php artisan config:clear

but we don’t access command line any type of server so that  we need remove file which are getting us problem to recreate cache file are located on.

Manual Remove Cache file(Server automatically generate new file with the location):

/bootstrap/cache/

there are

config.php

packages.php

services.php

 

 

so we need remove it manually then load site, the site are working properly from now.

 

+++++++++++++++++++++++++++

Add some clear config command with our route. then run the clear command but hitting url also be the fine solution to remove cache files.

+++++++++++++++++++++++++++

Route::get(‘/clear-cache’, function() {
Artisan::call(‘cache:clear’);
return”Cache is cleared”;
});

put these code into you route/web.php

and run from web url <your-domain>/clear-cache

it will works perfectly.

thanks

 

Mar.10

Prakash Bhandari 0 Php Mysql

Add value to existing array group : React Learning

const genre_with_all = [{‘name’:”All Movies”},…getGenres()];
this.setState({
movies:getMovies(),
//genre:getGenres(),
genre:genre_with_all,
})
+++++++++++++++++++++++++++
+++++++++++++++++++++++++++
export const genres = [
{ _id: “5b21ca3eeb7f6fbccd471818”, name: “Action” },
{ _id: “5b21ca3eeb7f6fbccd471814”, name: “Comedy” },
{ _id: “5b21ca3eeb7f6fbccd471820”, name: “Thriller” }
];
export function getGenres() {
return genres.filter(g=>g);
}

Mar.10

Prakash Bhandari 0 Php Mysql

Installing lodash javascript

lodash javascript library for mapping the

It is used to generate the array with the range.

 

installing lodash

lodash javascript

D:\\start\vidly>npm i lodash@v4.17.10

 

importing it in to required page

import _ from ‘lodash’;

or

//import lodash from ‘lodash’;
+++++++++++++++++++++++++++++++++++++++++
Notification on error
+++++++++++++++++++++++++++++++++++++++++
 
 : npm  install react-toastify@4.1
Need to install toastify module.
import it in to top of the Component.
+++++++++++++++++++++++++++++++++++++++++
Track User/Product error message into online system
Sentry
Ravin
+++++++++++++++++++++++++++++++++++++++++
www.sentry.io is the one of the best application to save our error message.
installation
:npm i raven-js@3.26.4
install the module
+++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++++
Sentry browser installation in
React
+++++++++++++++++++++++++++++++++++++++++++
or install
: npm i @sentry/browser
Initialized into the top page of application with your authorized code.
…………………………
initialized sentry

…………………………
Sentry.init({
dsn:”https://454938bc56074cadaa3e6317e9d6061e@sentry.io/1415291″
});
…………………………
To call sentry

…………………………
Sentry.captureException(error);
error is param to send error message.