Submit a Snippet
Search Snippets
New Snippets
Top Snippets
PHP (135) JavaScript (123) Java (65) VBSCRIPT (58) String (44) CSS (31) CSharp (28) File (28) HTML (27) C (24) mysql (24) VB.NET (24) CPlusPlus (23) groovy (23) Random (20)
Removing doubles ... IE Explorer Proxy... calculating md5 i... tabless form usin... find if array con... Rapleaf Address B... Javascript port o... hash sha1 URL Regular Expre... Email address val...Venture Capital Jobs
Snippet Menu
-SV
Keep doing the good work!
I am implementing your code and I would know if you could show some information about how you encrypt the password to the database?
My email address is zsnoop@gmail.com
Thanks and best regards
Zs
INSERT INTO login (loginname,password)
VALUES ('$loginname',password('$pass'))
SELECT loginid
FROM login
WHERE loginname = '$loginname'
AND password = password('$pass')
Please see the implementation:
$activation_hash = md5( $username . $password . time() );
// Insert query (has to be adapted for php)
INSERT INTO login (username,password,activation_hash)
VALUES ('$username', MD5('$password') , '$activation_hash' )
// Select query (has to be adapted for php)
SELECT loginid, password, activation_hash
FROM login
WHERE username = '$username'
//Check if the password entered is correct
if (md5($password) == $activation_hash)
{
echo "User Authenticated Correctly";
}
what arguments the code need?
Im realy new in stored procedured.
Stored Routines were introduced in MySQL 5.0, so you need that version or later. The snippet shows the "extra stuff" you need to create the procedure prc_hereiam.
Additional input parameters would be separated by commas.
DROP PROCEDURE if EXISTS `prc_hereiam`;
delimiter //
CREATE PROCEDURE prc_hereiam (varPHPSessID VARCHAR(32))
BEGIN
DECLARE outLoginId INT;
DECLARE outMemberLevel INT;
... rest of the code goes here
COMMIT;
END;
//
delimiter ;
CREATE PROCEDURE prc_procedurename (inputValue INT, inputAnother INT)