Q.uote.me

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

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 :

• To extract a random quote in json format :
  http://q.uote.me/api.php?p=json
• To extract a quote in csv format :
  http://q.uote.me/api.php?p=csv&w=permalink&wo=equal,xHlefA
• To extract last 10 quotes in rss2 format :
  http://q.uote.me/api.php?p=rss2&s=date,desc&l=10
• To extract the 10 following quotes :
  http://q.uote.me/api.php?p=rss2&s=date,desc&l=11,21
• Fun, one extraction with all options :
  http://q.uote.me/api.php?p=json&w=quote&wo=like,a&a=author&ao=like,douat&s=date,asc&l=5&s=random
• To extract a png file (actually just random quote) :
  http://q.uote.me/api.php?p=img
• To extract a jpeg file of 500 pixels width :
  http://q.uote.me/api.php?p=img&t=jpeg&wi=512

Index of website :

Just type address of website to view random quote. Click on the arrow to reload a new 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)

Requirements :

PHP

• = 5.3

• math
• gd
• json
• mbstring
• pdo
• pdo_mysql
• session
• hash

Other

• freetype2

Updates :

2014-10-03 (1.6b)

• Added authors and tags suggest in admin (ajax),
• Updated db format (added authors and tags tables),
• Added html parser,
• Added html search results,
• Added last quotes link,
• Added support for php 5.3 and 5.4,
• Added og metas,
• Updated to latest login version,
• Now quoteme is multi users,
• Added sharelinks for google+ facebook, twitter and shaarli in admin,
• Added feed link on footer.

2013-08-06 (1.5b)

• Added cache for non radom requests,
• Added ajax update on the index,
• Added api doc on api.php call.

2013-07-26 (1.4b)

• Added image parser.

2013-07-04 (1.3b):

• Added installation script,
• Fixed many bugs.

2013-06-30 (1.2b):

• Added languages support.

2013-06-28 (1.1b):

• Added daily check update for script.

2013-06-23 (1.0b):

• Added login module,
• Added administration,
• Optimized quoteme lib.

2013-06-14 :

• Added permalinks,
• Added creation date (in the future maybe changed by quote date),
• Added tags.

In the future :

1.7b :

• New syntax for api,
• Multi users field in quotes table.

Licence :

Timply is distributed under the BSD licence:

Copyright (c) 2013-2014 Daniel Douat All rights reserved.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
• Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
• Neither the name of the University of California, Berkeley nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE REGENTS AND CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.