nd3w

How to Disable SLiMS v9.6.1 Member Section (Redirect to Home)

Backup your SLiMS directory first.

File /template/default/index_template.inc.php

Line number 42, change:

include 'parts/_member.php';

List databases:

\l

Use a database:

\c db_name

Use schema other than default 'public':

Move a window to another workspace

Press Ctrl+Alt+Shift Left or Ctrl+Alt+Shift Right

Move a window to another monitor

Press Super+Shift Left or Super-Shift Right

Move active window around on the desktop

Search and Replace

Search and replace PHP variable in if control structure using regex:

if \(isset\(\$([a-zA-Z_]+)\)\) \{

Replace pattern

if (isset($$$1) AND $$$1 !== '') {

Install Apache2, PostgreSQL and PHP-FPM 8.2 on Ubuntu 20.04

Install Apache

sudo apt install apache2

sudo ufw app list

sudo ufw allow in "Apache"

Calculate average value from B2 to B32 with B24 to B32 are blanks:

=SUM(B2:B32)/(ROWS(B2:B32)-COUNTBLANK(B2:B32))

or simply:

=AVERAGE(B2:B32)

<input type="submit" name="value(submit)" value="Continue" onDblClick="fncDoubleOut();">
<input type="button" name="value(submit)" value="Cancel" onclick="cancel_onclick();" onDblClick="fncDoubleOut();">

function fncDoubleOut(){
   alert('Your transaction is being processed. Thank you.');
   return false;
}

To export data from MySQL to Excel using phpSpreadsheet, you can follow the steps below:

Connect to the MySQL database using PHP.

    $servername = "localhost";
    $username = "yourusername";
    $password = "yourpassword";
    $dbname = "yourdbname";

    // Create connection

Install a Laravel App into a Shared Hosting per OpenAI

When I asked ChatGPT how do I deploy a Laravel app into a shared hosting, here's its answer:

Here are the general steps to follow in order to install a Laravel application into a shared hosting:

Prepare the Laravel Application: First, you need to prepare your Laravel application for deployment by running the following commands in your terminal:

composer install --optimize-autoloader --no-dev

	#!/bin/bash
	#convert
	for image in *.png; do
	convert "$image" -quality 80 "${image%.png}.jpg"
	echo “$image converted to ${image%.png}.jpg ”
	done
	exit 0