epok07

SELECT
  professors.`name`,
	SUM(profs.professors.`salary`) AS salary #, count(profs.students.`name`) as "student count"  
FROM
	professors,
	students
CROSS JOIN courses
WHERE
	professors.`name` = prof_name
AND students.`name` = stud_name

epok07

I use the first

—– BEGIN LICENSE —–
TwitterInc
200 User License
EA7E-890007
1D77F72E 390CDD93 4DCBA022 FAF60790
61AA12C0 A37081C5 D0316412 4584D136
94D7F7D4 95BC8C1C 527DA828 560BB037
D1EDDD8C AE7B379F 50C9D69D B35179EF

epok07

<?php 
#seeding data

namespace Fuel\Tasks;

class Seed 
{
	public static function run()
	{
		$projects = array("Example Project Title"=>"Example Project description that descripting nothing...",

epok07

echo "Hello Franck! \n\r";
$url = 'https://newsapi.org/v2/top-headlines?' .
        'country=us&' .
        //'source=techcrunch&' .
        'apiKey=b714f12698014cf4aac6cd930ab5ffae';
        
$topnews = ( json_decode(file_get_contents($url)) );

$json_string = json_encode($topnews, JSON_PRETTY_PRINT);

epok07

module.exports = {
  "globDirectory": "build/",
  "globPatterns": [
    "**/*.{css,html,js}"
  ],
  "swDest": "build/sw.js",
  "swSrc": "src-sw.js"
};

epok07

Source

Get the first Monday of a month (and more)

This is a small cheat sheet for PHP's strtotime function, which can be used to convert textual sentences such as "next Friday" and "last Monday" into UNIX timestamps and formatted dates.

In the examples below, I've used the format "j, d-M-Y", which will give you something like: Monday, 17-Aug-2015. You can change this to your format of choice

epok07

#!/bin/sh
## backup each mysql db into a different file, rather than one big file
## as with --all-databases. This will make restores easier.
## To backup a single database simply add the db name as a parameter (or multiple dbs)
 
## Putting the script in /var/backups/mysql seems sensible... on a debian machine that is
## Create the user and directories
# mkdir -p /var/backups/mysql/databases
# useradd --home-dir /var/backups/mysql --gid backup --no-create-home mysql-backup
## Remember to make the script executable, and unreadable by others

epok07

Make Offline Mirror of a Site using wget https://www.guyrutenberg.com/2014/05/02/make-offline-mirror-of-a-site-using-wget/

Sometimes you want to create an offline copy of a site that you can take and view even without internet access. Using wget you can make such copy easily:

wget --mirror --convert-links --adjust-extension --page-requisites 
--no-parent http://example.org

epok07

L_PREFER_CANVAS = true;

leafletData.getMap().then(function(map) {

          leafletImage(map, function(err, canvas) {
            var img = document.createElement('img');
            var dimensions = map.getSize();
            img.width = dimensions.x;
            img.height = dimensions.y;
            img.src = canvas.toDataURL();