spry tabbed panels and mysql db

Report · Apr 24, 2008

I'm new to DW and am using CS3. The web page that I'm creating has a product page that would be great with the Spry Tabbed Panels.

My database is in MySql and I made a record set and then inserted a dynamic text table within a Spry Tabbed Panel (Tab 1). When I upload it onto my host, the data does not display but the table outlines and headers do. Tab 2 (did the same) nothing shows up at all. So I started wondering, is it possible to use Mysql databases within Spry Tabbed Panels? Everything that I've found talks about importing Mysql into xml. I was really hoping not to do that because I have other tables on other pages that are working lovely (not in panels). And I was wanting to use the mysql insert record form for the owner of the website to update their own data.

I hope I'm making enough sense here! Suggestions would be highly appreciated.

P.S. did i need to tell you that I'm using php?

Report · May 09, 2008

I'm experimenting with this also.

I believe, and I am open to correction, that Spry Panels cannot handle PHP or ASP driven Data directly. It needs to be converted to XML and then it can populate the Spry panels.

I see many referenced to this same issue throughout the web and never a direct response of, "It cannot be done...yet", except for links to documents on using XML data.

So you need to generate an XML file form your database and then onto the Spry Panel.

Adobe seem to be slow to admit this though for some reason........

Report · May 09, 2008

I am using a 3 tabbed panel with PHP/MySQL with much success. I have one tab for viewing users, one for adding users, and one for searching for users.

There must be something else going on here.

Glenn

Report · May 11, 2008

Abd you are not pulling the data from an XML file?

If not, how are you populating the panels in each tab?

I have have continuously tried this and the page loads as blank.

I create the usual binding recordsets. If I just drag a link straight onto the page it works fine.

If I then drag the same link into a tabbed panel....nothing.

Did you do have to customise anything?

Report · May 11, 2008

No, I'm just pulling data from a MySQL database with a record set and server behaviors.

I did nothing special to the page nor did I customize anything that I am aware of.

Unfortunately, I'm not sure how to help you, but wanted you to know that it will work.

Good Luck.

Glenn

Report · May 15, 2008

I did get this to work eventually without converting to xml data. I wish I could think of what the trick was so I could share with you. I think I just created a data recordset and then inserted a data table. If I remember correctly I was trying to get too fancy and trying to use repeat regions or something.

Good Luck! I hope you get yours working also.

Report · Oct 16, 2011

I want to paginate the output from an asp page (recordset with some tables etc) within a particular tab, without changing the tab. However, the pagination code is available on the output asp page, and not on the asp page having the tabbed panel.

When we click the next link on the output (placed inside the content portion of the tabbed panel), it should not open outside the tabbed panel, but the same tab should display the next set of records as per the offset values.

Please advise.

The code i am using is given below.

<body>
<div id="TabbedPanels1" class="TabbedPanels">
<ul class="TabbedPanelsTabGroup">
      <li class="TabbedPanelsTab" tabindex="0" onclick="Spry.Utils.updateContent('two','sample.asp?page=' <%=i%>); Spry.Data.initRegions();" >Tab 1</li>
       <li class="TabbedPanelsTab" tabindex="0">Tab 2</li>
</ul>
<div class="TabbedPanelsContentGroup">
    <div id=two class="TabbedPanelsContent">Content 1</div>
    <div class="TabbedPanelsContent">Content 2</div>
</div>
</div>
<script type="text/javascript">
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
</script>