tables, user data, LibraryAdmin, ect..

[mdemaree99]

I know this is long, but posted in another section and no response and having issues with tables.  Does anybody have  a good demo (see front and back end code) / walk through for tables and dealing with reports and members data.  My organization has used an access database in the past for user info and reports, but with the migration to websitebaker I would like to be able to move away from the access database all together.  If nobody has anything once I get the help I'll post some power point / word documents on how-to do a few things after I am done. 

I have tried several mods, but no luck to what I am really wanting...
Some success:  User Extend, DataTable, and DynamicTable

User Extend is table name I want and seems to be nice, however I cannot add or remove columns.  Would like to be able to incorporate this with DataTable.

I liked DataTables (and will use if needed) but wanted to know if there was any way to define the name of the table that is used vs let the program pick wb1_mod_datatable20 8 (it picks number)  datatable and a number doesn't define the table enough for me.  Ideal would be able to use this

DynamicTable is nice and quick, but can't change the table id.

LibraryAdmin Looks good, but I get:
Fatal error: Class 'PDO' not found in \\NAWINFS03\home\users\web\b1283\rh.jla\baker\modules\wblib\wbDatabase\class.wbDBBase.php on line 30

I checked out http://www.websitebakers.com/pages/libs/libraryadmin.php like another topic states, but
there isn't any help there.  Just info on each upgrade.

Finally.... I have played with SQL and PHP in the past, but can't seem to get everything to work out.
Depending on the user that is logged in I would like the user to be able to see his info.
Would like to join the wb1_users, wb1_groups(show group name vs #) , and  wb1_user_extend

Parse error: syntax error, unexpected '"' in \\NAWINFS03\home\users\web\b1283\rh.jla\baker\modules\code\view.php(32) : eval()'d code on line 5

Code:

if (isset($_SESSION['USER_ID']) && is_numeric($_SESSION['USER_ID'])) {
    // get login data of actual user from database
$sql = 'SELECT `wb1_users` . * , `wb1_groups` . * , `wb1_user_extend` . * '
        . ' FROM wb1_users , wb1_groups , wb1_user_extend '
        . ' WHERE `wb1_users` "." `user_id` = '" . $_SESSION['USER_ID'] . "';         
                       $results = $database->query($sql);
   if ($results && $data = $results->fetchRow()) {     
   echo "<b>----------------</b><br>";
   echo "<b>Basic info:</b><br>";
   echo "<b>----------------</b><br>";
   echo "Name :     ".$data['display_name']."<br>";
   echo "user_name : ".$data['username']."<br>";
   echo "user_id   : ".$data['user_id']. "<br>";
   echo "group_id : ".$data['group_id']."<br>";
   echo "Status : ".$data['name']."<br>";

   echo "e-mail : ".$data['email']."<br>";
   echo "login when : ".date('F j, Y, g:i a',$data['login_when'])."<br>";
   echo "login ip : ".$data['login_ip']."<br>";
   echo "active : ".$data['active']."<br>";
   echo "<b>----------------</b><br>";
   echo "<b>Extra info:</b><br>";
   echo "<b>----------------</b><br>";
   echo "<u>User-Status:</u> ".$data['status']."   <u>Club:</u> ".$data['association']."<br>";
   echo "<u>Full Name:</u> ".$data['title']."  ".$data['first_name']."  ".$data['surname']."  <b><u>Displayed as:</u></b>".$data['display_name']."<br>";
   echo "<u>Address:</u> ".$data['street_nr'].", ",$data['street']." - ".$data['suburb']." / ".$data['town']."  <u>p/c:</u> ".$data['country']."<br>";
   echo "<u>Place of Birth:</u> ".$data['birthplace']." - ".date('F j, Y',$data['birthday'])." - <u>Gender:</u> ".$data['gender']."<br>";
   echo "<u>Contact  -   Phone:</u> ".$data['telephone']."   <u>email:</u> ".$data['email']."   <u>Passport:</u> ".$data['passport']."<br>";
   echo "<hr>";
    }
}

Thanks in advance for any help..

[BlackBird]

LibraryAdmin is no table tool. You can use it to add jQuery Plugins to your page. You need PDO enabled to use it. See http://www.webbird.de/Websitebaker/LibraryAdmin

[bschaich]

Hi,
seems we have the same problem. What you want to do is to actually write a database app. And I tried this with a lot of tools. I checked generators, IDE's and dozens of CMSes. None could go anywhere near how I wanted. What I'm writing is nearly done with a Seminar module that exists in many variations, but never as I want to have it.

I stayed with CMS because it is a pain to doe the app and then bring a design behind it, and I stayed with WB because its routines are simple and crisp (try the database API with Joomla- I'd rather go down to the PHP API before using this).
I ended up with writing everything on pages in code sections and using the xc_Form module. I would really like to have a Form module that writes stuff into table fields, but that needs some more work. I'm thinking of doing this with the Form module, but that will take some time.
If you got some ideas, we could exchange them, as I'm still getting new ideas every other day and have yet no clue about how to bind in the cool stuff like jQuery...

Regards,
Benny

[mdemaree99]

I was able to get PDO enabled, and get the first page of LibraryAdmin, but it will not do anything after that.  Just goes to a blank page when I click anything.  Trying to get into the LibaryAdmin forum, but registered and can't log into the website.   Assuming website is having issues....

Once I get my script figured out I will probably port it to a droplet that would allow me just enter table name and it would populate the page from there.  Possibly add DynamicTable in a second section underneath it that would control the remaining part of the database.

[BlackBird]

@bschaich: Make a concept and try to get a paid developer to do it.

[BlackBird]

Trying to get into the LibaryAdmin forum, but registered and can't log into the website.

Have you received the unlock mail and clicked on the link? What's your nick there? (You can post it to me by PN.)

As Spammers still manage to register there, I don't think it's a problem with the Forum.

[bschaich]

@bschaich: Make a concept and try to get a paid developer to do it.

Yes, that would be the shortest way, but without any fun! 

[bschaich]

Once I get my script figured out I will probably port it to a droplet that would allow me just enter table name and it would populate the page from there.  Possibly add DynamicTable in a second section underneath it that would control the remaining part of the database.

If that is a droplet with just the  table name in it, it must be a mighty module that will do this. Think  only about fdifferent datatypes you have to read there. I think there are some more modules that might be usefull for that stuff.

Regards,
Benny

[Bug]

If i understand you correctly you wish to store more info than the standard info into the user rable and retrieve this with a module?


If so my guess is to first expand the user tables with all needed infofields and then use a snippet like f.i. Bakery anyitems to retrieve the needed fields from the database. You will offcourse need to alter bakery anyitems but since yt is a very small piece of code it is not so hard

Then again: maybe i do not understand you correctly