[ Index ]

PHP Cross Reference of Quick Form DataBase

title

Body

[close]

/ -> qfdb_db_mysql.php (summary)

MySQL Class of Quick Form DataBase (QFDB) Framework

Author: Everaldo Wanderlei Uavniczak
License: BSD License <http://www.qfdb.net/bsd_license.txt>
File Size: 522 lines (14 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 19 functions

  sql_connect()
  sql_select_db()
  sql_is_connected()
  sql_is_result()
  sql_error_msg()
  sql_close()
  sql_free_result()
  sql_query()
  sql_query2array()
  sql_fetchrow()
  sql_numrows()
  sql_affectedrows()
  sql_insertid()
  sql_error()
  sql_scape_string()
  sql_strip_slashes()
  sql_table_exists()
  sql_get_fields()
  sql_get_primary_key()

Functions
Functions that are not part of a class:

sql_connect()   X-Ref
Connect a Specific Data Base

param: : void
return: : void

sql_select_db($database='', $update_qfdb = false)   X-Ref
Select a DataBase

param: : string    $database     DataBase's Name
param: : bool      $update_qfdb  Update quickformdb::qdb['db']?
return: : bool

sql_is_connected($method=QFDBE_DB_FUNCTION_NOT_INFORMED)   X-Ref
Verify if has open connection with a DataBase

param: : void
return: : bool

sql_is_result($method=QFDBE_DB_FUNCTION_NOT_INFORMED)   X-Ref
Verify if has $result Query Object

param: : string  $method  Method that call this
return: : bool

sql_error_msg()   X-Ref
Return SQL Error Message

param: : void
return: : mixed

sql_close($connect_id = false)   X-Ref
Close a DataBase Connection

param: : resource  $connect_id   DataBase Link Identifier
return: : bool

sql_free_result($result = false)   X-Ref
Free  Result Memory

param: : void
return: : bool

sql_query($query)   X-Ref
Send a SQL Query

param: : string  $query   SQL Query
return: : resource

sql_query2array($query)   X-Ref
Send a SQL Query and return one result in array

param: : string  $query   SQL Query
return: : array of mixed

sql_fetchrow($query_id=false)   X-Ref
Fetch a result row as an associative array and a numeric array

param: : resource  $query_id   SQL Result Resource
return: : array of mixed

sql_numrows($query_id = false)   X-Ref
Get number of rows in result (used in SELECT query)

param: : resource  $query_id   SQL Query Object
return: : mixed

sql_affectedrows($connect_id = false)   X-Ref
Get number of affected rows in previous SQL operation (used to INSERT, UPDATE, REPLACE and DELETE query)

param: : resource  $connect_id   DataBase Link Identifier
return: : mixed

sql_insertid($connect_id = false)   X-Ref
Get the ID generated from the previous INSERT operation

param: : resource  $connect_id   DataBase Link Identifier
return: : int

sql_error($connect_id = false)   X-Ref
Return SQL error in array

param: : resource  $connect_id   DataBase Link Identifier
return: : array of mixed

sql_scape_string($query, $all = true)   X-Ref
Scape SQL Special Chars

param: : string  $query   SQL Query to Scape
param: : bool  $all   Scape % and _ char too
return: : string

sql_strip_slashes($query, $all = false)   X-Ref
Un-quote string quoted with addslashes()

param: : string  $query   SQL Query to Strip Slashes
param: : bool  $all   Strip '\%' and '\_' char too
return: : string

sql_table_exists($tablename)   X-Ref
Verify if Table Exists in DataBase

param: : string  $tablename   Table Name
return: : string

sql_get_fields($tablename)   X-Ref
Get fields from a DataBase

param: : string  $tablename   Table Name
return: : array of string

sql_get_primary_key($tablename)   X-Ref
Return the Primary Key or a DataBase Table

param: : string  $tablename   Table Name
return: : string



Generated: Fri Nov 14 17:48:13 2008 Cross-referenced by PHPXref 0.7