jquery - Trouble with a script for logging amount of facebook likes with mysql + php -

-

i trying write script log how many likes(facebook) page has in mysql using facebook api, ajax , mysql. @ moment isn't working. variables defined, connected mysql, , jquery embedded , i'm not getting , sql or php errors. can see i'm going wrong?

source code: index.php:

<?php $sql=mysql_query("select * likes order id desc limit 9"); while($row=mysql_fetch_array($sql)) { ?> <div id="fb-root"></div> <script src="http://connect.facebook.net/en_us/all.js"></script>  <script > fb.init({      status: true,     cookie: true,     xfbml: true });  fb.event.subscribe('edge.create', function(response) {     alert(response);      if (response == "http://fbquote.me/like.php?id=<?php print $row['id']; ?>") { $.ajax({ type: "post", url: "popular/ajax_pop.php", data: "id=<?php print $row['id']; ?>"  cache: false, });      } });  </script>                     <br />  <table style="width: 90%; height: 4px;" class="style11115" align="center">     <tr>         <td style="width: 68px; height: 23px;" class="style11111 " valign="top"><div id="fb-root"></div><script src="http://connect.facebook.net/en_us/all.js#xfbml=1"></script><fb:like href="http://fbquote.me/like.php?id=<?php print $row['id']; ?>" send="false" layout="button_count" show_faces="true" font=""></fb:like></td>         <td style="height: 23px" class="style11113" valign="top"><a href="http://www.fbquotes.me/like.php?id=<?php print $row['id']; ?>" class="style11112"><?php print $row['like']; ?></a></td>     </tr>     </table> <?php } ?>

alax_pop.php:

<?php include_once("../scripts/config.php"); $like = mysql_real_escape_string($get_['id']);  $current_pop = mysql_query("select pop likes id=$like") or die ("query failed: " . mysql_error());   $pop = $current_pop + 1;    $update = mysql_query("update set pop = ".$pop." id = ".$like."") or die ("query failed: " . mysql_error()); ;  ?>

well, there lots of issues in code above:

  1. your logic totally wrong including inside loop!

    1. you including same div "id" multiple of times (9 times according mysql query)
    2. including fb js library multiple of times (same thing js initializing snippet)
    3. you missing app id parameter
    4. you building 9 tables (i'm not sure if intended too!)
    5. you once again including fb code couple of times in table!

  2. check @zzarbi answer ajax backend page!

now solution code issues?

  1. do more effort on learning basics of php, html , javascript.
  2. move facebook , table code outside loop.

something started: 

<div id="fb-root"></div> <script src="http://connect.facebook.net/en_us/all.js"></script> <script > fb.init({     status: true,     cookie: true,     xfbml: true });  fb.event.subscribe('edge.create', function(response) {     $.ajax({         type: "post",         url: "popular/ajax_pop.php",         data: "url=" + response          cache: false     }); });  </script> <?php $result=mysql_query("select * likes order id desc limit 9"); if($result) { ?> <table style="width: 90%; height: 4px;" class="style11115" align="center"> <?php while($row=mysql_fetch_array($result)) { ?>     <tr>         <td style="width: 68px; height: 23px;" class="style11111 " valign="top">             <fb:like href="http://fbquote.me/like.php?id=<?php print $row['id']; ?>" send="false" layout="button_count" show_faces="true" font=""></fb:like>         </td>         <td style="height: 23px" class="style11113" valign="top">             <a href="http://www.fbquotes.me/like.php?id=<?php print $row['id']; ?>" class="style11112"><?php print $row['like']; ?></a>         </td>     </tr> <?php } ?> </table> <?php } ?>

in ajax url, read url , extract id it.


Comments

Post a Comment

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table...
Read more

delphi - ESC/P programming! -

-
why need use because printers using tprinter prints weird hieroglyph @ beginning of printable area. my problem if send commands, nothing happens. esc e (#27 #69) - sending escape sequence didn't work expected. removed first letter , rest of string made bold. eg. hello -> ello . after changed esc e esc (#27 #69 #27), worked fine. example managed figure out, but... trying select character table "esc t n" (#27 #116 n), make "õäöü" work. command doesn't work. nothing happens! , command supported esc/p, esc/p 2 , 9-pin esc/p, should work fine. manual can found here . if has ever needed use esc/p commands maybe 1 can shed light how work them! thanks in advance! edit: in previous post asked more or less same question though answers how did send commands printer. (i'll change question there according answers!) i accepted ken's answer, because claimed way transferred commands wasn't best , got work escape command. problem after t...
Read more

c++ - error: use of deleted function -

-
i've been working on c++ code friend has written , following error have never seen before when compiling gcc4.6: error: use of deleted function ‘gamefsm_<std::array<c, 2ul> >::hdealt::hdealt()’ implicitly deleted because default definition ill-formed: uninitialized non-static const member ‘const h_t floppokergamefsm_<std::array<c, 2ul> >::hdealt::h’ edit: comes part of code using boost msm: boost webpage edit2: there no = delete() used anywhere in sourcecode. generally speaking, error mean? should looking when type of error occurs? i don't think other answers mentioning =deleted; syntax correct. error message says default constructor has been deleted implicitly . says why: class contains non-static, const variable, not initialized default ctor. class x { const int x; }; since x::x const , must initialized -- default ctor wouldn't initialize (because it's pod type). therefore, default ctor, need define 1 (and must ...
Read more