accessing database values in javascript

[pswathi]

Well

The situation is we are using mysql.We have written the queries and extracted the result from the assoc array.Now how do we access the result from javascript.

$query = "SELECT firstname FROM employees;
$result = mysql_query( $query , $resource );
$value= mysql_fetch_assoc( $result);
extract( $value );

Now does the javascript code be like
<script type="text/javascript">
function somefunction(){
var databasefield = document.getElementsByName("firstname").value;
}
</script>

[skywalker2208]

It all depends on what you want to do. If you are just trying to use the info in javascript then you could always do something like
<script type="text/javascript">
var databasefield = '<?php echo $firstname; ?>';
</script>


However, if the field can change because it is in a textbox then you can access the info from the form by document.yourformname.formelementname.value.

I think what is best if you try to give us more detail about what exactly you are trying to accomplish because just saying you want to access information from database with javascript could be done in many different ways.

[pswathi]

Okay the thing is i have to compare the value the user entered in a textfield to the value entered in the database.

i am storing the textfield value in a php variable and when ever the user moves out of the field i am using the onBlur event and triggering a javascript function.In this javascript function i have to do a comparison and based on the result there should be an alert.

It all depends on what you want to do. If you are just trying to use the info in javascript then you could always do something like
<script type="text/javascript">
var databasefield = '<?php echo $firstname; ?>';
</script>


However, if the field can change because it is in a textbox then you can access the info from the form by document.yourformname.formelementname.value.

I think what is best if you try to give us more detail about what exactly you are trying to accomplish because just saying you want to access information from database with javascript could be done in many different ways.

[pswathi]

I am sorry,the textfield the user entered is compared to the value retrieved from the db.

Okay the thing is i have to compare the value the user entered in a textfield to the value entered in the database.

i am storing the textfield value in a php variable and when ever the user moves out of the field i am using the onBlur event and triggering a javascript function.In this javascript function i have to do a comparison and based on the result there should be an alert.

[skywalker2208]

Then I would suggest doing one of two things. Either use ajax and have it return the value you need or do something like this

<?php
$firstname = query database for first name
?>
<script type="text/javascript">
function compare() {
var databasefield = '<?php echo $firstname; ?>';
}
</script>

If you are checking more then one value like the first name and last name, etc then you use the json_encode php function.

Then you could do something like

<?php
$user_data = array('firstname' => 'Joe', 'lastname' => 'Smith');
?>
<script type="text/javascript">
var user_data = <?php echo json_encode($user_data); ?>;
alert(user_data.firstname); //This creates a pop with the name Joe in it.
</script>