This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
onny:notizen:programmierung [2022/03/10 17:30] – [wordpress] 185.52.247.41 | onny:notizen:programmierung [2023/02/25 15:12] – 10.100.0.1 | ||
---|---|---|---|
Line 176: | Line 176: | ||
</ | </ | ||
===== javascript ===== | ===== javascript ===== | ||
+ | |||
split up javascript files | split up javascript files | ||
+ | |||
<code javascript> | <code javascript> | ||
var MODULE = (function (my) { | var MODULE = (function (my) { | ||
Line 192: | Line 194: | ||
}(MODULE || {})); | }(MODULE || {})); | ||
</ | </ | ||
- | jquery select by attribute content | + | |
+ | on document ready | ||
<code javascript> | <code javascript> | ||
- | $( "tr[data-id=' | + | document.addEventListener("DOMContentLoaded", function() { |
- | </ | + | |
- | jquery select dynamicly loaded ajax elements | + | |
- | <code javascript> | + | |
- | $(' | + | |
- | | + | |
- | load_page(link); | + | |
}); | }); | ||
+ | |||
</ | </ | ||
- | jquery set background color | + | |
- | <code javascript> | + | change content text |
- | $(this).parent().css(" | + | |
- | </ | + | |
- | print mixed objects | + | |
- | <code javascript> | + | |
- | console.log(' | + | |
- | </ | + | |
- | javascript document ready | + | |
- | <code javascript> | + | |
- | $(document).ready(function(){ | + | |
- | console.log(' | + | |
- | }); | + | |
- | </ | + | |
- | vanilla js change content text | + | |
<code javascript> | <code javascript> | ||
var webgl_field = document.getElementById(' | var webgl_field = document.getElementById(' | ||
Line 226: | Line 214: | ||
} | } | ||
</ | </ | ||
- | vanilla js ajax post form | + | |
+ | ajax post form | ||
<code javascript> | <code javascript> | ||
document.getElementById(' | document.getElementById(' | ||
Line 244: | Line 234: | ||
} | } | ||
</ | </ | ||
- | vanilla js change style element | + | |
+ | change style element | ||
<code javascript> | <code javascript> | ||
function show_create_post() { | function show_create_post() { | ||
Line 257: | Line 249: | ||
trim string to max length | trim string to max length | ||
+ | |||
<code javascript> | <code javascript> | ||
var string = string.substring(0, | var string = string.substring(0, | ||
</ | </ | ||
- | vanilla js onclick class element | + | onclick class element |
<code javascript> | <code javascript> | ||
document.getElementsByClassName(' | document.getElementsByClassName(' | ||
Line 268: | Line 262: | ||
</ | </ | ||
- | add / remove class | + | onclick on all class elements |
+ | |||
+ | <code javascript> | ||
+ | # old: var anchors = document.getElementsByClassName(' | ||
+ | let allCheckBox = document.querySelectorAll(' | ||
+ | |||
+ | allCheckBox.forEach((checkbox) => { | ||
+ | checkbox.addEventListener(' | ||
+ | if (event.target.checked) { | ||
+ | console.log(event.target.value) | ||
+ | } | ||
+ | }) | ||
+ | }) | ||
+ | </code> | ||
+ | |||
+ | remove class from element | ||
+ | |||
+ | <code javascript> | ||
+ | var element = document.getElementsByClassName(' | ||
+ | element.classList.remove(" | ||
+ | </ | ||
+ | |||
+ | get url and pathname | ||
+ | |||
+ | <code javascript> | ||
+ | console.log(window.location.url) | ||
+ | console.log(window.location.pathname) | ||
+ | </ | ||
+ | |||
+ | querySelector | ||
+ | |||
+ | <code javascript> | ||
+ | var multicolumnHeadline = document.querySelector(' | ||
+ | </ | ||
+ | |||
+ | querySelectorAll | ||
<code javascript> | <code javascript> | ||
- | burgerMenu.classList.remove('is-active'); | + | var productAccordion = document.querySelectorAll('div.product__accordion'); |
- | burgerMenu.classList.add(' | + | productAccordion[1].style.display = " |
</ | </ | ||
==== vuejs ==== | ==== vuejs ==== | ||
Line 709: | Line 739: | ||
</ | </ | ||
- | print setting text inside template | + | add custom javascript js |
- | <code php> | + | |
- | <?php echo get_option(' | + | |
- | </ | + | |
- | customizer color chooser | ||
<code php> | <code php> | ||
- | function | + | function |
- | + | | |
- | | + | |
- | ' | + | |
- | ' | + | |
- | | + | |
- | + | ||
- | $wp_customize-> | + | |
- | $wp_customize, | + | |
- | ' | + | |
- | ' | + | |
- | ) ) ); | + | |
- | + | ||
- | }; | + | |
- | + | ||
- | function fachwerksauna_customize_css() | + | |
- | { | + | |
- | $theme_color = get_theme_mod(' | + | |
- | ?> | + | |
- | < | + | |
- | :root { | + | |
- | --themeColor: | + | |
- | } | + | |
- | </ | + | |
- | <?php | + | |
} | } | ||
- | add_action( 'wp_head', 'fachwerksauna_customize_css'); | + | add_action( 'wp_enqueue_scripts', 'twentytwentytwo_enqueue_custom_js' ); |
</ | </ | ||
===== sql ===== | ===== sql ===== | ||
Line 779: | Line 782: | ||
==== mysql ==== | ==== mysql ==== | ||
- | |||
- | Dump database | ||
- | <code bash> | ||
- | mysqldump -u root -p Tutorials > tut_backup.sql | ||
- | </ | ||
- | |||
- | Backup everything | ||
- | <code bash> | ||
- | mysqldump -u root -p --all-databases > alldb.sql | ||
- | </ | ||
- | |||
- | Import database | ||
- | < | ||
- | mysql> CREATE DATABASE wordpress; | ||
- | sudo mysql -u root wordpress < wordpress.sql | ||
- | </ | ||
- | |||
- | Setup | ||
- | <code bash> | ||
- | systemctl stop mysqld | ||
- | mysql_install_db --user=mysql --basedir=/ | ||
- | systemctl start mysqld | ||
- | mysql_secure_installation | ||
- | </ | ||
delete specific row | delete specific row | ||
Line 814: | Line 793: | ||
</ | </ | ||
- | ==== postgresql ==== | + | adjust permissions to table |
- | + | < | |
- | drop database | + | CREATE USER ' |
- | < | + | GRANT ALL PRIVILEGES ON ninja.* TO ' |
- | sudo -u postgres -i | + | GRANT ALL PRIVILEGES ON ninja.* TO ' |
- | dropdb onlyoffice | + | FLUSH PRIVILEGES; |
</ | </ | ||
- | list databases | + | update statement |
- | < | + | |
- | psql# \l | + | |
- | </ | + | |
- | dump database | + | < |
- | < | + | UPDATE wp_options SET option_value = ' |
- | pg_dump -U gitlab gitlabhq_production > /tmp/gitlab.pgsql | + | |
</ | </ | ||
- | dump all | ||
- | < | ||
- | pg_dumpall > / | ||
- | </ | ||
- | |||
- | import database | ||
- | < | ||
- | psql# CREATE DATABASE gitlabhq_production; | ||
- | psql -U gitlab gitlabhq_production < gitlab.pgsql | ||
- | </ | ||
- | |||
- | create and delete user | ||
- | < | ||
- | DROP ROLE gitlab; | ||
- | CREATE USER gitlab WITH PASSWORD ' | ||
- | </ | ||
- | |||
- | grant permissions | ||
- | < | ||
- | ALTER USER gitlab SUPERUSER; | ||
- | CREATE DATABASE gitlabhq_production OWNER gitlab; | ||
- | ALTER DATABASE gitlabhq_production OWNER TO gitlab; | ||
- | </ |