How to reorder table rows using drag and drop and automatically save the sequence in database. Sample Table code start <table class=”table table-bordered” id=”tbl_1″> <thead> <tr> <th width=”25%”>Column1 Label</th> <th…
When you have access to the command line and you have the export large database, you will not be able to export from phpmyadmin. Hence mysql provide you handy method…
We can get the SQL query from DB sql query in Laravel 5 $dataQuery = DB::table(‘sometable’) ->select(‘sometable.column1′, ‘sometable.column2′, ‘sometable.column3′, ‘sometable.column4′, ‘sometable.column5′); $dataQuery->toSql(); // this will give you the actual query…
$markers = $this->Post->find(‘all’, array( ‘joins’ => array( array( ‘table’ => ‘cp_user’, ‘alias’ => ‘users’, ‘type’ => ‘left’, ‘foreignKey’ => false, ‘conditions’=> array(‘Post.postauthor = users.id’) ) ), ‘conditions’=>’Post.poststatus = 1’, ‘fields’=>array(‘Post.postid’,…
The basic purpose of this post is to guide you all about fetching multilingual content from database. I mean to say that, if you have stored japanese text in your…
Open your shell prompt navigate to the mysql directory (default is /var/lib/mysql) cd /pathToYourMysqlDirectory/ then type the below command $ mysql -u mysqlUserName -p Password -h HostName DatabaseName < /loactionOfYourSqlFile/yourSqlFileName.sql…