1001 Freelance Projects -- Create Secure API/ MySQL with Filters

Latest Projects from Freelance Marketplaces

Today is: 25-Apr-2024 21:40 GMT

View this project in detail (Note: you will be redirected to external marketplace)
Project title:	Create Secure API/ MySQL with Filters
Posted by:	External project from Upwork
Started:	30-Jun-2022 21:38 GMT
Description:	Need to create a web based API to interface with a database. Major Requirements: Authentication is required, will need to be able to add/remove API keys Server side Filtering is required: API Key could provide some filter language (via mysql query language) (this filter would not be visible from the client side) *URL based filtering (timestamp, agency, subject) i.e. api.php?time=7days&agency="ampa"&subject="fire* I would like for the API keys, filters and a customers name be stored into a new table in the same database; I have included a copy of the structure of the source database for the API below: Thanks! The database structure that exists has the following configuration: /!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET NAMES utf8 /; /!50503 SET NAMES utf8mb4 /; /!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /; /!40103 SET TIME_ZONE='+00:00' /; /!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /; /!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /; /!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /; -- Dumping database structure for scrapes CREATE DATABASE IF NOT EXISTS `scrapes` /!40100 DEFAULT CHARACTER SET latin1 /; USE `scrapes`; -- Dumping structure for table scrapes.rss CREATE TABLE IF NOT EXISTS `rss` ( `id` int(11) NOT NULL AUTO_INCREMENT, `timestamp` datetime NOT NULL, `agency` varchar(255) NOT NULL, `subject` varchar(255) NOT NULL, `body` text NOT NULL, `source_url` varchar(255) NOT NULL, `listen_urls` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `agency_time` (`agency`,`timestamp`) ) ENGINE=InnoDB AUTO_INCREMENT=13950038 DEFAULT CHARSET=latin1; -- Data exporting was unselected. /!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') /; /!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') /; /!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) /; /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) /; Posted On: June 30, 2022 21:38 UTC Category: Back-End Development Skills:MySQL, PHP, API, Web Development Skills: MySQL, PHP, API, Web Development Country: United States click to apply
Project ID:	3268755
Project category:	MySQL, PHP, API, Web Development
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
I.T. Assistance Required - Wordpress, Elementor Pro, WooCommerce	25-Apr-2024 15:23 GMT
Create photo realistic images of new house build	25-Apr-2024 15:13 GMT
Looking for someone near Liverpool to support with video work	25-Apr-2024 15:08 GMT
NATIVE FRENCH VIDEO EDITOR & CAPTIONIST	25-Apr-2024 15:05 GMT
PPC Paid Ads Manager for Tradesman Software	25-Apr-2024 15:04 GMT
i need a figma designer	25-Apr-2024 15:04 GMT
Recreate Website from Website Builder to WordPress	25-Apr-2024 15:04 GMT
Create a bot that sends my trades as signals to telegram	25-Apr-2024 15:02 GMT
Social Media Expert	25-Apr-2024 14:59 GMT
CAD person 4 drawings 4 extension at home - PSE READ THE ADVERT	25-Apr-2024 14:59 GMT
UK based PR - sustainability , game, edutainment	25-Apr-2024 14:59 GMT
Packaging Design for a Frozen Food Brand	25-Apr-2024 14:31 GMT
A4 poster for dental whitening	25-Apr-2024 14:31 GMT
Website on Wordpress	25-Apr-2024 14:29 GMT
Brand Logo	25-Apr-2024 14:29 GMT

Browse All Projects

Projects by Skills ...
Projects for 'android' Projects for 'ajax' Projects for 'asp' Projects for 'aspnet' Projects for 'cms' Projects for 'cpp' Projects for 'csharp' Projects for 'css' Projects for 'delphi' Projects for 'design' Projects for 'drupal'	Projects for 'excel' Projects for 'facebook' Projects for 'flash' Projects for 'html' Projects for 'java' Projects for 'javascript' Projects for 'joomla' Projects for 'iphone' Projects for 'mysql' Projects for 'photoshop' Projects for 'php' Projects for 'python'	Projects for 'ruby' Projects for 'seo' Projects for 'sql' Projects for 'sysadm' Projects for 'translate' Projects for 'typing' Projects for 'twitter' Projects for 'vbnet' Projects for 'xml' Projects for 'wordpress' Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android' RSS feed for 'ajax' RSS feed for 'asp' RSS feed for 'aspnet' RSS feed for 'cms' RSS feed for 'cpp' RSS feed for 'csharp' RSS feed for 'css' RSS feed for 'delphi' RSS feed for 'design' RSS feed for 'drupal'	RSS feed for 'excel' RSS feed for 'facebook' RSS feed for 'flash' RSS feed for 'html' RSS feed for 'java' RSS feed for 'javascript' RSS feed for 'joomla' RSS feed for 'iphone' RSS feed for 'mysql' RSS feed for 'photoshop' RSS feed for 'php' RSS feed for 'python'	RSS feed for 'ruby' RSS feed for 'seo' RSS feed for 'sql' RSS feed for 'sysadm' RSS feed for 'translate' RSS feed for 'typing' RSS feed for 'twitter' RSS feed for 'vbnet' RSS feed for 'xml' RSS feed for 'wordpress' RSS feed for 'writing'

New!
Проекты на русском (Projects in Russian)	Short URL: 1001fp.com	Mobile version: m.1001freelanceprojects.com