Skip to content

Instantly share code, notes, and snippets.

@goelvibhor4
goelvibhor4 / gist:f4bcec8229cacb299ae6b0bd0c96041e
Created August 27, 2017 16:39 — forked from paulallies/gist:0052fab554b14bbfa3ef
Remove node_modules from git repo
#add 'node_modules' to .gitignore file
git rm -r --cached node_modules
git commit -m 'Remove the now ignored directory node_modules'
git push origin master
$query0 = "select name,estimate_number from campaigns_hul where id = '$cid'";
$data0 = $this->db->query($query0)->result();
//print_r($data0); die();
$query = "select pp.photo,s.city,s.locality,s.start_date,s.end_date,s.size,s.lighting,s.media_type "
. "FROM tasks_hul t "
. "LEFT JOIN campaigns_hul c ON c.id = t.campaign_id "
. "LEFT JOIN sites_hul s ON s.site_id = t.site_id "
. "LEFT JOIN photoproof_hul pp ON pp.task_id = t.task_id "
. "LEFT JOIN vendors_hul v ON v.vendor_id = t.vendor_id "
<?php
error_reporting(E_ALL);
ini_set('include_path', ini_get('include_path').';../Classes/');
include 'PHPExcel.php';
include 'PHPExcel/Writer/Excel2007.php';
$excel = new PHPExcel();
<?php
error_reporting(E_ALL);
ini_set('include_path', ini_get('include_path').';../Classes/');
include 'PHPExcel.php';
include 'PHPExcel/Writer/Excel2007.php';
$excel = new PHPExcel();
@goelvibhor4
goelvibhor4 / PHPExcel_Basics.md
Created June 10, 2016 11:00 — 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:

[{
"site_id": "66",
"campaign_id": "60",
"client_sub": "",
"locad_site_code": "DL2Z110049",
"state_code": "DL",
"number_code": "2",
"zip_code": "110049",
"site_code": "1",
"media_type": "Billboard",
[{
"site_id": "1",
"site_name": "C.P",
"campaign_id": "aaa1data",
"latitude": "28.6315",
"longitude": "77.2167"
}
]
<?php $client_arr = $obj_client_details;
// print_r($client_arr);
foreach($client_arr as $val) { ?>
<div class="clientbox">
<h1>Client Profile</h1>
<div class="clientboxinr">
<ul>
<li>
<div class="client1">
<div class="clienimg"><img src="<?= IMG ?>/client.jpg" alt="Client Profile"/></div>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title>FLOCALLY</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">