Git Product home page Git Product logo

geekytheory / automatic-api-rest Goto Github PK

View Code? Open in Web Editor NEW
87.0 15.0 44.0 3.27 MB

Automatic API REST is an Open Source Tool to create a full REST API of your Data Base in seconds. AAR use the native functions of MySQL to abstract your data base and provide the information in different formats (JSON available). Automatic API REST let you to build a JSON and XML tree of your Data Base. You can choose which tables are public and which are private to keep your secret information secure.

Home Page: http://automaticapirest.info

CSS 46.89% PHP 29.46% JavaScript 23.62% ApacheConf 0.03%

automatic-api-rest's Introduction

Automatic API REST (Beta) -

Automatic API REST is an Open Source Tool to create a full REST API of your Data Base in seconds. AAR uses the native functions of MySQL to abstract your data base and provide the information in different formats (JSON available). Automatic API REST let you to build a JSON and XML tree of your Data Base. You can choose which tables are public and which are private to keep your secret information secure.

Automatic API Rest works as a bridge to interact with all programing languages which can read a JSON and XML format, facilitating the communication machine-to-machine (M2M). Read from JAVA, c++, python (...) all the information from you data base to implement your apps.

Visit Automatic API REST to view our demo.

View DEMO | View Features | Installation Instructions | User Guide | Documentation | TO-DO | Links

Features

  • Creation of a powerful REST API of your MySQL DB in Seconds.
  • Management of the API in situ, it is not neccesary an extra database.
  • Private tables and columns.
  • REST-based URIs format.
  • Custom queries.

Dependencies

  • PHP5
  • MySQL
  • Apache or Nginx

Installation

  1. Download the source or clone the repository in the root folder of your project.
  2. Place it in /var/www/YourWebPage/ (for Apache).
  3. Open the fileconfig.php  and complete all the fields with the server credencials.
  4. Replace the file .htaccess in the root folder of your project if your are using Apache. In case you are using Nginx, please follow the intructions attached in /Server-Configuration/ folder.
  5. Go to http://domain.com/Automatic-API-REST

Note: If you have troubles with the privacy system, please allow access to xml folder..

Note 2: If you have troubles in localhost with apache, please see this issue.

Hello World (GET From PHP)

<?php
    //Get JSON from Automatic Api Rest
    $apiLink = "http://localhost/api/get/city/";
    $json = file_get_contents($apiLink);
    //Decode JSON
    $json = json_decode($json);
    //Print
    for($i=0;$i<count($json);$i++){
        echo $json[$i].ID;
    }

TO-DO

  • Implement XML Format
  • Documentation for all the platforms
  • Security
  • Complex query

Links

License

Copyright 2014 GeekyTheory (Alejandro Esquiva)

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

   http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

automatic-api-rest's People

Contributors

alejandroesquiva avatar bryant1410 avatar marioperezesteso avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

automatic-api-rest's Issues

Warning: SimpleXMLElement::__construct(): I/O warning : failed to load external entity &quot;xml/blacklist.xml&quot; in C:\wamp\www\Automatic-API-REST\inc\blackListClass.php on line 97

i got those errors after installation:
Warning: SimpleXMLElement::__construct(): I/O warning : failed to load external entity "xml/blacklist.xml" in C:\wamp\www\Automatic-API-REST\inc\blackListClass.php on line 97

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in C:\wamp\www\Automatic-API-REST\inc\blackListClass.php on line 97
( ! ) Exception: String could not be parsed as XML in C:\wamp\www\Automatic-API-REST\inc\blackListClass.php on line 97

why its so?

  Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\auto\mod\modTable.php on line 32
and xaml view giving this error
{"errors":[{"code":301,"message":"Invalid Parameters: "}]}

Problema recién instalado con la clase blackListClass

Hola, he intentado probar el código del proyecto y me ha dado el siguiente error:

Warning: SimpleXMLElement::__construct(): I/O warning : failed to load external entity "xml/blacklist.xml" in C:\wamp\www\Automatic-API-REST\inc\blackListClass.php on line 97

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in C:\wamp\www\Automatic-API-REST\inc\blackListClass.php on line 97

Por lo visto, hay un error en ese archivo, el cual he solucionado sustituyendo la línea 97 de esto:

$doc = new SimpleXMLElement('xml/blacklist.xml', null, true);

a esto:

$doc = new SimpleXMLElement(file_get_contents('xml/blacklist.xml'));

al parecer no puede acceder al archivo únicamente con el string de la ruta, por lo que el método file_get_contents le proporciona lo necesario a SimpleXMLElement para que pueda crear su nueva instancia.

Espero que a las personas que les haya ocurrido les solucione el problema como a mi.

Un saludo y enhorabuena por el proyecto, es una gran idea que puede ahorrar un montón de tiempo de código.

Error 404

Hola acabo de toparme con su repositorio, y lo he instalado en mi servidor local, cree un subdomino donde apunta a la carpeta del proyecto, puedo loguearme y ver las tablas de la base de datos, el problema esta en que al dar clic en el enlace de la tabla sale el error 404, en los comentarios de la pagina de donde vengo dice que es por .htaccess pero no e podido configurarlo para que funcione, tengo hasta el momento asi

RewriteCond %{HTTP_HOST} ^api.dominio.dev$
RewriteCond %{REQUEST_URI} ^/api-rest-mysql/ => api-rest-mysql se llama la carpeta del proyecto
RewriteRule ^api/ api-rest-mysql/api.php

SWEET!

I really like the system, I see that the .info domain does not work.

That it would be difficult to add the functionality of the TOKEN

Details to the API end point and special installation steps are missing

This is a great tool, I could literally set it up in seconds and logically it makes perfect sense. However i am unable to use it as the URL it gave me for the API is

http:///api/get/

, However the server name / api end point is not available and i am getting 404.

i have tried to make some changes to the codes and config but then its not my forte so i am seeking your opinion , how do i make it work or is there any setup that i have forgotten (i can see right data row counts for all the tables in my setup screen).

Not Found

The requested URL /api/get/bak_joom_finder_links_terms4/ was not found on this server.

Apache/2.4.7 (Ubuntu) Server at estr3 Port 80

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.