php 내장함수 정리3 DB관련
페이지 정보
본문
mssql_bind 저장프로시져 또는 원격저장프로시져의 인자를 추가한다
mssql_close 디비연결을 닫는다
mssql_connect int mssql_connect ( [string servername [, string username [, string password]]])
mssql_data_seek 결과에서 row_number 로 열을 이동한다.
mssql_execute 프로시져를 실행한다
mssql_fetch_array mysql_fetch_array와 동일
mssql_fetch_assoc 현재 행의 연관 배열에 의해 지정된 설정 결과를 반환합니다
mssql_fetch_batch 반환 레코드의 다음 배치
mssql_fetch_field 필드에 정보를 얻음
개체의 속성이 있음:
name - 만약 컬럼이 속성이 계산된 #N을 일련 번호로 설정된 함수의 결과면, 컬럼명이다.
column_source - 칼럼 선택 테이블에서
max_length - column의 최대 길이
numeric - 1 숫자 열의 경우 입니다
type - the column type.
mssql_fetch_object Fetch row as object
이 함수가 반환하는 필드 이름은 대소문자를 구별합니다.
mssql_fetch_row 나열된 행을 배열로 잡는다.
mssql_fetch_row를 결과 집합 이상 행을 호출 하거나, FALSE에서 다음 행을 반환합니다.
mssql_field_length
mssql_field_name field 명 반환
mssql_field_seek 지정한 필드 오프셋을 탐색
지정한 필드 오프셋을 찾습니다. mssql_fetch_field ()에 대한 다음 요청이 오프셋 필드를 포함하지 않으면, 이 필드를 반환합니다
mssql_field_type Gets the type of a field
mssql_free_result Free result memory
mssql_free_result() only needs to be called if you are worried about using too much memory while your script is running. All result memory will automatically be freed when the script ends. You may call mssql_free_result() with the result identifier as an argument and the associated result memory will be freed.
mssql_free_statement Free statement memory
mssql_free_statement() only needs to be called if you are worried about using too much memory while your script is running. All statement memory will automatically be freed when the script ends. You may call mssql_free_statement() with the statement identifier as an argument and the associated statement memory will be freed.
mssql_get_last_message Returns the last message from the server
mssql_guid_string Converts a 16 byte binary GUID to a string
mssql_init Initializes a stored procedure or a remote stored procedure
mssql_min_error_severity Sets the lower error severity
mssql_min_message_severity Sets the lower message severity
mssql_next_result Move the internal result pointer to the next result
mssql_num_fields Gets the number of fields in result
mssql_num_rows Gets the number of rows in result
mssql_pconnect Returns: A positive MS SQL persistent link identifier on success, or FALSE on error.
This type of links is therefore called 'persistent'.
mssql_query Send MS SQL query
mssql_result returns the contents of one cell from a MS SQL result set. The field argument can be the field's offset, the field's name or the field's table dot field's name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), it uses the alias instead of the column name.
When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these functions return the contents of multiple cells in one function call, they're MUCH quicker than mssql_result(). Also, note that specifying a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argument.
mssql_rows_affected Returns the number of records affected by the query
mssql_select_db Select MS SQL database
mssql_close 디비연결을 닫는다
mssql_connect int mssql_connect ( [string servername [, string username [, string password]]])
mssql_data_seek 결과에서 row_number 로 열을 이동한다.
mssql_execute 프로시져를 실행한다
mssql_fetch_array mysql_fetch_array와 동일
mssql_fetch_assoc 현재 행의 연관 배열에 의해 지정된 설정 결과를 반환합니다
mssql_fetch_batch 반환 레코드의 다음 배치
mssql_fetch_field 필드에 정보를 얻음
개체의 속성이 있음:
name - 만약 컬럼이 속성이 계산된 #N을 일련 번호로 설정된 함수의 결과면, 컬럼명이다.
column_source - 칼럼 선택 테이블에서
max_length - column의 최대 길이
numeric - 1 숫자 열의 경우 입니다
type - the column type.
mssql_fetch_object Fetch row as object
이 함수가 반환하는 필드 이름은 대소문자를 구별합니다.
mssql_fetch_row 나열된 행을 배열로 잡는다.
mssql_fetch_row를 결과 집합 이상 행을 호출 하거나, FALSE에서 다음 행을 반환합니다.
mssql_field_length
mssql_field_name field 명 반환
mssql_field_seek 지정한 필드 오프셋을 탐색
지정한 필드 오프셋을 찾습니다. mssql_fetch_field ()에 대한 다음 요청이 오프셋 필드를 포함하지 않으면, 이 필드를 반환합니다
mssql_field_type Gets the type of a field
mssql_free_result Free result memory
mssql_free_result() only needs to be called if you are worried about using too much memory while your script is running. All result memory will automatically be freed when the script ends. You may call mssql_free_result() with the result identifier as an argument and the associated result memory will be freed.
mssql_free_statement Free statement memory
mssql_free_statement() only needs to be called if you are worried about using too much memory while your script is running. All statement memory will automatically be freed when the script ends. You may call mssql_free_statement() with the statement identifier as an argument and the associated statement memory will be freed.
mssql_get_last_message Returns the last message from the server
mssql_guid_string Converts a 16 byte binary GUID to a string
mssql_init Initializes a stored procedure or a remote stored procedure
mssql_min_error_severity Sets the lower error severity
mssql_min_message_severity Sets the lower message severity
mssql_next_result Move the internal result pointer to the next result
mssql_num_fields Gets the number of fields in result
mssql_num_rows Gets the number of rows in result
mssql_pconnect Returns: A positive MS SQL persistent link identifier on success, or FALSE on error.
This type of links is therefore called 'persistent'.
mssql_query Send MS SQL query
mssql_result returns the contents of one cell from a MS SQL result set. The field argument can be the field's offset, the field's name or the field's table dot field's name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), it uses the alias instead of the column name.
When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these functions return the contents of multiple cells in one function call, they're MUCH quicker than mssql_result(). Also, note that specifying a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argument.
mssql_rows_affected Returns the number of records affected by the query
mssql_select_db Select MS SQL database
댓글목록
등록된 댓글이 없습니다.