Tools commands

- Show system environment path

echo %path%

- Change directory

C:\Windows>  to  D:\xampp\htdocs\laravel>

C:\Windows>D:

- Connect MySql 

D:\xampp\mysql\bin>mysql.exe mysql -u root -p

Mysql basic commands 

show databases;

create database dbName;

use databaseName;

show tables;

describe tableName;

select * from users \G;

http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm















Comments

Post a Comment

Popular posts from this blog

API

  <?php namespace  App\Http\Controllers\Api ; use App\Helpers\ ApiHelper ; use App\Helpers\ BraintreeHelper ; use App\Http\Controllers\ Controller ; use App\Model\ User ; use App\Model\ UserLogin ; use App\Model\ UserReferralCodes ; use App\Model\ UserPackagesSubscriptionHistories ; use App\Model\ SubscriptionHistories ; use App\Model\ SubscriptionPlan ; use App\Model\ Notification ; use App\Model\ UserMessage ; use Illuminate\Http\ Request ; use Illuminate\Support\Facades\ Auth ; use Illuminate\Support\Facades\ DB ; use Carbon\ Carbon ; class   AuthController   extends   Controller {      /*     |--------------------------------------------------------------------------     | Auth Controller     |--------------------------------------------------------------------------     | ...
Read more

Encryption and Decryption By PHP

<?php Encryption and Decryption By PHP  Stap : 1 Create Library In Codeigniter , Encryption.php Stap : 2 Call Library In Controller $this->load->library('encryption'); $encData ='This is Encryption Library ,Main use for URL Encryption and Decryption'; $enc =  $this->encryption->encryptor('encrypt', $encData); //Call for Encryption $dec =  $this->encryption->encryptor('decrypt', $enc); // Call for Decryption Encryption.php <?php class Encryption {     function encryptor($action, $string) {         $output = false;         $encrypt_method = "AES-256-CBC";         $secret_key = 'test';         $secret_iv = 'test123';         $key = hash('sha256', $secret_key);         $iv = substr(hash('sha256', $secret_iv), 0, 16);         if( $action == 'encrypt' ) {   ...
Read more

Seeder

 php artisan make:seeder UsersTableDataSeeder php artisan db:seed <?php use Illuminate\Database\Seeder; use App\Model\user; class UsersTableDataSeeder extends Seeder {     /**      * Run the database seeds.      *      * @return void      */     public function run()     {         for ($i=0; $i < 15; $i++) {              $pass = str_random(5);     user::create([                 'userType' => 'Admin',                 'name' => str_random(5),                 'email' => str_random(5).'@gmail.com',                 'password' => bcrypt($pass),                 'showPassword' => $pass,         ...
Read more