Snippets Sandbox

if (session_status() == PHP_SESSION_NONE) {
    session_start();
}

#[MyAttribute]
class MyClass {}

$reflection = new ReflectionClass(MyClass::class);
$attributes = $reflection->getAttributes();

$array = ['a' => 1, 'b' => 2];
$json = json_encode($array);
$arrayAgain = json_decode($json, true);

class A {
    public static function who() {
        echo static::class;
    }
}
class B extends A {}

B::who();  // Outputs "B"

ob_start();           // Start buffering
echo "Hello, ";
$output = ob_get_clean(); // Fetch the buffer contents and stop buffering

list($a, $b, $c) = [1, 2, 3];
echo $a; // 1

function sum(...$numbers) {
    return array_sum($numbers);
}
echo sum(1, 2, 3, 4, 5);  // Outputs 15

use MyNamespace\{
    ClassA, 
    ClassB, 
    ClassC as C
};

function getRange($start, $end) {
    for ($i = $start; $i <= $end; $i++) {
        yield $i;
    }
}

usort($array, function ($a, $b) {
    return $a <=> $b;
});

$username = $_GET['username'] ?? 'Guest'; 
// If $_GET['username'] is set and non-null, $username will get its value. Otherwise, 'Guest'.

$data = ['first', 'second'];
[$first, $second] = $data;
echo $first; // Outputs 'first'

$object = new class {
    public function sayHello() {
        return "Hello!";
    }
};
echo $object->sayHello(); // Prints "Hello!"

function redirect ( $url, $message ) {
    echo "<script type='text/javascript'>
            alert( '".$message."' );
            window.location.href='".$url."';
            </script>";
}

function convert_to_tagalog($month) {
    $months = [
        'January'   => 'Enero',
        'February'  => 'Pebrero',
        'March'     => 'Marso',
        'April'     => 'Abril',
        'May'       => 'Mayo',
        'June'      => 'Hunyo',
        'July'      => 'Hulyo',
        'August'    => 'Agosto',
        'September' => 'Setyembre',
        'October'   => 'Oktubre',
        'November'  => 'Nobyembre',
        'December'  => 'Disyembre'
    ];

    return array_key_exists ( $month, $months ) ? $months[$month] : $month;
}

<?php

include('db.php'); // YOUR DATABASE CREDENTIALS
/* include('debug.php'); */

$result = mysqli_query( $con, "SELECT * FROM `YOUR_TABLE`" );

if ( ! $result ) { die( 'Error: ' . mysqli_error( $con ) ); }

$fp = fopen( 'import_householders.csv', 'w' ); // write mode

// Get the column names
$field_info_all = mysqli_fetch_fields( $result );
foreach( $field_info_all as $field_info ) {
  $headers[] = $field_info->name;
}

// Output the column names as the first row
fputcsv( $fp, $headers );

// Output the rest of the rows
while ( $row = mysqli_fetch_assoc( $result ) ) { 
  // OPTIONAL: Change the value of the first column to an empty string
  // $row[$headers[0]] = '';
  
  // Write it now as CSV
  fputcsv( $fp, $row );
}

// Close the file and the database connection
fclose( $fp );
mysqli_close( $con );

// This sets the content type of the file as "text/csv" browser knows 
// that it's a CSV file and can handle it accordingly.
header( 'Content-Type: text/csv' );

// This sets the filename that will be used when the file is downloaded. 
// It also sets the Content-Disposition as "attachment" so that the browser 
// prompts the user to download the file instead of displaying it in the browser.
header( 'Content-Disposition: attachment; filename="import_householders.csv"' );

// This tells the browser not to cache the file, 
// so that it will always be the latest version.
header( 'Pragma: no-cache' );

// This sets the expiration date of the file to 0, so that the browser 
// will always check if a new version is available.
header( 'Expires: 0' );

// This reads the CSV file and sends its contents to the browser.
readfile( 'import_householders.csv' );
?>

<?php
function geocode($address) {
    // Map API needs '+' in place of spaces
    $key = /*Use your Google API Key!*/
    $address = str_replace (" ", "+", urlencode($address));
    $url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . $address . '&key=' . $key; 

    // Use curl instead of file_get_contents
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    $unparsed_json = curl_exec($ch);
    curl_close($ch);

    $result = json_decode($unparsed_json, true);

    // Extract only the necessary data
    $location = $result['results'][0]['geometry']['location'];
    $formatted_address = $result['results'][0]['formatted_address'];
    $building_type = $result['results'][0]['types'][0];

    $gps = array (
        'latitude'      => $location['lat'],
        'longitude'     => $location['lng'],
        'full_address'  => $formatted_address,
        'building_type' => $building_type
    ); 

    return $gps;
}
?>

<?php
    ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);
?>

$sql = 'SELECT COUNT(*) FROM your_table'; 
$total_pages = $con->query($sql)->fetch_row()[0];
$page = isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1;
$num_results_on_page = 20;

// pagination.php

<?php if (ceil($total_pages / $num_results_on_page) > 0): ?>
    <ul class="pagination">
    <?php if ($page > 1): ?>
    <li class="prev"><a href="territories.php?page=<?= $page-1 ?>"> Prev </a></li>
    <?php endif; ?>

    <?php if ($page > 3): ?>
    <li class="start"><a href="territories.php?page=1">1</a></li>
    <li class="dots" style="color:black">. . .</li>
    <?php endif; ?>

    <?php if ($page-2 > 0): ?><li class="page"><a href="territories.php?page=<?= $page-2 ?>">
    <?= $page-2 ?></a></li><?php endif; ?>
    <?php if ($page-1 > 0): ?><li class="page"><a href="territories.php?page=<?= $page-1 ?>">
    <?= $page-1 ?></a></li><?php endif; ?>

    <li class="currentpage"><a href="territories.php?page=<?= $page ?>"><?= $page ?></a></li>

    <?php if ($page+1 < ceil($total_pages / $num_results_on_page)+1): ?>
    <li class="page"><a href="territories.php?page=<?= $page+1 ?>"> 
    <?= $page+1 ?></a></li>
    <?php endif; ?>
    <?php if ($page+2 < ceil($total_pages / $num_results_on_page)+1): ?>
    <li class="page"><a href="territories.php?page=<?= $page+2 ?>">
    <?= $page+2 ?></a></li><?php endif; ?>

    <?php if ($page < ceil($total_pages / $num_results_on_page)-2): ?>
    <li class="dots" style="color:black">. . .</li>
    <li class="end">
    <a href="territories.php?page=<?= ceil($total_pages / $num_results_on_page) ?>">
    <?php echo ceil($total_pages / $num_results_on_page) ?></a></li>
    <?php endif; ?>

    <?php if ($page < ceil($total_pages / $num_results_on_page)): ?>
    <li class="next">
    <a href="territories.php?page=<?= $page+1 ?>">Next</a></li>
    <?php endif; ?>
    </ul>
<?php endif; ?>

<?php
// THIS FUNCTION CONVERTS STREET ADDRESS INTO GPS COORDINATES
function geocode($address) {

    // Map API needs '+' in place of spaces
    $key = /*Use your Google API Key!*/
    $address = str_replace (" ", "+", urlencode($address));
    $url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . $address . '&key=' . $key; 
    
    $unparsed_json = file_get_contents($url);
    $result = json_decode($unparsed_json, true);
    
    $gps = array (
        'latitude'      => $result['results'][0]['geometry']['location']['lat'],
        'longitude'     => $result['results'][0]['geometry']['location']['lng'],
        'full_address'  => $result['results'][0]['formatted_address'],
        'building_type' => $result['results'][0]['types'][0]
    ); 

    return $gps;
}
?>

global $wp_query;
$total = $wp_query->max_num_pages;

if ( $total > 1 )  {
    // get the current page
    if ( !$current_page = get_query_var('paged') ) {
        $current_page = 1;
    }
    // structure of "format" depends on whether we're using pretty permalinks
    $format =  get_option('permalink_structure', '') ? 'page/%#%/' : '&page=%#%';
     
    echo paginate_links ( 
        array (
            'base'     =>  home_url() . '/%_%',
            'format'   => $format,
            'current'  => max( 1, get_query_var('paged') ),
            'total'    => $wp_query->found_posts,
            'mid_size' => 4,
            'type'     => 'list'
        )
    );
}

Disable Search in WordPress

This code hooks into the template_redirect action in WordPress, which is run before the template for a specific page is selected. The is_search() function checks if the current page being viewed is a search results page. If it is, the wp_redirect() function redirects the user to the homepage of your website, and the exit command stops the rest of the code from running.

This should disable the search feature on your website. It will redirect all the requests made to search page to home page.

function disable_search() {
    if ( is_search() ) {
        wp_redirect( home_url() );
        exit;
    }
}
add_action('template_redirect', 'disable_search');

if ( current_user_can('contributor') && !current_user_can('upload_files') )
     add_action('admin_init', 'allow_contributor_uploads');      
     function allow_contributor_uploads() {
          $contributor = get_role('contributor');
          $contributor->add_cap('upload_files');
     }

© 
<?php echo date('Y'); ?> 
<a href="https://www.arbhie.com" target="_blank">arbhie.com</a> 
by Raymond Hernandez

<?php
    $result = mysqli_query($con, $query); 
    while ($row =  mysqli_fetch_assoc($result)):
        // echo row values here //
    endwhile;
?>