GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → mevdschee → php-crud-admin

mevdschee / php-crud-admin

Licence: MIT License
A database admin interface for MySQL, PostgreSQL or SQL Server in a single file PHP script.

Programming Languages

PHP
23972 projects - #3 most used programming language
HTML
75241 projects

Labels

mysqldatabasepostgresqlphpmyadminsqlservermulti-database

Projects that are alternatives of or similar to php-crud-admin

Php Crud Api
Single file PHP script that adds a REST API to a SQL database
Stars: ✭ 2,904 (+12000%)
Mutual labels:  sqlserver, multi-database
Rezoom.SQL
Statically typechecks a common SQL dialect and translates it to various RDBMS backends
Stars: ✭ 639 (+2562.5%)
Mutual labels:  sqlserver
DBA-Mastery
Main repository from contributions from my blog
Stars: ✭ 16 (-33.33%)
Mutual labels:  sqlserver
web-fuzz-wordlists
Common Web Managers Fuzz Wordlists
Stars: ✭ 137 (+470.83%)
Mutual labels:  phpmyadmin
SqlInMemory
SqlInMemory is a library for creating SqlServer database on Memory instead of hard disk, at last Drops and Disposes database when you're done with it. This is useful for Integration Testing.
Stars: ✭ 24 (+0%)
Mutual labels:  sqlserver
MLOS
MLOS is a Data Science powered infrastructure and methodology to democratize and automate Performance Engineering. MLOS enables continuous, instance-based, robust, and trackable systems optimization.
Stars: ✭ 75 (+212.5%)
Mutual labels:  sqlserver
docker-lemp-stack
Simple Docker LEPM stack
Stars: ✭ 58 (+141.67%)
Mutual labels:  phpmyadmin
INTER-Mediator
The new style web application framework, you could develop a db-driven web application with declarative descriptions.
Stars: ✭ 27 (+12.5%)
Mutual labels:  sqlserver
Addax
Addax is an open source universal ETL tool that supports most of those RDBMS and NoSQLs on the planet, helping you transfer data from any one place to another.
Stars: ✭ 615 (+2462.5%)
Mutual labels:  sqlserver
mammaskitchen
A Simple Restaurant Management
Stars: ✭ 72 (+200%)
Mutual labels:  phpmyadmin
sync-client
SyncProxy javascript client with support for all major embedded databases (IndexedDB, SQLite, WebSQL, LokiJS...)
Stars: ✭ 30 (+25%)
Mutual labels:  sqlserver
typetta
Node.js ORM written in TypeScript for type lovers.
Stars: ✭ 44 (+83.33%)
Mutual labels:  sqlserver
ssms-addin
SQL Server Management Studio 2018 Productivity Tool
Stars: ✭ 15 (-37.5%)
Mutual labels:  sqlserver
mssql-restapi
A simple REST API for SQL Server, Azure SQL DB and Azure SQL DW using SMO on .NET Core 2.0
Stars: ✭ 33 (+37.5%)
Mutual labels:  sqlserver
zeppelin
Apache Zeppelin with support for SQL Server
Stars: ✭ 17 (-29.17%)
Mutual labels:  sqlserver
GraphQL.RepoDB
A set of extensions for working with HotChocolate GraphQL and Database access with micro-orms such as RepoDb (or Dapper). This extension pack provides access to key elements such as Selections/Projections, Sort arguments, & Paging arguments in a significantly simplified facade so this logic can be leveraged in the Serivces/Repositories that enca…
Stars: ✭ 25 (+4.17%)
Mutual labels:  sqlserver
craftcms3-docker
Get started playing with Craft CMS 3 in a few command lines with Docker
Stars: ✭ 36 (+50%)
Mutual labels:  phpmyadmin
thinkorm
A flexible, lightweight and powerful Object-Relational Mapper for Node.js. Support TypeScript!!
Stars: ✭ 33 (+37.5%)
Mutual labels:  sqlserver
ormdb
ORM tool for .Net / .Net.Core
Stars: ✭ 14 (-41.67%)
Mutual labels:  sqlserver
Apache
Docker container running Apache running on Ubuntu, Composer, Lavavel, TDD via Shippable & CircleCI
Stars: ✭ 15 (-37.5%)
Mutual labels:  phpmyadmin
View All Similar Projects ➔

PHP-CRUD-ADMIN

A database admin interface for MySQL, PostgreSQL or SQL Server in a single file PHP script.

PHP-CRUD-ADMIN screenshot

Requirements

  • PHP 7.0 or higher with PDO drivers for MySQL, PgSQL or SqlSrv enabled

Installation

This is a single file application! Upload "admin.php" somewhere and enjoy!

For local development you may run PHP's built-in web server:

php -S localhost:8080

Test the script by opening the following URL:

http://localhost:8080/admin.php/

Don't forget to modify the configuration at the bottom of the file.

Configuration

Use the 'api' config parameter to configure the embedded PHP-CRUD-API.

These are the most important 'api' configuration options and their default value between brackets:

  • "driver": mysql, pgsql or sqlsrv (mysql)
  • "address": Hostname of the database server (localhost)
  • "port": TCP port of the database server (defaults to driver default)
  • "username": Username of the user connecting to the database (no default)
  • "password": Password of the user connecting to the database (no default)
  • "database": Database the connecting is made to (no default)

For more information check out the PHP-CRUD-API documentation.

Compilation

You can install all dependencies of this project using the following command:

php install.php

You can compile all files into a single "ui.php" file using:

php build.php

NB: The install script will patch the dependencies in the vendor directory for PHP 7.0 compatibility.

Development

You can access the non-compiled code at the URL:

http://localhost:8080/src/admin/column/posts/list

The non-compiled code resides in the "src" and "vendor" directories. The "vendor" directory contains the dependencies.

Updating dependencies

You can update all dependencies of this project using the following command:

php update.php

This script will install and run Composer to update the dependencies.

NB: The update script will patch the dependencies in the vendor directory for PHP 7.0 compatibility.

Local or remote API

This script is powered by PHP-CRUD-API and embeds this project. Alternatively, it can run against a remote (live) installation.

If you want to run this against a remote installation, then replace the 'api' config parameter with one called 'url' that holds the base URL of your PHP-CRUD-API installation.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].