php - How to check if there is an added record on the database -

-

i have here index.php. contains layout , php code inside it. want know if there new record on database. research needs refreshed. tried javascript auto refresh , whole page refreshes if there new records table automatically show new record. problem how know if there changes. able show if there update on database through refresh not able notify if there changes. want put notification if there new records. want know how check if there new records on database. here code.

<div class="panel panel-default">     <div class ="panel-body">       <!-- table of reports -->     <div align = "center" style = " font-size: 9000px">         <table class="table table-striped" name = "report">             <thead>                 <tr align = "center"class = "active" >                      <td class  = "theads" >id</td>                     <td class  = "theads" >message</td>                 </tr>             </thead>              <!--start of php code -->             <?php                $page=1;//default page             $limit=10;//records per page             $start=0;//starts displaying records 0             if(isset($_get['page']) && $_get['page']!='')             {                 $page=$_get['page'];             }                 $start=($page-1)*$limit;                  //get total records (you can use mysql count function count records)                 $query=mysql_query("select report_id reports");                 $rows=mysql_num_rows($query);                  $query=mysql_query("select * reports order datetime desc limit $start, $limit");                   if(mysql_num_rows($query)>0)                 {                     while($row=mysql_fetch_array($query,1))                     {             ?>              <tbody>                 <tr class = 'active'>                 <td align = 'center'><?php echo $row['report_id'] . "<br>";?></td>                 <td align = 'center'><?php echo $row['message'] . "<br>";?></td>                 </tr>             </tbody>                  <?php                     }                 }             ?>         </table>      </div>      </div> </div>

if want notification system on client side can create cookie latest created date , check if created date greater date of cookie count rows having greater date cookie's value.

if want on server side have save last seen created date in database table , above process.

$query=mysql_query("select * reports order datetime desc limit $start, $limit"); if(isset($_session['chk'])) {     $sql=mysql_query("select count(*) new_record reports datetime>$_session['chk']");     $count=mysql_fetch_array($sql);     $new_record=$count['new_record']; // new records }  if(mysql_num_rows($query)>0){$i=0; while($row=mysql_fetch_array($query,1)){if($i==0){$_session['chk']=$row['datetime'];$i++;} ?>

Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile:
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo
Read more