Metabase - working example

It would be real nice to have working example of populating a form from data in a table using metabase

That is the purpose of this complementary class:

phpclasses.org/databaseaccess

Use it with Metabase and also with the forms generation class. The forms class even comes with nice plug-ins to implement AJAX controls that link select inputs with options from a database, and also auto-complete text inputs with values retrieved from a database query using Metabase on the server side.

phpclasses.org/formsgeneration

I acutally downloaded thatand was looking at it. I am really new to this, where do you put the call to selectformvalues? Could it be right after your last AddInput to the form?

Like I said I am still a little new this, so please forgive my lack of knowledge.

Yes, first you need to add the inputs to the form. Then you use selectformvalues to load the input values from database query results.

well i am close but I got this error
Fatal error: Call to a member function Query() on a non-object in /Library/WebServer/Documents/phpclasses/metabase/metabase_interface.php on line 28

i was working off your example

$error=MetabaseSetupDatabaseObject(array(
"Type"=>"mysql",
"User"=>"root",
"Password"=>"software"

), $db);
if($error!="")
{

echo "Database setup error: $error\n";
exit;

}
$db->SetDatabase("test");
MetabaseSetDatabase($db->database,"test");




and then later in my code



/*
* Create a databaseaccess object.
*/
$dba=new database_access_class;




and then

$error = $dba->selectformvalues(

$form,
"users",
array(
"id"=>"Integer",
"user_name"=>"text",
"name"=>"text",
"password"=>"text",
"reminder"=>"text",
"email"=>"text"
),
array(
"id"=>"id",
"user_name"=>"user_name",
"name"=>"name",
"password"=>"password",
"reminder"=>"reminder",
"email"=>"email"
),
array(
"id"=>"",
"user_name"=>"*****",

"name"=>"",
"password"=>"",
"reminder"=>"",
"email"=>""
),
" WHERE id = 1"

);


I am leaving something out i know

Thanks

You need to set the database handle variable of the database access class.

$dba->database = $db->database

well i got a lot closer, but now I have an error in this line$error = $dba->selectformvalues(

$form,
"users",
array(
"id"=>"Integer",
"user_name"=>"text",
"name"=>"text",
"password"=>"text",
"reminder"=>"text",
"email"=>"text"
),
array(
"id"=>"id",
"user_name"=>"user_name",
"name"=>"name",
"password"=>"password",
"reminder"=>"reminder",
"email"=>"email"
),
array(
"id"=>"",
"user_name"=>"",
"name"=>"",
"password"=>"",
"reminder"=>"",
"email"=>""
),
" WHERE id = 1"

);
unexpected T_VARIABLE in /Library/WebServer/Documents/samples/users_form.php on line 361

am i missing a paren in there? I am never really sure where this error comes from

You have been a tremendous help

Thanks again

It looks Ok. Maybe you are missing a semi-colon in the previous line.

well you were right, I was missing a semi colon on the previous line. I put that in, and now the form is being displayed but the values from the record are not there. I call to the metabase query on the previous line and got the fields returned, so I think I am still doing something wrong.The from that I am displaying is basically form_body.html.php from your templates directory.

Almost there.

Thanks again

I figured it out, I had lowercase on types of fields - thanks a lot. But I am sure more questions will follow. Great set of classes you have written.