how to use kodus with php

You'll want to set up some kind of web service that the kudos JavaScript can send data to, and then that web service will need to store the data in something like a database. Then, when the PHP page loads the next time, you'll want to retrieve the data from the database with PHP and echo it to the screen.

Does that help?

Yeah... Thanks Randy

But my problem is that i don't know how to write the code to do these things... I mean the database part...

I've heard of AJAX (far from the part that @Jason teaches it)... Should it be something Like that?

any code hint?

The code for this is pretty tricky if you haven't done it before. I plan to cover something like this in a future video tutorial. I'll try to find a good resource for creating a PHP web service that can be accessed with an Ajax request.

Hi,

thanks... I'll wait for the video...

I'm making progress : for Some reason I decided to have a input text [number ] ( which people insert how many people around them are actually doing the suggestion in the text ) [called as "count"] & a submit button :

There is a database called "el" , which contains two tables "el_c", "el_f".

in "el_c" there are 2 fields : "elc_id" , "elc_count".

and in "el_f" there are 2 fields : "elf_id" , "elf_sum"

Here's my code : [in a page called add.php]

$count = $_POST["count"];
$link = mysql_connect("localhost","root","");
mysql_select_db("el",$link);
$sql = "INSERT into el_c (elc_count)"."value ($count)";
mysql_query($sql,$link);

now I want to UPDATE the first row of table "el_f" with the SUM of all "elc_count" datas from "el_c" table...

I don't believe it would be too hard!

thanks in advanced

;)

Hi

This should work... but I don't know why it doesn't...

I made it a little better too...

$count = $_POST["count"];
$link = mysql_connect("localhost","root","");
mysql_select_db("el",$link);
mysql_query("INSERT into el_c (elc_count) value ($count)",$link);
mysql_query("UPDATE el_f SET elf_sum = SUM(elc_count) FROM el_c WHERE elf_id='1'",$link);

It'd be really happy to be helped.

;)

thanks

Here it goes :

mysql_query("UPDATE el_f SET elf_sum = (SELECT SUM(elc_count) FROM el_c WHERE elf_id=1)",$link);

It just needed a "SELECT" ....