Web Guru...

Personal

noreply@blogger.com (Manoj Agarwal) — Fri, 12 Dec 2025 03:15:00 +0000

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

noreply@blogger.com (Manoj Agarwal) — Mon, 27 Jul 2015 05:21:00 +0000

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

noreply@blogger.com (Manoj Agarwal) — Fri, 22 May 2015 10:38:00 +0000


<?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

noreply@blogger.com (Manoj Agarwal) — Mon, 16 Mar 2015 14:46:00 +0000

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

noreply@blogger.com (Manoj Agarwal) — Fri, 13 Mar 2015 04:50:00 +0000

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

Get content between two special character from a string in php

noreply@blogger.com (Manoj Agarwal) — Thu, 29 Jan 2015 09:15:00 +0000

<?php
$string='[countrycontent countryname="GB"] london [/countrycontent]

[countrycontent countryname="IN"] INDIA [/countrycontent] [countrycontent countryname="IN"] INDIA [/countrycontent]';
preg_match_all('/\](.*?)\[/',$string, $matches);

// array [1] is the stripped matches... array[0] would reurn with the []'s :)
$matches1 = $matches[1];
$contentA=array();
// cycle through the matches and add them to the searched for string
foreach ($matches1 as $match1){

$contentA[]=$match1;
}

preg_match_all('/\"(.*?)\"/',$string, $matches);

// array [1] is the stripped matches... array[0] would reurn with the []'s :)
$matches2 = $matches[1];
$countryA=array();
// cycle through the matches and add them to the searched for string
foreach ($matches2 as $match2){

$countryA[]=$match2;
}

$result = array_combine($countryA, $contentA);

foreach($result as $key=>$v)
{
if($key=="GB")
{
echo $v;
}

}

?>

Remove the Joomla URL ID

noreply@blogger.com (Manoj Agarwal) — Tue, 25 Mar 2014 05:18:00 +0000

A search engine friendly URL means that it can easily be understood by people, and search engine robots. An article's URL is usually made up of 3 sections divided by forward slashes. The domain, the category, and the title of the article. It looks something like this "domain.com/category/article-title".

By having a search engine friendly URL you make it easier for your visitors to navigate your site. Your article will also be placed higher up on the SERP (Search Engine Result Page), since it has more keywords. This article will help you clean up your url if you're using Joomla.

Remember to backup your website regularly, and make copies of files you're about to edit.

SEF URL WITH JOOMLA

It seems like the creators of Joomla doesn't want people to remove the ID for some reason. They pretty much remove the "hack/fix" in every update. I would suggest you just migrate to WordPress, unless you need Joomla for a specific reason. If you find a solution/problem, please share it in the comments, and I'll try to help.

Plugins

SEBLOD can help you with the ID. I haven't tried it myself, but it looks promising. Read their FAQ before you install it. Also read this Forum post about changing the URL ID.

You can look for SEF Joomla extensions here: http://extensions.joomla.org/extensions/site-management/sef

Warning: This guide may cause duplicate content, so if you don't know how to fix that yourself, you should try the extensions.

Notes

Joomla 2.5.6 - Here's a video tutorial if you would prefer that.
Joomla 2.5.7+ - There are 2 instances of get('sef_advanced_link', 0). Make sure you changes both.
Joomla 3.0.2 - Changing get('sef_advanced_link', 0) is all you have to do. (Be aware of duplicate content with the old and the new URL, read comments for more info.)
This may not work on newer version of Joomla! Try SEBLOD, and changing the URL ID.
Added Joomla 3.1 - step 4.

Step 1

Joomla 2.5

Copy "components/com_content/router.php" to "/your-template/html", (if you don't have a folder called html, you need to create it.) then continue on step 2.

Joomla 3.0.2: This is the only way I got it working. If you find another way, please let us know!

Edit "components/com_content/router.php", then continue on step 2.

Remember, you'll probably have to re-do this step every time you update Joomla.

Step 2

(Try rewriting the symbols if it doesn't work.)

Change this:

`1`	`$advanced` `=` `$params->get('sef_advanced_link', 0);`

To this:

`1`	`$advanced` `=` `$params->get('sef_advanced_link', 1);`

Joomla 3+ - You're done!

Joomla 2.5 - Continue Below

Step 3

Replace this:

1if (strpos($segments[0], ':') === false) {

2$vars['view'] = 'article';

3$vars['id'] = (int)$segments[0];

4return $vars;

5}

With This:

1/*if (strpos($segments[0], ':') === false) {

2$vars['view'] = 'article';

3$vars['id'] = (int)$segments[0];

4return $vars;

5}*/

Joomla 2.5 - Done!

Joomla 3.1 - Continue below, thanks to Phuoc Nguyen.

Step 4

You want to edit your router.php file:

From:

1->where($db->quoteName('alias') . ' = ' . $db->quote($db->quote($segment)));

To:

`1`	`->where($db->quoteName('alias') .` `' = '` `.` `$db->quote($segment));`

Help Section

If it doesn't work, there are a few common mistakes you may want to look into.

Contact form connectivity with php form

noreply@blogger.com (Manoj Agarwal) — Wed, 22 Jan 2014 12:29:00 +0000

$query=mysql_query("SELECT * FROM wp_cf7dbplugin_submits ORDER BY id DESC LIMIT 1 ");
$row=@mysql_fetch_array($query);
$time=$row['submit_time'];
$timeA=explode(".",$time);

$t1=strtotime("now");
$t2=$timeA[1]+1;
$newtime=$t1.".".$t2;

$query1=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Name','$name',0, NULL) ");

$query2=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Email','$email',1, NULL) ");

$query3=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','ContactNo','$mob',2, NULL) ");

$query4=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Event Details','$eventdetail',3, NULL) ");

$query5=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Event Date','$date',4, NULL) ");

$query6=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Event Venue','$venue',5, NULL) ");
$query7=mysql_query("INSERT INTO `wp_cf7dbplugin_submits` (`submit_time`, `form_name`, `field_name`, `field_value`, `field_order`, `file`) VALUES ('$newtime','Contact Form','Event City','$city',5, NULL) ");

mysql_query is fine but showing mysql_fetch_array() expects parameter 1 to be resource, boolean given in

noreply@blogger.com (Manoj Agarwal) — Wed, 27 Nov 2013 06:03:00 +0000

$query = htmlspecialchars("select * from table");
$query = mysql_real_escape_string($query);

$result=mysql_query($query);

Need a Web Security Expert , Website security expert,MY WEBSITE HAS BEEN HACKED, Recover from a site hack, website hack, Protect your website from hackers, malware and other threats

noreply@blogger.com (Manoj Agarwal) — Fri, 20 Sep 2013 09:14:00 +0000

Find Out Exactly What Happened

The more you know about the hack, the more your host and the Internet will be able to help you. How did the hackers get in? Did this hack affect numerous sites, or were you the lone target? Was it a cPanel hack, FTP password entrance, remote file inclusion, or a code injection? Check to see if any of your data is missing, or if anything’s been added to your database, like strange uploaded files you don’t recognize. Once you have thoroughly checked your site, it’s time to ask for help.

Contact Me

Wordpress custom code in php, add custom field in wordpress

noreply@blogger.com (Manoj Agarwal) — Mon, 22 Jul 2013 05:40:00 +0000

Add custom field in wordpress

wp-admin-posts->edit post-> Screen options -> Custom field on

add value and title:

<?php the_meta(); ?>

<?php
require('blog/wp-blog-header.php');

function limit_words($string, $word_limit)
{
    $words = explode(" ",$string);
    return implode(" ", array_splice($words, 0, $word_limit));
}
//db parameters
$db_username = '';
$db_password = ';
$db_database = '';

//connect to the database
mysql_connect(localhost, $db_username, $db_password);
@mysql_select_db($db_database) or die("Unable to select database");

//get data from database -- !IMPORTANT, the "LIMIT 5" means how many posts will appear. Change the 5 to any whole number.
$query = "Select * FROM wp_posts WHERE post_type='post' AND post_status='publish' ORDER BY id DESC LIMIT 1";

$query_result = mysql_query($query);
$num_rows = mysql_fetch_array($query_result);
$blog_id=$num_rows['ID'];
$blog_date = $num_rows['post_date'];
$blog_date= date('jS F, Y', strtotime($blog_date));
$blog_tags=wp_get_post_tags($blog_id,'name');

foreach($blog_tags as $term){
    $tag=$term->name;
    $tag1.=$tag.",";
}



$tag1=rtrim($tag1, ",");
//$blog_date=date('l jS F Y ',$blog_date);

$blog_title = $num_rows['post_title'];
$blog_content = $num_rows['post_content'];
$blog_permalink =$num_rows['guid'];
$blog_post_author=$num_rows['post_author'];

//close database connection

function getAuthor($blog_post_author)
{
$query1=mysql_query("select * from wp_users where ID='$blog_post_author' ");
$ruser=mysql_fetch_array($query1);
return $ruser['user_login'];

}
function getaddress($id) /// custom field value...
{

$query=mysql_query("select * from wp_postmeta where post_id='$id' and meta_key='Address' ");
$row=mysql_fetch_array($query);
return $row['meta_value'];
}

?>

Image

<?php $image1 = wp_get_attachment_url(get_post_thumbnail_id($blog_id) ); ?>
                    <img alt="img" src=" <?php echo $image1; ?>">

Comment
<?php
                        $comments = $wpdb->get_row("SELECT comment_count as count FROM wp_posts WHERE ID = '$blog_id'");
                        $commentcount = $comments->count;
                        echo $commentcount;?>

Tags

   <?php
                    $exp1=explode(",",$tag1);
                    foreach($exp1 as $v)
                    {
                    ?>
                        <li class="skin-background-color7 skin-background-hover2"><a href="blog/?tag=<?php echo $v; ?>" class="skin-color8"><?php echo $v; ?></a></li>

                    <?php } ?>

Content limit

<?php

    $cont=$blog_content;
    echo limit_words($cont,100); ?>

Check for an internet connection using php

noreply@blogger.com (Manoj Agarwal) — Tue, 16 Jul 2013 09:51:00 +0000

In writing a recent distributed db application (using AMP) I needed to find a way to check if the local machine had access to the internet, to be able to update the db at the master site. So I wrote this.

It uses fsockopen() to open a connection to a remote website, substitute yours in, and looks on ports 80 for http connections or 443 for SSL connections.

When called the function returns true id connected or false if not.

//-----------------------------------------------------------------------------
// is_connected function to check for internet connection
//-----------------------------------------------------------------------------
<?php function is_connected()
{
  //check to see if the local machine is connected to the web
//uses sockets to open a connection to apisonline.com
  $connected = @fsockopen("www.some_domain.com", [80|443]);
if ($connected){
  $is_conn = true;
  fclose($connected);
}else{
  $is_conn = false;
}
return $is_conn;

}//end is_connected function ?>

Get which checkbox's are selected using Jquery, Multi checkbox search filter using php ajax jquery

noreply@blogger.com (Manoj Agarwal) — Fri, 12 Jul 2013 10:10:00 +0000

Create thumbnail image in php

noreply@blogger.com (Manoj Agarwal) — Thu, 11 Jul 2013 05:34:00 +0000

function make_thumb($src, $dest,$desired_height, $desired_width) {

    /* read the source image */
    $source_image = imagecreatefromjpeg($src);
    $width = imagesx($source_image);
    $height = imagesy($source_image);

    /* find the "desired height" of this thumbnail, relative to the desired width */
    //$desired_height = floor($height * ($desired_width / $width));

    /* create a new, "virtual" image */
    $virtual_image = imagecreatetruecolor($desired_width, $desired_height);

    /* copy source image at a resized size */
    imagecopyresampled($virtual_image, $source_image, 0, 0, 0, 0, $desired_width, $desired_height, $width, $height);

    /* create the physical thumbnail image to its destination */
    imagejpeg($virtual_image, $dest);
}

calling
@move_uploaded_file($_FILES['product_image1']['tmp_name'], 'uploads/'.$random_digit.$_FILES['product_image1']['name']);
echo make_thumb('uploads/'.$random_digit.$_FILES['product_image1']['name'],'uploads/'.$random_digit.$_FILES['product_image1']['name'],626,476);

Google map

noreply@blogger.com (Manoj Agarwal) — Wed, 03 Jul 2013 12:24:00 +0000

Joomla 2.5 load component and load module.

noreply@blogger.com (Manoj Agarwal) — Thu, 27 Jun 2013 09:38:00 +0000

load component in article

{component url='component/com_helloworld' }

load module in article

{loadposition xx}
{loadmodule yyy}

date format change in php , wordpress

noreply@blogger.com (Manoj Agarwal) — Fri, 14 Jun 2013 09:26:00 +0000

echo date("d F Y", strtotime($row['my_date']));
// Correct: Outputs the expected date. eg '30 December 2010'

Export excel sheet in joomla 3.0

noreply@blogger.com (Manoj Agarwal) — Mon, 03 Jun 2013 12:18:00 +0000

public function export() {
$db = JFactory::getDBO();
$query = 'SELECT * FROM #__table'
$db->setQuery($query);
$items = $db->loadObjectList();

header('Content-type: application/text');
header('Content-Disposition: attachment; filename="export.csv"');
echo HPCSV::create($items);
}

<?php
/**
* Class to export/import data to CSV
*
* @author Hannes Papenberg
* @license GNU/GPL
*/

// no direct access
defined('_JEXEC') or die('Restricted access');

class HPCSV
{
function create($data)
{
$csv = self::create_csv_file_header($

data);
foreach ($data as $key=>$val){
$csv .= self::create_csv_file_row($val);
}
return $csv;
}

function read($string)
{
$rows = explode("\n", $string);
foreach($rows as &$row)
{
$row = explode(',',$row);
}
return $rows;
}

function create_csv_file_header($data)
{
$row = "";
if (count($data)>0){
foreach ($data[0] as $key=>$val)
{
if ($row){
$row .= ',' . $key;
}else{
$row .= $key;
}
}
$row .= "\n";
}
return $row;
}

function create_csv_file_row($row)
{
$res = "";
foreach ($row as $key=>$val)
{
if ($res){
$res .= ',' .'"'. $val.'"';
}else{
$res .= '"'.$val.'"';
}
}
$res .= "\n";

return $res;
}

}

Export excel sheet code in php

noreply@blogger.com (Manoj Agarwal) — Mon, 03 Jun 2013 12:17:00 +0000

                $query = "SELECT `name` , `dob` , `gender` , `email` ,

                `mobile` , `street` , `city` , `state` , `postalcode` , `country` ,

                `applied` , `appliedmonth` , `appliedyear` ,

                `tenthcourse` , `tenthpercent` , `twelvethcourse` , `twelvethpercent` , `graduationcourse` , `graduationpercent` ,

                `pgcourse` , `pgpercent` , `haveexperience` , `expinmonth` ,

                `currentemployer` , `currentdesig` , `durationinmonth` , `currentsalary` , `expectedsalary` ,

                `appliedposition` , `resume` FROM `applyonline` order by `id` DESC";

                $result = mysql_query($query) or die(mysql_error());

                $tsv = array();

                $html = array();

                //////////////////////////////top heading in excel file////////////////////////////////////////////

                //$tsv[] = "<B>APPLIED CANDIDATES REPORT</B>";

                //$html[] = "<tr>" ."<td>"."<B>APPLIED CANDIDATES REPORT</B>"."</td></tr>";



                $tsv[] = "<B>Name</B>";

                $html[] = "<tr>" ."<td>"."<B>Name</B>"."</td>";



                $tsv[] = "<B>DOB</B>";

                $html[] = "<td>"."<B>DOB</B>"."</td>";



                $tsv[] = "<B>Gender</B>";

                $html[] = "<td>"."<B>Gender</B>"."</td>";



/*                $tsv[] = "<B>City of work</B>";

                $html[] = "<td>"."<B>City of work</B>"."</td>";

*/



                $tsv[] = "<B>Email</B>";

                $html[] = "<td>"."<B>Email</B>"."</td>";





                $tsv[] = "<B>Mobile</B>";

                $html[] = "<td>"."<B>Mobile</B>"."</td>";





                $tsv[] = "<B>Street</B>";

                $html[] = "<td>"."<B>Street</B>"."</td>";



                $tsv[] = "<B>City</B>";

                $html[] = "<td>"."<B>City</B>"."</td>";





                $tsv[] = "<B>State</B>";

                $html[] = "<td>"."<B>State</B>"."</td>";





                $tsv[] = "<B>Postal Code</B>";

                $html[] = "<td>"."<B>Postal Code</B>"."</td>";





                $tsv[] = "<B>Country</B>";

                $html[] = "<td>"."<B>Country</B>"."</td>";





                $tsv[] = "<B>Applied</B>";

                $html[] = "<td>"."<B>Applied</B>"."</td>";





                $tsv[] = "<B>Applied Month</B>";

                $html[] = "<td>"."<B>Applied Month</B>"."</td>";





                $tsv[] = "<B>Applied Year</B>";

                $html[] = "<td>"."<B>Applied Year</B>"."</td>";





                $tsv[] = "<B>Xth Course</B>";

                $html[] = "<td>"."<B>Xth Course</B>"."</td>";





                $tsv[] = "<B>Xth Percent</B>";

                $html[] = "<td>"."<B>Xth Percent</B>"."</td>";





                $tsv[] = "<B>XIIth Course</B>";

                $html[] = "<td>"."<B>XIIth Course</B>"."</td>";





                $tsv[] = "<B>XIIth Percent</B>";

                $html[] = "<td>"."<B>XIIth Percent</B>"."</td>";





                $tsv[] = "<B>Graduation Course</B>";

                $html[] = "<td>"."<B>Graduation Course</B>"."</td>";





                $tsv[] = "<B>Graduation Percent</B>";

                $html[] = "<td>"."<B>Graduation Percent</B>"."</td>";





                $tsv[] = "<B>PG Course</B>";

                $html[] = "<td>"."<B>PG Course</B>"."</td>";





                $tsv[] = "<B>PG Percent</B>";

                $html[] = "<td>"."<B>PG Percent</B>"."</td>";





                $tsv[] = "<B>Have Experience</B>";

                $html[] = "<td>"."<B>Have Experience</B>"."</td>";





                $tsv[] = "<B>Exp. in Month</B>";

                $html[] = "<td>"."<B>Exp. in Month</B>". "</td>";





                $tsv[] = "<B>Current Employer</B>";

                $html[] = "<td>"."<B>Current Employer</B>"."</td>";





                $tsv[] = "<B>Current Designation</B>";

                $html[] = "<td>"."<B>Current Designation</B>"."</td>";





                $tsv[] = "<B>Duration in Month</B>";

                $html[] = "<td>"."<B>Duration in Month</B>"."</td>";





                $tsv[] = "<B>Current Salary</B>";

                $html[] = "<td>"."<B>Current Salary</B>"."</td>";





                $tsv[] = "<B>Expected Salary</B>";

                $html[] = "<td>"."<B>Expected Salary</B>"."</td>";





                $tsv[] = "<B>Applied Position</B>";

                $html[] = "<td>"."<B>Applied Position</B>"."</td>";





                $tsv[] = "<B>Resume</B>";

                $html[] = "<td>"."<B>Resume</B>"."</td></tr>";







                ///////////////////////////////////////////////////////////////////////////////////////////////////

                while($row = mysql_fetch_array($result, MYSQL_NUM))

                {

                   $tsv[] = implode("\t", $row);

                   $html[] = "<tr><td>" .implode("</td><td>", $row) ."</td></tr>";

                }



                $tsv = implode("\r\n", $tsv);

                $html = "<table border=1>" . implode("\r\n", $html) . "</table>";



                $fileName = 'report.xls';

                header("Content-type: application/vnd.ms-excel");

                header("Content-Disposition: attachment; filename=$fileName");

                //echo $tsv;

                echo $html;

Image upload using php without page referesh

noreply@blogger.com (Manoj Agarwal) — Mon, 15 Apr 2013 07:00:00 +0000

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script language="javascript">
function confirmFun(me)
{
if(confirm("Are You Want To Delete"))
{

document.frm.action ="image_upload.php?act=DEL";
document.frm.target = "imgFrame";
document.frm.submit();
return true;
}
else
{
me.checked = false;
return false;
}

}
function uploadImg()
{
document.frm.action ="image_upload.php?act=UP";
document.frm.target = "imgFrame";
document.frm.submit();

}
</script>
</head>

<body>
<form name="frm" action="<?=$_SERVER['PHP_SELF'];?>" method="post" enctype="multipart/form-data">
<p>File1:
<input type="file" name="img" id="img" value="" onchange="return uploadImg()" />
Please Upload JPG,GIFor BMP.</p>

<p><br />
<img id="imgId" border="0" style="display:none" width="100" height="100"/><br />
<div id="del" style="display:none">
<input type="radio" id="radioBtn" value="D" onclick="return confirmFun(this);">Delete Image
</div>
<input type="hidden" name="hdnImgNm" id="hdnImgNm" value = "" />
</p>
<iframe name="imgFrame" style="display:none"></iframe>
</form>
</body>
</html>

<?php
$allowedExts = array("gif", "jpeg", "jpg", "png");
$extension = end(explode(".", $_FILES["file"]["name"]));
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/jpg")
|| ($_FILES["file"]["type"] == "image/png"))
&& ($_FILES["file"]["size"] < 20000)
&& in_array($extension, $allowedExts))
{
if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
    }
else
    {
    echo "Upload: " . $_FILES["file"]["name"] . "<br>";
    echo "Type: " . $_FILES["file"]["type"] . "<br>";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br>";

    if (file_exists("upload/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
      }
    }
}
else
{
echo "Invalid file";
}
?>

Get all image source of html file using dom in php

noreply@blogger.com (Manoj Agarwal) — Thu, 11 Apr 2013 11:51:00 +0000

<?php
    $doc = new DOMDocument();
    $doc->loadHTML(htmlstring);
    $imageTags = $doc->getElementsByTagName('img');

    foreach($imageTags as $tag) {
        echo $tag->getAttribute('src');
    }
?>

Alphabet listing of result in php mysql

noreply@blogger.com (Manoj Agarwal) — Tue, 26 Mar 2013 10:12:00 +0000

<?php

//CONNECTS TO YOUR DATABASE (MODIFY TO YOUR SETTINGS)
mysql_connect("localhost", "root", "");
$db = 'library';
$table = 'titles';

$alpha = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z");

//LISTS TITLE IN ALPHABETICAL ORDER UNDER EACH LETTER
foreach($alpha as $a){
    $q = mysql_query("SELECT * FROM $db.$table WHERE title LIKE '$a%'");
    $n = mysql_num_rows($q);

    //EXCLUDES LETTER IF THERE TITLES THAT START WITH IT
    if($n){
        echo '<b style="font-size:20px">'.$a.'</b><br><br>';
        while($r=mysql_fetch_array($q)){
            echo $r["title"].'<br>';
        }
        echo '<br>';
    }
}

?>

CREATE TABLE `titles` (
    `title` VARCHAR ( 100 ) NOT NULL
) ENGINE = MYISAM;
INSERT INTO titles VALUES ('Alpha'), ('Betical'), ('Order'), ('Demo'), ('Demo2'), ('Demo3', 'Indexing');

Jquery Zoom

noreply@blogger.com (Manoj Agarwal) — Tue, 26 Mar 2013 03:47:00 +0000

http://www.mind-projects.it/projects/jqzoom/archives/jqzoom_ev-2.3.zip

Checkbox act as radio button in html

noreply@blogger.com (Manoj Agarwal) — Sat, 23 Mar 2013 10:51:00 +0000

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>
<script src="http://ajax.googleapis.com/ajax/

libs/jquery/1.3.2/jquery.min.js"></script>
<title>Sandbox</title>


</head>
<body>
<input type='checkbox' name='mygroup1' value='1' class='unique'>
<input type='checkbox' name='mygroup2' value='2' class='unique'>
<input type='checkbox' name='mygroup3' value='3' class='unique'>
<script>
$('input.unique').click(function() {
    $('input.unique:checked').not(this).removeAttr('checked');
});

</script>


</body>
</html>

best practice to optimize PHP code performances

noreply@blogger.com (Manoj Agarwal) — Sat, 09 Mar 2013 04:54:00 +0000

Today i am searching solutions for any tips and tricks about best practice to optimize PHP code performances and i found some of useful articles which you may interested with.
A good list of consideration practice in optimizing PHP code performances.

Here are Webber’s points:

If a method can be static, declare it static. Speed improvement is by a factor of 4.
echo is faster than print.(* compare with list from phplens by John Lim)
Use echo’s multiple parameters instead of string concatenation.
Set the maxvalue for your for-loops before and not in the loop.
Unset your variables to free memory, especially large arrays.
Avoid magic like __get, __set, __autoload
require_once() is expensive
Use full paths in includes and requires, less time spent on resolving the OS paths.
If you need to find out the time when the script started executing, $_SERVER[’REQUEST_TIME’] is preferred to time()
See if you can use strncasecmp, strpbrk and stripos instead of regex
str_replace is faster than preg_replace, but strtr is faster than str_replace by a factor of 4
If the function, such as string replacement function, accepts both arrays and single characters as arguments, and if your argument list is not too long, consider writing a few redundant replacement statements, passing one character at a time, instead of one line of code that accepts arrays as search and replace arguments.
It’s better to use select statements than multi if, else if, statements.
Error suppression with @ is very slow.
Turn on apache’s mod_deflate
Close your database connections when you’re done with them
$row[’id’] is 7 times faster than $row[id]
Error messages are expensive
Do not use functions inside of for loop, such as for ($x=0; $x < count($array); $x) The count() function gets called each time.
Incrementing a local variable in a method is the fastest. Nearly the same as calling a local variable in a function.
Incrementing a global variable is 2 times slow than a local var.
Incrementing an object property (eg. $this->prop++) is 3 times slower than a local variable.
Incrementing an undefined local variable is 9-10 times slower than a pre-initialized one.
Just declaring a global variable without using it in a function also slows things down (by about the same amount as incrementing a local var). PHP probably does a check to see if the global exists.
Method invocation appears to be independent of the number of methods defined in the class because I added 10 more methods to the test class (before and after the test method) with no change in performance.
Methods in derived classes run faster than ones defined in the base class.
A function call with one parameter and an empty function body takes about the same time as doing 7-8 $localvar++ operations. A similar method call is of course about 15 $localvar++ operations.
Surrounding your string by ‘ instead of ” will make things interpret a little faster since php looks for variables inside “…” but not inside ‘…’. Of course you can only do this when you don’t need to have variables in the string.
When echoing strings it’s faster to separate them by comma instead of dot. Note: This only works with echo, which is a function that can take several strings as arguments.
A PHP script will be served at least 2-10 times slower than a static HTML page by Apache. Try to use more static HTML pages and fewer scripts.
Your PHP scripts are recompiled every time unless the scripts are cached. Install a PHP caching product to typically increase performance by 25-100% by removing compile times.
Cache as much as possible. Use memcached – memcached is a high-performance memory object caching system intended to speed up dynamic web applications by alleviating database load. OP code caches are useful so that your script does not have to be compiled on every request
When working with strings and you need to check that the string is either of a certain length you’d understandably would want to use the strlen() function. This function is pretty quick since it’s operation does not perform any calculation but merely return the already known length of a string available in the zval structure (internal C struct used to store variables in PHP). However because strlen() is a function it is still somewhat slow because the function call requires several operations such as lowercase & hashtable lookup followed by the execution of said function. In some instance you can improve the speed of your code by using an isset() trick.