$dom = new DOMDocument();
$dom->loadHTML($data['description']);
$images = $dom->getElementsByTagName('img');
foreach ($images as $image) {
$old_src = $image->getAttribute('src');
$new_src = 'image/products/newimage.jpg';
$image->setAttribute('src', $new_src);
$image->setAttribute('data-src', $old_src);
}
$data['description'] = $dom->saveHTML();
PHP
Install LAMP (Linux Apache Mysql PHP) Web Server on Raspberry Pi
Install Apache
- Open a terminal window by selecting Accessories > Terminal from the menu.
- Install the
apache2package by typing the following command into the terminal and pressing Enter:
sudo apt-get install apache2 -yGo to your host name or ip for example mine is http://quepaso and apache
if you dont know your ip do – ip a on the terminal.
Install Apache
sudo apt-get install php -ycreate a php file to test
cd /var/www/clients/client2/web10/web
sudo nano index.php
<?php phpinfo(); ?>
sudo service apache2 restartInstall MariaDB
sudo apt-get install mariadb-server php-mysql -y
sudo mysql_secure_installationsudo service apache2 restartConfigure WordPress phpmailer settings
add_action( 'phpmailer_init', 'setup_phpmailer_init' );
function setup_phpmailer_init( PHPMailer $phpmailer ) {
$phpmailer->Host = 'HOSTNAME'; // for example, smtp.mailtrap.io
$phpmailer->Port = 587; // set the appropriate port: 465, 2525, etc.
$phpmailer->Username = 'YOURUSERNAME'; // your SMTP username
$phpmailer->Password = 'YOURPASSWORD'; // your SMTP password
$phpmailer->SMTPAuth = true;
$phpmailer->SMTPSecure = 'tls'; // preferable but optional
$phpmailer->IsSMTP();
}
Install Composer in Debian 10 Buster to Use with Ispconfig and Jailkit
You must have ispconfig installed and jailkit.
Install Composer – hash updated May 2, 2021
cd ~
php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
php -r "if (hash_file('sha384', 'composer-setup.php') === '756890a4488ce9024fc62c56153228907f1545c228516cbf63f885e036d37e9a59d27d63f46af1d4d07ee0f76181c7d3') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
php composer-setup.php --install-dir=/usr/local/bin --filename=composer
php -r "unlink('composer-setup.php');"
Add code to jailkit to use as shell user
Add to /etc/jailkit/jk_init.ini
[php] comment = the php interpreter and libraries executables = /usr/bin/php, /usr/bin/php7.3 directories = /usr/lib/php, /usr/share/php, /usr/share/php, /usr/share/php-geshi, /etc/php,/usr/share/zoneinfo, /etc/snmp, /usr/share/snmp includesections = env [env] comment = environment variables executables = /usr/bin/env [composer] comment = Dependency Manager for PHP executables = /usr/local/bin/composer #directories = /usr/share/composer includesections = php, uidbasics, netbasics
Once that is completed
Go to System – Server Config – Select Server you want jailkit on
add php and composer to Jailkit chroot app sections:
Install Composer in Debian 10 Buster
If you need to install composer in debian this is quick an easy to use globally. Works with Digitalocean as well as ispconfig.
Hash updated May 2, 2021
cd ~
php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
php -r "if (hash_file('sha384', 'composer-setup.php') === '756890a4488ce9024fc62c56153228907f1545c228516cbf63f885e036d37e9a59d27d63f46af1d4d07ee0f76181c7d3') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
php composer-setup.php --install-dir=/usr/local/bin --filename=composer
php -r "unlink('composer-setup.php');"
Ispconfig Jailkit php, composer, mysql, drush, composer, node, ruby, compass
Install components
Install Composer
sudo apt-get install composerInstall Node.js and NPM
sudo apt install nodejsInstall Ruby and Gem
sudo apt install ruby-fullInstall Compass
sudo gem install compassAfter you have installed the required libraries we need to update the commands in the jailkit init file.
sudo nano /etc/jailkit/jk_init.ini [php] comment = the php interpreter and libraries executables = /usr/bin/php,/usr/bin/php5.6,/usr/bin/php7.0,/usr/bin/php7.1 directories = /usr/lib/php, /usr/share/php, /usr/share/php5, /etc/php, /usr/share/php-geshi, /usr/share/zoneinfo, /etc/snmp, /usr/share/snmp includesections = env [env] comment = environment variables executables = /usr/bin/env [mysql-client] comment = mysql client executables = /usr/bin/mysql, /usr/bin/mysqldump paths = /usr/lib/libmysqlclient.so [drush] comment = drush (drupal command line) executables = /usr/local/bin/drush includesections = php, mysql-client, uidbasics, netbasics directories = /etc/ssl/certs, /usr/share/ca-certificates [composer] comment = composer executables = /usr/local/bin/composer includesections = php, uidbasics, netbasics [node] comment = NodeJS executables = /usr/bin/npm, /usr/bin/node, /usr/bin/nodejs directories = /usr/lib/node_modules [ruby] comment = Ruby executable = /usr/bin/ruby, /usr/bin/gem, /usr/bin/gem2.3 directories = /usr/lib/ruby, /usr/lib/x86_64-linux-gnu/ruby, /var/lib/gems, /usr/share/rubygems-integration [compass] comment = Compass executables = /usr/bin/compass includesections = ruby directories = /usr/share/compass
If user and site is created already
jk_init -c /etc/jailkit/jk_init.ini -f -k -j /var/www/clients/client1/web1 php node mysql-client drush
Go to system -> server config with ( php git composer node ruby compass )
Rewrite Express Engine Urls
<IfModule mod_rewrite.c>
# Enable Rewrite Engine
# ------------------------------
RewriteEngine On
RewriteBase /
# Redirect index.php Requests
# ------------------------------
RewriteCond %{THE_REQUEST} ^GET.*index\.php [NC]
RewriteCond %{THE_REQUEST} !/system/.*
RewriteRule (.*?)index\.php/*(.*) /$1$2 [R=301,L]
# Standard ExpressionEngine Rewrite
# ------------------------------
RewriteCond $1 !\.(css|js|gif|jpe?g|png) [NC]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /index.php/$1 [L]
</IfModule>Add Mysql Database Table Using WordPress Theme or Plugin (Works with multisite)
global $senormedia_jal_db_version;
$senormedia_jal_db_version = '1.0';
function senormedia_jal_install() {
global $wpdb;
global $senormedia_jal_db_version;
$table_name = $wpdb->prefix.'_subscriptions';
$charset_collate = $wpdb->get_charset_collate();
$sql = "CREATE TABLE $table_name (
subscribe_id int(11) NOT NULL auto_increment,
site_id varchar(500) NOT NULL,
email varchar(500) NOT NULL,
status varchar(256) NOT NULL,
url varchar(256) NOT NULL,
date timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (subscribe_id)
) $charset_collate;";
require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
$eeor = dbDelta( $sql );
add_option( 'senormedia_jal_db_version', $senormedia_jal_db_version );
}
register_activation_hook( __FILE__, 'senormedia_jal_install' );
function myplugin_update_db_check_senormedia() {
global $senormedia_jal_db_version;
if ( get_site_option( 'senormedia_jal_db_version' ) != $senormedia_jal_db_version ) {
senormedia_jal_install();
}
}
add_action( 'plugins_loaded', 'myplugin_update_db_check_senormedia' );
How to delete all unpublished commands on Drupal using sql
DELETE c, rcb, dcb
FROM
comment AS c
JOIN field_revision_comment_body AS rcb ON (c.cid = rcb.entity_id)
JOIN field_data_comment_body AS dcb ON (rcb.entity_id = dcb.entity_id)
WHERE
c. STATUS = 0
or
DELETE FROM field_data_comment_body USING field_data_comment_body JOIN comment ON comment.cid=field_data_comment_body.entity_id AND comment.status=0
DELETE FROM field_revision_comment_body USING field_revision_comment_body JOIN comment ON comment.cid=field_revision_comment_body.entity_id AND comment.status=0
DELETE FROM comment WHERE status=0