This is a little howto on how to use the autoschema generator:


====Assumptions====
  - you have pear, DB_DataObject_FormBuilder, and all dependancies instaled.
  - You know how to setup the DSN.  [have link point to DSN setup]
  - You have a database setup.



====Getting started====
  - config/db_dataobject.ini
<code php>[DB_DataObject]
database = mysql://user:password@localhost/dbName
schema_location = E:/HTTPRoot/Calendar/config/
class_location = E:/HTTPRoot/Calendar
extends = DB_DataObject
extends_location = DB/DataObject.php
require_prefix  = DataObjects/
class_prefix = DataObjects_</code>

where <code>database = mysql://user:password@localhost/dbName</code>
user = username

password = password

localhost = the host/ip of your database

dbName = the name of the database
  
  - run -> 
<code>php.exe regenerate_dabaobject_info.php</code>
or any other method of running

<code>php.exe DB/DataObject/createTables.php db_databoject.ini</code>
I would recommend have db_dataobject.ini placed somewhere outside of the reach of your webserver deamon.
  - ...
  - Profit!

====Using Foreign Keys in dropdown / select menus===
pseudo schema
<code>tbl_Categories
categories_id;
title;


tbl_Books
books_id;
title;
categories_id;
</code>

make a <dbName>.links.ini file, that accompanies your "dbName.ini" that got generated from above.

inside dbName.link.ini file add:
<code>
[tbl_Books]
categories_id : tbl_Categories:categories_id;
</code>


inside your generated tbl_Books.php file
add the line to your class
<code>
var $fb_linkDisplayFields = array('title', 'categories_id');
</code>

inside your generated tbl_Categories.php file
add the line to your class
<code>
var $fb_linkDisplayFields = array('title');
</code>

inside your db_dataobject.ini
add the line
<code>
linkDisplayLevel = 2
</code>
You have to set linkDisplayLevel greater than 1.  //Read the docs for further information//

[[FileUpload]]