phpDocumentor default
[ class tree: default ] [ index: default ] [ all elements ]

Procedural File: sql-modified.php

Source Location: /lodel/scripts/pma/sql-modified.php

Page Details

Set of functions used to build SQL dumps of tables

Functions
PMA_exportComment  [line 72]

bool PMA_exportComment( string $text  )

Outputs comment

Parameters:
string   $text:  Text of comment

API Tags:
Return:  Whether it suceeded


[ Top ]
PMA_exportData  [line 695]

bool PMA_exportData( string $db, string $table, string $crlf, string $error_url, string $sql_query  )

Dispatches between the versions of 'getTableContent' to use depending on the php version

Parameters:
string   $db:  the database name
string   $table:  the table name
string   $crlf:  the end of line sequence
string   $error_url:  the url to go back in case of error
string   $sql_query:  SQL query for obtaining data

API Tags:
Return:  Whether it suceeded
See:  PMA_getTableContentFast(), PMA_getTableContentOld()
Access:  public

Information Tags:
Author:  staybyte

[ Top ]
PMA_exportDBCreate  [line 111]

bool PMA_exportDBCreate( string $db  )

Outputs create database database

Parameters:
string   $db:  Database name

API Tags:
Return:  Whether it suceeded
Access:  public


[ Top ]
PMA_exportDBFooter  [line 146]

bool PMA_exportDBFooter( string $db  )

Outputs database footer

Parameters:
string   $db:  Database name

API Tags:
Return:  Whether it suceeded
Access:  public


[ Top ]
PMA_exportDBHeader  [line 129]

bool PMA_exportDBHeader( string $db  )

Outputs database header

Parameters:
string   $db:  Database name

API Tags:
Return:  Whether it suceeded
Access:  public


[ Top ]
PMA_exportHeader  [line 83]

bool PMA_exportHeader( )

Outputs export header


API Tags:
Return:  Whether it suceeded
Access:  public


[ Top ]
PMA_exportStructure  [line 416]

bool PMA_exportStructure( string $db, string $table, string $crlf, string $error_url, [boolean $relation = FALSE], [boolean $comments = FALSE], [boolean $mime = FALSE]  )

Outputs table's structure

Parameters:
string   $db:  the database name
string   $table:  the table name
string   $crlf:  the end of line sequence
string   $error_url:  the url to go back in case of error
boolean   $relation:  whether to include relation comments
boolean   $comments:  whether to include column comments
boolean   $mime:  whether to include mime comments

API Tags:
Return:  Whether it suceeded
Access:  public


[ Top ]
PMA_fieldTypes  [line 56]

array PMA_fieldTypes( string $db, string $table, $use_backquotes  )

Returns $table's field types

Parameters:
string   $db:  the database name
string   $table:  the table name
   $use_backquotes: 

API Tags:
Return:  the field types; key of array is PMA_backquote of the field name


[ Top ]
PMA_getTableContentFast  [line 456]

boolean PMA_getTableContentFast( string $db, string $table, string $crlf, string $error_url, string $sql_query  )

php >= 4.0.5 only : get the content of $table as a series of INSERT statements.

Last revision 13 July 2001: Patch for limiting dump size from vinay@sanisoft.com & girish@sanisoft.com

Parameters:
string   $db:  the current database name
string   $table:  the current table name
string   $crlf:  the end of line sequence
string   $error_url:  the url to go back in case of error
string   $sql_query:  the sql query

API Tags:
Return:  whether it suceeded
Global:  integer 1: the number of records
Global:  integer 2: the current record position
Global:  boolean $use_backquotes$rows_cnt$current_row: whether to use backquotes to allow the use of special characters in database, table and fields names or not
See:  PMA_getTableContent()
Access:  private

Information Tags:
Author:  staybyte

[ Top ]
PMA_getTableContentOld  [line 586]

bool PMA_getTableContentOld( string $db, string $table, string $crlf, string $error_url, string $sql_query  )

php < 4.0.5 only: get the content of $table as a series of INSERT statements.

Parameters:
string   $db:  the current database name
string   $table:  the current table name
string   $crlf:  the end of line sequence
string   $error_url:  the url to go back in case of error
string   $sql_query:  the sql query

API Tags:
Return:  Whether it suceeded
Global:  integer 1: the number of records
Global:  integer 2: the current record position
Global:  boolean $use_backquotes$rows_cnt$current_row: whether to use backquotes to allow the use of special characters in database, table and fields names or not
See:  PMA_getTableContent()
Access:  private


[ Top ]
PMA_getTableDef  [line 170]

string PMA_getTableDef( string $db, string $table, string $crlf, string $error_url, [boolean $do_relation = false], [boolean $do_comments = false], [boolean $do_mime = false]  )

Returns $table's CREATE definition

Parameters:
string   $db:  the database name
string   $table:  the table name
string   $crlf:  the end of line sequence
string   $error_url:  the url to go back in case of error
boolean   $do_relation:  whether to include relation comments
boolean   $do_comments:  whether to include column comments
boolean   $do_mime:  whether to include mime comments

API Tags:
Return:  resulting schema
Global:  boolean 1: whether to use backquotes to allow the use of special characters in database, table and fields names or not
Global:  boolean $drop$use_backquotes$cfgRelation$sql_constraints: whether to add 'drop' statements or not
Access:  public


[ Top ]


Documentation generated on Wed, 29 Aug 2007 14:30:02 +0200 by phpDocumentor 1.4.0a2