Fortis Central Forum
September 19, 2019, 04:59:02 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Brotherhood above all circumtances  -  Fortis Central is Unity
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Function Encrpyt di MySQL  (Read 2881 times)
0 Members and 1 Guest are viewing this topic.
ggkk


Karma: +0/-0
Offline Offline

Posts: 7



View Profile
« on: July 01, 2009, 08:56:07 AM »

Numpang tanya masih newbie di PHP & MySQL, di MySQL ada beberapa function untuk melakukan encrpryt saat nilai suatu atribut diinputkan seperti MD5,Password, dsb.
1. Nah diantaranya manakah yg biasanya paling sering digunakan?
2. Kalau dah diencrpyt apa pas querynya di PHP butuh function khusus dari PHP?

misal  : $sql = "SELECT nama,umur FROM siswa WHERE nama = password('$fm_nama')";  -> Utk function encrypt yg password

terima kasih ya , mohon petunjuknya
Logged

2 Hard 4 lose
Seraphim
Executive Manager
***

Karma: +0/-0
Offline Offline

Posts: 268


Owen Ario Hendrawan, S.KOM


View Profile
« Reply #1 on: July 01, 2009, 01:28:43 PM »

Woi.... mana neh cah sama edwin nih yang jago PHP

Ngomong" ggkk intro dulu donk disini, khan ada pepatah tak kenal maka tak sayang.

Hehehe
Logged

Frozt86
Executive Manager
***

Karma: +0/-0
Offline Offline

Posts: 129



View Profile
« Reply #2 on: July 01, 2009, 07:27:34 PM »

Berdasarkan yang saya lihat dari MYSQL Manual Documentation alias HELP ada banyak sekali function..

AES_DECRYPT() --> Decrypt using AES
AES_ENCRYPT() --> Encrypt using AES
COMPRESS()(v4.1.1) --> Return result as a binary string
DECODE() --> Decodes a string encrypted using ENCODE()
DES_DECRYPT() --> Decrypt a string
DES_ENCRYPT() --> Encrypt a string
ENCODE() --> Encode a string
ENCRYPT() --> Encrypt a string
MD5() --> Calculate MD5 checksum
OLD_PASSWORD()(v4.1) --> Return the value of the old (pre-4.1) implementation of PASSWORD
PASSWORD() --> Calculate and return a password string
SHA1(), SHA() --> Calculate an SHA-1 160-bit checksum
UNCOMPRESS()(v4.1.1) --> Uncompress a string compressed
UNCOMPRESSED_LENGTH()(v4.1.1) --> Return the length of a string before compression

anda bisa pake
1. AES_ENCRYPT(), AES_DECRYPT()
parameter
- AES_ENCRYPT(str,key_str)
- AES_DECRYPT(crypt_str,key_str)
2. DES_ENCRYPT(), DES_DECRYPT()
parameter
- DES_ENCRYPT(str[,{key_num|key_str}])
- DES_DECRYPT(crypt_str[,key_str])
3. ENCODE(), DECODE()
parameter
- ENCODE(str,pass_str)
- DECODE(crypt_str,pass_str)

untuk lebih lanjut, silahkan kunjungi dan download Documentation-nya (HELP, API, MANUAL) di http://dev.mysql.com/doc/


PHP..
ada juga sih.. dan lebih banyak...
silahkan kunjungi dan download Documentation-nya (HELP, API, MANUAL) di http://www.php.net/docs.php

semoga membantu...
Logged
Seraphim
Executive Manager
***

Karma: +0/-0
Offline Offline

Posts: 268


Owen Ario Hendrawan, S.KOM


View Profile
« Reply #3 on: July 03, 2009, 03:26:31 AM »

Wogh... jangan bilang km juga lagi belajar menguasai PHP den... ckckckckckck  Shocked  Shocked  Shocked
Logged

Frozt86
Executive Manager
***

Karma: +0/-0
Offline Offline

Posts: 129



View Profile
« Reply #4 on: July 03, 2009, 10:32:57 AM »

ga.. cuman punya manualnya doank.. tinggal search aja dah nemu kok...
Logged
Fluckz
Executive Manager
***

Karma: +0/-0
Offline Offline

Posts: 72


Aditya Eka Nugraha, S.Kom


View Profile
« Reply #5 on: September 16, 2009, 09:21:06 PM »

saya bingung kalau belajar PHP mulai darimana sekarang.... Huh? Huh? Huh? banyak fungsi2 baru, aplikasi web yg sangat cepat berkembangnya...fiuhhh....ada yg punya saran?
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by SMF 1.1.8 | SMF © 2006-2008, Simple Machines LLC
Theme updated by Runic Warrior.  Originally Designed by m3talc0re.
Page created in 0.024 seconds with 21 queries.