Parent-Child Object relationship?

everknown

I'm trying to create some code to make creation of mysql enabled forms easier (also to learn php, i understand i am reinventing the wheel here.)

This should make it a 2 minute job to create a new mysql enabled form -- just define the fields properites, then in the HTML where i want a mysql enabled field to appear i call somthing like:

<?php mysqlform.insertfield(1);>

The code that reads in existing records, performs the INSERT or UPDATE and does validation will all reference my FORM Object.

If figure the first step is to create a class called mySqlForm. I'd put this in an include file so I could use it in all my apps.

The "myform" class would have properites for the linked db name, the table name, the onsubmit action and a collection of fields that have properites such as the name, label, type, maxchars,size, validation criteria, etc.

Once I get this working I'm going to post in the critique so I can see how real PHP people would have approached the task. For now i'm just trying to get my hybred php/vb pseudo code functional.

So I'm stuck trying to define the form class. All the properties are easy, but i dont know how to define the fields collection. It is obviously an array, but it needs to be an array of FIELD objects defined by my class for FIELDS.

Is there any documentation or tutorials you could point me to? I've never done this in VB so i'm not sure.

rachel2004

I'm not exactly sure what VB has to do with this... but you may want to check out pear.php.net and phpclasses.org

This may have already been solved at phpclasses.org.

ahundiak

class Field
{
  var $name;
  var $type;
  function Field($name,$type)
  {
    $this->name = $name;
    $this->type = $type;
  }
}
class Table
{
  var $fields = array();

  function addField($field)
  {
    $this->fields[] = $field;
  }
}
$table = new Table();
$table->addField(new Field('person_id','integer'));

everknown

As I was writing my pseudocode, if i didn't know how to do it in PHP i wrote it in VB.

Originally posted by rachel2004
I'm not exactly sure what VB has to do with this... but you may want to check out pear.php.net and phpclasses.org

This may have already been solved at phpclasses.org.

everknown

Thank you the code help.

I'm trying to get some output form the fields in the table object but i get nothing returned.

Am i referencing the fields incorrectly or did i set them up wrong? I get the feeling i'm missing something

In VB i would just do "print table.fields[1].text" and looking at the documentation i figure it should be $table->$fields[1].$text

<?php

// start definitions

class Field
{
var $name;
var $label;
var $size;
var $maxchar;
var $type;
var $validationrule;

function Field ($name, $label, $size, $maxchar, $type, $validationrule) {
$this->name = $name;
$this->type = $type;
$this->label=$label;
$this->size=$size;
$this->maxchar=$maxchar;
$this->validationrule=$validationrule;
}

function PrintName() {
echo "Print Name : " . $this->name;
}

}

class Table
{
var $fields = array();

function addField($field)
{
$this->fields[] = $field;
}
}

// end definitions

$table = new Table();

$table->addField(new Field('username','text','User name:','10','10','NO NULL'));
$table->addField(new Field('password','password','Password:','10','10','NO NULL'));
$table->addField(new Field('firstname','text','First name:','10','10','NO NULL'));
$table->addField(new Field('lastname','text','Last name:','10','10','NO NULL'));
$table->addField(new Field('city','text','City:','15','15','NO NULL'));
$table->addField(new Field('state','text','State:','2','2','NO NULL'));

echo "1" . $table->$fields[0]->$text . "<BR>"; // only get 1 in output

$table->$fields[0]->printname; // no ouput

</body>
</html>

ahundiak

echo $table->fields[0]->name;