Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Code Snippet and functions - 8
  5. Blank Center Panel

Blank Center Panel

Asked Modified Viewed 3,647 times
Back to Forum Index Previous Topic Next Topic
Print
A
afoster
A
  • Senior Member, joined since
  • Contributed 725 posts on the community forums.
  • Started 128 threads in the forums
  • Started this discussions
asked
Senior Member

I have the following code that I am trying to place in a panel, and although the database information is being pulled correctly, it is blanking out the center panel. Can anyone show me where my mistake is located?

Code Download source
if (!defined("IN_FUSION")) { die("Access Denied"); }

opensidex("Spreads Pool");
$sql = dbquery("SELECT * FROM table Where tot_wins>0 ORDER By tot_wins DESC Limit 0,5");
echo '<br>
<table align="center" cellspacing="1" cellpadding="3" width="100%" class="tbl-border">
<tr class="tbl2"><td width="50%"><b><center>Name</b></td><td width="25%"><b><center>Won</b></td><td width="25%"><b><center>Win Pct</b></td></tr>';
while($data = dbarray($sql))
{
   echo '<tr class="tbl1"><td>'.$data['name'].'</td><td align="right">'.$data['tot_wins'].'</td><td align="right">'.$data['pct'].'</td></tr>';
}
echo '</table>
<br>';
openside("Confidence Pool");
$sql = dbquery("SELECT * FROM table1 Where cpts>0 ORDER By cpts DESC Limit 0,3");
echo '<br>
<table align="center" cellspacing="1" cellpadding="3" width="100%" class="tbl-border">
<tr class="tbl2"><td width="50%"><b><center>Name</b></td><td width="25%"><b><center>Won</b></td><td width="25%"><b><center>Conf Pts</b></td></tr>';
while($data = dbarray($sql))
{
   echo '<tr class="tbl1"><td>'.$data['name'].'</td><td align="right">'.$data['tot_wins'].'</td><td align="right">'.$data['cpts'].'</td></tr>';
}
echo '</table>';
closeside();
closesidex();


Thanks for your help.
0 replies

11 posts

J
jikaka
J
jikaka 10
www.rusfusion.ru - russian nss
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 82 threads in the forums
answered
Veteran Member

in php-fusion v7.02 function opensidex no longer used
0 replies
A
Ankur
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
answered
Veteran Member

Quote

jikaka wrote:

in php-fusion v7.02 function opensidex no longer used


Yes. jikaka is right. Use openside and closeside.
0 replies
C
Craig
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
answered
Fusioneer

WRONG!!! Wrong!

opensidex closesidex is still supported try it guys. I just did and it does work as usual.
0 replies
A
Ankur
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
answered
Veteran Member

Yes Fangree is right... We are wrong...

There could be problem with your Query. Do you think that you are doing the correct query ? is it the table as table or it should be ".DB_PREFIX."table ?
0 replies
J
jikaka
J
jikaka 10
www.rusfusion.ru - russian nss
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 82 threads in the forums
answered
Veteran Member

how can work opensidex(), if she never set?
:P
0 replies
C
Craig
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
answered
Fusioneer

What?

if you use opensidex closeidex then it will be closed default until you either state on or off in the panel title.
0 replies
A
afoster
A
  • Senior Member, joined since
  • Contributed 725 posts on the community forums.
  • Started 128 threads in the forums
  • Started this discussions
answered
Senior Member

I don't know if this is the right way to fix this problem, but adding these two lines at the end of the code worked.

Code Download source
echo "</td>";
echo "</table></center>";
0 replies
C
Craig
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
answered
Fusioneer

I see the issue its because you are using a mix of ' and " it should be like this....

Code Download source
if (!defined("IN_FUSION")) { die("Access Denied"); }

opensidex("Spreads Pool");
$sql = dbquery("SELECT * FROM table Where tot_wins>0 ORDER By tot_wins DESC Limit 0,5");
echo "<br>
<table align='center' cellspacing='1' cellpadding='3' width='100%' class='tbl-border'>
<tr class='tbl2'><td width='50%'><b><center>Name</b></td><td width='25%'><b><center>Won</b></td><td width='25%'><b><center>Win Pct</b></td></tr>";
while($data = dbarray($sql))
{
   echo "<tr class='tbl1'><td>".$data['name']."</td><td align='right'>".$data['tot_wins']."</td><td align='right'>".$data['pct']."</td></tr>";
}
echo "</table>
<br>";
openside("Confidence Pool");
$sql = dbquery("SELECT * FROM table1 Where cpts>0 ORDER By cpts DESC Limit 0,3");
echo "<br>
<table align='center' cellspacing='1' cellpadding='3' width='100%' class='tbl-border'>
<tr class='tbl2'><td width='50%'><b><center>Name</b></td><td width='25%'><b><center>Won</b></td><td width='25%'><b><center>Conf Pts</b></td></tr>";
while($data = dbarray($sql))
{
   echo "<tr class='tbl1'><td>".$data['name']."</td><td align='right'>".$data['tot_wins']."</td><td align='right'>".$data['cpts']."</td></tr>";
}
echo "</table>";
closeside();
closesidex();


Also I know you are probably aware of this or don't really mind but it's not XHTML Valid. ;)
0 replies
A
afoster
A
  • Senior Member, joined since
  • Contributed 725 posts on the community forums.
  • Started 128 threads in the forums
  • Started this discussions
answered
Senior Member

fangree_craig, thanks for the revised code. Again, the data is being pulled into the panel however like my code, the center panel information is blank. Yes, I am aware that the code is not XHTML valid.
0 replies
C
Craig
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
answered
Fusioneer

You know its blank until you open the panel coz your using opensidex which is for open/close function by default it is closed click the arrow on the panel it will open
0 replies
A
afoster
A
  • Senior Member, joined since
  • Contributed 725 posts on the community forums.
  • Started 128 threads in the forums
  • Started this discussions
answered
Senior Member

I'm not referring to the panel where the opensidex code is, I am referring to the center panel where the news, articles etc is displayed. PHP Fusion has a left hand panel, right hand panel and a center panel. With your code (and with mine prior to adding the two lines mentioned earlier), the center panel information is not displayed.
0 replies

Category Forum

Code Snippet and functions - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 11 posts
  • Votes 0 votes
  • Topic users 4 members

4 participants

C
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
A
A
  • Senior Member, joined since
  • Contributed 725 posts on the community forums.
  • Started 128 threads in the forums
  • Started this discussions
J
J
jikaka 10
www.rusfusion.ru - russian nss
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 82 threads in the forums
A
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet