Thursday 15 September 2011

How to transfer a value on DB to JAVASCRIPT through PHP -



How to transfer a value on DB to JAVASCRIPT through PHP -

<?php // connect database server mysql_connect("192.168.1.101/phpmyadmin/", "root", "praticas") or die (mysql_error ()); // select database mysql_select_db("logs_history") or die(mysql_error()); //---> @ point, want yo pull value column called potencia_ativa , insert in // code js below mysql_query($strsql); // close database connection mysql_close(); ?> //js code------------------------------------------------------------------------------------------- <div id="graphholder" style="height:75%;width:100%"></div> <script type="text/javascript"> setinterval( function() { var d1 = []; (var = 0; < parseint(document.getelementbyid('number').value,10); += 0.5) { d1.push([ //----------> pull value php/db float ]); } $.plot("#graphholder", [{ label: "label", data: d1, lines: { show: true, fill: true } } ]); }, 1000); </script>

remember, php executes on server , generates page runs javascript on client. putting value php js code simple as:

<script> var foo = <?php echo json_encode('bar'); ?>; </script>

if need send php info on after page generated , send client, need have client execute ajax request fetch info server. 1 time php has shoved page out door, it's done , can't "reach out" client updates on own.

also: note utilize of json_encode(). should never dump output php straight javascript context without it. else puts @ risk of generating js syntax errors, kill entire js code block.

javascript php html database

No comments:

Post a Comment