StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POJoomla plugin database mistakes? What is wrong here?
primarykey
Id
12086995
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-08-23T07:47:16.830
FavoriteCount
0
LastActivityDate
2012-08-23T09:19:24.617
LastEditDate
LastEditorUserId
0
OwnerUserId
2115030
ParentId
0
PostTypeId
1
Score
0
ViewCount
144
LastEditorDisplayName
text
Body
<p>i've just started learning Jplugin development, so here i made a little voting script. Everything here works fine, but i want conf.php file to be made in joomla framework style. As you see here, 1 and 2 files works perfectly together. I want to use third example instead of second, in which i use simple php code. The last example i tried to do is using joomla framework, but it doesnt work. I have no idea what's wrong with that code. Anyone see could tell where I made a mistake or maybe far away from doing it right ?</p> <pre><code><?php defined( '_JEXEC' ) or die; ?> <?php class plgSystemRatingx extends JPlugin { public function onContentBeforeDisplay() { ?> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $(".like").click(function() { var id=$(this).attr("id"); var name=$(this).attr("name"); var dataString = 'id='+ id + '&name='+ name; $("#votebox").slideDown("slow"); $("#flash").fadeIn("slow"); $.ajax ({ type: "POST", url: "conf.php", data: dataString, cache: false, success: function(html) { $("#flash").fadeOut("slow"); $("#content").html(html); } }); }); $(".close").click(function() { $("#votebox").slideUp("slow"); }); }); </script> <body> <div style="margin:50px"> <a href="#" class="like" id="1" name="up">Like</a> -- <a href="#" class="like" id="1" name="down">Dislike</a> <div id="votebox"> <span id='close'><a href="#" class="close" title="Close This">X</a></span> <div style="height:13px"> <div id="flash">Loading........</div> </div> <div id="content"> </div> </div> </div> <?php return true; } } </code></pre> <p>this piece of code works perfectly</p> <pre><code><?php $mysql_hostname = "localhost"; $mysql_user = "px"; $mysql_password = "px"; $mysql_database = "jum"; $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Opps some thing went wrong"); mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong"); if($_POST['id']) { $id=mysql_real_escape_string($_POST['id']); $name=mysql_real_escape_string($_POST['name']); mysql_query("update messages set $name=$name+1 where id='$id'"); $result=mysql_query("select up,down from messages where id='$id'"); $row=mysql_fetch_array($result); $up_value=$row['up']; $down_value=$row['down']; $total=$up_value+$down_value; $up_per=($up_value*100)/$total; $down_per=($down_value*100)/$total; ?> <div style="margin-bottom:10px"> <b>Ratings for this blog</b> ( <?php echo $total; ?> total) </div> <table width="700px"> <tr> <td width="30px"></td> <td width="60px"><?php echo $up_value; ?></td> <td width="600px"><div id="greebar" style="width:<?php echo $up_per; ?>%"></div></td> </tr> <tr> <td width="30px"></td> <td width="60px"><?php echo $down_value; ?></td> <td width="600px"><div id="redbar" style="width:<?php echo $down_per; ?>%"></div></td> </tr> </table> <?php } ?> </code></pre> <p>and this made in joomla style doesnt work at all</p> <pre><code><?php defined( '_JEXEC' ) or die; ?> <?php if(JRequest::getVar('id')) { $id = JRequest::getInt('id'); $name = JRequest::getInt('name'); $db = JFactory::getDbo(); $query = $db->getQuery(true); $query2 = $db->getQuery(true); $queryup = $db->getQuery(true); $querydown = $db->getQuery(true); $query->update('messages'); $query->set("message = 1"); $query->where("id = $id"); $query2->select('up,down'); $query2->from('messages'); $query2->where("id = $id"); $queryup->select('up'); $queryup->from('messages'); $queryup->where("id = $id"); $querydown->select('down'); $querydown->from('messages'); $querydown->where("id = $id"); $db->setQuery( $query ); $db->query(); $db->setQuery( $query2 ); $db->query(); $db->setQuery( $queryup ); $data0 = $db->query(); $db->setQuery( $querydown ); $data1 = $db->query(); $up_value= $db->insertid($data0);; $down_value = $db->insertid($data1); $total=$up_value+$down_value; $up_per=($up_value*100)/$total; $down_per=($down_value*100)/$total; ?> <table width="700px"> <tr> <td width="30px"></td> <td width="60px"><?php echo $up_value; ?></td> <td width="600px"><div id="greebar" style="width:<?php echo $up_per; ?>%"></div></td> </tr> <tr> <td width="30px"></td> <td width="60px"><?php echo $down_value; ?></td> <td width="600px"><div id="redbar" style="width:<?php echo $down_per; ?>%"></div></td> </tr> </table> <?php } </code></pre>
Tags
<ajax><plugins><joomla>
Title
Joomla plugin database mistakes? What is wrong here?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJonuux
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.