Hi,

I created a basic form using the db-form wizard and copied file and db_myutil.inc to web server.

Running the form, I can add to database OK.

Using query ?id=62 returns a blank form.

Running query from NuSphere IDE returns data.

Any ideas?


Also, any easy way to generate a lising of records in table that will allow user to click on a listing to see details? Or does that have to be coded by hand.

Thanks!!

If you need a basic table-aware editing tool, you'd take mysqladmin or pgsqladmin projects (both are written in php) and derive whatsoever you need. They both are really good projects. As with db-wizard, it's a kind of trivial tool and if you get a problem with generated scripts you always may check that with the IDE itself. Did you forget about debugger ?
If you experienced a problem with DB wizard that can be replicated, we will thank you for more detailed report.

I was looking for more of a table editing tools for users like phpMyEdit.

But anyway, in the db-form generated file we have the comments

// The default mode of this script allows a user to add a new record
// to table 'mos_users' in database 'psax'.
// To have this form function in update mode, the script needs to be
// called with a parameter for 'id' (key record field).
//
// Example: localhost:9000/myapps/myscript.php?id=3

// This would display the form with the data for record #3 appearing
// in each field.
//
// To serve the purpose of viewing a record call the form in the same
// way you would if it were to be used for 'Update mode' with the exception
// that you would probably want to remove the 'Save' button.


but if I try something similar to the example, a blank form is shown.

I tried to print the value for $id, but it was blank.

I read a post that if you had register_globals=off in the php server configuration, the value for passed variable would be blank.


But I was hoping that the wizard would take that into account.

Does that sound like what is happening?

I think that localhost:9000/myapps/myscript.php?id=3 is wrong URL
It is _sample_ and you'd adjust URL accordingly, depending on where you placed the script.

Yes, I know

Same issue, the variable for the primary key which is also id in my db, does not seem to get passed correctly. If I try to print id in the php code, nothing is returned.

I meant echo not print

this is perhaps a little late, and hopefull the issue's been resolved.. I had the same problem, and for me, I had register_globals = off (the secure way of doing PHP). So right after the POST statement at the top of that comment you referenced above, I put $ID = $_GET['ID']; I think there's a slightly better way with "isset()" or something, but there you go...