Skip to content

Instantly share code, notes, and snippets.

View ShaneCunn's full-sized avatar

Shane Cunningham ShaneCunn

1 follower · 1 following
  • Sleepless
  • Galway, Ireland
View GitHub Profile
@ShaneCunn
ShaneCunn / getModel.php
Last active August 12, 2018 13:46
<?php
$image = null;
$humidity = '0.56';
$wind = '45';
$city = "galway";
$temperature = 300;
/* Get Location IP section
localhost ip address not for website
$ip = $_SERVER['HTTP_CLIENT_IP'] ?
$_SERVER['HTTP_CLIENT_IP'] : ($_SERVER['HTTP_X_FORWARDE‌​D_FOR'] ?
@ShaneCunn
ShaneCunn / include.php
Created March 20, 2018 21:05
include '../DB/configDB.php';
@ShaneCunn
ShaneCunn / checkifset.php
Created March 20, 2018 20:59
if (isset($_POST['action']) && !empty($_POST['action'])) {
$action = $_POST['action'];
switch ($action) {
case 'getEMP' :
getEMP($DBconnect);
break;
case 'getProd' :
getProducts($DBconnect);
break;
// ...etc...
@ShaneCunn
ShaneCunn / response.php
Created March 20, 2018 20:58
function getEMP($DBconnect)
{
// storing request (ie, get/post) global array to a variable
$requestData = $_REQUEST;
$columns = array(
// datatable column index => database column name
0 => 'employee_name',
1 => 'employee_salary',
2 => 'employee_age'
);
@ShaneCunn
ShaneCunn / config.php
Created March 20, 2018 20:49
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'passwordForDB');
define('DB_NAME', 'DatabaseName');
$DBconnect = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
//echo "Connect Successfully. Host info: " . mysqli_get_host_info($DBconnect);
if (!$DBconnect) {
die("Connection failed: " . mysqli_connect_error());
}
@ShaneCunn
ShaneCunn / datatable.js
Created March 20, 2018 20:48
$(document).ready(function () {
var dataTable = $('#employee-grid').DataTable({
"responsive": true,
"processing": true,
"serverSide": true,
"ajax": {
url: "ajax/response.php", // json datasource
data: {action: 'getEMP'}, // Set the POST variable called action to contain getEMP
type: 'post', // method , by default get
},
@ShaneCunn
ShaneCunn / layout.html
Last active March 20, 2018 21:03
<div class="container">
<div class
<div class="header"><h1>Server side DataTable demo in Php,Mysql and Ajax </h1></div>
<div class="container">
<table id="employee-grid" class="table table-striped table-bordered" style="width:100%">
<thead>
<tr>
<th>Employee name</th>
<th>Salary</th>
<th>Age</th>
@ShaneCunn
ShaneCunn / scripts.html
Last active March 20, 2018 21:22
CSS and Javascript Scripts
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"/>
<link href="https://cdn.datatables.net/1.10.16/css/dataTables.bootstrap.min.css" rel="stylesheet"/>
<script src="https://code.jquery.com/jquery-3.3.1.min.js"
integrity="sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8="
crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/r/dt/dt-1.10.9/datatables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/dataTables.bootstrap.min.js"></script>
@ShaneCunn
ShaneCunn / configDB.php
Last active May 1, 2023 12:37
Ajax php mysql DataTables example that get data from mysql database using ajax, that calls a php method
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'passwordForDB');
define('DB_NAME', 'DatabaseName');
$DBconnect = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
@ShaneCunn
ShaneCunn / bootstrap.html
Last active August 14, 2018 07:28
bootstrap cdn
<!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"/>
<meta name="description" content=""/>
<meta name="author" content=""/>