9

I have a website for a client offering information from a database. But other websites want to show that information in their website, so my client ask me for it.

Since the begining I thought it might be something similar to the twitter widget. As I want to give out a code similar to this:

<script src="http://widgets.twimg.com/j/2/widget.js"></script>
<script>
new TWTR.Widget({ ......

And other websites will show the information from my database.

But I cannot find a exactly example, I found this: http://tutorialzine.com/2010/03/who-is-online-widget-php-mysql-jquery/

But it is not exactly what I want.

My deployment is the following: In the server I've got a mySQL database and a website, I would like to create php and javascript code (or even jquery, but I'm not very expert with it) so other website could incorporate the information from the database in a secure mode.

Could anybody give a hint?

gen_Eric
  • 223,194
  • 41
  • 299
  • 337
cjbs
  • 329
  • 1
  • 4
  • 13
  • why don't you create a webservice in your server? it would transmit only the necessary information for your widget to show. – Yuri Ghensev Nov 18 '11 at 21:07
  • 1
    Not really. You'd need to become quite an expert before attempting something like this. Here's some stuff to consider: http://www.w3.org/TR/widgets-reqs/ – James Nov 18 '11 at 21:13
  • Yes, I want to offer something similar to a webservice, and then using the code – cjbs Nov 18 '11 at 21:26

3 Answers3

6

You'll need a RESTful service on your server which other sites can ping. You will use an AJAX request to get the information from that service.

The big piece of this for you will be creating a JavaScript object that has all the functionality you want. It is much easier to give people directions on how to use your REST API and let them implement it via AJAX on their own pages. If you really do want a full widget, you'll want to check out a lot of things. First is closures in JS to ensure you don't conflict with any of their variables. Also make sure you are good at developing cross-browser Javascript independent of libraries. And finally, you'll want to make sure your server is configured for cross-domain AJAX requests. Again, my recommendation is to set up a REST API for them, and let them do the dirty work.

Community
  • 1
  • 1
LoveAndCoding
  • 7,857
  • 2
  • 31
  • 55
  • Thank you! I have thought that. In the begining I thought to create a web service (easy one) created in php or so (php does not gives you a real web service, but it emulates quite good, as far as I know). Anyway, I thought I could collect data and offer it via JSON, so the client of the web service has to do the dirty work, as you say. But I thought it might be a good oportunity for learning how to do this kind of things. – cjbs Nov 18 '11 at 21:21
4

There is an interesting tutorial about how to create a twitter widget using PHP and JavaScript on the nettuts website, I think you may find it useful.

alessioalex
  • 62,577
  • 16
  • 155
  • 122
2

Well, although it's not specific for PHP, this is by far the best resource I could find to this subject: http://alexmarandon.com/articles/web_widget_jquery/

Lulu
  • 438
  • 5
  • 15