php — codestacker

wordpress popular posts

   1  <ul>
   2  <?php $result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 5");
   3  foreach ($result as $post) {
   4  setup_postdata($post);
   5  $postid = $post->ID;
   6  $title = $post->post_title;
   7  $commentcount = $post->comment_count;
   8  if ($commentcount != 0) { ?>
   9  <li><a href="<?php echo get_permalink($postid); ?>" title="<?php echo $title ?>">
  10  <?php echo $title ?></a> {<?php echo $commentcount ?>}</li>
  11  <?php } } ?>
  12  </ul>

<ul>
<?php $result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 5");
foreach ($result as $post) {
setup_postdata($post);
$postid = $post->ID;
$title = $post->post_title;
$commentcount = $post->comment_count;
if ($commentcount != 0) { ?>
<li><a href="<?php echo get_permalink($postid); ?>" title="<?php echo $title ?>">
<?php echo $title ?></a> {<?php echo $commentcount ?>}</li>
<?php } } ?>
</ul>

created by leozera — 22 August 2009 — get a short url — tags: php wordpress — embed

short url in wordpress with tinyurl

paste the function in function.php file and call in you template with:

<?php echo ‘’.getShortUrl(get_permalink($post→ID)).‘“>short url’; ?>

show/hide lines

   1  function getShortUrl($url) {
   2    $tinyurl = file_get_contents("http://tinyurl.com/api-create.php?url=".$url);
   3    return $tinyurl;
   4  }

function getShortUrl($url) {
  $tinyurl = file_get_contents("http://tinyurl.com/api-create.php?url=".$url);
  return $tinyurl;
}

created by leozera — 26 April 2009 — get a short url — tags: php tinyurl wordpress — embed

watermark

show/hide lines

   1  function watermark($imagesource){
   2  	$filetype = substr($imagesource,strlen($imagesource)-4,4); 
   3  	$filetype = strtolower($filetype); 
   4  	if($filetype == ".gif")  $image = @imagecreatefromgif($imagesource);  
   5  	if($filetype == ".jpg")  $image = @imagecreatefromjpeg($imagesource);  
   6  	if($filetype == ".png")  $image = @imagecreatefrompng($imagesource);  
   7  	if (!$image) die(); 
   8  	$watermark = @imagecreatefrompng('../images/watermark.png'); 
   9  	$imagewidth = imageSX($image); 
  10  	$imageheight = imageSY($image);  
  11  	$watermarkwidth =  imageSX($watermark); 
  12  	$watermarkheight =  imageSY($watermark); 
  13  	$startwidth = $imagewidth - $watermarkwidth - 5;  
  14  	$startheight = $imageheight - $watermarkheight - 5;
  15  	imagecopy($image, $watermark,  $startwidth, $startheight, 0, 0, $watermarkwidth, $watermarkheight); 
  16  	imagejpeg($image,$imagesource);
  17  	imagedestroy($image); 
  18  	imagedestroy($watermark);
  19  }

function watermark($imagesource){
	$filetype = substr($imagesource,strlen($imagesource)-4,4); 
	$filetype = strtolower($filetype); 
	if($filetype == ".gif")  $image = @imagecreatefromgif($imagesource);  
	if($filetype == ".jpg")  $image = @imagecreatefromjpeg($imagesource);  
	if($filetype == ".png")  $image = @imagecreatefrompng($imagesource);  
	if (!$image) die(); 
	$watermark = @imagecreatefrompng('../images/watermark.png'); 
	$imagewidth = imageSX($image); 
	$imageheight = imageSY($image);  
	$watermarkwidth =  imageSX($watermark); 
	$watermarkheight =  imageSY($watermark); 
	$startwidth = $imagewidth - $watermarkwidth - 5;  
	$startheight = $imageheight - $watermarkheight - 5;
	imagecopy($image, $watermark,  $startwidth, $startheight, 0, 0, $watermarkwidth, $watermarkheight); 
	imagejpeg($image,$imagesource);
	imagedestroy($image); 
	imagedestroy($watermark);
}

created by leozera — 23 November 2008 — get a short url — tags: php watermark — embed

wordpress functions to count posts

for example: save all functions in ‘your_theme/stats.php’

show/hide lines

   1  // comments_count
   2  function comments_count() { 
   3      global $wpdb; 
   4      $count = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'"; 
   5      echo $wpdb->get_var($count); 
   6  } 
   7  // < ?php comments_count() ?> comments
   8  
   9  // posts_count
  10  function posts_count() { 
  11      global $wpdb; 
  12      $count = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish'"; 
  13      echo $wpdb->get_var($count); 
  14  } 
  15  // <?php posts_count() ?></strong> articles
  16  
  17  // retro_count
  18  function retro_count() { 
  19      global $wpdb; 
  20      $count = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_type = 'pingback'"; 
  21      echo $wpdb->get_var($count); 
  22  } 
  23  // < ?php retro_count() ?> pingbacks

// comments_count
function comments_count() { 
    global $wpdb; 
    $count = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'"; 
    echo $wpdb->get_var($count); 
} 
// < ?php comments_count() ?> comments

// posts_count
function posts_count() { 
    global $wpdb; 
    $count = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish'"; 
    echo $wpdb->get_var($count); 
} 
// <?php posts_count() ?></strong> articles

// retro_count
function retro_count() { 
    global $wpdb; 
    $count = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_type = 'pingback'"; 
    echo $wpdb->get_var($count); 
} 
// < ?php retro_count() ?> pingbacks

created by leozera — 18 November 2008 — get a short url — tags: php wordpress — embed

php script for mysql backup

show/hide lines

   1  <?php
   2  
   3  function backup_tables($host,$user,$pass,$name,$tables = '*'){
   4  	
   5  	$link = mysql_connect($host,$user,$pass);
   6  	mysql_select_db($name,$link);
   7  	
   8  	//get all of the tables
   9  	if($tables == '*')
  10  	{
  11  		$tables = array();
  12  		$result = mysql_query('SHOW TABLES');
  13  		while($row = mysql_fetch_row($result))
  14  		{
  15  			$tables[] = $row[0];
  16  		}
  17  	}
  18  	else
  19  	{
  20  		$tables = is_array($tables) ? $tables : explode(',',$tables);
  21  	}
  22  	
  23  	//cycle through
  24  	foreach($tables as $table)
  25  	{
  26  		$result = mysql_query('SELECT * FROM '.$table);
  27  		$num_fields = mysql_num_fields($result);
  28  		for ($i = 0; $i < $num_fields; $i++) 
  29  		{
  30  			$return.= 'DROP TABLE '.$table.';';
  31  			
  32  			$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
  33  			$return.= "\n\n".$row2[1].";\n\n";
  34  			
  35  			while($row = mysql_fetch_row($result))
  36  			{
  37  				$return.= 'INSERT INTO '.$table.' VALUES(';
  38  				for($j=0; $j<$num_fields; $j++) 
  39  				{
  40  					$row[$j] = addslashes($row[$j]);
  41  					$row[$j] = ereg_replace("\n","\\n",$row[$j]);
  42  					if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
  43  					if ($j<($num_fields-1)) { $return.= ','; }
  44  				}
  45  				$return.= ");\n";
  46  			}
  47  		}
  48  		$return.="\n\n\n";
  49  	}
  50  	
  51  	//save file
  52  	$handle = fopen('db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+');
  53  	fwrite($handle,$return);
  54  	fclose($handle);
  55  }
  56  
  57  backup_tables('localhost','username','password','blog');
  58  
  59  ?>

<?php

function backup_tables($host,$user,$pass,$name,$tables = '*'){
	
	$link = mysql_connect($host,$user,$pass);
	mysql_select_db($name,$link);
	
	//get all of the tables
	if($tables == '*')
	{
		$tables = array();
		$result = mysql_query('SHOW TABLES');
		while($row = mysql_fetch_row($result))
		{
			$tables[] = $row[0];
		}
	}
	else
	{
		$tables = is_array($tables) ? $tables : explode(',',$tables);
	}
	
	//cycle through
	foreach($tables as $table)
	{
		$result = mysql_query('SELECT * FROM '.$table);
		$num_fields = mysql_num_fields($result);
		for ($i = 0; $i < $num_fields; $i++) 
		{
			$return.= 'DROP TABLE '.$table.';';
			
			$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
			$return.= "\n\n".$row2[1].";\n\n";
			
			while($row = mysql_fetch_row($result))
			{
				$return.= 'INSERT INTO '.$table.' VALUES(';
				for($j=0; $j<$num_fields; $j++) 
				{
					$row[$j] = addslashes($row[$j]);
					$row[$j] = ereg_replace("\n","\\n",$row[$j]);
					if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
					if ($j<($num_fields-1)) { $return.= ','; }
				}
				$return.= ");\n";
			}
		}
		$return.="\n\n\n";
	}
	
	//save file
	$handle = fopen('db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+');
	fwrite($handle,$return);
	fclose($handle);
}

backup_tables('localhost','username','password','blog');

?>

created by leozera — 01 September 2008 — get a short url — tags: backup mysql php — embed

resize image

show/hide lines

   1  <?
   2  ////////////////////////////////////////////////////////////////////////////////////
   3  // generate a croped-image from a picture
   4  // source: http://mediumexposure.com/techblog/smart-image-resizing-while-preserving-transparency-php-and-gd-library
   5  // resizes a image, without crop
   6  // usage: resizeImage("test/6.jpg", "540", "720", true, "test/output.jpg")
   7  ////////////////////////////////////////////////////////////////////////////////////
   8  
   9  function resizeImage( $file, $width = 0, $height = 0, $proportional = false, $output = 'file') {
  10  	$info = getimagesize($file);
  11  	$image = '';
  12  	$final_width = 0;
  13  	$final_height = 0;
  14  	list($width_old, $height_old) = $info;
  15  	if ($proportional) {
  16  		if ($width == 0) $factor = $height/$height_old;
  17  		elseif ($height == 0) $factor = $width/$width_old;
  18  		else $factor = min ( $width / $width_old, $height / $height_old);  
  19  		$final_width = round ($width_old * $factor);
  20  		$final_height = round ($height_old * $factor);
  21  	}
  22  	else {
  23  		$final_width = ( $width <= 0 ) ? $width_old : $width;
  24  		$final_height = ( $height <= 0 ) ? $height_old : $height;
  25  	}
  26  	switch ( $info[2] ) {
  27  		case IMAGETYPE_GIF:
  28  			$image = imagecreatefromgif($file);
  29  		break;
  30  		case IMAGETYPE_JPEG:
  31  			$image = imagecreatefromjpeg($file);
  32  		break;
  33  		case IMAGETYPE_PNG:
  34  			$image = imagecreatefrompng($file);
  35  		break;
  36  		default:
  37  			return false;
  38  	}
  39          
  40  	$image_resized = imagecreatetruecolor( $final_width, $final_height );
  41  			
  42  	if ( ($info[2] == IMAGETYPE_GIF) || ($info[2] == IMAGETYPE_PNG) ) {
  43  		$trnprt_indx = imagecolortransparent($image);
  44  
  45  		if ($trnprt_indx >= 0) {
  46  			$trnprt_color    = imagecolorsforindex($image, $trnprt_indx);
  47  			$trnprt_indx    = imagecolorallocate($image_resized, $trnprt_color['red'], $trnprt_color['green'], $trnprt_color['blue']);
  48  			imagefill($image_resized, 0, 0, $trnprt_indx);
  49  			imagecolortransparent($image_resized, $trnprt_indx);
  50  		} 
  51  		elseif ($info[2] == IMAGETYPE_PNG) {
  52  			imagealphablending($image_resized, false);
  53  			$color = imagecolorallocatealpha($image_resized, 0, 0, 0, 127);
  54  			imagefill($image_resized, 0, 0, $color);
  55  			imagesavealpha($image_resized, true);
  56  		}
  57  	}
  58  	imagecopyresampled($image_resized, $image, 0, 0, 0, 0, $final_width, $final_height, $width_old, $height_old);    
  59          
  60  	switch ( strtolower($output) ) {
  61  		case 'browser':
  62  			$mime = image_type_to_mime_type($info[2]);
  63  			header("Content-type: $mime");
  64  			$output = NULL;
  65  		break;
  66  		case 'file':
  67  			$output = $file;
  68  		break;
  69  		case 'return':
  70  			return $image_resized;
  71  		break;
  72  		default:
  73  		break;
  74  	}
  75  	switch ( $info[2] ) {
  76  		case IMAGETYPE_GIF:
  77  			imagegif($image_resized, $output);
  78  		break;
  79  		case IMAGETYPE_JPEG:
  80  			imagejpeg($image_resized, $output);
  81  		break;
  82  		case IMAGETYPE_PNG:
  83  			imagepng($image_resized, $output);
  84  		break;
  85  		default:
  86  			return false;
  87  	}
  88  	return true;
  89  }
  90  ?>

<?
////////////////////////////////////////////////////////////////////////////////////
// generate a croped-image from a picture
// source: http://mediumexposure.com/techblog/smart-image-resizing-while-preserving-transparency-php-and-gd-library
// resizes a image, without crop
// usage: resizeImage("test/6.jpg", "540", "720", true, "test/output.jpg")
////////////////////////////////////////////////////////////////////////////////////

function resizeImage( $file, $width = 0, $height = 0, $proportional = false, $output = 'file') {
	$info = getimagesize($file);
	$image = '';
	$final_width = 0;
	$final_height = 0;
	list($width_old, $height_old) = $info;
	if ($proportional) {
		if ($width == 0) $factor = $height/$height_old;
		elseif ($height == 0) $factor = $width/$width_old;
		else $factor = min ( $width / $width_old, $height / $height_old);  
		$final_width = round ($width_old * $factor);
		$final_height = round ($height_old * $factor);
	}
	else {
		$final_width = ( $width <= 0 ) ? $width_old : $width;
		$final_height = ( $height <= 0 ) ? $height_old : $height;
	}
	switch ( $info[2] ) {
		case IMAGETYPE_GIF:
			$image = imagecreatefromgif($file);
		break;
		case IMAGETYPE_JPEG:
			$image = imagecreatefromjpeg($file);
		break;
		case IMAGETYPE_PNG:
			$image = imagecreatefrompng($file);
		break;
		default:
			return false;
	}
        
	$image_resized = imagecreatetruecolor( $final_width, $final_height );
			
	if ( ($info[2] == IMAGETYPE_GIF) || ($info[2] == IMAGETYPE_PNG) ) {
		$trnprt_indx = imagecolortransparent($image);

		if ($trnprt_indx >= 0) {
			$trnprt_color    = imagecolorsforindex($image, $trnprt_indx);
			$trnprt_indx    = imagecolorallocate($image_resized, $trnprt_color['red'], $trnprt_color['green'], $trnprt_color['blue']);
			imagefill($image_resized, 0, 0, $trnprt_indx);
			imagecolortransparent($image_resized, $trnprt_indx);
		} 
		elseif ($info[2] == IMAGETYPE_PNG) {
			imagealphablending($image_resized, false);
			$color = imagecolorallocatealpha($image_resized, 0, 0, 0, 127);
			imagefill($image_resized, 0, 0, $color);
			imagesavealpha($image_resized, true);
		}
	}
	imagecopyresampled($image_resized, $image, 0, 0, 0, 0, $final_width, $final_height, $width_old, $height_old);    
        
	switch ( strtolower($output) ) {
		case 'browser':
			$mime = image_type_to_mime_type($info[2]);
			header("Content-type: $mime");
			$output = NULL;
		break;
		case 'file':
			$output = $file;
		break;
		case 'return':
			return $image_resized;
		break;
		default:
		break;
	}
	switch ( $info[2] ) {
		case IMAGETYPE_GIF:
			imagegif($image_resized, $output);
		break;
		case IMAGETYPE_JPEG:
			imagejpeg($image_resized, $output);
		break;
		case IMAGETYPE_PNG:
			imagepng($image_resized, $output);
		break;
		default:
			return false;
	}
	return true;
}
?>

created by anonymous — 05 July 2008 — get a short url — tags: gd php resize — embed

resize image with crop

show/hide lines

   1  ////////////////////////////////////////////////////////////////////////////////////
   2  // generate a croped-image from a picture
   3  // source: http://www.seaton-online.com/forum/index.php?showtopic=545
   4  // usage: cropImage("300", "225", "test/5.jpg", "jpg", "test/output.jpg");
   5  ////////////////////////////////////////////////////////////////////////////////////
   6  
   7  function cropImage($nw, $nh, $source, $stype, $dest) {
   8           $size = getimagesize($source);
   9           $w = $size[0];
  10           $h = $size[1];
  11  
  12            switch($stype) {
  13                case 'gif':
  14                $simg = imagecreatefromgif($source);
  15                break;
  16                case 'jpg':
  17                $simg = imagecreatefromjpeg($source);
  18                break;
  19                case 'png':
  20                $simg = imagecreatefrompng($source);
  21                break;
  22            }
  23  
  24            $dimg = imagecreatetruecolor($nw, $nh);
  25            $wm = $w/$nw;
  26            $hm = $h/$nh;
  27            $h_height = $nh/2;
  28            $w_height = $nw/2;
  29  
  30            if($w> $h) {
  31                $adjusted_width = $w / $hm;
  32                $half_width = $adjusted_width / 2;
  33                $int_width = $half_width - $w_height;
  34                imagecopyresampled($dimg,$simg,-$int_width,0,0,0,$adjusted_width,$nh,$w,$h);
  35            } elseif(($w <$h) || ($w == $h)) {
  36                $adjusted_height = $h / $wm;
  37                $half_height = $adjusted_height / 2;
  38                $int_height = $half_height - $h_height;
  39                imagecopyresampled($dimg,$simg,0,-$int_height,0,0,$nw,$adjusted_height,$w,$h);
  40            } else {
  41                imagecopyresampled($dimg,$simg,0,0,0,0,$nw,$nh,$w,$h);
  42            }
  43  
  44            imagejpeg($dimg,$dest,80);
  45  }

////////////////////////////////////////////////////////////////////////////////////
// generate a croped-image from a picture
// source: http://www.seaton-online.com/forum/index.php?showtopic=545
// usage: cropImage("300", "225", "test/5.jpg", "jpg", "test/output.jpg");
////////////////////////////////////////////////////////////////////////////////////

function cropImage($nw, $nh, $source, $stype, $dest) {
         $size = getimagesize($source);
         $w = $size[0];
         $h = $size[1];

          switch($stype) {
              case 'gif':
              $simg = imagecreatefromgif($source);
              break;
              case 'jpg':
              $simg = imagecreatefromjpeg($source);
              break;
              case 'png':
              $simg = imagecreatefrompng($source);
              break;
          }

          $dimg = imagecreatetruecolor($nw, $nh);
          $wm = $w/$nw;
          $hm = $h/$nh;
          $h_height = $nh/2;
          $w_height = $nw/2;

          if($w> $h) {
              $adjusted_width = $w / $hm;
              $half_width = $adjusted_width / 2;
              $int_width = $half_width - $w_height;
              imagecopyresampled($dimg,$simg,-$int_width,0,0,0,$adjusted_width,$nh,$w,$h);
          } elseif(($w <$h) || ($w == $h)) {
              $adjusted_height = $h / $wm;
              $half_height = $adjusted_height / 2;
              $int_height = $half_height - $h_height;
              imagecopyresampled($dimg,$simg,0,-$int_height,0,0,$nw,$adjusted_height,$w,$h);
          } else {
              imagecopyresampled($dimg,$simg,0,0,0,0,$nw,$nh,$w,$h);
          }

          imagejpeg($dimg,$dest,80);
}

created by anonymous — 05 July 2008 — get a short url — tags: gd php resize — embed

hello kitty em php

show/hide lines

   1  <?php
   2  
   3  echo "hello kitty";
   4  
   5  ?>

<?php

echo "hello kitty";

?>

created by anonymous — 05 July 2008 — get a short url — tags: hellokitty php — embed

undescored para CameCase em PHP

Transforma uma string usando underscores para CamelCase

show/hide lines

   1  $name = 'we_love_code';
   2  preg_replace('/_([a-z])/e', 'strtoupper(\\1)', "_{$name}");

$name = 'we_love_code';
preg_replace('/_([a-z])/e', 'strtoupper(\\1)', "_{$name}");

created by rafaess — 04 July 2008 — get a short url — tags: camelcase php underscore — embed

codestacker

codestacker is a community to share snippets easily!

Login

Login

you are in: codestacker → codes [RSS] → tag: php [RSS]

wordpress popular posts

Send this to a friend

short url in wordpress with tinyurl

Send this to a friend

watermark

Send this to a friend

wordpress functions to count posts

Send this to a friend

php script for mysql backup

Send this to a friend

resize image

Send this to a friend

resize image with crop

Send this to a friend

hello kitty em php

Send this to a friend

undescored para CameCase em PHP

Send this to a friend