<?php
    phpinfo();
?>

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

    CREATE  PROCEDURE sp_Easypaging 

	(
	
	@Tables varchar(1000),
	@PK varchar(100),
	@JoinStatements varchar(1000)='',
	@Fields varchar(5000) = '*',
	@Filter varchar(5000) = NULL,
	@Sort varchar(200) = NULL,
	@PageNumber int = 1,
	@PageSize int = 10,
	@TotalRec int =0 Output,
	@Group varchar(1000) = NULL
	
		
	)

AS



/*
Created by Kashif Akram
Email Muhammad_kashif@msn.com

The publication rights are reserved  
You can use this procedure with out removing these comments 
*/



DECLARE @strPageSize varchar(50)
DECLARE @strStartRow varchar(50)


SET @strPageSize = CAST(@PageSize AS varchar(50))
SET @strStartRow = CAST(((@PageNumber - 1)*@PageSize + 1) AS varchar(50))



--set @PK =' tbl_Items.ItemID '

create table #PageTable (PID  bigint primary key IDENTITY (1, 1) , UID int)
create table #PageIndex (UID int)

/*
CREATE UNIQUE CLUSTERED
  INDEX [PK_tbl_PageTable] ON #PageTable (PID)
*/
CREATE  
  INDEX [PK_tbl_PageIndex] ON #PageIndex (UID)


--'SELECT ' + @Fields + ' FROM ' + @Tables + '' + @JoinStatements +' WHERE ' + @strSortColumn + @operator + ' @SortColumn ' + @strSimpleFilter + ' ' + @strGroup + ' ORDER BY ' + @Sort +  ' DESC '
exec ('

set rowcount 0

	insert into #pageTable(UID) 
	 SELECT ' + @PK + ' FROM ' + @Tables + ' ' + @JoinStatements +' WHERE ' +  @Filter + ' ' + @Group + ' ORDER BY ' + @Sort +  ' 


DECLARE @SortColumn int

SET ROWCOUNT '+  @strStartRow +'

select  @SortColumn=PID from #PageTable --option (keep plan)

print @SortColumn

SET ROWCOUNT '+  @strPageSize +'

insert into #pageIndex
select UID from #PageTable where PID >= @SortColumn -- option (keep plan)


          
SELECT ' + @Fields + ' FROM ' + @Tables + ' ' + @JoinStatements +' WHERE ' +  @Filter + ' and  '+ @PK + ' in (Select UID from #pageIndex)' + @Group + ' ORDER BY ' + @Sort +  ' '

 )



select @TotalRec=count(*) from  #pageTable 





drop table #PageTable 
drop table #PageIndex


	
RETURN 

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

10 print "Hola mundo"

if (!function_exists('subsent')) {

   function subsent($string, $start = 0, $length = 0, $cap = '...') {

      if ($length <= 0 || strlen($string) < $length) { return $string; }

      $string = substr($string, $start, strpos($string, ' ', $length)) . ' ' . $cap;

      return $string;

   }

}

$image_name = md5(uniqid(rand())).".jpg";

def pi():
    # Compute digits of Pi.
    # Algorithm due to LGLT Meertens.
    k, a, b, a1, b1 = 2, 4, 1, 12, 4
    while 1:
        p, q, k = k*k, 2*k+1, k+1
        a, b, a1, b1 = a1, b1, p*a+q*a1, p*b+q*b1
        d, d1 = a//b, a1//b1
        while d == d1:
            yield d
            a, a1 = 10*(a%b), 10*(a1%b1)
            d, d1 = a//b, a1//b1

function check_nome ($nome) {
		$busca = array (
			'á','é','í','ó','ú','à','è','ì','ò','ù',
			'â','ê','î','ô','û','ä','ë','ï','ö','ü',
			'Á','É','Í','Ó','Ú','À','È','Ì','Ò','Ù',
			'Â','Ê','Î','Ô','Û','Ä','Ë','Ï','Ö','Ü',
			'ñ','Ñ','ç','Ç',' ','(',')','?','¿','/',
			'#','º','ª','!','·','#','%','¬','=','¡',
			'^',';','"',"'",'+','[',']','{','}',';',
			'~','¤','¶','ø','þ','æ','ß','ð','«','»',
			'¢','µ','€','\\',':','*','<','>','|','$',
			'&','@');
		$cambia = array (
			'a','e','i','o','u','a','e','i','o','u',
			'a','e','i','o','u','a','e','i','o','u',
			'A','E','I','O','U','A','E','I','O','U',
			'A','E','I','O','U','A','E','I','O','U',
			'n','N','c','C','_','_','_','_','_','_',
			'_','o','a','_','_','_','_','_','_','_',
			'_','_','_','_','_','_','_','_','_','_',
			'_','_','_','_','_','_','_','_','_','_',
			'_','_','_','_','_','_','_','_','_','_',
			'_','_');

	return str_replace($busca, $cambia, trim($nome));
}

function querystringWithoutParameter($parametro){
	return preg_replace('/[\&\?]+'.$parametro.'=[^\&]*/','',$_SERVER['QUERY_STRING']);
}

function xmlattribute($value){
	return str_replace('&','&',str_replace('"','"',$value));
}

<!-- Search flickr -->

<form method=GET action="http://www.flickr.com/search/" target="_blank">

<input type=hidden name=w value="38901813@N00">

<input type=hidden name=m value="text">

<input type=text name=q size=25 maxlength=255 value="">

<input type=submit value="Flickr Search">

</form>

<!-- Search flickr -->