Solved

TableGear - PHP includes

Posted on 2012-04-01
4
924 Views
Last Modified: 2012-04-20
Hi,

I am using TableGear: http://andrewplummer.com/code/tablegear/

index.php code:
<table border="0" bordercolor="" width="100%" cellpadding="3" cellspacing="3">
	<tr>
		<td width="50%"><?php include("inactive-sites.php"); ?></td>
		<td width="50%"><?php include("active-sites.php"); ?></td>
	</tr>
</table>

Open in new window


inactive-sites.php and active-sites.php are technically php grids from TableGear with 2 different select statements. However, when I do so, only inactive-sites.php shows up but not active-sites.php

However, when I run both the scripts independently, they works fine. Here is the code for inactive-sites.php

<?php

include("scripts/tablegear/include/TableGear1.6.1.php");
include("constants.php");

$database_table = "mysites";

$options = array();
$options["database"] = array();
$options["pagination"] = array();

// Database host: if omitted defaults to localhost.
$options["database"]["host"]        = $database_host;

// Basic database information. These are required.

$options["database"]["name"]        = $database_name;
$options["database"]["username"]    = $database_username;
$options["database"]["password"]    = $database_password;
$options["database"]["table"]       = $database_table;

// -- Row Deletion
$options["allowDelete"] = false;

// -- Default Sort
$options["database"]["sort"]       = array("domainname", "expirydate");   // Sorting on multiple fields.

// -- Database Fields
//
// This option will limit the fields selected in the auto query to those specified in the array.
// Also note that if you are using a custom query with fetchData (below) and are limiting the fields
// returned in that query, you MUST specify those exact fields here as well if you want to be able
// to add new rows!
// $options["database"]["fields"]   = array("<FIELD1>", "<FIELD2>");

// -- noAutoQuery (for custom queries)
//
// This will prevent the default query (which selects all fields in the table) from being run automatically.
// Turn this on when using custom queries (fetchData). Note that "table" above is still necessary for
// update/insert to work.
$options["database"]["noAutoQuery"] = true;

// -- Editable fields.
// Defaults to all except the auto increment field.
// $options["editable"]  = array("<FIELD1>", "<FIELD2", "ETC...");


// -- Select Elements
// $options["selects"] = array("<FIELD>" => array("yes", "no"));             // Will output <option value="yes">yes</option>, etc.
$options["selects"] = array("status" => array("active","inactive"));

// -- Totals
// You can add totals to the bottom of the table by adding the "totals" option here.
//$options["totals"] = array("memory","number");

// -- Pagination
$options["pagination"]["perPage"] = 100;  // 10 rows per page.
$options["pagination"]["prev"] = "prev"; // "prev" link will be shown.
$options["pagination"]["next"] = "next"; // "next" link will be shown.
$options["pagination"]["linkCount"] = 20; //  2 links on each side of the current page.

// Instanciates the table. This must be included here!
$table1 = new TableGear($options);

$table1->fetchData("SELECT SQL_CALC_FOUND_ROWS id,sitename,status,notes,id from mysites where status='inactive'");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>TableGear for jQuery</title>
  <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
  <script type="text/javascript" src="scripts/tablegear/javascripts/TableGear1.6.1-jQuery.js"></script>
  <link type="text/css" rel="stylesheet" href="scripts/tablegear/stylesheets/tablegear.css" />
</head>
<body>
  <div>
    <?php $table1->getTable() ?>
  </div>
<?php $table1->getJavascript("jquery") ?>
</body>
</html>

Open in new window

0
Comment
Question by:nainil
  • 2
4 Comments
 
LVL 30

Expert Comment

by:Marco Gasi
Comment Utility
Check if in active-sites.php you use $table1 as in inactive-sites.php: if so, change all its occurrences to $table2

Hope this helps
Cheers
0
 
LVL 108

Expert Comment

by:Ray Paseur
Comment Utility
Please post the URL that shows this in action, thanks.
0
 

Accepted Solution

by:
nainil earned 0 total points
Comment Utility
I found the solution reading the forum for TableGear. All set.
0
 

Author Closing Comment

by:nainil
Comment Utility
I did some more googling and found the solution on the Forum for TableGear.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now