Skip to content

Instantly share code, notes, and snippets.

View REPTILEHAUS's full-sized avatar

Paddy REPTILEHAUS

View GitHub Profile
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getMemeber_sproc`(
IN `usersession` INT(11),
OUT `output_name` VARCHAR(25)
)
BEGIN
SELECT name INTO output_name FROM members WHERE id = usersession;
END$$
<?php
// Change to your hosts IP, username, password and database name
define('HOST','localhost');
define('USER','root');
define('PASS','');
define('DB','storedprocedures');
$dbh = @new mysqli(HOST, USER, PASS, DB);
<?php
$dsn = "mysql:host=localhost;dbname=storedprocedures;charset=utf8;"; //change to your hosts IP and database name
$user = 'root'; //database username
$pass = ''; //database password
//PDO Error Exceptions added to to the connection string below
$options = array(PDO::ATTR_ERRMODE =--> PDO::ERRMODE_EXCEPTION);
try {
import { Component, OnInit, OnDestroy } from '@angular/core';
import { ChatService } from '../chat.service';
@Component({
selector: 'app-chat',
template: `
<p>
REPTILEHAUS NG2 CHAT DEMO
</p>
import { Injectable } from '@angular/core';
import { Subject } from 'rxjs/Subject';
import { Observable } from 'rxjs/Observable';
import * as io from 'socket.io-client';
@Injectable()
export class ChatService {
private url = 'http://localhost:5000';
private socket;
'use strict';
const db
const dbconnection = 'mongodb://username:[email protected]:35333/your-database-name';
const express = require('express')
const app = express()
const bodyParser = require('body-parser')
const http = require('http').Server(app);
const io = require('socket.io')(http);
const MongoClient = require('mongodb').MongoClient
<app-chat></app-chat>
const dbconnection = 'mongodb://username:[email protected]:35333/your-database-name';
@REPTILEHAUS
REPTILEHAUS / chat.js
Created March 15, 2018 09:58 — forked from bas-vk/chat.js
whisper chat demo
var chat = {
username: "<not set>",
topic: "0xfeedbabe",
key: "",
identity: "",
pollInterval: null,
filter: null,
setUsername: function(name) {
this.username = name;