I was wondering how to get values from mysql?
In php i would use something like
$sql = mysql_query("SELECT * FROM table");
while($row = mysql_fetch_array($sql)){
$value = $row['name'];
}
But how do I get something from $value in jquery? Say I want to use a value from $value and put in a
var Value = $value;
or something like that?
Thank you
var Value = <?php echo json_encode($value) ?>;
Assuming $value contains a string, it will be encoded as ".." after escaping any double quote characters present in the string itself.
You're trying to combine server-side scripting with client-side scripting here. I suggest you output data from your PHP code like this:
<div id="myDiv"><?php echo $value; ?></div>
and then write your jQuery code to pick it from there:
var Value = $('#myDiv').text();
<div node in your document whose only purpose is passing the value, which is kinda dirty. And the answer by @Anurang just outputs the string inside your <script> tag.You could do something like:
var Value = "<?php echo $value ?>";
<script type='text/javascript'>
var value = <?php echo "'$value'"; ?>
</script>
