Personal

Database

CREATE TABLE `tracking` (

  `srno` int(11) NOT NULL,

  `day` varchar(20) DEFAULT NULL,

  `time` decimal(10,0) DEFAULT NULL,

  `min` decimal(10,0) DEFAULT NULL,

  `max` decimal(10,0) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--

-- Dumping data for table `tracking`

--

INSERT INTO `tracking` (`srno`, `day`, `time`, `min`, `max`) VALUES

(1, 'mon', 1, 50, 150),

(2, 'mon', 2, 100, 150),

(3, 'mon', 3, 150, 250),

(4, 'mon', 4, 250, 350),

(5, 'mon', 5, 350, 450),

(6, 'mon', 6, 450, 550),

(7, 'mon', 7, 550, 650),

(8, 'mon', 8, 650, 750),

(9, 'mon', 9, 650, 750),

(10, 'mon', 10, 650, 750),

(11, 'mon', 11, 650, 750),

(12, 'mon', 12, 650, 750),

(13, 'mon', 13, 650, 750),

(14, 'mon', 14, 650, 750),

(15, 'mon', 15, 650, 750),

(16, 'mon', 16, 650, 750),

(17, 'mon', 17, 650, 750),

(18, 'mon', 18, 650, 750),

(19, 'mon', 19, 650, 750),

(20, 'mon', 20, 650, 750),

(21, 'mon', 21, 650, 750),

(22, 'mon', 22, 650, 750),

(23, 'mon', 23, 650, 750),

(24, 'thu', 1, 50, 150),

(25, 'thu', 2, 100, 150),

(26, 'thu', 3, 150, 250),

(27, 'thu', 4, 250, 350),

(28, 'thu', 5, 350, 450),

(29, 'thu', 6, 450, 550),

(30, 'thu', 7, 550, 650),

(31, 'thu', 8, 650, 750),

(32, 'thu', 9, 650, 750),

(33, 'thu', 10, 650, 750),

(34, 'thu', 11, 650, 750),

(35, 'thu', 12, 650, 750),

(36, 'thu', 13, 650, 750),

(37, 'thu', 14, 650, 750),

(38, 'thu', 15, 650, 750),

(39, 'thu', 16, 650, 750),

(40, 'thu', 17, 650, 750),

(41, 'thu', 18, 650, 750),

(42, 'thu', 19, 650, 750),

(43, 'thu', 20, 650, 750),

(44, 'thu', 21, 650, 750),

(45, 'thu', 22, 650, 750),

(46, 'thu', 23, 1700, 1950),

(47, 'mon', 0, 40, 70),

(94, 'fri', 1, 50, 150),

(95, 'fri', 2, 100, 150),

(96, 'fri', 3, 150, 250),

(97, 'fri', 4, 250, 350),

(98, 'fri', 5, 350, 450),

(99, 'fri', 6, 450, 550),

(100, 'fri', 7, 550, 650),

(101, 'fri', 8, 650, 750),

(102, 'fri', 9, 650, 750),

(103, 'fri', 10, 650, 750),

(104, 'fri', 11, 650, 750),

(105, 'fri', 12, 650, 750),

(106, 'fri', 13, 650, 750),

(107, 'fri', 14, 650, 750),

(108, 'fri', 15, 650, 750),

(109, 'fri', 16, 650, 750),

(110, 'fri', 17, 650, 750),

(111, 'fri', 18, 650, 750),

(112, 'fri', 19, 650, 750),

(113, 'fri', 20, 650, 750),

(114, 'fri', 21, 650, 750),

(115, 'fri', 22, 650, 750),

(116, 'fri', 23, 650, 750);

--

-- Indexes for dumped tables

--

--

-- Indexes for table `tracking`

--

ALTER TABLE `tracking`

  ADD PRIMARY KEY (`srno`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `tracking`

--

ALTER TABLE `tracking`

  MODIFY `srno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;

COMMIT;

 

<?php

/**

 * Get min/max for given day & hour from `tracking`, compute minute bucket and final row count.

 *

 * @param array  $dbConfig        ['host' => '', 'user' => '', 'pass' => '', 'name' => '']

 * @param string $table           Table name (e.g., 'tracking')

 * @param string $timezone        PHP timezone (e.g., 'Asia/Kolkata')

 * @param string $day             Day key used in DB (e.g., 'mon', 'tue', 'wed', 'thu', ...)

 * @param int    $hour            Hour 0–23 (24h). If null, derived from system.

 * @param int    $minute          Minute 0–59. If null, derived from system.

 * @param array  $bucketOffsets   Offsets to add to min for buckets [15, 30, 45, 60] => [9, 27, 37, 57]

 * @param int    $actualRowsLimit Cap for final row count (e.g., 50)

 *

 * @return array {

 *   success: bool,

 *   messages: string[],

 *   day: string,

 *   hour: int,

 *   minute: int,

 *   bucketLabel: string|null,

 *   min: int|null,

 *   max: int|null,

 *   finalRowCount: int|null

 * }

 */

// Configuration

$dbConfig = [

    'host' => 'localhost',

    'user' => 'root',

    'pass' => '',

    'name' => 'test',

];

function getTrackingInfo(

    array $dbConfig,

    string $table = 'tracking',

    string $timezone = 'Asia/Kolkata',

    string $day = null,

    ?int $hour = null,

    ?int $minute = null,

    array $bucketOffsets = [9, 27, 37, 57],

    int $actualRowsLimit = 50

): array {

    $out = [

        'success'       => false,

        'messages'      => [],

        'day'           => $day,

        'hour'          => null,

        'minute'        => null,

        'bucketLabel'   => null,

        'min'           => null,

        'max'           => null,

        'finalRowCount' => null,

    ];

    // 1) Time setup

    if ($timezone) {

        if (!@date_default_timezone_set($timezone)) {

            $out['messages'][] = "Warning: Failed to set timezone '{$timezone}'. Using default.";

        }

    }

    $resolvedDay    = $day ?: strtolower(date('D')); // 'mon', 'tue', ...

    $resolvedHour   = isset($hour)   ? (int)$hour   : (int)date('G'); // 0–23

    $resolvedMinute = isset($minute) ? (int)$minute : (int)date('i'); // 0–59

    $labels = ['15min', '30min', '45min', '60min'];

    if (count($bucketOffsets) !== 4) {

        $out['messages'][] = 'Error: bucketOffsets must have 4 entries for 15/30/45/60 minute buckets.';

        return $out;

    }

    if     ($resolvedMinute <= 15) { $bucketIndex = 0; }

    elseif ($resolvedMinute <= 30) { $bucketIndex = 1; }

    elseif ($resolvedMinute <= 45) { $bucketIndex = 2; }

    else                           { $bucketIndex = 3; }

    $out['bucketLabel'] = $labels[$bucketIndex];

    // 3) DB connection

    $mysqli = @new mysqli($dbConfig['host'], $dbConfig['user'], $dbConfig['pass'], $dbConfig['name']);

    if ($mysqli->connect_error) {

        $out['messages'][] = 'DB Connect Error (' . $mysqli->connect_errno . '): ' . $mysqli->connect_error;

        return $out;

    }

    // 4) Query min/max for day & hour

    $sql = "SELECT `min`, `max` FROM `{$table}` WHERE `day` = ? AND `time` = ? LIMIT 1";

    $stmt = $mysqli->prepare($sql);

    if (!$stmt) {

        $out['messages'][] = 'Prepare failed: ' . $mysqli->error;

        $mysqli->close();

        return $out;

    }

    $stmt->bind_param('si', $resolvedDay, $resolvedHour);

    $stmt->execute();

    $res = $stmt->get_result();

    if ($row = $res->fetch_assoc()) {

        $minVal = isset($row['min']) ? (int)$row['min'] : null;

        $maxVal = isset($row['max']) ? (int)$row['max'] : null;

        $out['min'] = $minVal;

        $out['max'] = $maxVal;

        if ($minVal !== null) {

            $offset = (int)$bucketOffsets[$bucketIndex];

            $final = $minVal + $offset;

            // Cap by actualRowsLimit

            if ($final > $actualRowsLimit) {

                $out['messages'][] = "Info: finalRowCount capped from   {$actualRowsLimit} to {$final} .";

                $final = $actualRowsLimit;

            }

            $out['finalRowCount'] = $final;

            $out['success'] = true;

            $out['messages'][] = "OK: day={$resolvedDay}, hour={$resolvedHour}, minute={$resolvedMinute}, bucket={$labels[$bucketIndex]}, min={$minVal}, max={$maxVal}, finalRowCount={$final}.";

        } else {

            $out['messages'][] = "Error: Row found but 'min' was NULL.";

        }

    } else {

        $out['messages'][] = "No data found for day={$resolvedDay}, hour={$resolvedHour}.";

    }

    $stmt->close();

    $mysqli->close();

    return $out;

}

// Call using current system time

$infoCurrent = getTrackingInfo(

    dbConfig:        $dbConfig,

    table:           'tracking',

    timezone:        'Asia/Kolkata',

    day:             null,              // derive from system ('mon', 'tue', ...)

    hour:            null,              // derive current hour

    minute:          null,              // derive current minute

    bucketOffsets:   [9, 27, 37, 57],   // your offsets

    actualRowsLimit: 50              // cap

);

// Helper to print nicely

function printInfoHtml(array $info, string $title): void {

    echo "<h3 style='font-family: Segoe UI, Arial; color:#333;'>{$title}</h3>";

    echo "<pre style='background:#f7f7f7; padding:12px; border:1px solid #ddd; border-radius:6px;'>";

    echo "Success       : " . ($info['success'] ? 'Yes' : 'No') . PHP_EOL;

    echo "Messages      : " . implode(' | ', $info['messages']) . PHP_EOL;

    echo "Day/Time      : {$info['day']} {$info['hour']}:{$info['minute']} ({$info['bucketLabel']})" . PHP_EOL;

    echo "Row min/max   : " . ($info['min'] ?? 'NULL') . " / " . ($info['max'] ?? 'NULL') . PHP_EOL;

    echo "FinalRowCount : " . ($info['finalRowCount'] ?? 'NULL') . PHP_EOL;

    echo "</pre>";

}

// Render page

echo "<!doctype html><html><head><meta charset='utf-8'><title>Tracking Output</title></head><body style='margin:28px; font-family: Segoe UI, Arial;'>";

printInfoHtml($infoCurrent, 'Call 1: Current Time');

echo "<hr/>";

//printInfoHtml($infoTest, 'Call 2: Explicit 1 AM, Minute=7');

echo "</body></html>";

Screen Sizes for PSD, standard psd size for website

Higher screen resolutions ultimately make everything look smaller.  

A very small percentage of Internet users are still using older resolutions like the once popular 800×600.

Sites using a 720px width appear very small on high resolution screens, and don’t leave room for a sidebar. Now most websites are staying somewhere around 960px wide. Some sites are even catering to the latest technology with much wider sites.

Although it is important to consider the newest devices, I believe the optimal website width is still 960px wide. This width caters to the majority of devices and makes your site fit nicely in both 1024px and 1366px wide screens.

960 is divisible by 2, 3, 4, 5, 6, 8, 10, 12, and 15. It is a dream for making a perfect grid site. This leads to the popular resource called the “960 grid system“.

How to Send a Confirmation Email with a File Attachment

<?php





 




 function mail_attachment($filename, $path, $mailto, $from_mail, $from_name, $replyto, $subject, $message) {


 


     $file = $path.$filename;


     $file_size = filesize($file);


     $handle = fopen($file, "r");


     $content = fread($handle, $file_size);


     fclose($handle);


     $content = chunk_split(base64_encode($content));


     


     $uid = md5(uniqid(time()));


     


     $header = "From: ".$from_name." <".$from_mail.">\r\n";


     $header .= "Reply-To: ".$replyto."\r\n";


     $header .= "MIME-Version: 1.0\r\n";


     $header .= "Content-Type: multipart/mixed; boundary=\"".$uid."\"\r\n\r\n";


     $header .= "This is a multi-part message in MIME format.\r\n";


     $header .= "--".$uid."\r\n";


     $header .= "Content-type:text/plain; charset=iso-8859-1\r\n";


     $header .= "Content-Transfer-Encoding: 7bit\r\n\r\n";


     $header .= $message."\r\n\r\n";


     $header .= "--".$uid."\r\n";


     $header .= "Content-Type: application/octet-stream; name=\"".$filename."\"\r\n";


     $header .= "Content-Transfer-Encoding: base64\r\n";


     $header .= "Content-Disposition: attachment; filename=\"".$filename."\"\r\n\r\n";


     $header .= $content."\r\n\r\n";


     $header .= "--".$uid."--";


     


     // Messages for testing only, nobody will see them unless this script URL is visited manually


     if (mail($mailto, $subject, "", $header)) {


         echo "Message sent!";


     } else {


         echo "ERROR sending message.";


     }


     


 }


  


 // Only accept POSTs from authenticated source


 if ($_POST['HandshakeKey'] != 'secret-handshake-key') {


   echo "<h1>You are not who you say you are, mister man.</h1>";


  die();


 }


 


 


 


 // EDIT FROM HERE DOWN TO 


 // CUSTOMIZE EMAIL


 


 


 


 // File to attach


 $my_file = "whitepaper.doc";


 $my_path = ''; // $_SERVER['DOCUMENT_ROOT']."/your_path_here/";


 


 // Who email is FROM


 $my_name    = "Your Name (or) Your Business";


 $my_mail    = "youremail@yourbusiness.com";


 $my_replyto = "youremail@yourbusiness.com";


 


 // Whe email is going TO


 $to_email   = $_POST['Field103']; // Comes from Wufoo WebHook


 


 // Subject line of email


 $my_subject = "Your file has arrived!";


 


 // Content of email message (Text only)


 $requester   = $_POST['Field101'];  // Comes from Wufoo WebHook


 $message     = "Hey $requester,


 


Your custom email message


goes here";


 


 // Call function to send email


 mail_attachment($my_file, $my_path, $to_email, $my_mail, $my_name, $my_replyto, $my_subject, $message);





?>

Understanding the ‘self’ keyword in PHP

In PHP, you use the self keyword to access static properties and methods.

The problem is that you can replace $this->method() withself::method() anywhere, regardless if method() is declared static or not. So which one should you use?

Consider this code:

class ParentClass {
 function test() {
  self::who(); // will output 'parent'
  $this->who(); // will output 'child'
 }

 function who() {
  echo 'parent';
 }
}

class ChildClass extends ParentClass {
 function who() {
  echo 'child';
 }
}

$obj = new ChildClass();
$obj->test();

In this example, self::who() will always output ‘parent’, while $this->who() will depend on what class the object has.

Now we can see that self refers to the class in which it is called, while$this refers to the class of the current object.

So, you should use self only when $this is not available, or when you don’t want to allow descendant classes to overwrite the current method.

How to get plugin directory path in wordpress

$pluginpath = WP_PLUGIN_URL . '/'. str_replace( basename( __FILE__ ), "", plugin_basename(__FILE__) );