Mahmoud Saad hoodasaad

## List.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                hoodasaad
                / List.md
            
            
              Created
              January 2, 2020 11:52
                — forked from msurguy/List.md
            
              
                List of open source projects made with Laravel
              
          
    Other people's projects:

https://github.com/laracasts/URL-Shortener URL Shortener by Jeffrey Way
https://github.com/basco-johnkevin/laravelsnippets Source code of http://laravelsnippets.com website
https://github.com/jesseterry/FusionInvoice FusionInvoice is built for freelancers and small businesses who need a simple, yet powerful self-hosted web based invoicing system.
https://github.com/ezynda3/burnmsg is a self-destructing encrypted message app. A demo is also running on https://burnmsg.com
https://github.com/martindilling/auto-generating-gallery the demo is at http://gallerydemo.martindilling.com/

My projects (tutorials are on my blog at http://maxoffsky.com):

https://github.com/CodepadME/laravel-tricks - Source of Laravel-tricks.com


## Mysql -> Count From Big Table.txt
SELECT `AUTO_INCREMENT` as 'count' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'mahmouda_million' AND TABLE_NAME = 'member'

## best
SELECT uuid() AS 'rvkey' FROM `{$prefix}visit` WHERE 'rvkey' NOT IN (SELECT `vkey` FROM `{$prefix}visit`) LIMIT 1

## Laravel Multiple Counts with multiple joins
$prefix = Config::get('database.connections.mysql.prefix');
 $posts = App\Post::select(
      'post.title'
      ,'post.pskey'
      ,'post.phone'
      ,'post.show_map'
      ,'post.publish_at'
      ,'city.city'
      ,'city_alias.alias as city_alias'
      ,'post_alias.alias'

## Cron Run Php File without link
 /usr/bin/php -q /home/cpanelHost/FileName.php key=MahmoudSaad_WWW.msa3d.COM_m4saad@gmail.com secret=70caFdvdf73c5ced644f8a393ca0d188d6180cc0c app=4f0d56d0f37bb9ad351ff4re3er3faab1530b > /dev/null 2>&1

## How To Get $_GET in Javascript
var $_GET = {};

document.location.search.replace(/\??(?:([^=]+)=([^&]*)&?)/g, function () {
    function decode(s) {
        return decodeURIComponent(s.split("+").join(" "));
    }

    $_GET[decode(arguments[1])] = decode(arguments[2]);
});
	$prefix = Config::get('database.connections.mysql.prefix');
	$posts = App\Post::select(
	'post.title'
	,'post.pskey'
	,'post.phone'
	,'post.show_map'
	,'post.publish_at'
	,'city.city'
	,'city_alias.alias as city_alias'
	,'post_alias.alias'
	var $_GET = {};

	document.location.search.replace(/\??(?:([^=]+)=([^&]*)&?)/g, function () {
	function decode(s) {
	return decodeURIComponent(s.split("+").join(" "));
	}

	$_GET[decode(arguments[1])] = decode(arguments[2]);
	});