Skip to content

Instantly share code, notes, and snippets.

View jaffreyjoy's full-sized avatar
👁️
Staring at progress bars...

Jaffrey jaffreyjoy

👁️
Staring at progress bars...
43 followers · 298 following
  • EdgeCortix
  • Hyderabad
  • 06:40 (UTC +05:30)
  • X @jaffreyjoy
View GitHub Profile
@jaffreyjoy
jaffreyjoy / sql_commands_with_syntax_and_description.sql
Last active August 25, 2018 06:55
List of all commands (with detailed info) for the SQL workshop . Happy Querying :) Feel free to post any queries
-- is used for single line comment
/* some sql code */ -> is used for multiline comment
--CREATE A DATABASE
--SYNTAX : CREATE DATABASE db_name;
CREATE DATABASE STUDENT;
@jaffreyjoy
jaffreyjoy / pdf-pages.php
Last active April 6, 2018 15:48
PHP and python script for finding no. of pgs in a pdf
/*
First function requires an executable called pdfinfo.exe
Alternative function using python script needs PyPDF2 package to be installed
*/
<?php
// Make a function for convenience
function getPDFPages($document)
{
@jaffreyjoy
jaffreyjoy / update.php
Last active April 6, 2018 15:49
PHP - update & file upload
<?php
$conn = new mysqli("localhost","id3320560_root_lol","lol1234","id3320560_organd");
if($conn->connect_error)
die("Connection failed".$conn->connect_error);
$name = $_POST["name"];
$username = $_POST["username"];
$email = $_POST["email"];
@jaffreyjoy
jaffreyjoy / login.php
Last active April 6, 2018 15:49
PHP basic authentication
<?php
if(isset($_POST["login_btn"])) {
$conn = new mysqli("localhost","id3320560_root_lol","lol1234","id3320560_organd");
if($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$username = $_POST["username"];
@jaffreyjoy
jaffreyjoy / js-php.js
Last active August 24, 2019 03:44
PHP <--> JS (data)
//send data to a php file using AJAX
$.ajax({
type: 'POST',
url: 'del_table.php',
data: {'variable': myval},
});
@jaffreyjoy
jaffreyjoy / control.js
Last active February 1, 2018 19:18 — forked from shawn-kb/control.js
ugly buttons
import React from 'react';
import {
ScrollView,
StyleSheet,
Modal,
Text,
TextInput,
TouchableOpacity,
View,
Platform,
@jaffreyjoy
jaffreyjoy / esoc-tasks.md
Last active May 20, 2018 07:11
Tasks assigned for ESOC '18.

Mail

  • send and receive email using IMAP
  • create and delete mail ( interface )

WebRTC

  • transmit simple data using webrtc
  • otp
  • firewall .....

Accounting + Inventory + CRM

@jaffreyjoy
jaffreyjoy / run.md
Last active June 21, 2018 05:31
frappejs-accounting test setup

To run the project :

Run these commands in the root directory

  yarn build

  yarn server
@jaffreyjoy
jaffreyjoy / Sprint-1.md
Last active January 2, 2019 07:57
Winter Internship Sprints

Invoice Customization

  • 3 beautiful invoice templates
  • Dynamic color theme selection
  • Dynamic Address
  • Color prop fix
  • Fix Layout ⏬
  • Custom Fonts ⏬
  • Company Logo ⏬

GSTR1

@jaffreyjoy
jaffreyjoy / keybase_old.md
Last active July 18, 2020 08:51
keybase_old.md

Keybase proof

I hereby claim:

  • I am jaffrey98 on github.
  • I am jaffreyjoy (https://keybase.io/jaffreyjoy) on keybase.
  • I have a public key ASD1QpVolARdSsu-J3s9ZzXukjMuDCwil0g4aYqGNzmHaQo

To claim this, I am signing this object: