#Q.uote.me
PHP script to store and view random quotes. (v1.3b)
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. 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 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)
####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
###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-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.
###Bugfixes : 2013-06-14 :
- Fixed RSS (dates, links other errors like {item} in source,
- Foreach control for json and csv parser.
##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 :
-
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.
-
Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software.
-
This notice may not be removed or altered from any source distribution.