March 15, 2022 in Tips and Tricks
convert the & with %26
For Example
<span class="share"><a id="whatsapp" href="https://api.whatsapp.com/send?phone=&text=वृष www.shubhcalendar.com/sign-detail?id=2%26utm_source=web%26utm_medium=in" data-action="share/whatsapp/share" class="social-share-url.whatsapp" target="_blank">
<img src="/image/whatsapp_50.png" alt="">
</a></span>March 3, 2022 in Tips and Tricks
Open the terminal window and type:w
The w command shows information about the Linux users currently on the server, and their running processes. The first line displays, in this order:
The following info displayed for each current logged in user:
sweta pts/10 minitx 22:11 5.00s 0.04s 0.02s vim replicant.py
Where,
March 3, 2022 in Laravel, Php, Technology, Tips and Tricks
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateReminderTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('reminder', function (Blueprint $table) {
$table->id();
$table->integer('user_id')->nullable();
$table->date('date')->nullable();
$table->time('time')->nullable();
$table->text('description')->nullable();
$table->tinyInteger('type')->nullable();
$table->string('ip',150)->nullable();
$table->softDeletes();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('reminder');
}
}
February 24, 2022 in Laravel, MySql, Tips and Tricks
They do the SQL DATE() work for you, and manage the differences of SQLite.
Your result can be achieved as so:
->whereDate('date', '<=', '2014-07-10')Though the above method is convenient, as noted by Arth it is inefficient on large datasets, because the DATE() SQL function has to be applied on each record, thus discarding the possible index.
Here are some ways to make the comparison (but please read notes below):
->where('date', '<=', '2014-07-10 23:59:59')
->where('date', '<', '2014-07-11')
// '2014-07-11'
$dayAfter = (new DateTime('2014-07-10'))->modify('+1 day')->format('Y-m-d');
->where('date', '<', $dayAfter)->whereDate('date','=','2014-07-10')
->whereDate('date', '<=', '2014-07-10')February 24, 2022 in Laravel, Php, Tips and Tricks
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateExpenseTableTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('expense_table', function (Blueprint $table) {
$table->id();
$table->integer('user_id')->nullable();
$table->double('amount', 10, 2)->nullable();
$table->text('description')->nullable();
$table->string('ip',150)->nullable();
$table->softDeletes();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('expense_table');
}
}
February 19, 2022 in Tips and Tricks
Example 1
$(document).ready(function() {
// Setup - add a text input to each footer cell
$('#example tfoot th').each( function () {
var title = $(this).text();
if(title == 'Status'){
$(this).html( '<input type="text" size="5px" placeholder="'+title+'" />' );
}
});
// DataTable
var table = $('#example').DataTable({
initComplete: function () {
// Apply the search
this.api().columns().every( function () {
var that = this;
$( 'input', this.footer() ).on( 'keyup change clear', function () {
if ( that.search() !== this.value ) {
that
.search( this.value )
.draw();
}
} );
} );
}
});
} );Example 2
$(document).ready(function() {
// Setup - add a text input to each footer cell
$('#example tfoot th').each( function () {
var title = $(this).text();
if(title == 'Status'){
$(this).html( '<input type="text" size="5px" placeholder="'+title+'" />' );
}
});
// DataTable
var table = $('#example').DataTable({
initComplete: function () {
// Apply the search
this.api().columns().every( function () {
var that = this;
$( 'input', this.footer() ).on( 'keyup change clear', function () {
if ( that.search() !== this.value ) {
that
.search( this.value )
.draw();
}
} );
} );
},
"columnDefs": [
{ "orderable": false, "targets": [1] },
{ 'searchable' : false, 'targets' : [7]
},
],
"order": [[ 6, "desc" ]]
});
} );February 14, 2022 in Laravel, Tips and Tricks
public function sendResponse($result, $message)
{
$response = [
'success' => true,
'data' => $result,
'message' => $message,
];
return response()->json($response, 200);
}
/**
* return error response.
*
* @return \Illuminate\Http\Response
*/
public function sendError($error, $errorMessages = [], $code = 404)
{
$response = [
'success' => false,
'message' => $error,
];
if(!empty($errorMessages)){
$response['data'] = $errorMessages;
}
return response()->json($response, $code);
}
public function logout(Request $request)
{
$user = Auth::user()->token();
$user->revoke();
$success['status']='1';
return $this->sendResponse($success, 'User logout successfully.');
}Route::group(['middleware' => ['auth:api']], function(){
Route::post('logout', 'ApiController@logout');
});February 5, 2022 in Php, Tips and Tricks
<?php
$imagedata = file_get_contents("https://websitename.com/images/fee_279_4_%E0%A4%AE%E0%A4%BE%E0%A4%98_%E0%A4%A8%E0%A4%B5%E0%A4%B0%E0%A4%BE%E0%A4%A4%E0%A5%8D%E0%A4%B0%E0%A4%BF.jpg");
$base64 = base64_encode($imagedata);
echo "<img src='data:image/jpeg;base64,$base64'>";
?>February 5, 2022 in Tips and Tricks
To solve it (on Windows) just do the following:
Open the Task Manager
Find the process CoreSync.exe and right click > Open file location
Delete the file
Find the process CCXProcess.exe and right click > Open file location
Delete the file
Note: backup it before deleting
January 25, 2022 in Tips and Tricks, Ubuntu
grep "session opened" /var/log/auth.log
cat /var/log/auth.log | grep "session opened"In order to display extra information about the failed SSH logins, issue the command as shown in the below example.
egrep "session opened|successful" /var/log/auth.log
