AJAX engine listings data with PHP and mySQL

[Luckyluke]

Hi,

Here is a message for all of you PHP coders.
On this site you will see an AJAX engine listings data with PHP and mySQL. What's in a name but it looks like powerful stuff.
Since I'm not a PHP coder, I want to know whether someone can fold this in a WB module or snippet?
Or, maybe it fits in the Address module from Aldus (look here).

Grtz,
Luc

[Luckyluke]

Nope, It doesn't work in the "code" section 
Hmmm....

[kweitzel]

And if you "include" it via php?

cheers

Klaus

[Luckyluke]

Thx for the response Klaus!

It didn't work with an include.
I put the php and js scripts in the map modules/lst/...
With the error messages on (E_ALL) it couln't connect to the database. The dbname, password etc are all correct.
Maybe the first module can't find the other modules but my php brain isn't that strong.

I know this is a very strong module for viewing data from a database. I hope it will work. But I'm not loosing my patience, so I look further for a solution 

Grtz,
Luc

[pcwacht]

Remember if you use code wich make a connection to the database you need to reconnect to the database the WB way or WB won't know the database!

Code:

$database = new database;

I had simular done with datagrid -> http://phpbuilder.blogspot.com

What I did was copying the extracted datagrid to the modules dir
Made a code page and put the content of code_template.php in it and start modifying what I needed

Tips
- before you start using datagrid , try playing with the settings
- make sure you fetch the datagrid with the correct version php you have!
- test for the username to set editing on and off etc.

Code:

if ($wb->get_username()=="admin" ) {
 $admin=1;
}else {
 $admin=0;
}

Have fun,
John

[Luckyluke]

Remember if you use code wich make a connection to the database you need to reconnect to the database the WB way or WB won't know the database!

Code:

$database = new database;

I had simular done with datagrid -> http://phpbuilder.blogspot.com
..............
..............

Have fun,
John

Hi John,

Thx for the response but all this is too heavy for me 
But I looked to the datagrid as well but It didn't work.

Can I see a running demo of the datagrid? The live demo's at the datagrid site doesn't work.
I just want a sortable grid with groups.
Aldus was making something but he's a busy man 

Grtz,
Luc

[pcwacht]

Find another one wich seems easy enough

phpMyEdit -> http://www.phpmyedit.org/

John

[Luckyluke]

Find another one wich seems easy enough

phpMyEdit -> http://www.phpmyedit.org/

John

It has some potential. However, there is no hoover for selecting the row.
But I have to test it. I've got some results in Wamp without WB running.

Luc

[Luckyluke]

I had simular done with datagrid -> http://phpbuilder.blogspot.com

What I did was copying the extracted datagrid to the modules dir
Made a code page and put the content of code_template.php in it and start modifying what I needed

Tips
- before you start using datagrid , try playing with the settings
- make sure you fetch the datagrid with the correct version php you have!
- test for the username to set editing on and off etc.

Code:

if ($wb->get_username()=="admin" ) {
 $admin=1;
}else {
 $admin=0;
}

Have fun,
John

Djeezes, Pfft... a lot of settings. I just want to view some data and I see the words "delete"  and "change". I just want to view data with a filter on a field. I'll test again but I think there is too much "gadgets" on this grid.

Luc

[pcwacht]

If you can create a table form the db, try this one:

Next to these there are some smart ajax classes wich can turn any ordinary table into clientside filtering/search enabled lists etc
If you need some links for these, just ask.
Got some links somewhere...
The nicest one I know is sortables -> http://free-javascript.all-faqs.info/sorttable2.html


Have fun,
John

[Luckyluke]

There are some nice table sort scripts in this link http://www.ajaxdaddy.com/ (and also other nice scripts).
But, none of them are good for me. I want a little popup-window with more info about the selected record.
I google some more 

Luc