Need help with trongate-framework?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

davidjconnelly
142 Stars 25 Forks Other 110 Commits 2 Opened issues

Description

The Trongate PHP framework

Services available

!
?

Need anything else?

Contributors list

For best results, it's HIGHLY recommended to use the Trongate Desktop App, which is available at https://trongate.io.

If - for some reason - you'd like to use the Trongate framework without the desktop app AND you'd like to use the API manager then you'll need to set up a mySQL database. Here's a dump of some SQL code that will get you started with API authentication:

START

-- phpMyAdmin SQL Dump -- version 4.7.9

-- https://www.phpmyadmin.net/

-- Host: localhost -- Generation Time: Aug 13, 2019 at 08:25 PM -- Server version: 10.1.31-MariaDB -- PHP Version: 7.0.28

SET SQLMODE = "NOAUTOVALUEON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION;

CREATE TABLE IF NOT EXISTS

comments
(
id
int(11) NOT NULL AUTOINCREMENT,
comment
text NOT NULL, `date
created
int(11) NOT NULL DEFAULT '0',
userid
int(11) NOT NULL,
target
table
varchar(125) NOT NULL,
updateid
int(11) NOT NULL,
code
varchar(6) NOT NULL DEFAULT '',
  PRIMARY KEY (
id`) ) ENGINE=InnoDB AUTO
INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS

trongate_tokens
(
id
int(11) NOT NULL AUTOINCREMENT,
token
varchar(125) NOT NULL, `user
id
int(11) NOT NULL DEFAULT '0',
expirydate
int(11) NOT NULL,
code
varchar(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (
id`) ) ENGINE=InnoDB AUTO
INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS

trongate_users
(
id
int(11) NOT NULL AUTOINCREMENT,
code
varchar(32) DEFAULT NULL, `user
levelid
int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (
id`) ) ENGINE=InnoDB AUTO
INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO

trongate_users
(
id
,
code
,
user_level_id
) VALUES (1, 'UVsY8ASG5evncc4U6trru2XH5Tbq7MU5', 1);

CREATE TABLE IF NOT EXISTS

trongate_user_levels
(
id
int(11) NOT NULL AUTOINCREMENT, `leveltitle
varchar(125) NOT NULL DEFAULT '',
  PRIMARY KEY (
id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO

trongate_user_levels
(
id
,
level_title
) VALUES (1, 'admin');

CREATE TABLE IF NOT EXISTS

trongate_administrators
(
id
int(11) NOT NULL,
username
varchar(65) NOT NULL,
password
varchar(60) NOT NULL,
trongate_user_id
int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO

trongate_administrators
(
id
,
username
,
password
,
trongate_user_id
) VALUES (11, 'admin', '$2y$11$SoHZDvbfLSRHAi3WiKIBiu.tAoi/GCBBO4HRxVX1I3qQkq3wCWfXi', 1);

ALTER TABLE

trongate_administrators
ADD PRIMARY KEY (
id
);

ALTER TABLE

trongate_administrators
MODIFY
id
int(11) NOT NULL AUTOINCREMENT, AUTOINCREMENT=1; COMMIT;

COMMIT;

END

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.