Jump to content

How Can I Best Adapt A Php File To Prevent Page Refresh?

wright67uk

By wright67uk
in Javascript Help

 Share

Recommended Posts

wright67uk Advanced Member

wright67uk

Posted
Posted

I have a php file which grabs data from my MySQL db, and displays the results in a javascript graph.

 

I'm using the $year variable in an sql query, and give my users an option to select a years worth of results at a time.

 

When the user selects a different year, in the code below, my browser refreshes and a new sql query is run.

 

Is it possible to use Ajax rather than php, to change the year?

 

If so... How much code would I need to change?

 

 $year = (isset($_GET['year'])) ? (int)$_GET['year'] : date('Y');
$year_links = '';
$_GET['year'] = $year-1; 
$year_links .= "<a href='?" . http_build_query($_GET, '', '&') . "'>-</a> ";
$year_links .= " $year ";
$_GET['year'] = $year+1; 
$year_links .= " <a href='?" . http_build_query($_GET, '', '&') . "'>+</a>";
[Code/]
 
My full file...
 
[Code]
 <!DOCTYPE HTML>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
		<title> Ranges</title>
        <?php
 
 
 
 
$connect_solning = mysql_connect($hostname_connect, $username_connect, $password_connect) or trigger_error(mysql_error(),E_USER_ERROR);
 
@mysql_select_db($database_connect) or die (mysql_error()); 
 
$tbl_name = "snag";
$user_id = $_POST["user_id"];
 
$year = (isset($_GET['year'])) ? (int)$_GET['year'] : date('Y');
$year_links = '';
$_GET['year'] = $year-1; 
$year_links .= "<a href='?" . http_build_query($_GET, '', '&') . "'>-</a> ";
$year_links .= " $year ";
$_GET['year'] = $year+1; 
$year_links .= " <a href='?" . http_build_query($_GET, '', '&') . "'>+</a>";
 
 
 $sql = "SELECT user_id, fname, lname FROM registration"; $result = mysql_query($sql);
 
$selected_id = isset($_POST['user_id']) ? intval($_POST['user_id']) : false; 
$who = ''; 
$options = ''; 
while ($row=mysql_fetch_array($result)) { if($selected_id==$row['user_id']) 
{ $who = "{$row['fname']} {$row['lname']}"; 
$selected = ' selected="selected"'; } else { $selected = ''; } 
$options .= "<option value=\"{$row['user_id']}\"{$selected}>{$row['fname']} 
{$row['lname']}</option>\n"; } 
 
?>
 
 
 
<style type="text/css">
a:link {text-decoration:none;}
</style>
 
 
 
		<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
		<script type="text/javascript">
$(function () {
    var chart;
    $(document).ready(function() {
        chart = new Highcharts.Chart({
            chart: {
                renderTo: 'container',
                type: 'line',
                marginRight: 130,
                marginBottom: 25
            },
            title: {
                text: '<?php echo $year ?> Ranges by Club for <?php echo $who ?>',
                x: -20 //center
            },
            subtitle: {
                text: 'Averages for month',
                x: -20
            },
            xAxis: {
                categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
                    'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'] 		
            },
            yAxis: {
                title: {
                    text: 'Score'
                },
                plotLines: [{
                    value: 0,
                    width: 1,
                    color: '#808080'
                }]
            },
            tooltip: {
                formatter: function() {
                        return '<b>'+ this.series.name +'</b><br/>'+
                        this.x +': '+ this.y +'';
                }
            },
            legend: {
                layout: 'vertical',
                align: 'right',
                verticalAlign: 'top',
                x: -10,
                y: 100,
                borderWidth: 0
            },
            series: [{
                name: 'Driver',
                data: 
				[<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = 'Driver' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
            }, {
                name: '3 Wood',
                data: 
				[<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '3 wood' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
            }, {
                name: '5 Wood',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '5 wood' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
				/* SELECT yard FROM `snag` WHERE club = '5 wood' AND user_id = 1 */
            }, {
                name: 'Hybrid',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = 'Hybrid' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: '3 iron',
                data:[<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '3 iron' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: '4 iron',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '4 iron' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: '5 iron',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '5 iron' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: '6 iron',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '6 iron' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: '7 iron',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '7 iron' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: '8 iron',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '8 iron' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: '9 iron',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = '9 iron' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: 'P Wedge',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = 'P wedge' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
 
				 }, {
                name: 'S Wedge',
                data: [<?php 
				$sql= "SELECT month_table.month , IFNULL(AVG( yard ), 0) AS avscore FROM month_table LEFT JOIN `snag` ON month_table.month = 
				       MONTH( STR_TO_DATE( sdate, '%d/%m/%y' ) ) AND club = 'S  wedge' AND user_id = $user_id AND YEAR = $year GROUP BY `month`";
                $result=mysql_query($sql);
				while($row = mysql_fetch_array($result) ){ echo $row['avscore'].',';} 
				?>]
            }]
        });
    });
 
});
		</script>
	</head>
	<body>
<script src="../../js/highcharts.js"></script>
<script src="../../js/modules/exporting.js"></script>
 
 
<form method="post" action="<?php echo $PHP_SELF;?>">
<select name="user_id">
 
            <option>Select User</option>
            <?php echo $options ?>
        </select>
        <input type="submit" value="Submit">
        </form>
 
      <?php echo $year_links;?>  
 
<div id="container" style="min-width: 400px; height: 400px; margin: 0 auto">
 
</div>
 
	</body>
</html>
[code/]



			
		


		
			

				
					
						

	
	
		

			
				
				

					
				

			
			
			
		

	


					
				
				
			

		

		
	


	

	





	
Link to comment

	
		
	
	
	

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				
			
			



		

	


	
	
	
	
	
		
	
      
This thread is more than a year old. Please don't revive it unless you have something important to add.

			
				
				

	
		

			
Join the conversation

			

	
				
					You can post now and register later.
				
				If you have an account, sign in now to post with your account.
				
			

	
		

	




	
	
		
	
		
	
		
	
	
		
		
	
	

		

		


	
		Guest
	


		

			
				
					
				
					
						
    
							
  • 
								


	
	
	
	

								
							
    • 
						

					
				
					
				
			
			
				
					
						
							
						
						



    

		
		

			
		

		
			
 Reply to this topic...

		
		

			

				
					×
					  Pasted as rich text.   Restore formatting
				
			

		

		

			

				  Only 75 emoji are allowed.
			

		

		

			

				×
				  Your link has been automatically embedded.   Display as a link instead
			

		

		

			

			

		

		

			

				×
				  Your previous content has been restored.   Clear editor
			

		

		

			

				×
				  You cannot paste images directly. Upload or insert images from URL.
			

		

		
	

		
	

	

	

		

			×
			
		

		

	



						
					
				
					
				
					
				
			
			
    
				
					
						
					
						
					
						
							
  • 
								


    
	

    

								
							
    • 
						
					
				
				
					
  • 

	

    • 
				
			

		

	



			
		

	

	
		

			

				
					


    
          Share
    

    

        
        
            

            
        
    


				
				
                

                


				
			

		

	







	

		
			
				Go to topic listing
			
		
	

	




						


					

					


					

				

			

			
		

		
		


	

		×
		

			
				

					
				

			

			

			

			
		

	






	

		×
		

			
    
				
  • Create New...
    • 
				
			

		

	



		






















	

		

			
Important Information

			
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.