ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:dictionary:setactualtype

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
v5:dictionary:setactualtype [2017/05/15 16:46]
dregad [Usage] adjust formatting, fix typo
v5:dictionary:setactualtype [2017/07/22 18:39] (current)
mnewnham
Line 29: Line 29:
 $dict->​setActualType('​D','​DATE'​);​ $dict->​setActualType('​D','​DATE'​);​
 </​code>​ </​code>​
-In the second example, we will create a new actual ​types so that we can use the ADOdb dictionary function to create tables containing geospatial information.+In the second example, we will create a new **actual ​type** ​so that we can use the ADOdb dictionary function to create tables containing geospatial information.
  
 <code php> <code php>
Line 41: Line 41:
  * Add 2 new columns to table  * Add 2 new columns to table
 */ */
-$columns = 'GEODATA ​G, POINTDATA ​P'; +$columns = 'GEODATA_COL ​G, POINTDATA_COL ​P'; 
-$sqlarray = $dict->​addColumnSql('​POSITION',​$columns);​+$sqlarray = $dict->​addColumnSql('​POSITION_TABLE',​$columns);​
    
 print_r($sqlarray);​ print_r($sqlarray);​
Line 50: Line 50:
 Array Array
 ( (
- [0] => ALTER TABLE POSITION ​ADD GEODATA ​GEOMETRY + [0] => ALTER TABLE POSITION_TABLE ​ADD GEODATA_COL ​GEOMETRY 
- [1] => ALTER TABLE POSITION ​ADD POINTDATA ​POINT+ [1] => ALTER TABLE POSITION_TABLE ​ADD POINTDATA_COL ​POINT
 ) )
 */ */
v5/dictionary/setactualtype.txt · Last modified: 2017/07/22 18:39 by mnewnham