New Module Data Table

[web-based-media]

Hi, thank You for thi great module. I guess this is just what I am lookin for.
But I have one big problem (due to I have no clue about mySQL...)
I would use the Data of one of the table-cells and put it into a pulldown-menue in a contakt form.
Can anybody help me with that?

Thanx in advance.
Kind regards
Jan

[Spritemarkiv]

Hi Jan,
This might get you started.

Code:

//Page number of your database
$datatablepage=4;


//connect to database 
// access database and obtain users table
$query = "SELECT * FROM ".TABLE_PREFIX."mod_datatable".$datatablepage;
$results = $database->query($query);

echo"<select>";
  while($row = $results->fetchRow()) {
          // write out usernames, last login & more
        echo "<option>". $row["Your_column_name_here"]."</option>";
}
echo"</select>";

[web-based-media]

Hi Spritemarkiv,
thank You for the help.
But unfortunately I have no clue how to use this code or where to put it...
I would need the data of the tables in a normal contact form. It is meant for booking certain events. Kind of Date Picker is what I am looking for, I guess.

Regards
Jan

[Spritemarkiv]

It sounds like you would do better with the booking module. http://www.websitebakers.com/pages/modules/calendar-and-time/bookings.php

[web-based-media]

Yes, I think so, but I tested it and it does not do the job I need, too. Date Picker for registration form is missing...
But thank You for the advice.

[donv]

I was thrilled to find this module and installed it yesterday.

I created a page with the data table and was able to set up the column headers. One thing I noted when doing so is that having non-alpha or space characters in a column name prevented adding that column (I had tried adding cols. with a & and $ in them, then tried +, -, ., and , with the same issue). It failed silently with no error message but did not add the column until the name was revised.

So I had my table with the revised column headers and went ahead to add a row and fill in the data. One column was a monetary amount, so I entered $123 and saved the value.

After that, the page updated and my row did not display (just the column header/footer), and the Show/Hide Tools button will not open.

I tried reloading the page and got the following messages in a hover-over dialog, one after the other:

• Warning: ColVis requires DataTables 1.7 or greater - www.datatables.net/download
  
• Warning: TableTools requires DataTables 1.5 or greater - www.datatables.net/download

Given the above, I figured the special character '$' might be causing the issue, so used phpMyAdmin to take a look at the database. The record was added. So I used the db editor to remove the '$', then went back to the original DataTable page of my site and reloaded it. Got the same two messages and the row did not display, etc. I tried forcing a complete reload with shift-reload (Firefox 4) but no change.

So this was using FF4 on Ubuntu 11.04 and my site is WB 2.8 with DataTable 0.73 (latest as of yesterday).

Through further experimentation, I find that if I log out and back in again after clearing the special characters from the database, the page will again display properly. It appears there is a need to do something to escape/transform/filter special characters?

[donv]

Correction: The above is with version 7.4. I used the latest DataTable 7.4 zip file, but the module's info.php gives Version 0.73 via the "Module Details" function in the backend.

[Spritemarkiv]

Hi Donv,
Thanks for the well documented feedback. I will have a look into it and let you know what I can do.

[Spritemarkiv]

New version available on AMASP.

Version 0.7.6
*Feed back when column is added or fails
*Upated DataTable Jquery Plugin to v 1.7.6

Donv,
Column header are now striped to use only alphanumeric characters any spaces are replaced with a "_".
ie"My*$@% Column Name" becomes "My_Column_Name".  Should there be any MYSQL error or success it is reported on the page. Unfortunately it is just before a mandatory page refresh, so the feed back only shows for a few seconds.

Thanks again for the feedback, and let me know how it goes.

[bschaich]

Hi,

did anybody ever try this module on 2.8.2?
I cannot add any column to the table, it seems the table just does not react.

Regards,
Benny

[scoob2000]

Yes, i seem to have the same problems.
The backend works just as it should.
When i access the frontend page "delete all rows" doesn't work, i can't add a row or column, only the "Delete row" button seems to work.

I've downloaded the latest version, installed on a clean 2.8.2 installation, checked out the given answers in this forum and tried again, but unfortunately with the same results.

Later on i will be able to test this at another hosting provider.
If any results differ i'll post it here.

Thnx

[lausianne]

Just installed v0.7.6 on WB2.8.3r1638. Initially it worked fine. I could add rows and columns and edit data. Then I tried to hide columns. The columns disappeared, although the checkmarks stayed in the control boxes. Eventually I had all columns hidden, then switched them on again. The columns are all back now, but no rows are displayed anymore ...
There is a box with a message "Bitte warten..." (please wait). Stays there forever.

In the console I see this error: obj is null (data-table.php (Zeile 58))
That row reads:    obj.style.visibility = "visible"

[lausianne]

ok. I tried exactly the same thing again (deleted the data table page, created it again, clicked the same buttons). Now everything seems to work as it should ... strange ... Only thing I did inbetween was deleting all cookies.

Cool module, very nice, thank you!

[lausianne]

For the application that I have in mind, it would be necessary to have a "fixed" filter for the data. What I'd like to do is display user specific data. I.e. each registered user sees his own data. In that case one of the columns contains user ids, and a logged in user sees only those rows that correspond to his user id.
I "believe" this should be very simple to add to the module. Just one more line in the query ... I wouldn't mind to hard code that. Maybe you could give me a hint where to add that line?
Another question: how "safe" is the module? My table will contain sensitive data, and it is very important that no user can ever see any data of any other user ...

Thank you!

[mdemaree99]

Using WB2.8.1  and I can get dynamictable to work, but not this one..

I have tested on different templates and table appears at top  of screen outside of block.
Exactly the mod I need to get working...

[marmot]

Hi,

In that case one of the columns contains user ids, and a logged in user sees only those rows that correspond to his user id.
I "believe" this should be very simple to add to the module. Just one more line in the query ... I wouldn't mind to hard code that. Maybe you could give me a hint where to add that line?

try line 64 in Server_Side_Process ing.php:

Code:

$query="SELECT * FROM ".$sTable;

Regrding security I have no tipps.

regards