Procedural File: functions_mysql.php

Source Location: /functions_mysql.php

Page Details:

Mysql function lib for PureFTPd.

This file holds all the mysql funtions used in the class file

Tags:

copyright:	Copyright 2004, Michiel van Baak
author:	Michiel van Baak <mvanbaak@users.sourceforge.net>
link:	Project home.
license:	GPL
version:	0.2.0

sql_affected_rows [line 131]

integer sql_affected_rows(
[resource $result = ""])

Get number of affected rows in previous MySQL operation.

Tags:

return:	The number of rows affected by the last INSERT, UPDATE or DELETE query.
access:	public

Parameters

resource

$result

The result resource from a previous sql_query call - optional.

[ Top ]

sql_data_seek [line 142]

boolean sql_data_seek(
resource $result, integer $pos)

Move internal result pointer.

Tags:

return:	TRUE on success or FALSE on failure.
access:	public

Parameters

resource	$result	The result resource from a previous sql_query call.
integer	$pos	Position in data set

[ Top ]

sql_error [line 158]

void sql_error(
mixed $filename, mixed $linenumber, [mixed $query = ""])

Obsolete error handler. It's still here for backward compatability

[ Top ]

sql_fetch_array [line 74]

array sql_fetch_array(
resource $result)

Fetch a result row as an associative array, a numeric array, or both.

Tags:

return:	Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
access:	public

Parameters

resource

$result

The result resource from a previous sql_query call.

[ Top ]

sql_fetch_assoc [line 94]

array sql_fetch_assoc(
resource $result)

Fetch a result row as an associative array.

Tags:

return:	Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.
access:	public

Parameters

resource

$result

The result resource from a previous sql_query call.

[ Top ]

sql_fetch_row [line 84]

array sql_fetch_row(
resource $result)

Get a result row as an enumerated array.

Tags:

return:	Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
access:	public

Parameters

resource

$result

The result resource from a previous sql_query call.

[ Top ]

sql_insert_id [line 151]

integer sql_insert_id(
)

Get the ID generated from the previous INSERT operation.

Tags:

return:	The ID generated for an AUTO_INCREMENT column by the previous INSERT query.
access:	public

[ Top ]

sql_num_rows [line 121]

integer sql_num_rows(
[resource $result = ""])

Get number of rows in result.

Tags:

return:	The number of rows in a result set.
access:	public

Parameters

resource

$result

The result resource from a previous sql_query call - optional.

[ Top ]

sql_query [line 63]

resource sql_query(
string $query)

Send query to database server.

Tags:

return:	Mysql result resource.
access:	public

Parameters

string

$query

The query sent to the database server.

[ Top ]

sql_result [line 106]

mixed sql_result(
resource $result, [integer $pos = 0], [string $field = ""])

Get result data.

Tags:

return:	The contents of one cell from a MySQL result set.
access:	public

Parameters

resource	$result	The result resource from a previous sql_query call.
integer	$pos	The offset - optional.
string	$field	The field in the result array - optional.

[ Top ]

sql_trigger_error [line 20]

string sql_trigger_error(
string $query, string $err)

Error handler.

Tags:

return:	Error page with backtrace.
access:	private

Parameters

string	$query	The query sent to the database server.
string	$err	User supplied extra error info.

[ Top ]

Documentation generated on Sun, 3 Oct 2004 21:52:30 +0200 by phpDocumentor 1.3.0RC3