Skip to content

Instantly share code, notes, and snippets.

View pchatterjee's full-sized avatar

pchatterjee

View GitHub Profile
@pchatterjee
pchatterjee / book.csv
Last active April 11, 2023 17:47
book_id isbn-10 isbn-13 book_title book_currency book_rrp book_price book_stock book_format book_pages book_publish_date book_description publisher_id_fk
1 0192804774 9780192804778 Anarchism: A Very Short Introduction GBP 7.99 5.99 8 Paperback 128 2004-10-21 Ward considers anarchism from a variety of perspectives: theoretical, historical, and international. The text also explores the ideas of key anarchist thinkers from Kropotkin to Chomsky. 1
2 1851687173 9781851687176 Anarchism: A Beginner's Guide GBP 9.99 7.43 7 Paperback 192 2009-09-01 "A valuable contribution to our understanding of this much misunderstood philosophy." - Howard Zinn, author of A People's History of the United States "Ruth Kinna cannot be praised highly enough for writing a comprehensive, original and sympathetic work which will no doubt come to be viewed as the key text on the subject." - Simon Tormey, Professor of Politics, University of Nottingham 2
@pchatterjee
pchatterjee / mysql_to_html_table_v2.php
Last active March 14, 2023 17:55
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset='UTF-8'>
<title>CSV to HTML5 Table Example </title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css"
integrity="sha384-HSMxcRTRxnN+Bdg0JdbxYKrThecOKuH5zCYotlSAcp1+c8xmyTe9GYg1l9a69psu" crossorigin="anonymous" />
<style>
body {
margin: 20px auto;
@pchatterjee
pchatterjee / mysql_to_html_table_v1.php
Last active March 14, 2023 18:39
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset='UTF-8'>
<title>CSV to HTML5 Table Example </title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css"
integrity="sha384-HSMxcRTRxnN+Bdg0JdbxYKrThecOKuH5zCYotlSAcp1+c8xmyTe9GYg1l9a69psu" crossorigin="anonymous" />
<style>
body {
margin: 20px auto;
@pchatterjee
pchatterjee / survey_to_html_v2.php
Last active March 7, 2023 02:23
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Survey (CSV to HTML) example</title>
<meta name="description" content="it workshop 4 - answer">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/pure/2.0.3/pure-min.css">
<style>
body {
@pchatterjee
pchatterjee / survey_to_html_v1.php
Last active March 7, 2023 01:08
<?php
$fh = fopen("survey.csv", "r");
$header = TRUE;
echo '<table>';
while (!feof($fh)) {
$rec = fgetcsv($fh);
@pchatterjee
pchatterjee / survey.php
Created March 6, 2023 20:31
<?php
# open the file ready for append
$fh = fopen("survey.csv", "a");
# append $_POST global to file
fputcsv($fh, $_POST);
# close the file
fclose($fh);
?>
@pchatterjee
pchatterjee / survey.html
Created March 6, 2023 19:54
<!DOCTYPE html>
<html lang="en">
<head>
<title>HTML5 Form Example </title>
<style>
body {
margin: 20px auto;
font-family: Helvetica, sans-serif;
font-weight: 400;
font-size: 1.25rem;
@pchatterjee
pchatterjee / books.xml
Created March 5, 2023 15:58
<?xml version="1.0" encoding="UTF-8"?>
<books>
<book isbn-13="9780192804778" isbn-10="0192804774">
<title>Anarchism: A Very Short Introduction</title>
<author>Ward, Colin</author>
<class>anarchism</class>
<class>ethics</class>
<class>politics</class>
<price currency="GBP">
<rrp>7.99</rrp>
@pchatterjee
pchatterjee / books.xml
Last active March 5, 2023 13:24
<?xml version="1.0" encoding="UTF-8"?>
<books>
<book isbn-13="9780192804778" isbn-10="0192804774">
<title>Anarchism: A Very Short Introduction</title>
<author>Ward, Colin</author>
<classification class="anarchism, philosophy, ethics,
politics, social theory, libertarianism" />
<price currency="GBP">
<rrp>7.99</rrp>
<price>5.99</price>
@pchatterjee
pchatterjee / patient.xsl
Last active March 4, 2023 15:58
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" version="5.0"
encoding="UTF-8" indent="yes"/>
<xsl:variable name="space">
<xsl:text> </xsl:text>
</xsl:variable>