PHP Constants Containing Arrays? – Stack Overflow

by ⋅ Link

PHP Constants Containing Arrays? – Stack Overflow

You can also serialize your array and then put it into the constant:

# define constant, serialize array
define ("FRUITS", serialize (array ("apple", "cherry", "banana")));

# use it
$my_fruits = unserialize (FRUITS);

mysql – How to return multi-count of specific values – Stack Overflow

by ⋅ Link

mysql – How to return multi-count of specific values – Stack Overflow

예시)

SELECT SUM(CASE WHEN category = 0 THEN 1 ELSE 0 END) AS cat0count,
       SUM(CASE WHEN category = 1 THEN 1 ELSE 0 END) AS cat1count,
       SUM(CASE WHEN category = 2 THEN 1 ELSE 0 END) AS cat2count,
       SUM(CASE WHEN category = 3 THEN 1 ELSE 0 END) AS cat3count
    FROM YourTable

sql – How do I check if a column is empty or null in mysql – Stack Overflow

by ⋅ Link

sql – How do I check if a column is empty or null in mysql – Stack Overflow

This will select all rows where some_col is NULL or '' (empty string)

SELECT * FROM table WHERE some_col IS NULL OR some_col = '';

PHP Forms Validate E-mail and URL

by ⋅ Link

PHP Forms Validate E-mail and URL

PHP – Validate Name

The code below shows a simple way to check if the name field only contains letters and whitespace. If the value of the name field is not valid, then store an error message:

$name = test_input($_POST[“name”]);
if (!preg_match(“/^[a-zA-Z ]*$/”,$name))
  {
  $nameErr = “Only letters and white space allowed”; 
  }

NoteThe preg_match() function searches a string for pattern, returning true if the pattern exists, and false otherwise.

PHP – Validate E-mail

The code below shows a simple way to check if an e-mail address syntax is valid. If the e-mail address syntax is not valid, then store an error message:

$email = test_input($_POST[“email”]);
if (!preg_match(“/([w-]+@[w-]+.[w-]+)/”,$email))
  {
  $emailErr = “Invalid email format”; 
  }

PHP – Validate URL

The code below shows a way to check if a URL address syntax is valid (this regular expression also allows dashes in the URL). If the URL address syntax is not valid, then store an error message:

$website = test_input($_POST[“website”]);
if (!preg_match(“/b(?:(?:https?|ftp)://|www.)[-a-z0-9+&@#/%?=~_|!:,.;]*[-a-z0-9+&@#/%=~_|]/i”,$website))
  {
  $websiteErr = “Invalid URL”; 
  }

javascript 에서 php의 print_r() 이나 var_dump() 역활을 하는 함수

by ⋅ Link

function dump(obj) {
var out = “;
for (var i in obj) {
out += i + ”: “ + obj[i] + ”n";
}

alert(out);

// or, if you wanted to avoid alerts…

var pre = document.createElement(‘pre’);
pre.innerHTML = out;
document.body.appendChild(pre)
}