SQL Coding Standards

A Sample of My Coding Functions, for Quick Reference.Updated 1 year ago

Coding and Naming Standards:

On every project I've worked on, people have discussed coding & Naming Standards, but we always eventually realize that nobody has written these things down. So I have started these proposed standards:

Names: like_this
ID: Must be (INT) Named like: table_id

Coding Analogies

Variable- Cooking ingredient
Switch - Train switching station. or a choose your own adventure
If - For in the road
Break - Exit out of current Loop
Exit (or Die)- Quit IMMEDIATELY, and print something to the screen

Regex GEdit:

Delete every other line.

([^\n]*\n)[^\n]*\n

Regex tester for Search AND Replace:

RegExe.com

Make all Links open in a New Window jquery.

SQL Queries

Count all Table Rows

SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = "adamwith_main";

Hwo to assign an array to two variables

I always forget :P
list($first, $second)=array(1,2);

Geo IP Location:

You are in: Columbus, United States

My Commonly Used Functions:

addorremovebitmapperm

cleanfordatabasefield

cleanforshorturl

cleanfortitle

cleanupmultifilearray

createslideshowquickthumbnaildirectories

findpicfromanyextension

getcollageandimagemap

getcollageimg

getcurrencyrates

getcurrentquerystring

getimagefromandsaveto

getscriptnamewithoutparams

getthumbnailoffilesin

imagecolorallocatebyname

imagettfstroketext

in_arrayresursive

incrementfilenameifexists

isprivatecookieloggedin

returnshortenedstring

subtractyearfrommovie

View Function: printbreadcrumb

function printBreadCrumb()
{
  if (isset($_GET)) {

    if (!isset($_GET['p'])) {
      $_GET['p'] = 'dashboard';
    }

    $bcArray = $_GET;
    unset($bcArray['cmd']);
    $count = count($_GET);
    $output = '';
    $c = 0;
    foreach ($bcArray as $key => $val) {
      if ($c < $count) {

        if ($key == 'p') {
          $key = '

';
          $val = 'Loaded Page: ?p=' . $val;
        } else {

          //$key = $sep.$key.$sep;
          $key = '&' . $key . '=';
          $val = $val;

        }
        $output .= $key . $val;
      }
      $c++;
    }
    $output .= '

';

  } else {
    $output = '';
  }
  return $output;
}
***Declared In:/home4/adamwith/public_html/includes/functions/fw_htmlOutput.php

Add a hyphen to lists when Copying & Pasting

const prependChar = "-";
document.addEventListener("copy", function(e) {
const selected = getSelectionHtml();
if (selected.html.includes("")) {
const ul = selected.container.querySelectorAll("li");
Array.from(ul).forEach(c => {
if (c.tagName === "LI") {
c.innerText = prependChar + " $$$ " + c.innerText;
}
});
// Remove unwanted whitespace
const html = selected.container.innerHTML.replace(/(^|>)[ \n\t]+/g, ">\n"); 
const list = `${html}`;
const wrap = document.createElement("div");
wrap.innerHTML = list;
e.clipboardData.setData("text/plain", wrap.textContent);
e.clipboardData.setData("text/html", list);
e.preventDefault();
}
});
function getSelectionHtml() {
let html = "";
let container;
if (typeof window.getSelection !== "undefined") {
const sel = window.getSelection();
if (sel.rangeCount) {
container = document.createElement("div");
for (let i = 0, len = sel.rangeCount; i < len; ++i) {
container.appendChild(sel.getRangeAt(i).cloneContents());
}
html = container.innerHTML;
}
} else if (typeof document.selection !== "undefined") {
if (document.selection.type === "Text") {
html = document.selection.createRange().htmlText;
}
}
return { html, container };
}