Monthly Archives: maio 2010

A emocionante vida de um programador.

Extend no PHP

Essa encontrei na net, simples exemplo de como criar herança no PHP usando OOP. Daqui a pouco vou postar uma class que estou fazendo no trabalho para conexão ao MySQL.

abs

<?php
abstract class Mamifero
{
    private $habitat;
    private $no_patas;

    protected function setHabitat ($habitat)
    {
    	$this->habitat = $habitat;
    }

    protected function setNoPatas ($integer)
    {
    	$this->no_patas = $integer;
    }
}
?>

setHabitat ('terrestre');
        	$this->setNoPatas (2);
	}

	public function fala ($texto)
	{
        	echo $texto;
	}
}
?>

ABAP – Lendo dados de um arquivo

Olá, é bem fácil ler um arquivo utilizando o ABAP para preservar os dados no SAP. Abaixo um código de simples utilização

" Nome do Programa
REPORT ZCHAP2604.
* Um parameter para a importação do arquivo
PARAMETERS FILENAME(128) DEFAULT 'c:\users\default\testfile.dat'
LOWER CASE.
" Tabela customers.
TABLES CUSTOMERS.
" Declaração da variavel all_customers
" Do mesmo tipo da estrutura CUSTOMERS
" Com linha de header para cabeçalho
DATA: ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE.

" Função standard para upload
CALL FUNCTION 'WS_UPLOAD'
EXPORTING
FILENAME = FILENAME
TABLES
DATA_TAB = ALL_CUSTOMERS
EXCEPTIONS
FILE_OPEN_ERROR = 1
OTHERS = 2.
CASE SY-SUBRC.
WHEN 1.
WRITE 'Erro para abrir!'.
EXIT.
WHEN 2.
WRITE 'Erro na transferência'.
EXIT.
ENDCASE.
* O resultado da tabela interna no programa
LOOP AT ALL_CUSTOMERS.
WRITE: / ALL_CUSTOMERS-NAME,
ALL_CUSTOMERS-CITY.
ENDLOOP.

Abss…
Léo

SQL – Limit em diferentes bases de dados

Todo mundo já usou o Limit para fazer uma paginação, por exemplo, vejamos como criar um limit nos três banco de dados mais “famosos”..rs


// mysql
select col from tbl limit 20;

// Oracle
select col from tbl where rownum<=20;

// Microsoft SQL
select top 20 col from tbl;

// Firebird
select first 5 * from clientes // Primeiro 5 registros
select last 5 * from clientes // Últimos 5 registros

// DB2 da IBM
// Os 5 primeiros somente
select * from clientes fetch first 5 rows only

// PostgresSQL
SELECT * FROM tbl LIMIT 1 OFFSET 5

Acho que dá para ajudar em alguma coisa né...rs

abs
léo

iPad – Detectando iPad com diferentes plataformas

A Apple vendeu, somente nos EUA, 700 mil iPad no primeiro final de semana do lançamento oficial. Vejamos agora como identificar, em diferentes plataformas, o tablet da Apple.

Usando o bom e velho JavaScript:

var iPad = navigator.userAgent.match(/iPad/i) != NULL;

Usando o nosso amigo PHP

$VAR = strpos($_SERVER["HTTP_USER_AGENT"],"ipad"); // VERDADEIRO OU FALSO

Usando o bom e VELHO asp clássico :-)

request.servervariables("http_user_agent") == "iPad"

Em ASP.net tem mais ou menos uma maneira

Dim ServerVar, tmpValue As String
For Each ServerVar In Request.ServerVariables
    tmpValue = Request.ServerVariables(ServerVar)
    Response.Write(ServerVar & " = " & tmpValue & "")
Next

Para o .Net tem uma lista com os SERVERS_Variables…

ALL_HTTP
Returns all HTTP headers sent by the client. Always prefixed with HTTP_ and capitalized

ALL_RAW
Returns all headers in raw form

APPL_MD_PATH
Returns the meta base path for the application for the ISAPI DLL

APPL_PHYSICAL_PATH
Returns the physical path corresponding to the meta base path

AUTH_PASSWORD
Returns the value entered in the client's authentication dialog

AUTH_TYPE
The authentication method that the server uses to validate users

AUTH_USER
Returns the raw authenticated user name

CERT_COOKIE
Returns the unique ID for client certificate as a string

CERT_FLAGS
bit0 is set to 1 if the client certificate is present and bit1 is set to
1 if the cCertification authority of the client certificate is not valid

CERT_ISSUER
Returns the issuer field of the client certificate

CERT_KEYSIZE
Returns the number of bits in Secure Sockets Layer connection key size

CERT_SECRETKEYSIZE
Returns the number of bits in server certificate private key

CERT_SERIALNUMBER
Returns the serial number field of the client certificate

CERT_SERVER_ISSUER
Returns the issuer field of the server certificate

CERT_SERVER_SUBJECT
Returns the subject field of the server certificate

CERT_SUBJECT
Returns the subject field of the client certificate

CONTENT_LENGTH
Returns the length of the content as sent by the client

CONTENT_TYPE
Returns the data type of the content

GATEWAY_INTERFACE
Returns the revision of the CGI specification used by the server

HTTP_
Returns the value stored in the header HeaderName

HTTP_ACCEPT
Returns the value of the Accept header

HTTP_ACCEPT_LANGUAGE
Returns a string describing the language to use for displaying content

HTTP_COOKIE
Returns the cookie string included with the request

HTTP_REFERER
Returns a string containing the URL of the page that
referred the request to the current page using an  tag.
If the page is redirected, HTTP_REFERER is empty

HTTP_USER_AGENT
Returns a string describing the browser that sent the request

HTTPS
Returns ON if the request came in through secure channel or
OFF if the request came in through a non-secure channel

HTTPS_KEYSIZE
Returns the number of bits in Secure Sockets Layer connection key size

HTTPS_SECRETKEYSIZE
Returns the number of bits in server certificate private key

HTTPS_SERVER_ISSUER
Returns the issuer field of the server certificate

HTTPS_SERVER_SUBJECT
Returns the subject field of the server certificate

INSTANCE_ID
The ID for the IIS instance in text format

INSTANCE_META_PATH
The meta base path for the instance of IIS that responds to the request

LOCAL_ADDR
Returns the server address on which the request came in

LOGON_USER
Returns the Windows account that the user is logged into

PATH_INFO
Returns extra path information as given by the client

PATH_TRANSLATED
A translated version of PATH_INFO that takes the path
and performs any necessary virtual-to-physical mapping

QUERY_STRING
Returns the query information stored in the string
following the question mark (?) in the HTTP request

REMOTE_ADDR
Returns the IP address of the remote host making the request

REMOTE_HOST
Returns the name of the host making the request

REMOTE_USER
Returns an unmapped user-name string sent in by the user

REQUEST_METHOD
Returns the method used to make the request

SCRIPT_NAME
Returns a virtual path to the script being executed

SERVER_NAME
Returns the server's host name, DNS alias, or
IP address as it would appear in self-referencing URLs

SERVER_PORT
Returns the port number to which the request was sent

SERVER_PORT_SECURE
Returns a string that contains 0 or 1. If the request
is being handled on the secure port, it will be 1. Otherwise, it will be 0

SERVER_PROTOCOL
Returns the name and revision of the request information protocol

SERVER_SOFTWARE
Returns the name and version of the server software
that answers the request and runs the gateway

URL
Returns the base portion of the URL

Bom gente é só uma idéia para testar… só q não testei pq estou com preguiça..rs

abss