Voorbeeld code SQL
// switch boolean $sql = " UPDATE table SET boolcolumn = !boolcolumn WHERE id = ? "; $db->prepare($sql)->execute([$id]);
// update $sql = " UPDATE table SET name = ? WHERE id = ? "; $db->prepare($sql)->execute([$name, $id]);
// insert $sql = " INSERT INTO table (name,id) VALUES (?,?) "; $db->prepare($sql)->execute([$name, $id]);
// delete $sql = " DELETE FROM table WHERE id = ? "; $db->prepare($sql)->execute([$id]);
// get all rows without prepared statement
$stmt = $db->query(" SELECT id, name FROM table ");
foreach($stmt as $row){ echo $row['name']; }
// get single row with prepared statement
$stmt = $db->prepare(" SELECT name FROM table WHERE id = ? ");
$stmt->execute([$id]); $row = $stmt->fetch(PDO::FETCH_ASSOC);
// get all rows with prepared statement
$stmt = $db->prepare(" SELECT id, name FROM table WHERE id = ? "); $stmt->execute([$id]);
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){ echo $row['name']; }
// count rows $count = $db->query(" SELECT count(1) FROM table ")->fetchColumn();
// add all rows in array $numbers = $db->query(" SELECT name FROM table ")->fetchAll(PDO::FETCH_ASSOC);
// add all rows of single column in array $numbers = $db->query(" SELECT name FROM table ")->fetchAll(PDO::FETCH_COLUMN);
// get time difference in different formats $numbers = $db->query(" SELECT TIMESTAMPDIFF(timeformat,datetime_start,datetime_end)) AS diff FROM table ")->fetchAll(PDO::FETCH_COLUMN);
// get specific time format $numbers = $db->query(" SELECT YEAR|MONTH|DAY|HOUR|MINUTE|SECOND(datetime) AS time FROM table ")->fetchAll(PDO::FETCH_COLUMN);
Voorbeeld code PHP
// redirects <meta HTTP-EQUIV="REFRESH" content="0; url=https://www.metlichtgeschreven.nl/">
header("Refresh:0"); header("Refresh:0; url=page2.php"); header('Location: https://metlichtgeschreven.nl/'); header("Refresh:0; url=".$_SERVER['PHP_SELF']);
// datetime setlocale(LC_ALL, 'nl_NL'); date_default_timezone_set('Europe/Amsterdam');
$date_dutch = IntlDateFormatter::formatObject($datum_object,"EEEE dd MMMM y",'nl_NL');
$last_modified_to_datetime = (new DateTime('@'.filemtime($file)))->format('Y-m-d H:i:s');
$monday->setISODate($year,$week); $sunday->setISODate($year,$week)->modify('+7 days');
// filter array by value $fa_allowed = '*searchword*'; $filtered_array = array_filter($array,function($intern) use ($fa_allowed){ return fnmatch($fa_allowed,$intern); });
// filter array by key $fa_allowed = '*searchword*'; $filtered_array = array_filter($array,function($intern) use ($fa_allowed){ return fnmatch($fa_allowed,$intern); },ARRAY_FILTER_USE_KEY);
// match $result = match ($x){
$a, $b, $c => 5, // this match arm
$a => 5, $b => 5, $c => 5, // is equivalent to these three match arms:
};
// sorteer op kolom datum usort($array,function($a,$b){ $t1 = strtotime($a['datum']); $t2 = strtotime($b['datum']); return $t1 - $t2; });
Voorbeeld code JS
// loop Object.keys(object).forEach(function(key){ console.log(key + data[key]); })
// fetch post
let formData = new FormData(); formData.append('name','test');
Object.entries(postData).forEach(el => formData.append(el[0],el[1]));
let formData = new URLSearchParams(new FormData(formElement));
let query1 = fetch("test.php",{method: "POST", body: formData}).then(response => response.text()).then(function(data){
console.log(data); let dataJSON = JSON.parse(data);
});
// fetch get let query2 = fetch('?name=test').then(response => response.text()).then(function(data){
console.log(data); let dataJSON = JSON.parse(data);
});
Promise.all([query1,query2]).then( function(data){ console.log(data); });
// URL parameters const urlParams = new URLSearchParams(window.location.search);
urlParams.has('country'); urlParams.get('country'); urlParams.append('country','nl'));
// e-mail check emailString.match(/^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/);
// add event listener to multiple elements document.querySelectorAll('input[name=postcode_start],input[name=postcode_end]').forEach(el => el.addEventListener('input',getKm));
// remove all event listeners elem.replaceWith(elem.cloneNode(true));
// remove everything in element Array.from(elem.childNodes).forEach(el => el.remove());
// 'beforebegin' | 'afterbegin' | 'beforeend' | 'afterend' elem.insertAdjacentHTML('afterbegin','<div></div>');
// replace all accented characters String.normalize('NFD').replace(/[\u0300-\u036f]/g,"");
// remove all extra whitespaces String.replace(/\s+/g,' ');
// fire event
elem.dispatchEvent(new Event('event'));
// get child node index from parent node Array.prototype.indexOf.call(Children_of_parent,current_child)
// async pauze await new Promise(resolve => setTimeout(resolve, 200))