Nice job man! I have a question. Instead of a SQL query I would like to know if you can fill the table with an array. I want to use it as shopping cart, so, I don´t want to copy the products to the database untils the user has finished. So I want to creat a product´s array and show them in the table, with delete and add button.

Is it possible? May be the answer is in front of me, but I am quite novice in php.

Thanks!

try it please and let me know, if you can see anything…
like:

include(“adodb/adodb.inc.php”);

$dbObject = activeDBLib(“ADODB”);
$dbObject->connect($dbhost,$dbuser,$dbpass,$dbname);
$result = $dbObject->execute(“hier comes your query”);
$dbObject->debug();
$dbObject->error();
print($dbObject->htmlTable());
print($result);

I get no errors and i seem to get an accurate count of the amount of records in querying in my database (67 to be exact –which is shown on your table as the number of records) The problem is that the actual values from the records aren’t being echo’d to the screen. So i get a sortable table of no values. I looked into adodb-mssql.inc.php and activeDBLib.php but nothing. Any ideas?

If your problem is like the second one, I´ve already been thinking about it during the design phase and there is a secondKey property for the class phpSortColumn. But the propertys value will only be appended to your phpSortable entry, if the column has the datatype “link”. There you should properly intialize the secondKey and secondKeyColumn properties in your phpSortColumn declaration. For more details see the docs.
I hope it has been helpfull…

Regards

bye

this version of the Class doesn´t work with multiple keys yet.
I know, it can be very helpfull and be working in this feature a.s.a.p.

Regards

does this class work with multiple keys in the table. If yes how can I use it.

bye

ilpaso

yes, you are right. The WHERE part gets lost because the $_POST and $_GET are not appended to the Sort links in your version, I supose.

I have already solved this problem in an other version of phpSortTable… the new version is called phpSorTable and can be found hier: http://www.phpclasses.org/browse/package/3704.html.

But therefore you should convert your $_POST vars in $_GET vars before you call the printTable() method. The POST vars get lost, but the GET should not.
There you can also find an online documentation for these version.

Please try it and let me know, if it works in your project.

Best Regard,

Wagner

It works perfectly on a simple query, but I get the WHERE part of the query from a form ($_POST). So the table is shown the first time, but when I use the sort function I only get an empty screen. My conclusion is that the WHERE part gets lost, because if I give a hard definition it works OK.

Can you help me?

Regards,

Stoitjkov