Q.uote.me

PHP script to store and view random quotes. (v1.4b)

Q.uote.me is a simple PHP script to manage your quotes.

Actually, you have your favorite quotes in multiple txt files, one for your mails, another for your web app, etc...

When you find a new quote, you have to update your files... It can be boring !

With this script, you manage only one SQL database. With his API, you read it in your favorite format (actualy, json, rss2, csv).

Features

Storage: Store your favorite quotes in a single place,

API: you can extract quotes with sql like queries in multiples formats,
Supported: RSS2, JSON, CSV, IMG. in the future: XML, TXT, ATOM and iCal ;),

How to use

Api.php:

To extract datas, use api.php (ex: http://q.uote.me/api.php) and use the following syntax in url:
p > parser: json rss2 csv img ex: p=json
s > sort: data,asc desc or random ex: s=date,desc s=random
l > limit: like sql syntax ex: l=10 l=5,25
w > where: like sql syntax ex: w=quote must be followed by:
wo > where options, the first part of the option can be minus = <, plus = >, equal = = and like ex: w=quote&wo=like,lorem
a > and: like (and must be preceded by) where
ao > and second part (and option) like and option

Availables columns:

quote (text), author (varchar), source (varchar), tags (varchar), permalink (char 6), date (datetime)

Image extraction options:

t > type: png gif jpeg (or all image supported by your phpgd version) ex: t=png
wi > width: width of image in pixel ex: wi=512
If you want extract a png image, options are not required

Full examples:

Index of website:

Just type address of website to view random quote. Add permalink option in the URL to view a specific quote.
Permalink format example: http://q.uote.me?xHlefA (thank to sebsauvage for permalink function)

Updates:

2013-07-26 (1.4b)

2013-07-04 (1.3b):

2013-06-30 (1.2b):

2013-06-28 (1.1b):

2013-06-23 (1.0b):

2013-06-14:

Bugfixes:

2013-06-14:

Licence:

Q.uote.me is distributed under the zlib/libpng License:

Copyright (c) 2013 Daniel Douat, Aélys Informatique

This software is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this software.

Permission is granted to anyone to use this software for any purpose, including commercial applications, and to alter it and redistribute it freely, subject to the following restrictions:

  1. The origin of this software must not be misrepresented; you must not claim that you wrote the original software. If you use this software in a product, an acknowledgment in the product documentation would be appreciated but is not required.

  2. Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software.

  3. This notice may not be removed or altered from any source distribution.