information technology
Changing the collation for a table will only set the collation for the next column that’s added. To change all of the existing columns to the new collation :
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ALTER DATABASE dbname COLLATE utf8_general_ci
Automatic background updates were introduced in WordPress 3.7 in an effort to promote better security, and to streamline the update experience overall. By default, only minor releases – such as for maintenance and security purposes – and translation file updates are enabled on most sites. In special cases, plugins and themes may be updated.
Read moreConfiguring Automatic Background Updates – WordPress
Open terminal:
curl -I https://www.apple.com
This command via terminal removes old simulators Xcode no longer use:
$ xcrun simctl delete unavailable
.carousel-control.right
# view hero-carousel.bloc# https://forum.blocsapp.com/t/automatically-changing-background-of-a-page/1313/7
.hero-carousel { margin-bottom: -100px; }
I’ve just added the navigation bloc above fullscreen carousel, and used negative margin custom class to hide this nav bloc behind carousel.
1. disable FTP commands from config.php
2. add to config.php
// Update core define( 'WP_AUTO_UPDATE_CORE', true );
optionally for Synology NAS
# reset chown for Synology user nobody
chown -R nobody:nobody /web/wordpress/dir
# reset files and folders chmod in /web/wordpress/dir
find . -type f -exec chmod 0644 {} \;
find . -type d -exec chmod 0755 {} \;Edit this file:
xcrud/themes/your_theme/xcrud_list_view.php
SQL injection is a technique where malicious users can inject SQL commands into an SQL statement, via web page input.
Injected SQL commands can alter SQL statement and compromise the security of a web application.
SQL Injection Based on 1=1 is Always True
Look at the example above, one more time.
Let’s say that the original purpose of the code was to create an SQL statement to select a user with a given user id.
If there is nothing to prevent a user from entering “wrong” input, the user can enter some “smart” input like this:
UserId:
PHP functions
The function
//Blind SQL-INJECTION Escape sequence. Line codes anti SQL-Injection
function anti_injection($input){
$clean=strip_tags(addslashes(trim($input)));
$clean=str_replace('"','\"',$clean);
$clean=str_replace(';','\;',$clean);
$clean=str_replace('--','\--',$clean);
$clean=str_replace('+','\+',$clean);
$clean=str_replace('(','\(',$clean);
$clean=str_replace(')','\)',$clean);
$clean=str_replace('=','\=',$clean);
$clean=str_replace('>','\>',$clean);
$clean=str_replace('<','\<',$clean);
return $clean;
}
How to use
$id=$_GET['id']; $id_clean=anti_injection($id);