View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Spry Tabbed Panels in DreamWeaver CS3

Thread began 6/24/2009 1:41 pm by gwgyesdahl382984 | Last modified 6/26/2009 12:08 pm by gwgyesdahl382984 | 5588 views | 3 replies

gwgyesdahl382984

Spry Tabbed Panels in DreamWeaver CS3

Hi I was reading the post (showthread.php?t=278) concerning cs4 and spry tabs with form submission. I have a similar issue with cs3 and by reading the solution for the above I have managed to get the tab I am working on (tab2 index 1)to re-open after data insert however when first opening my admin page where the tabs are located, the page opens on tab number 2 (index1) and not the first tab as it should. I have forms on about 8 tabs and need the admin page to default to the normal state when first opening and then depending on which tab I am going to work on (probably all of them at different times in one session) I need the tab I am working on at that time to re-open after I click "submit". I have created a test page with two tabs to get this right before placing a new page in my website and have posted the code below here. I am hoping you can show me where I am going wrong with it. Being a total newbie I find most of the forums I have visited are way over my head.. Hope you can help me.. best regards,
###### 2admin.php code below ####
<?php require_once('../Connections/la.php'); ?>
<?php

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO days (day_id, `day`) VALUES (%s, %s)",
GetSQLValueString($_POST['day_id'], "int"),
GetSQLValueString($_POST['day'], "text"));

mysql_select_db($database_la, $la);
$Result1 = mysql_query($insertSQL, $la) or die(mysql_error());
}

$maxRows_days = 10;
$pageNum_days = 0;
if (isset($_GET['pageNum_days'])) {
$pageNum_days = $_GET['pageNum_days'];
}
$startRow_days = $pageNum_days * $maxRows_days;

mysql_select_db($database_la, $la);
$query_days = "SELECT days.`day` FROM days";
$query_limit_days = sprintf("%s LIMIT %d, %d", $query_days, $startRow_days, $maxRows_days);
$days = mysql_query($query_limit_days, $la) or die(mysql_error());
$row_days = mysql_fetch_assoc($days);

if (isset($_GET['totalRows_days'])) {
$totalRows_days = $_GET['totalRows_days'];
} else {
$all_days = mysql_query($query_days);
$totalRows_days = mysql_num_rows($all_days);
}
$totalPages_days = ceil($totalRows_days/$maxRows_days)-1;

$queryString_days = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_days") == false &&
stristr($param, "totalRows_days") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_days = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_days = sprintf("&totalRows_days=%d%s", $totalRows_days, $queryString_days);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="../SpryAssets/SpryTabbedPanels.js" type="text/javascript"></script>
<link href="../SpryAssets/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
</head>

</head>

<body>
<div id="TabbedPanels1" class="TabbedPanels">
<ul class="TabbedPanelsTabGroup">
<li class="TabbedPanelsTab" tabindex="0">Tab 1</li>
<li class="TabbedPanelsTab" tabindex="1">Days</li>
</ul>
<div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent">Content 1</div>
<div class="TabbedPanelsContent">Content 2
<form id="form1" name="form1" method="post" action="">
<table border="1" align="center">
<tr>
<td>day</td>
</tr>
<?php do { ?>
<tr>
<td><a href="daydet.php?recordID=<?php echo $row_days['day']; ?>"> <?php echo $row_days['day']; ?>&nbsp; </a> </td>
</tr>
<?php } while ($row_days = mysql_fetch_assoc($days)); ?>
</table>
<br />
<table border="0">
<tr>
<td><?php if ($pageNum_days > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_days=%d%s", $currentPage, 0, $queryString_days); ?>">First</a>
<?php } // Show if not first page ?>
</td>
<td><?php if ($pageNum_days > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_days=%d%s", $currentPage, max(0, $pageNum_days - 1), $queryString_days); ?>">Previous</a>
<?php } // Show if not first page ?>
</td>
<td><?php if ($pageNum_days < $totalPages_days) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_days=%d%s", $currentPage, min($totalPages_days, $pageNum_days + 1), $queryString_days); ?>">Next</a>
<?php } // Show if not last page ?>
</td>
<td><?php if ($pageNum_days < $totalPages_days) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_days=%d%s", $currentPage, $totalPages_days, $queryString_days); ?>">Last</a>
<?php } // Show if not last page
?>
</td>
</tr>
</table>
Records <?php echo ($startRow_days + 1) ?> to <?php echo min($startRow_days + $maxRows_days, $totalRows_days) ?> of <?php echo $totalRows_days ?>
</form>

<form action="<?php echo $editFormAction; ?>" method="post" name="form2" id="form2">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">Day:</td>
<td><input type="text" name="day" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">&nbsp;</td>
<td><input type="submit" value="Insert record" /></td>
</tr>
</table>
<input type="hidden" name="day_id" value="" />
<input type="hidden" name="MM_insert" value="form2" />
</form>
<p>&nbsp;</p>
</div>
</div>
</div>
</div>
<script type="text/javascript">
<!--
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1", { defaultTab: 1 });
//-->
</script>
</body>
</html>
<?php
mysql_free_result($days);
?>

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...