Paul's Programming Notes PostsRSSGithub

Google Maps Event Firing Order

I wanted to see the order Google Maps fires its events in. Google’s official Map Events example wires up listeners for the map’s events, so it’s a good starting point for seeing how they behave as you pan, zoom, and click.

Tunnel Traffic Through Webserver Using Your Browser

Use the following command in Cygwin (using your IP and Username, of course):

ssh yourUsername@198.168.xxx.xxx -D 2280 -i your/certificate

Set the following settings in Firefox (connect settings, under the advanced tab):

proxy settings

Easyphp Change Directory To Github

  1. Right click on the easyphp icon –> configuration –> apache (this should open the httpd.conf in your easyphp apache directory)

  2. Find the section labelled DocumentRootDirectory and overwrite with this:

# DocumentRootDirectory
<Directory "C:/Users/your_username/Documents/GitHub/your_project/">
    #
    # Possible values for the Options directive are "None", "All",
    # or any combination of:
    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
    #
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    #
    # The Options directive is both complicated and important.  Please see
    # http://httpd.apache.org/docs/2.4/mod/core.html#options
    # for more information.
    #
    Options Indexes FollowSymLinks Includes ExecCGI

    #
    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   Options FileInfo AuthConfig Limit
    #
    AllowOverride All

    #
    # Controls who can get stuff from this server.
    #
    Require all granted

</Directory>

Setting Up Github Windows Client Behind a Proxy

  1. Navigate to your git.exe directory (C:\Users\your_username\AppData\Local\GitHub\PortableGit~\bin)
  2. git config --global http.proxy http://username:password@host:port/
  3. git config --system http.sslcainfo /bin/curl-ca-bundle.crt
  4. Open the github client (it should work now)

move_uploaded_file To Current Path - PHP 

$uploadfile = './' . basename($_FILES['file']['name']);

if (move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile)) {
    echo "File was successfully uploaded.\n";
} else {
    echo "There was an issue uploading the file.\n";
}

View In Use and Will Not DROP - MySQL

I had several views in my MySQL database that were showing “In Use” and phpmyadmin would not let me drop them through the interface.

The solution:
Open the MySQL in terminal and “DROP VIEW yourView;”

Include Array From File - PHP

file.php

<?php
return array('item1','item2');
?>

Your php code:

<?php
$thisVariable = include('file.php');
print_r($thisVariable); //prints the array
?>

Don't Use Nested IFNULL, Use COALESCE - MySQL

If you’re looking for how to do a nested IFNULL, you probably need to be looking at how to use COALESCE instead. It returns the first non-null item in a list.

Example:

SELECT COALESCE(NULL,1);

Returns 1