elShunior junioryauricasa

## LICENCE SUBLIME TEXT
## Sublime Text 3 Serial key build is 3103

—– BEGIN LICENSE —–
Michael Barnes
Single User License
EA7E-821385
8A353C41 872A0D5C DF9B2950 AFF6F667
C458EA6D 8EA3C286 98D1D650 131A97AB
AA919AEC EF20E143 B361B1E7 4C8B7F04
B085E65E 2F5F5360 8489D422 FB8FC1AA

## PHPExcel_Basics.md

      
              6 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                junioryauricasa
                / PHPExcel_Basics.md
            
            
              Created
              December 12, 2017 16:48
                — forked from r-sal/PHPExcel_Basics.md
            
              
                PHPExcel Notes and code snippets
              
          
    Basics

Creating a new PHPExcel Object.
    $this->PHPExcel = new PHPExcel();

Working with sheets

Creating a new sheet:


## PHP - Save DB Table as CSV
<?php
$username="root";		$password="";		$database="exam_codes";
$con = mysql_connect("localhost",$username,$password) or die( "Unable to Connect database");
mysql_select_db($database,$con) or die( "Unable to select database");
// Table Name that you want
// to export in csv
$ShowTable = "blogs";

$FileName = "_export.csv";
$file = fopen($FileName,"w");

## .htaccess-mod_headers
<IfModule mod_headers.c>
Header set Connection keep-alive

# Cache-control headers
    # 2 HOURS
    #<filesMatch "*">
        Header set Cache-Control "max-age=7200, must-revalidate"
    #</filesMatch>

    # 480 weeks - 290304000

## browser-detect.php
<?php
	$user_agent = $_SERVER['HTTP_USER_AGENT'];
	echo $user_agent;
	function getBrowser($user_agent){
		if(strpos($user_agent, 'Maxthon') !== FALSE)
			return "Maxthon";
		elseif(strpos($user_agent, 'SeaMonkey') !== FALSE)
			return "SeaMonkey";
		elseif(strpos($user_agent, 'Vivaldi') !== FALSE)
			return "Vivaldi";
	## Sublime Text 3 Serial key build is 3103

	—– BEGIN LICENSE —–
	Michael Barnes
	Single User License
	EA7E-821385
	8A353C41 872A0D5C DF9B2950 AFF6F667
	C458EA6D 8EA3C286 98D1D650 131A97AB
	AA919AEC EF20E143 B361B1E7 4C8B7F04
	B085E65E 2F5F5360 8489D422 FB8FC1AA
	<?php
	$username="root"; $password=""; $database="exam_codes";
	$con = mysql_connect("localhost",$username,$password) or die( "Unable to Connect database");
	mysql_select_db($database,$con) or die( "Unable to select database");
	// Table Name that you want
	// to export in csv
	$ShowTable = "blogs";

	$FileName = "_export.csv";
	$file = fopen($FileName,"w");
	<IfModule mod_headers.c>
	Header set Connection keep-alive

	# Cache-control headers
	# 2 HOURS
	#<filesMatch "*">
	Header set Cache-Control "max-age=7200, must-revalidate"
	#</filesMatch>

	# 480 weeks - 290304000
	<?php
	$user_agent = $_SERVER['HTTP_USER_AGENT'];
	echo $user_agent;
	function getBrowser($user_agent){
	if(strpos($user_agent, 'Maxthon') !== FALSE)
	return "Maxthon";
	elseif(strpos($user_agent, 'SeaMonkey') !== FALSE)
	return "SeaMonkey";
	elseif(strpos($user_agent, 'Vivaldi') !== FALSE)
	return "Vivaldi";