Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function connecToDatabase(){
- $host = "localhost";
- $username = "root";
- $password = "p@ssword";
- $database = "flood_reports";
- mysql_connect("$host", "$username", "$password") or die(mysql_error());
- mysql_select_db("$database") or die(mysql_error());
- }
- function retrieveData(){
- connecToDatabase();
- $data = mysql_query('SELECT * FROM entries') or die(mysql_error());
- $entries = array();
- $index = 0;
- while($info = mysql_fetch_array( $data ))
- {
- $entries[$index] = array('entry_id' => $info['entry_id'],
- 'location' => $info['location'],
- 'image_dir' => $info['image_dir'],
- 'longitude' => $info['longitude'],
- 'latitude' => $info['latitude'],
- 'level' => $info['level']);
- $index++;
- }
- $json = json_encode($entries);
- echo $json;
- mysql_close();
- }
- retrieveData();
- ?>
- <script type="text/javascript">
- var jsvar = <?php echo $phpvar;?>
- </script>
- echo $json;
- echo 'var fromPhp = ' . $json . ';';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement