Store JavaScript Result In Php variable

Question

I have Some Passwords which contain some special and methimatical chracters like this password "HHE1134ƒ" if i want to generate password with php md5() then this not give me correct hashes like this "679b6dc6122a9c83ed31476ee82af36e".

So i have Java Script which can generate correct hash for my passwords But how can i store this value to mysql

my code is given below please Help Me.

$result = mysql_query("SELECT * FROM `table`") or die(mysql_error());

while ($row = mysql_fetch_assoc($result))
{

$user_id = $row['user_id'];
$firstname = $row['firstname'];
$lastname = $row['lastname'];
$spno = $row['spno'];
$password = $row['password'];

$tmp =  "<script type='text/javascript'> document.write(MD5('".$password."'));</script>";

$query1="UPDATE `wp_110504users` SET `user_pass` = '$tmp' WHERE `user_login` = '$user_id'";

mysql_query($query1) or die(mysql_error());
}

this will give me error like

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'text/javascript'> document.write(MD5('HW72'));' WHERE `user_login` = '0' at line 1

?>

Some one tell me use Ajax, Please tell me how can i use Ajax for this code can you give me an example .....

You know that your javascript-code is not going to be parsed and interpreted by the PHP interpeter? — Jacob
– Jacob, Commented Jul 19, 2011 at 8:17
are you trying to implement client-side logic on server-side? — Alex Ackerman
– Alex Ackerman, Commented Jul 19, 2011 at 8:18
This gets asked a couple of times a week. Did you not think to search for existing questions first? — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Jul 19, 2011 at 8:19
I've honestly never seen someone try to write a script tag that uses document.write to write an MD5 hash into a PHP variable to insert into a SQL query (by magic, since $userpass is never used). I don't think any search would pull this up, Tomalak. — Dan Grossman
– Dan Grossman, Commented Jul 19, 2011 at 8:22

Dan Grossman · Accepted Answer · 2011-07-19 08:17:42Z

3

You cannot run JavaScript code inside your PHP code on the server. The PHP interpreter only interprets PHP code.

You don't need to, both MySQL and PHP have md5 functions to compute those hashes as well.

answered Jul 19, 2011 at 8:17

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paul · Accepted Answer · 2011-07-19 08:30:50Z

2

Javascript doesn't run until it reaches the user's browser. This is called client side.

PHP is server side. All your PHP code executes before the web page is delivered to the user. Then your Javascript is executed on their own computer, by their web browser.

The only way to send something from Javascript to the server is using Ajax. You could look into it, but I don't think you should at your current experience level with the two languages. How long have you been using them for?

You can just use the md5() function which is built right into php btw: http://php.net/manual/en/function.md5.php

edited Jul 19, 2011 at 8:30

answered Jul 19, 2011 at 8:19

Paul

142k28 gold badges285 silver badges272 bronze badges

3 Comments

Mohammad Umer Over a year ago

Yes you are right but i have some passwords which is not working with php md5 function like this password "HHE1134ƒ"

Mohammad Umer Over a year ago

if you have any function to generate a correct like this "679b6dc6122a9c83ed31476ee82af36e" for this password "HHE1134ƒ" with php please tell me

WooCaSh Over a year ago

when i type in php: echo md5('HHE1134ƒ'); i get: 679b6dc6122a9c83ed31476ee82af36e So where is Your problem?

Alex Ackerman · Accepted Answer · 2011-07-19 08:19:42Z

1

Use php native md5 function:

md5($password);

answered Jul 19, 2011 at 8:19

Alex Ackerman

1,34113 silver badges14 bronze badges

Comments

Tobias · Accepted Answer · 2011-07-19 08:18:06Z

0

PHP is interpreted before javascript reaches the browser. You cannot do this that way. Read more about AJAX, this will help you.

BTW: why are you generating md5 hashes with javascript?

answered Jul 19, 2011 at 8:18

Tobias

7,40311 gold badges51 silver badges82 bronze badges

Comments

Aif · Accepted Answer · 2011-07-19 08:18:35Z

0

This is very normal, you userpass value will just be <script type.... Javascript is a client side scripting language, whereas php runs server side, how would you want your md5 to be interpreted server-side?

What you can do, is hash the password before sending it, but it would make you trust the visitor, what you should never do, or simply use php function for md5 hashing.

answered Jul 19, 2011 at 8:18

Aif

11.3k1 gold badge32 silver badges44 bronze badges

Comments

Timur · Accepted Answer · 2011-07-19 08:19:26Z

0

I think you copy-pasted code not correctly. According to error, you trying to put $userpass variable in SQL statement, but, in code, you are using $tmp variable, which is not defined at all.

answered Jul 19, 2011 at 8:19

Timur

6,7381 gold badge30 silver badges37 bronze badges

Comments

WooCaSh · Accepted Answer · 2011-07-19 08:20:18Z

0

Try this:

$tmp = md5($password);
$query1="UPDATE `wp_110504users` SET `user_pass` = '$tmp' WHERE `user_login` = '$user_id'";

Also u can use MySQL function:

$query1="UPDATE `wp_110504users` SET `user_pass` = MD5('$tmp') WHERE `user_login` = '$user_id'";

answered Jul 19, 2011 at 8:20

WooCaSh

5,2225 gold badges39 silver badges55 bronze badges

Collectives™ on Stack Overflow

Store JavaScript Result In Php variable

7 Answers 7

Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related