How to Code

Quick Methods to Name Ranges
Method 1: Using the Name Box (Fastest)

1. Select the cells or range you want to name.
   
2. Click into the Name Box (the empty box just to the left of the formula bar).
   
3. Type a name (remember: no spaces or special characters are allowed; use underscores instead of spaces, like Total_Sales).
   
4. Press Enter to save the name.

$result=mysqli_query($connection,"SHOW GRANTS FOR CURRENT_USER");
if ($result) {
echo "

Privileges:

";
while ($row = $result->fetch_assoc()) {
echo "
• " . htmlspecialchars(current($row)) . "
";
}
echo "

";
$result->free();
} else {
echo "Error: " . $mysqli->error;
}
exit;

// Source - https://stackoverflow.com/q/53312997
// Posted by Tr?n V? Anh D?ng
// Retrieved 2026-07-10, License - CC BY-SA 4.0

$servername = "localhost";
$user = "admin";
$pass = "admin";
$dbname = "examples";

// Create connection
$conn = new mysqli($servername, $user, $pass, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$id = $_POST['id'];
$name = $_POST['name'];
$year = $_POST['year'];

$sql = "INSERT INTO cars (id, name, year)
VALUES ($id, $name, $year)";

if ($conn->query($sql) === TRUE) {
echo "T?o m?i th� nh công";
} else {
echo "L?i: " . $sql . "
" . $conn->error;
}

$conn->close();
?>

In VB.NET, if you have a TabControl and want to get the index of the currently selected tab, you can use the SelectedIndex property.
If you want the index of a specific TabPage, you can use the TabPages.IndexOf() method.

Example: Get Current Selected Tab Index
VbnetImports System.Windows.Forms

Public Class Form1
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
' Example: Add some tabs
TabControl1.TabPages.Add("Tab 1")
TabControl1.TabPages.Add("Tab 2")
TabControl1.TabPages.Add("Tab 3")
End Sub

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
' Get the index of the currently selected tab
Dim currentIndex As Integer = TabControl1.SelectedIndex
MessageBox.Show("Current Tab Index: " & currentIndex)
End Sub
End Class


Example: Get Index of a Specific TabPage
Vbnet' Suppose you have a reference to a TabPage
Dim myTab As TabPage = TabControl1.TabPages("Tab 2")
Dim index As Integer = TabControl1.TabPages.IndexOf(myTab)
MessageBox.Show("Index of 'Tab 2': " & index)

look up units
=IF(tank_sizeB<51,XLOOKUP(R3,convertA,convertG),IF(tank_sizeB<101,XLOOKUP(R3,convertA,convertE),XLOOKUP(R3,convertA,convertC)))

look up multiplier
=IF(tank_sizeB<51,XLOOKUP(I4,convertA,convertF),IF(tank_sizeB<101,XLOOKUP(I4,convertA,convertD),XLOOKUP(I4,convertA,convertB)))

=IF(tank_sizeB<51,XLOOKUP(R3, convertA,convertF),"")
=IF(tank_sizeB<51,XLOOKUP(R3,convertA,convertG),"")

A B C D E F G
Units convert units2 convert2 units3 convert3 units4
oz 128 gal 32 qt 1.00 oz
pt 8 gal 2 qt 1.00 pt
qt 4 gal 1 qt 1.00 qt
gal 1 gal 0.25 qt 1.00 gal
ozd 16 lbs 16 lbs 1.00 ozd
lbs 1 lbs 1 lbs 1.00 lbs_
feet 1 ft1 1 ft2 1.00 feet
zz 1 zz 1 zz 1 zz

//require_once($_SERVER['DOCUMENT_ROOT']."/activate75.php");

if($bypass!=true){
$appid="636390303046554890";
$user='softwax3_build99';$password='Web2Build.now';$database='softwax3_SoftwareUsers';
$connection = swd_mysql("localhost", $user,$password,$database);
//if($appid>"636390303046554897"){$qu=new mysqli_swd();}else{$qu=new dbase();}
$qu=new mysqli_swd();
$sql="SELECT lock_device,security_level FROM users WHERE device_name='".$_COOKIE["machine_id"]."'";
$qu->dbsql($sql);
if($qu->num==0 || $qu->data1[0]==1) { echo "You are locked out";exit; }
$_SESSION['LEVEL']=$qu->data1[1]; $LEVEL=$qu->data1[1];
define('SWD_AUTHENTICATE', true);define('SWD_KEY', 'JesusIsLord');
}
if($bypass==true){define('SWD_AUTHENTICATE', true);}

?>

Copy File

$source = 'uploads/document.pdf';
$destination = 'backup/document.pdf'; // Must include the filename

if (copy($source, $destination)) {
echo "File copied successfully!";
} else { echo "Failed to copy file."; }

Keeping the Same Filename Dynamically

If you have a path to a folder and want to keep the original file's name, combine copy() with basename() to extract the filename

$sourceFile = 'uploads/images/photo.jpg';
$targetDir = 'archive/';

// Safely joins the directory and the original file name
$destinationFile = $targetDir . basename($sourceFile);

if (copy($sourceFile, $destinationFile)) { echo "File copied to: " . $destinationFile; }

Copy Across Multiple Folders

[?php
$title="ledger View";
$appid="639016745369596833";$appidLast='';$bodyAppend='';
error_reporting( E_ERROR );
$folder_list=explode(",","accounting,ACCT,Bible/admin31,CODE,EMAIL,HAIRSHOPPE,invoice/admin31,iqofpost/admin31,MAP,scripture,WINTERBROS/admin31,WinterBrother/admin31");
foreach($folder_list as $k=>$value) {
$source = __DIR__ ."/".$value. '/configBKUP.php';
$destination = __DIR__ ."/".$value. '/config.php';
if (file_exists($source)) {
if (copy($source, $destination)) {
touch($destination); //echo "Config file restored successfully.";
} else { echo "copy problem ".$source; exit; }
} else { echo "file $source does not exist."; }
// look for htacess
$source = __DIR__ ."/".$value. '/.htaccessBKUP';
$destination = __DIR__ ."/".$value. '/.htaccess.php';
if (file_exists($source)) {
if (copy($source, $destination)) {
touch($destination); //echo "Config file restored successfully.";
} else { echo "copy problem ".$source; exit; }
} else { echo "file $source does not exist."; }

}
echo "It has run";
?]

Merge Many Files Into One

[?php
$file1 = 'destination.txt';
$file2 = 'source_to_merge.txt';

// Read the contents of the second file
$contents2 = file_get_contents($file2);

// Append it to the destination file
// FILE_APPEND prevents overwriting the existing data in destination.txt
file_put_contents($file1, $contents2, FILE_APPEND); ?]

Move Files

$old_path = 'images/photo.jpg';
$new_path = 'archive/photo.jpg';

// Ensure the target directory exists before moving
if (!is_dir('archive')) { mkdir('archive', 0755, true); }

// Move the file
if (rename($old_path, $new_path)) {
echo "File moved successfully.";
} else { echo "Failed to move the file."; }

To copy a file in PHP, you use the built-in
copy() function. This function takes the source file path and the destination path as arguments and returns true on success or false on failure.
Syntax
php

bool copy(string $source, string $destination, resource $context = null): bool

$source (Required): The path to the original file you want to copy.
$destination (Required): The path, including the new filename, where the file will be copied. If the destination file already exists, it will be overwritten.
$context (Optional): A context resource created with stream_context_create().

Example
Here is a basic example of how to copy a file and check the result:

=?php

// Specify the source file path
$source_file = 'path/to/original_file.txt';

// Specify the destination path, including the new filename
$destination_file = 'path/to/new_directory/copied_file.txt';

// Use the copy() function
if (copy($source_file, $destination_file)) {
echo "File copied successfully!";
} else {
echo "Something went wrong while copying the file. Check permissions.";
}

?=

---

Important Considerations

File Permissions: The PHP script must have permission to read the source file and write to the destination directory. Permission errors are a common reason for failure.
Destination Path: The destination must include the new filename, not just the directory name. For example, you need .../new_dir/copied.txt, not just .../new_dir/.
Error Handling: The copy() function returns a boolean, so it is important to use an if statement to handle potential errors gracefully.
Moving vs. Copying: If you want to move a file (delete the original after copying), use the rename() function instead.
Uploaded Files: For handling files uploaded via an HTML form (HTTP POST method), you must use the specialized move_uploaded_file() function, not copy().

PHP strrpos() Function

Example
Find the position of the last occurrence of "php" inside the string:

echo strrpos("I love php, I love php too!","php");
?>
Definition and Usage
The strrpos() function finds the position of the last occurrence of a string inside another string.

Note: The strrpos() function is case-sensitive.

Related functions:

strpos() - Finds the position of the first occurrence of a string inside another string (case-sensitive)
stripos() - Finds the position of the first occurrence of a string inside another string (case-insensitive)
strripos() - Finds the position of the last occurrence of a string inside another string (case-insensitive)
Syntax

// PHP 7.0 conversion Mysql

class mysqli_swd{
// global $wpdb;
var $num=0;
var $id=0;
var $fieldflags="";var $fieldlength=0;var $fieldname="";var $fieldtable;var $fieldtype="";
var $data; var $data1=array();
var $row=array();
var $fields=0;
var $insertoption="";
var $quickarray=true;

function multipleRecs($value){
if($value==true)$value=false;
else $value=true;
$this->quickarray=$value;return true;
}
function tableOption($query){
global $connection;
$q = mysqli_query($connection,$query); //mysql_query($query);
$num_fields = mysqli_num_fields($q);
for($ii = 0; $ii < $num_fields; $ii++) {
//$result.= mysql_field_name($query,$ii)."-".mysql_field_type($query,$ii)."(".mysql_field_len($query,$ii).")".mysql_field_flags($query,$ii)."n";
$fieldinfo=mysqli_field_flags($q,$ii);
if(strpos($fieldinfo,"rimary_key")>0){ $this->fieldname=mysql_field_name($q,$ii);break; }
}
}
function dbRow($result){
return mysqli_fetch_array($result,MYSQLI_BOTH); //,MYSQLI_BOTH
}
function dbTable($result,$k){
$table_info = mysqli_fetch_field_direct($result, $k); //print_r($table_info);echo"
";
$this->fieldlength = $table_info->max_length;
$this->fieldname = $table_info->name;
$this->fieldtable = $table_info->table;
$this->fieldtype = $table_info->type;
$this->fieldflag = $table_info->flags;
}
function dbsql2($query){
$this->insertoption=$query;
}
function dbsql($query){
global $db; global $dc;global $debug; global $appid; global $connection; global $wpdb;
// $result=mysqli_query($connection,$query); // or die(mysqli_error().' from '.$query); //;mysql_query($query)
$result=mysqli_query($wpdb->dbh,$query);
if(!$result){
echo "You definitely Botched the Output requirement";exit;
//echo $query;exit;
}
$sql= strtolower($query);
if(strpos($sql,"nsert into")==1)$AC=1;
if(strpos($sql,"elect")==1){ $AC=2;$this->num=mysqli_num_rows($result); }
if(strpos($sql,"pdate")==1 || strpos($sql,"elete")==1)$AC=3;
switch($AC){
case 1:
$this->id=mysqli_insert_id($connection);
break;
case 2:
if($this->num==0 && $this->insertoption!=""){ $this->dbq($this->insertoption); return false; }
if($this->num==0) return false;
if($appid!=""){
$this->data1=mysqli_fetch_array($result,MYSQLI_BOTH);mysqli_data_seek($result,0); //mysql_data_seek($result,0);
$this->data=$result;
}else{
if($this->num==1 && $this->quickarray==true)$this->data=mysqli_fetch_array($result,MYSQLI_BOTH); //mysql_fetch_array($result);
else $this->data=$result;
}
$this->fields = mysqli_num_fields($result);
return true;
break;
case 3:
return true;
break;
} // end switch
}

} // end class

function MovieCall($file){
$poster=str_replace(".mp4",".png",$file);
$var="";
//$var="";

return $var;
}
function sizepicture($picture,$maxwidth,$maxheight){
list($width, $height, $type, $attr) = getimagesize($picture);
if($width==0)$width=1;if($height==0)$height=1;
$size[2]=$width;$size[3]=$height;
$hratio=$height/$maxheight; $wratio=$width/$maxwidth;
if ($wratio>$hratio){
$ratio=$width/$height;
if($width>$maxwidth){
$height=(int)($maxwidth/$ratio);$width=$maxwidth;
}
}else{
$ratio=$height/$width;
if($height>$maxheight){
$width=(int)($maxheight/$ratio);$height=$maxheight;
}
}
$size[0]=$width;$size[1]=$height;
return $size;
}
function replaceForm($longadd){
$longadd=stripslashes($longadd);
$longadd=str_replace(chr(160),chr(32),$longadd);
$longadd=str_replace("'","'",$longadd);
$longadd=str_replace(chr(34),""",$longadd);
return $longadd;
}

function replacePunctuation($longadd){
$longadd=stripslashes($longadd);
$longadd=str_replace(chr(160),chr(32),$longadd);
return $longadd;
}
function radiochecked($var,$item){
if($var==$item) return "checked";
else return "";
}
function checkboxchecked($value){
if($value==1) return "checked";
else return "";
}
function checkhtml($var){
$var2=strip_tags($var);
if($var2!=$var){ echo "Mail Server Crashed";exit; }
if(strpos("|".$var,"http:")>0){ echo "Mail Server Crashed";exit; }
$var=addslashes($var);
return $var;
}
function stripDESC($var1){
$m=strpos($var1,'DESC');
if($m>0)$var1=substr($var1,0,$m-1);
return $var1;
}
function ShortenString($var1){
global $prn;
$var1=stripslashes($var1);
$var1=str_replace(chr(160)," ",$var1); $var1=str_replace(chr(32).chr(32),"  ",$var1);
$var1=str_replace(chr(13),'
',$var1);
if(strlen($var1)>100 && $prn==''){
// $var1=substr($var1,0,40).'....';
//$var1="";
}
//if($var1=='')$var1=' ';
return $var1;
}
function checkBlanks($value){
if($value!="")return "
".$value;
else return "";
}

function convertmdy($date1){
if($date1==""||$date1=="0000-00-00"){
$date1="";return date("m/d/y");
}
$new=strtotime($date1);
$date1= date('m/d/Y',$new);
return $date1;
}
function convertmdytime($date1){
if($date1==""||$date1=="0000-00-00"){
$date1="";return $date1;
}
$time=strtotime($date1);
$date1= date('m/d/Y H:i:s',$time);
return $date1;
}
function convertdate($date1){
if($date1=="") return date('Y-m-d');
$date1=str_replace("/","|",$date1); $date1=str_replace("-","|",$date1);
$time=explode("|",$date1);
if(strlen($time[0])==1) $time[0]="0".$time[0];
if(strlen($time[1])==1) $time[1]="0".$time[1];
$new=trim($time[2])."-".$time[0]."-".$time[1];
$date1= date('Y-m-d',strtotime($new));
return $date1;
}
function convertdatetime($date1){
if($date1=="") return date("Y-m-d H:i:s");
$date1= date('Y-m-d H:i:s',strtotime($date1));
return $date1;
}

function retrieveSettings($appid){
$bkup=array();
$savedSessions= json_decode(stripslashes($_COOKIE["SESSIONARRAY".$appid])); $savedPosts= json_decode(stripslashes($_COOKIE["POSTARRAY".$appid])); $savedGets= json_decode(stripslashes($_COOKIE["GETARRAY".$appid]));
if(gettype($savedSessions)=='array' || gettype($savedSessions)=='object'){
foreach($savedSessions as $k=>$value) {
if($value!="")$bkup[$k]=$value;
}
}
if(gettype($savedPosts)=='array' || gettype($savedPosts)=='object'){
foreach($savedPosts as $k=>$value) {
if($value!="")$bkup[$k]=$value;
}
}
if(gettype($savedGets)=='array' || gettype($savedGets)=='object'){
foreach($savedGets as $k=>$value) {
if($value!="")$bkup[$k]=$value;
}
}
return $bkup;
}
function checkValue($value1,$value2){
if($value1=="")$value1=$value2;
return $value1;
}
function comboResultSet($fieldidx,$fieldx,$tablex){
//global $r;global $appid; global $connection; global $wpdb;
$r=new mysqli_swd;
$settings=array(); $WHERE="";
if(function_exists("createConditions")){
$settings=createConditions($tablex);
if($settings[0]!="" )$WHERE=$settings[0];
if($settings[1]!="" )$fieldx=$settings[1];
}
$sql="SELECT $fieldidx,$fieldx FROM $tablex $WHERE ORDER BY $fieldx";//echo $sql;exit;
$r->dbsql($sql);
return $r->data;
}
function comboResultSet2($tablex,$fieldidx,$valuex){
$r=new mysqli_swd;//global $r;
$sql="SELECT * FROM $tablex WHERE $fieldidx = '$valuex'";$r->dbsql($sql);
return $r->data1;
}
function reportArray($result,$fieldxid,$fieldx){
$r=new mysqli_swd;
mysqli_data_seek($result,0);
For ($i=0; $i< mysqli_num_rows($result); $i++){
$row=$r->dbRow($result);
$xid=replacepunctuation($row["$fieldxid"]);
$x=replacepunctuation($row["$fieldx"]);
$createdArray[$xid]=$x;
}
return $createdArray;
}
function reportArray2($fieldx){
$rowtemp=explode(",",$fieldx[2]); $row=array();
foreach($rowtemp as $k=>$value) {
$row[$value]=$value;
}
return $row;
}
function reportCombo($result,$fieldxid,$fieldx,$selectx){
$r=new mysqli_swd;
mysqli_data_seek($result,0);
For ($i=0; $i< mysqli_num_rows($result); $i++){
$row=$r->dbRow($result);
$xid=replacepunctuation($row["$fieldxid"]);
$x=replacepunctuation($row["$fieldx"]);
if ($xid == $selectx){
$dis1 .= "$xn";
}
else{
$dis1 .= "$xn";
}
}
return $dis1;
}
function reportCombo2($result,$selectx){
foreach($result as $k=>$value) {
$tmp="";if ($value == $selectx){ $tmp="selected"; }
$dis1 .= "$valuen";
}
return $dis1;
}
function reportArrayToCombo($result,$selectx){
foreach($result as $k=>$value) {
if ($k == $selectx){
$dis1 .= "$valuen";
}
else{
$dis1 .= "$valuen";
}
}
return $dis1;
}
function CreateLinks($inx,$num,$range){
global $ALPHA; global $VIEW;global $txWhere;global $PDS_;
$SubCat="&PDS_=";if($PDS_>0)$SubCat="&PDS_=".$PDS_;
$ratio=(int)($num/$range);$start=1;$maxlinks=30;
if($ratio<$num/$range)$ratio+=1;
$end=$ratio;
if($ratio>$maxlinks){
$start=$inx/$range-$maxlinks/2;
if($start<1)$start=1;
$end=$start+$maxlinks;
if($end>$ratio){
$end=$ratio;$start=$end-$maxlinks;
}
}
for($i=$start;$i<=$end;$i++){
switch($VIEW){
case 2:
$submenu.="$i|";
break;
default:
$submenu.="$i|";
}
}
$dis1.=$submenu;
return $dis1;
}
define('MOVIE_DIRECTORY', '/wp-content/uploads/movies/');
$allowed_tags = array(
'video' => array(
'controls' => true,
'autoplay' => true,
'loop' => true,
'muted' => true,
'poster' => true,
'preload' => true,
'width' => true,
'height' => true
),
'source' => array(
'src' => true,
'type' => true
)
);
wp_kses( $video_html_from_db, $allowed_tags );
?>

AI Overview
WordPress knows you are logged in by storing hashed, secure cookies in your browser upon successful authentication. When you navigate to a new page, WordPress checks for the wordpress_logged_in_[hash] cookie to identify who you are, making it stateless rather than using server-side PHP sessions.

Authentication Cookie: After login, WordPress sets a wordpress_logged_in_[hash] cookie that lasts for a specific duration, storing your username and authentication details.
Verification: On every admin page request, WordPress checks wp-includes/pluggable.php (using wp_validate_auth_cookie) to verify this cookie, ensuring you are logged in.
Without Cookies: If cookies are disabled or expired, WordPress will not recognize you and will request login credentials again.
No Active Monitoring: By default, WordPress does not track active sessions in the database; it only validates the cookies sent by your browser. Plugins are required to see "who is online"

You can automatically number a column in Excel using the Fill Handle, Fill Series, or the ROW function to create a sequential numbering system easily.
Method 1: Using the Fill Handle
Enter Initial Numbers: In the first two cells of the column where you want to start numbering, enter the numbers 1 and 2 (or any starting numbers you prefer).
Select Cells: Highlight both cells containing the numbers.
Use the Fill Handle: Move your cursor to the bottom-right corner of the selection until you see a small plus sign (the Fill Handle).
Drag or Double-Click: Click and drag the Fill Handle down to fill the column with sequential numbers, or double-click it to auto-fill the column based on adjacent data.
2


2 Sources
Method 2: Using the Fill Series Option
Enter Starting Value: Type 1 in the first cell of the column.
Access Fill Options: Go to the Home tab, click on Fill, and select Series from the dropdown menu.
Configure Series: In the Series dialog box, choose Columns for Series in, set the Step Value to 1, and specify the Stop Value based on how many rows you want to number.
Click OK: This will fill the column with a sequential series of numbers.
2


2 Sources
Method 3: Using the ROW Function
Enter the Formula: In the first cell of the column, type the formula =ROW(A1) (adjust the cell reference based on your starting position). This will return the row number of the cell.
Drag the Fill Handle: Use the Fill Handle to drag the formula down the column. Each cell will display its corresponding row number, which updates automatically if rows are added or deleted.
2


2 Sources
Tips
Adjust Starting Point: If you want to start numbering from a different number, you can modify the formula accordingly (e.g., =ROW(A1)-4 to start from 1 in row 5).
Manual Updates: If you use the Fill Handle or Fill Series, remember that these numbers won't automatically update if you add or remove rows; you may need to redo the process to maintain accuracy.
1

By following these methods, you can efficiently auto-number columns in Excel to keep your data organized and easily readable.

Move saved locations to a new computer
You can move locations you've saved in Google Earth to a different computer. Saved locations are called placemarks, and they're automatically saved to your computer.

Step 1: Find location file
Windows
Press Ctrl + Esc + r or Windows key + r.
. In the "Open" box, enter "%USERPROFILE%AppDataLocalLowGoogleGoogleEarth".
If you're using Windows XP, enter "%USERPROFILE%Application DataGoogleGoogleEarth" instead.
Select OK.
In the directory, you'll see a file called "myplaces.kml". This file has your saved locations.
Note: If you want to replace a corrupted myplaces.kml file, use "myplaces.backup.kml."
Mac
Open the Finder.
At the top of the screen, click Go. Hold down Option or Alt, then click Library and then Application support and then Google Earth.
You'll see a file called "myplaces.kml". This file has your saved locations.
Note: If you want to replace a corrupted myplaces.kml file, use "myplaces.backup.kml."
Step 2: Move location file
There are a few ways you can transfer the file with your saved locations to another computer:

Save the file in Google Drive
Email the file to yourself
Save the file to a USB drive
Tip: Back up your myplaces.kml file to a removable device, like USB drive.

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Button2_Click(Sender, e)
End Sub

BTbulkMove_Click(sender As Object, e As EventArgs) translates to BTbulkMove_Click(sender, e)

BTtest_Click(sender As Object, e As EventArgs) translates to BTtest_Click(sender, e)

Control panel
Date And time
Button Change date and time
Link "Change calendar settings
Select "English United states"