README

小博比表格作为服务（LBTaaS）是在2013年11月2日Memphis TechCamp上为我的Composer演讲而创建的，作为composer create-project的一个示例。

在线演示

在生产环境中查看http://lbtaas.jeremykendall.net。

安装

• 安装Composer
• 运行composer create-project jeremykendall/lbtaas lbtaas
• 将127.0.0.1 lbtaas.dev添加到/etc/hosts
• 创建一个vhost，将DocumentRoot设置为/path/to/lbtaas/public
• 重启apache
• WIN

用法

向http://lbtaas.dev/lbt?version=1发送GET请求。你应该会收到以下JSON响应

{
   "status":"success",
   "data":{
      "name":"Exploits of a Mom",
      "permalink":"http:\/\/xkcd.com\/327\/",
      "image":"http:\/\/imgs.xkcd.com\/comics\/exploits_of_a_mom.png",
      "alt":"Her daughter is named Help I'm trapped in a driver's license factory.",
      "link":"\/lbt?version=1&format=json"
   }
}

官方xkcd JSON接口

我并不知道，实际上有一个真正的、不夸张的、正在生产的JSON接口用于xkcd。从xkcd的关于页面

有没有一个接口供自动化系统访问漫画和元数据？

是的。你可以通过JSON接口获取漫画，如http://xkcd.com/info.0.json（当前漫画）和http://xkcd.com/614/info.0.json（第614期漫画）。

所以“真正的”LBTaaS应该是http://xkcd.com/327/info.0.json，对吧？

官方xkcd JSON接口响应体

这是从官方JSON端点获取的Little Bobby Tables的响应体

{
   "month":"10",
   "num":327,
   "link":"",
   "year":"2007",
   "news":"",
   "safe_title":"Exploits of a Mom",
   "transcript":"[[A woman is talking on the phone, holding a cup]]\nPhone: Hi, this is your son's school. We're having some computer trouble.\nMom: Oh dear\u00e2\u0080\u0094did he break something?\nPhone: In a way\u00e2\u0080\u0094\nPhone: Did you really name your son \"Robert'); DROP TABLE Students;--\" ?\nMom: Oh, yes. Little Bobby Tables, we call him.\nPhone: Well, we've lost this year's student records. I hope you're happy.\nMom: And I hope you've learned to sanitize your database inputs.\n{{title-text: Her daughter is named Help I'm trapped in a driver's license factory.}}",
   "alt":"Her daughter is named Help I'm trapped in a driver's license factory.",
   "img":"http:\/\/imgs.xkcd.com\/comics\/exploits_of_a_mom.png",
   "title":"Exploits of a Mom",
   "day":"10"
}
```