Akhilesh Darjee akhileshdarjee

## javascript useful functions and prototypes.js
// convert string to proper case
String.prototype.toProperCase = function () {
	return this.replace(/\w\S*/g, function(txt){return txt.charAt(0).toUpperCase() + txt.substr(1).toLowerCase();});
};

// convert string to snake case
String.prototype.toSnakeCase = function () {
	return this.replace(/(.)([A-Z])/g, "$1_$2").toLowerCase();
};

## scheduling mysql backups with laravel.php
To manually dump the database you can run the following one-liner code

mysqldump -u[user] -p[pass] [db] > [file_path]

But what if you want to automate the process, here are the steps:

1. Setup cron entry to your server
* * * * * php /path-to-your-project/artisan schedule:run >> /dev/null 2>&1

2. Create a command BackupDatabase by running the following code:

## use proxy in laravel
Use the following parameters in .env file:

HTTPS_PROXY={http/https://}PROXY_USER:PROXY_PWD@PROXY:PROXY_PORT
(Combination of Proxy Address:Proxy Password@Proxy Address with port, don’t include http/https)

PROXY=xxxxxx (Proxy Name)
PROXY_PORT=xxxx (Proxy Port)
PROXY_USER=xxxxxxxxx (Proxy User Name)
PROXY_PWD=xxxxxxxxx (Proxy User Password)
PROXY_TYPE=CURLPROXY_HTTP

## change public directory in laravel
1. Cut all the files and folders in public directory and paste it to root folder

2. Update the index.php as below:

<?php

/**
 * Laravel - A PHP Framework For Web Artisans
 *
 * @package  Laravel

## clean and correct way to call a request internally in laravel 5.php
// GET request
$request = Request::create(config('app.url') . '/your-url-here', 'GET');
$response = Route::dispatch($request);
return $response;

// POST request
$params = array(
    'product_code' => 'GYU16R',
    'qty' => '1',
    'price' => 660,

## access mysql remote access
mysql -u {user_name} -p -h {IP} -D {database_name}

Parameters:

user_name: MySQL user name on remote server
IP: IP Address of remote server
database_name: Name of the database on remote server

## how to fetch google news rss and filter with source.php
The output of Google News RSS is in XML format. Here is a sample Google News RSS XML output:

<rss xmlns:media="http://search.yahoo.com/mrss/" version="2.0">
    <channel>
        <generator>NFE/5.0</generator>
        <title>"Apple" - Google News</title>
        <link>
            https://news.google.com/search?q=apple
        </link>
        <language>en-IN</language>

## best way to apply bootstrap tooltip across the application.js
$("body").tooltip({
	selector: '[data-toggle="tooltip"]',
	trigger : 'hover'
});

// selector: This method helps to initialise tooltips and works even if tooltip is generated dynamically
// trigger: This will show tooltip only when the cursor is placed on the element.
// When clicked on any element or button, the tooltip stays intact even if the cursor if not placed on it.
// The 'trigger' method helps to solves this issue and show only when cursor is placed on the element

## always keep cursor horizontally and vertically center of the dragging object.js
$('body').find('.draggable').draggable({
	stack: ".draggable",
	helper: 'clone',
	start: function(event, ui) {
		$(this).draggable('instance').offset.click = {
			left: Math.floor(ui.helper.width() / 2),
			top: Math.floor(ui.helper.height() / 2)
		};

		ui.helper.css('cursor', 'move');

## laravel 5 manually create password reset record in db the laravel way.php
$token = app('auth.password.broker')->createToken(auth()->user());
OR
$token = app('auth.password.broker')->createToken($user);

$user must implement App\User
	// convert string to proper case
	String.prototype.toProperCase = function () {
	return this.replace(/\w\S*/g, function(txt){return txt.charAt(0).toUpperCase() + txt.substr(1).toLowerCase();});
	};

	// convert string to snake case
	String.prototype.toSnakeCase = function () {
	return this.replace(/(.)([A-Z])/g, "$1_$2").toLowerCase();
	};
	To manually dump the database you can run the following one-liner code

	mysqldump -u[user] -p[pass] [db] > [file_path]

	But what if you want to automate the process, here are the steps:

	1. Setup cron entry to your server
	* * * * * php /path-to-your-project/artisan schedule:run >> /dev/null 2>&1

	2. Create a command BackupDatabase by running the following code:
	Use the following parameters in .env file:

	HTTPS_PROXY={http/https://}PROXY_USER:PROXY_PWD@PROXY:PROXY_PORT
	(Combination of Proxy Address:Proxy Password@Proxy Address with port, don’t include http/https)

	PROXY=xxxxxx (Proxy Name)
	PROXY_PORT=xxxx (Proxy Port)
	PROXY_USER=xxxxxxxxx (Proxy User Name)
	PROXY_PWD=xxxxxxxxx (Proxy User Password)
	PROXY_TYPE=CURLPROXY_HTTP
	1. Cut all the files and folders in public directory and paste it to root folder

	2. Update the index.php as below:

	<?php

	/**
	* Laravel - A PHP Framework For Web Artisans
	*
	* @package Laravel
	// GET request
	$request = Request::create(config('app.url') . '/your-url-here', 'GET');
	$response = Route::dispatch($request);
	return $response;

	// POST request
	$params = array(
	'product_code' => 'GYU16R',
	'qty' => '1',
	'price' => 660,
	mysql -u {user_name} -p -h {IP} -D {database_name}

	Parameters:

	user_name: MySQL user name on remote server
	IP: IP Address of remote server
	database_name: Name of the database on remote server
	The output of Google News RSS is in XML format. Here is a sample Google News RSS XML output:

	<rss xmlns:media="http://search.yahoo.com/mrss/" version="2.0">
	<channel>
	<generator>NFE/5.0</generator>
	<title>"Apple" - Google News</title>
	<link>
	https://news.google.com/search?q=apple
	</link>
	<language>en-IN</language>
	$("body").tooltip({
	selector: '[data-toggle="tooltip"]',
	trigger : 'hover'
	});

	// selector: This method helps to initialise tooltips and works even if tooltip is generated dynamically
	// trigger: This will show tooltip only when the cursor is placed on the element.
	// When clicked on any element or button, the tooltip stays intact even if the cursor if not placed on it.
	// The 'trigger' method helps to solves this issue and show only when cursor is placed on the element
	$('body').find('.draggable').draggable({
	stack: ".draggable",
	helper: 'clone',
	start: function(event, ui) {
	$(this).draggable('instance').offset.click = {
	left: Math.floor(ui.helper.width() / 2),
	top: Math.floor(ui.helper.height() / 2)
	};

	ui.helper.css('cursor', 'move');
	$token = app('auth.password.broker')->createToken(auth()->user());
	OR
	$token = app('auth.password.broker')->createToken($user);

	$user must implement App\User