Received: from agate.sge.net (agate.sge.net [152.91.14.27]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9GN52P01938 for ; Tue, 16 Oct 2001 19:05:02 -0400 (EDT) (envelope-from Ben.Westgarth@facs.gov.au) Received: from kulanite.sge.net (fosters.sge.net [152.91.9.15]) by agate.sge.net (Postfix) with ESMTP id 86CD94C366 for ; Wed, 17 Oct 2001 09:05:02 +1000 (EST) Received: from olivine3.sge.net (olivine3.sge.net [10.1.2.32]) by kulanite.sge.net (Postfix) with SMTP id 41C963B111 for ; Wed, 17 Oct 2001 09:04:58 +1000 (EST) Received: FROM cascade.sge.net BY olivine3.sge.net ; Wed Oct 17 09:05:06 2001 +1000 Received: by cascade.sge.net (Postfix, from userid 5) id A22B442915; Wed, 17 Oct 2001 09:06:56 +1000 (EST) Received: from nodnsquery(172.16.151.1) by cascade.sge.net via csmap (V6.0) id srcAAAvLaGmr; Wed, 17 Oct 01 09:06:55 +1000 Received: from facs.gov.au (unknown [10.18.20.57]) by bixbyite.sge.net (Postfix) with SMTP id 440DCA6412; Wed, 17 Oct 2001 09:03:50 +1000 (EST) Received: by facs.gov.au(Lotus SMTP MTA v4.6.7 (934.1 12-30-1999)) id CA256AE7.007EC5FF ; Wed, 17 Oct 2001 09:04:42 +1000 X-Lotus-FromDomain: FACS To: "ums san sankari" Cc: pgsql-php@postgresql.org Message-ID: Date: Wed, 17 Oct 2001 09:01:59 +1000 Subject: Re: Encrypt given Data Mime-Version: 1.0 Content-type: multipart/mixed; Boundary="0__=KHwPtAdLreBeZJN5yun0lw74R0BPP94iR1yVcdPX5XpXQa2T8c24leCF" Content-Disposition: inline From: Ben.Westgarth@facs.gov.au X-Archive-Number: 200110/68 X-Sequence-Number: 621 --0__=KHwPtAdLreBeZJN5yun0lw74R0BPP94iR1yVcdPX5XpXQa2T8c24leCF Content-type: text/plain; charset=us-ascii Content-Disposition: inline First of all, this is a list dedicated to php and POSTGRESQL, not Mysql. But because you are using php... It completely depends on how much security matters to you. For most purposes, the php function crypt( ) will do the job. It is pretty well covered by most of the php resources out there which is really where you should check first. Try the following: $encryptedPass = crypt($password, '.v'); This encrypts the string $password using the 2 character salt '.v' -you can change these characters as you like. AFAIK there is no way to decrypt this as such, so... - take user's login password and encrypt it using the same two character salt. - compare it against the encrypted password already stored in the database. If you need to more about this there are plenty of resources out there including php.net. And remember that in future this list is for POSTGRESQL users. There are other lists where you can post your mysql related questions. "ums san sankari" on 16/10/2001 22:16:13 Please respond to "ums san sankari" To: pgsql-php@postgresql.org cc: (bcc: Ben Westgarth/User/FaCS) Subject: [PHP] Encrypt given Data Greetings! Can u spent some times for me ?. I need the coding to encrypt the data given by the user and i have to store that details in mysql database.Send the coding as soon as possible.and also i have to decrypt the data -Uma ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org --0__=KHwPtAdLreBeZJN5yun0lw74R0BPP94iR1yVcdPX5XpXQa2T8c24leCF Content-type: application/octet-stream; name="att1.eml" Content-Disposition: attachment; filename="att1.eml" Content-transfer-encoding: base64 UmVjZWl2ZWQ6IGZyb20gYml4YnlpdGUuc2dlLm5ldCAoWzEwLjE4LjkuMV0p IGJ5IGZhY3MuZ292LmF1IChMb3R1cyBTTVRQIE1UQSB2NC42LjcgICg5MzQu MSAxMi0zMC0xOTk5KSkgd2l0aCBTTVRQIGlkIENBMjU2QUU3LjAwNkI4OTM3 OyBXZWQsIDE3IE9jdCAyMDAxIDA1OjM0OjM0ICsxMDAwDQpSZWNlaXZlZDog ZnJvbSBrdWxhbml0ZS5zZ2UubmV0IChrdWxhbml0ZTIuc2dlLm5ldCBbMTAu MS4yLjIyXSkNCglieSBiaXhieWl0ZS5zZ2UubmV0IChQb3N0Zml4KSB3aXRo IEVTTVRQIGlkIEU1Q0IyQTY0MDUNCglmb3IgPEJlbi5XZXN0Z2FydGhAZmFj cy5nb3YuYXU+OyBXZWQsIDE3IE9jdCAyMDAxIDA1OjMzOjQwICsxMDAwIChF U1QpDQpSZWNlaXZlZDogZnJvbSB0aG9yaXVtMi5zZ2UubmV0ICh0aG9yaXVt Mi5zZ2UubmV0IFsxMC4xLjIuMzZdKQ0KCWJ5IGt1bGFuaXRlLnNnZS5uZXQg KFBvc3RmaXgpIHdpdGggU01UUCBpZCAyQkM1MjNCMTExDQoJZm9yIDxCZW4u V2VzdGdhcnRoQGZhY3MuZ292LmF1PjsgV2VkLCAxNyBPY3QgMjAwMSAwNToz Mzo0MSArMTAwMCAoRVNUKQ0KUmVjZWl2ZWQ6IEZST00gY29vcGVycy5zZ2Uu bmV0IEJZIHRob3JpdW0yLnNnZS5uZXQgOyBXZWQgT2N0IDE3IDA1OjMzOjM5 IDIwMDEgKzEwMDANClJlY2VpdmVkOiBieSBjb29wZXJzLnNnZS5uZXQgKFBv c3RmaXgsIGZyb20gdXNlcmlkIDUpDQoJaWQgNDc5RTI3MzYxNTsgV2VkLCAx NyBPY3QgMjAwMSAwNTozNjowMyArMTAwMCAoRVNUKQ0KUmVjZWl2ZWQ6IGZy b20gbm9kbnNxdWVyeSgxNTIuOTEuMTQuMjYpIGJ5IGNvb3BlcnMuc2dlLm5l dCB2aWEgY3NtYXAgKFY2LjApDQoJaWQgc3JjQUFBWkthaTJFOyBXZWQsIDE3 IE9jdCAwMSAwNTozNjowMyArMTAwMA0KUmVjZWl2ZWQ6IGZyb20gcG9zdGdy ZXNxbC5vcmcgKHdlYm1haWwucG9zdGdyZXNxbC5vcmcgWzIxNi4xMjYuODUu MjhdKQ0KCWJ5IGlvbGl0ZS5zZ2UubmV0IChQb3N0Zml4KSB3aXRoIEVTTVRQ IGlkIDhFMzVDQkQzRg0KCWZvciA8QmVuLldlc3RnYXJ0aEBmYWNzLmdvdi5h dT47IFdlZCwgMTcgT2N0IDIwMDEgMDU6MzM6MjkgKzEwMDAgKEVTVCkNClJl Y2VpdmVkOiBmcm9tIHBvc3RncmVzcWwub3JnICh3ZWJtYWlsLnBvc3RncmVz cWwub3JnIFsyMTYuMTI2Ljg1LjI4XSkNCglieSBwb3N0Z3Jlc3FsLm9yZyAo OC4xMS4zLzguMTEuNCkgd2l0aCBTTVRQIGlkIGY5R0VEZFA1MjU5NTsNCglU dWUsIDE2IE9jdCAyMDAxIDEwOjEzOjM5IC0wNDAwIChFRFQpDQoJKGVudmVs b3BlLWZyb20gcGdzcWwtcGhwLW93bmVyK002MThAcG9zdGdyZXNxbC5vcmcp DQpSZWNlaXZlZDogZnJvbSBtYWlsd2ViMjkucmVkaWZmbWFpbC5jb20gKFsy MDMuMTk5LjgzLjE0OV0pDQoJYnkgcG9zdGdyZXNxbC5vcmcgKDguMTEuMy84 LjExLjQpIHdpdGggU01UUCBpZCBmOUdDR0NQMTYyNjQNCglmb3IgPHBnc3Fs LXBocEBwb3N0Z3Jlc3FsLm9yZz47IFR1ZSwgMTYgT2N0IDIwMDEgMDg6MTY6 MTIgLTA0MDAgKEVEVCkNCgkoZW52ZWxvcGUtZnJvbSB1bWFzaGFua2FyaXRA cmVkaWZmbWFpbC5jb20pDQpSZWNlaXZlZDogKHFtYWlsIDIwMjc5IGludm9r ZWQgYnkgdWlkIDUxMCk7IDE2IE9jdCAyMDAxIDEyOjE2OjEzIC0wMDAwDQpE YXRlOiAxNiBPY3QgMjAwMSAxMjoxNjoxMyAtMDAwMA0KTWVzc2FnZS1JRDog PDIwMDExMDE2MTIxNjEzLjIwMjc4LnFtYWlsQG1haWx3ZWIyOS5yZWRpZmZt YWlsLmNvbT4NClJlY2VpdmVkOiBmcm9tIHVua25vd24gKDIwMi4xNDEuMjQu MikgYnkgcmVkaWZmbWFpbC5jb20gdmlhIEhUVFA7IDE2IE9jdCAyMDAxIDEy OjE2OjEzIC0wMDAwDQpNSU1FLVZlcnNpb246IDEuMA0KRnJvbTogInVtcyBz YW4gc2Fua2FyaSIgPHVtYXNoYW5rYXJpdEByZWRpZmZtYWlsLmNvbT4NClJl cGx5LVRvOiAidW1zIHNhbiBzYW5rYXJpIiA8dW1hc2hhbmthcml0QHJlZGlm Zm1haWwuY29tPg0KVG86IDxwZ3NxbC1waHBAcG9zdGdyZXNxbC5vcmc+DQpT dWJqZWN0OiBbUEhQXSBFbmNyeXB0IGdpdmVuIERhdGENCkNvbnRlbnQtdHlw ZTogdGV4dC9wbGFpbjsNCgljaGFyc2V0PWlzby04ODU5LTENCkNvbnRlbnQt RGlzcG9zaXRpb246IGlubGluZQ0KQ29udGVudC1UcmFuc2Zlci1FbmNvZGlu ZzogOGJpdA0KWC1NSU1FLUF1dG9jb252ZXJ0ZWQ6IGZyb20gcXVvdGVkLXBy aW50YWJsZSB0byA4Yml0IGJ5IHBvc3RncmVzcWwub3JnIGlkIGY5R0RBQ00z NzA4MA0KUHJlY2VkZW5jZTogYnVsaw0KU2VuZGVyOiBwZ3NxbC1waHAtb3du ZXJAcG9zdGdyZXNxbC5vcmcNCg0KDQpHcmVldGluZ3MhDQoNCg0KICAgIENh biB1IHNwZW50IHNvbWUgdGltZXMgZm9yIG1lID8uIEkgbmVlZCB0aGUgY29k aW5nIHRvIGVuY3J5cHQgdGhlIGRhdGEgZ2l2ZW4gYnkgdGhlIHVzZXIgYW5k IGkgaGF2ZSB0byBzdG9yZSB0aGF0IGRldGFpbHMgaW4gbXlzcWwgZGF0YWJh c2UuU2VuZCB0aGUgY29kaW5nIGFzIHNvb24gYXMgcG9zc2libGUuYW5kIGFs c28gaSBoYXZlIHRvIGRlY3J5cHQgdGhlIGRhdGEgIA0KDQotVW1hIA0KDQoN Ci0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0 KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KVElQIDY6IEhhdmUgeW91 IHNlYXJjaGVkIG91ciBsaXN0IGFyY2hpdmVzPw0KDQpodHRwOi8vYXJjaGl2 ZXMucG9zdGdyZXNxbC5vcmcNCg== --0__=KHwPtAdLreBeZJN5yun0lw74R0BPP94iR1yVcdPX5XpXQa2T8c24leCF--