Skip to content

Instantly share code, notes, and snippets.

View pchatterjee's full-sized avatar

pchatterjee

View GitHub Profile
@pchatterjee
pchatterjee / anon.php
Created November 12, 2018 23:50
<?php
echo <<<__xml
<?xml version="1.0" encoding="UTF-8"?>
<me>Hello from {$_SERVER['PHP_SELF']}</me>
__xml;
?>
@pchatterjee
pchatterjee / ajax_xml_example.html
Created November 13, 2018 00:11
<!DOCTYPE html>
<html>
<head>
<title>AJAX pull XML Example</title>
<style>
textarea {
outline: none;
resize: none;
width: 400px;
@pchatterjee
pchatterjee / ajax_xml_example.html
Created November 13, 2018 00:12
<!DOCTYPE html>
<html>
<head>
<title>AJAX pull XML Example</title>
<style>
textarea {
outline: none;
resize: none;
width: 400px;
height: 400px;
@pchatterjee
pchatterjee / vaidate_dom.php
Created November 26, 2018 21:50
<?php
$xml = new DOMDocument();
$xml->load('cv2.xml');
if (!$xml->schemaValidate('EuropassSchema.xsd')) {
echo libxml_display_errors();
}
else {
echo "Document is valid";
}
@pchatterjee
pchatterjee / validate_libxml.php
Created November 26, 2018 22:35
<?php
libxml_use_internal_errors(true);
$xml = new XMLReader;
$xml->open('cv2.xml');
$xml->setSchema('EuropassSchema.xsd');
while (@$xml->read()) {};
if (count(libxml_get_errors ())==0) {
@pchatterjee
pchatterjee / validate_libxml.php
Created November 26, 2018 23:48
<?php
libxml_use_internal_errors(true);
$xml = new XMLReader;
$xml->open('cv2.xml');
$xml->setSchema('EuropassSchema.xsd');
while (@$xml->read()) {};
if (count(libxml_get_errors ())==0) {
@pchatterjee
pchatterjee / eb-example.sql
Created February 27, 2019 18:39
CREATE TABLE IF NOT EXISTS `category` (
`categoryID` INT NOT NULL AUTO_INCREMENT ,
`catName` VARCHAR(48) NOT NULL ,
`catParent` INT NOT NULL ,
PRIMARY KEY (`categoryID`) )
ENGINE = InnoDB;
CREATE TABLE IF NOT EXISTS `product` (
`productID` INT NOT NULL AUTO_INCREMENT ,
`prodName` VARCHAR(72) NOT NULL ,
@pchatterjee
pchatterjee / eb-example-inserts.sql
Created February 27, 2019 19:03
INSERT INTO `category` (`categoryID`, `catName`, `catParent`) VALUES
(1, 'Kitchen and Home Appliances', 0),
(2, 'Computers and Electronics', 0),
(3, 'Sports and Outdoors', 0),
(4, 'Garden and Outdoors', 0),
(5, 'Irons', 1),
(6, 'Cameras', 2),
(7, 'Toasters', 1),
(8, 'Kettles', 1),
(9, 'Laptops', 2),
@pchatterjee
pchatterjee / returnTable.php
Created March 2, 2019 11:17
<?php
function returnTable ($con, $sql, $format, $imgwidth=200) {
$con->query('SET NAMES utf8');
$result = $con->query($sql);
$table = '<table>';
$table .= '<tr>';
foreach($format as $key=>$val) {
$table .= "<th>$val</th>";
@pchatterjee
pchatterjee / returnTable.php
Created March 2, 2019 16:53
<?php
function returnTable ($con, $sql, $format) {
$con->query('SET NAMES utf8');
$result = $con->query($sql);
$table = '<table>';
$table .= '<tr>';
foreach($format as $key=>$val) {
$table .= "<th>$val</th>";