[PHP-DOC] Re: [PHP-CVS] cvs: php-src(PHP_5_3) /ext/ming ming.c php_ming.h
Hi Derick, I'm working on optimizing the version checking to make it possible to compile and link against at least 0.3, but older versions might not be possible as it would create too much spaghetti code. - Frank > On Fri, 25 Jul 2008, Derick Rethans wrote: > > > On Thu, 24 Jul 2008, Frank M. Kromann wrote: > > > > > fmk Thu Jul 24 08:02:39 2008 UTC > > > > > > Modified files: (Branch: PHP_5_3) > > > /php-src/ext/ming ming.c php_ming.h > > > Log: > > > Syncronize the ming extension with libming 0.4 > > > [DOC] PHP 5.3 requires libming 0.4 > > > > Is that really necessary? libming 0.3 has been working fine, and it's > > the latest that debian unstable has - could you please see if it'd be > > possible to support that as well? > > This is even more useful as PHP < 5.3 doesn't compile against libming > 0.4. In order to be able to run both 5.2 and 5.3 I need both version of > the lib - something that many distributions don't do. > > regards, > Derick > -- > HEAD before 5_3!: http://tinyurl.com/6d2esb > http://derickrethans.nl | http://ezcomponents.org | http://xdebug.org >
[PHP-DOC] cvs: phpdoc /en/reference/mssql/functions mssql-connect.xml mssql-pconnect.xml
fmk Thu Mar 9 18:50:23 2006 UTC Modified files: /phpdoc/en/reference/mssql/functionsmssql-connect.xml mssql-pconnect.xml Log: Add missing parameters http://cvs.php.net/viewcvs.cgi/phpdoc/en/reference/mssql/functions/mssql-connect.xml?r1=1.3&r2=1.4&diff_format=u Index: phpdoc/en/reference/mssql/functions/mssql-connect.xml diff -u phpdoc/en/reference/mssql/functions/mssql-connect.xml:1.3 phpdoc/en/reference/mssql/functions/mssql-connect.xml:1.4 --- phpdoc/en/reference/mssql/functions/mssql-connect.xml:1.3 Mon Apr 11 21:20:04 2005 +++ phpdoc/en/reference/mssql/functions/mssql-connect.xml Thu Mar 9 18:50:23 2006 @@ -1,5 +1,5 @@ - + @@ -13,6 +13,7 @@ stringservername stringusername stringpassword + boolnew_link Returns: A MS SQL link identifier on success, or &false; http://cvs.php.net/viewcvs.cgi/phpdoc/en/reference/mssql/functions/mssql-pconnect.xml?r1=1.3&r2=1.4&diff_format=u Index: phpdoc/en/reference/mssql/functions/mssql-pconnect.xml diff -u phpdoc/en/reference/mssql/functions/mssql-pconnect.xml:1.3 phpdoc/en/reference/mssql/functions/mssql-pconnect.xml:1.4 --- phpdoc/en/reference/mssql/functions/mssql-pconnect.xml:1.3 Thu Jun 23 16:53:26 2005 +++ phpdoc/en/reference/mssql/functions/mssql-pconnect.xml Thu Mar 9 18:50:23 2006 @@ -1,5 +1,5 @@ - + @@ -13,6 +13,7 @@ stringservername stringusername stringpassword + boolnew_link Returns: A positive MS SQL persistent link identifier on success,
RE: FW: [PHP-DOC] help needed with windows install part of the PHP manual
> > Following discussion on irc, we're now waiting for Canada to come online so > that Frank can explain how he has his sapi installations working without > using PATH.. Canada or California thats almost the same exect for the temperature and the amount of sunlight we get:-) I'm using ispi only for testing. CGI is fast enough for my development tasks. My configuration is with all PHP files in one dir and the script mapping set to .php -> c:\php5\php5isapi.dll. This configuration does not llok for the php.ini file located in c:\php5. It looks for the file in c:\windows. When running as isapi, the dll is loaded by a process that is started from c:\winows\system32\inetsrv, and it does nt have any knowledge about the c:\php5 folder. So in the case of isapi I'm running without a php.ini file. - Frank > > (in which case Edin's right - but what do the majority of new users install? > cgi or sapi?) >
[PHP-DOC] Re: help needed with windows install part of the PHP manual
Hi Gabor, I have used PHP since the early days of PHP3 and I have never copied any files arround. I have only used php on Windows NT/2000/XP and there might be other needs on Windows 98/ME. On my development box I have the following directory structure: c:\php4 c:\php4\debug c:\php5 c:\php5\debug In each of these directories I keep all files related to the version of PHP. That includes all .exe, .dll and the php.ini file. I also keep any external library required for extension in the same folder (this is for extensions like PHP-GTK and Imagick etc.) PEAR is a little tricky as it requires pear.ini to be in %windir%! In the php.ini file I set extension_dir = ./ I use IIS for most of my work and I configure it with the folowing virtual directories all pointing to the same physical directory: /php4, script map: .php => c:\php4\php-cgi.exe /php4debug, script map: .php => c:\php4\debug\php-cgi.exe /php5, script map: .php => c:\php5\php-cgi.exe /php5isapi, script map: .php => c:\php5\php5isapi.dll /php5debug, script map: .php => c:\php5\debug\php-cgi.exe /php5fcgi, script map: .php => c:\php4\isapi_fcgi.dll It is not possible to configure IIS with more than one isapi/fcgi module. This way I can test the same php script with different versions of PHP without changing anything but the URL. This configuration also allows me to use both web based and PHP-GTK applications. I use the same configuration on the systems we ship to our customers. It's a touch screen computer with a PHP5 based application. - Frank > Hi Frank, Wez, and all! > > Wez promised us that he will help rewamp the Windows installation part, > but he does not reply to our mails. Our dilemma is the following: > > - the current Windows docs suggest users to copy files to the windows > and system32 folders > > - people (Daniel Convissor) report that it is possible to not do > this, but set PATH to include the PHP folder and the dlls > folder below the PHP folder (for PHP 4) + set PHPRC > > - others (Nuno Lopes) report that it does not work for PHP 5 > > - the PHP 5 package suspiciosly looks like if the dlls and sapi > folder was merged with the root folder just to support Daniel's > suggestion, or enable setup with even less configuration > (no PATH and no PHPRC setting required) <- just a hiphotesis > > Now we need someone with decent Windows PHP knowledge to help us clean > up the installation part. What do we need? > > - Simple manual installation instructions for PHP 4 on Windows > - Simple manual installation instructions for PHP 5 on Windows > - Instructions on how can you run them paralelly (both server > independent - ie. CLI, and server dependent - ie. Apache, etc). > > Wez said it is not required to copy files around neither for PHP 4 nor > for PHP5. Now we need exact instructions. > > Thanks, > Gabor Hojtsy - PHP Documentation Editor >
[PHP-DOC] cvs: phpdoc /en/reference/mssql/functions mssql-result.xml
fmk Mon Nov 24 15:00:47 2003 EDT Modified files: /phpdoc/en/reference/mssql/functionsmssql-result.xml Log: change parameter name from i to row Index: phpdoc/en/reference/mssql/functions/mssql-result.xml diff -u phpdoc/en/reference/mssql/functions/mssql-result.xml:1.3 phpdoc/en/reference/mssql/functions/mssql-result.xml:1.4 --- phpdoc/en/reference/mssql/functions/mssql-result.xml:1.3Thu Jul 3 08:38:23 2003 +++ phpdoc/en/reference/mssql/functions/mssql-result.xmlMon Nov 24 15:00:47 2003 @@ -1,5 +1,5 @@ - + @@ -11,7 +11,7 @@ stringmssql_result resourceresult - inti + introw mixedfield
[PHP-DOC] cvs: phpdoc /en/reference/fbsql/functions fbsql-insert-id.xml
fmk Wed Feb 19 12:51:15 2003 EDT Modified files: /phpdoc/en/reference/fbsql/functionsfbsql-insert-id.xml Log: Make the documentation match the features. Index: phpdoc/en/reference/fbsql/functions/fbsql-insert-id.xml diff -u phpdoc/en/reference/fbsql/functions/fbsql-insert-id.xml:1.2 phpdoc/en/reference/fbsql/functions/fbsql-insert-id.xml:1.3 --- phpdoc/en/reference/fbsql/functions/fbsql-insert-id.xml:1.2 Wed Apr 17 02:37:53 2002 +++ phpdoc/en/reference/fbsql/functions/fbsql-insert-id.xml Wed Feb 19 12:51:14 +2003 @@ -1,5 +1,5 @@ - + @@ -32,7 +32,7 @@ The value of the FrontBase SQL function - LAST_INSERT_ID() always contains the most + fbsql_insert_id always contains the most recently generated DEFAULT UNIQUE value, and is not reset between queries. -- PHP Documentation Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DOC] cvs: phpdoc /en/reference/mssql configure.xml
fmk Sun Feb 9 22:24:42 2003 EDT Modified files: /phpdoc/en/reference/mssql configure.xml Log: Adding a note about compiling FreeTDS using --enable-msdblib Index: phpdoc/en/reference/mssql/configure.xml diff -u phpdoc/en/reference/mssql/configure.xml:1.3 phpdoc/en/reference/mssql/configure.xml:1.4 --- phpdoc/en/reference/mssql/configure.xml:1.3 Tue Jan 7 06:26:23 2003 +++ phpdoc/en/reference/mssql/configure.xml Sun Feb 9 22:24:42 2003 @@ -1,5 +1,5 @@ - + &reftitle.install; @@ -9,7 +9,7 @@ To get these functions to work, you have to compile PHP with --with-mssql[=DIR], where DIR is the - FreeTDS install prefix. + FreeTDS install prefix. And FreeTDS should be compiled using --enable-msdblib. -- PHP Documentation Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DOC] cvs: phpdoc /en/reference/mssql/functions mssql-bind.xml mssql-execute.xml mssql-free-statement.xml mssql-init.xml
fmk Thu Jan 9 13:46:33 2003 EDT Added files: /phpdoc/en/reference/mssql/functionsmssql-free-statement.xml Modified files: /phpdoc/en/reference/mssql/functionsmssql-bind.xml mssql-execute.xml mssql-init.xml Log: Adding a little more information about stored procedure handling Index: phpdoc/en/reference/mssql/functions/mssql-bind.xml diff -u phpdoc/en/reference/mssql/functions/mssql-bind.xml:1.2 phpdoc/en/reference/mssql/functions/mssql-bind.xml:1.3 --- phpdoc/en/reference/mssql/functions/mssql-bind.xml:1.2 Wed Apr 17 02:40:59 2002 +++ phpdoc/en/reference/mssql/functions/mssql-bind.xml Thu Jan 9 13:46:33 2003 @@ -1,5 +1,5 @@ - + @@ -22,6 +22,10 @@ &warn.undocumented.func; + + + See also mssql_execute, +mssql_free_statement + and mssql_init Index: phpdoc/en/reference/mssql/functions/mssql-execute.xml diff -u phpdoc/en/reference/mssql/functions/mssql-execute.xml:1.3 phpdoc/en/reference/mssql/functions/mssql-execute.xml:1.4 --- phpdoc/en/reference/mssql/functions/mssql-execute.xml:1.3 Sun Jun 30 06:41:43 2002 +++ phpdoc/en/reference/mssql/functions/mssql-execute.xml Thu Jan 9 13:46:33 +2003 @@ -1,5 +1,5 @@ - + @@ -16,6 +16,20 @@ &warn.undocumented.func; + + + + if the stored procedure returns parameters or a return value these will + be available after the call to mssql_execute unless + the stored procedure returns more than one result set. In that case + use mssql_next_result to shift through the results. + When the last result has been processed the output parameters and return + values will be available. + + + + See also mssql_bind, +mssql_free_statement + and mssql_init Index: phpdoc/en/reference/mssql/functions/mssql-init.xml diff -u phpdoc/en/reference/mssql/functions/mssql-init.xml:1.2 phpdoc/en/reference/mssql/functions/mssql-init.xml:1.3 --- phpdoc/en/reference/mssql/functions/mssql-init.xml:1.2 Wed Apr 17 02:41:01 2002 +++ phpdoc/en/reference/mssql/functions/mssql-init.xml Thu Jan 9 13:46:33 2003 @@ -1,5 +1,5 @@ - + @@ -17,6 +17,10 @@ &warn.undocumented.func; + + + See also mssql_bind, mssql_execute + and mssql_free_statement Index: phpdoc/en/reference/mssql/functions/mssql-free-statement.xml +++ phpdoc/en/reference/mssql/functions/mssql-free-statement.xml mssql_free_statement Free statement memory Description intmssql_free_statement intstatement 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. See also mssql_bind, mssql_execute and mssql_init -- PHP Documentation Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DOC] cvs: phpdoc /entities global.ent
fmk Wed Dec 18 02:27:37 2002 EDT Modified files: /phpdoc/entitiesglobal.ent Log: Adding FreeTDS to the list of entities Index: phpdoc/entities/global.ent diff -u phpdoc/entities/global.ent:1.64 phpdoc/entities/global.ent:1.65 --- phpdoc/entities/global.ent:1.64 Fri Dec 6 23:24:00 2002 +++ phpdoc/entities/global.ent Wed Dec 18 02:27:37 2002 @@ -1,6 +1,6 @@
[PHP-DOC] cvs: phpdoc /en/reference/mssql configure.xml reference.xml
fmk Wed Dec 18 02:27:10 2002 EDT Modified files: /phpdoc/en/reference/mssql configure.xml reference.xml Log: Updating documentation to match the code Index: phpdoc/en/reference/mssql/configure.xml diff -u phpdoc/en/reference/mssql/configure.xml:1.1 phpdoc/en/reference/mssql/configure.xml:1.2 --- phpdoc/en/reference/mssql/configure.xml:1.1 Sat Nov 30 10:33:22 2002 +++ phpdoc/en/reference/mssql/configure.xml Wed Dec 18 02:27:10 2002 @@ -1,10 +1,15 @@ - + &reftitle.install; The MSSQL extension is enabled by adding extension=php_mssql.dll to &php.ini;. + + + To get these functions to work, you have to compile PHP with + --with-mssql=[DIR], where DIR is the + FreeTDS install prefix. Index: phpdoc/en/reference/mssql/reference.xml diff -u phpdoc/en/reference/mssql/reference.xml:1.7 phpdoc/en/reference/mssql/reference.xml:1.8 --- phpdoc/en/reference/mssql/reference.xml:1.7 Sat Nov 30 10:33:22 2002 +++ phpdoc/en/reference/mssql/reference.xml Wed Dec 18 02:27:10 2002 @@ -1,5 +1,5 @@ - + Microsoft SQL Server functions MS SQL Server @@ -10,18 +10,14 @@ These functions allow you to access MS SQL Server database. - - - The MSSQL extension is available on Win32 systems only. You can - use the Sybase extension to connect to - MSSQL databases from other platforms. - - &reftitle.required; + Requirements for WIn32 platforms. + + The extension requires the MS SQL Client Tools to be installed on the system where PHP is installed. The Client Tools can be installed from the MS SQL Server CD or by copying @@ -30,6 +26,15 @@ \winnt\system32 on the PHP box. Copying ntwdblib.dll will only provide access. Configuration of the client will require installation of all the tools. + + + Requirements for Unix/Linux platforms. + + + To use the MSSQL extension on Unix/Linux, you first need to build and + install the FreeTDS library. Source code and installation instructions + are available at the FreeTDS home page: + &url.freetds; -- PHP Documentation Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DOC] cvs: phpdoc /en/functions fbsql.xml
fmk Tue Jan 29 13:12:03 2002 EDT Modified files: /phpdoc/en/functionsfbsql.xml Log: Fixing documentation for fbsql_database_password Index: phpdoc/en/functions/fbsql.xml diff -u phpdoc/en/functions/fbsql.xml:1.36 phpdoc/en/functions/fbsql.xml:1.37 --- phpdoc/en/functions/fbsql.xml:1.36 Sat Jan 19 18:42:21 2002 +++ phpdoc/en/functions/fbsql.xml Tue Jan 29 13:12:02 2002 @@ -1,5 +1,5 @@ - + FrontBase Functions FrontBase @@ -496,22 +496,40 @@ - Returns: The database password for the database represented by - the link identifier. + Returns: The database password associated with the link identifier. fbsql_database_password sets and retrieves - the database password for the current database. if the second + the database password used by the connection. if a database is + protected by a database password, the user must call this function + before calling fbsql_select_db. if the second optional parameter is given the function sets the database - password for the database on the server that's associated with - the specified link identifier. If no link identifier is + password for the specified link identifier. If no link identifier is specified, the last opened link is assumed. If no link is open, the function will try to establish a link as if fbsql_connect was called, and use it. - See also: fbsql_connect and - fbsql_pconnect. + This function does not change the database password in the database + nor can it be used to retrive the database password for a database. + + + fbsql_create_clob example + + + + + + See also: fbsql_connect, + fbsql_pconnect and + fbsql_select_db. @@ -2252,9 +2270,15 @@ Every subsequent call to fbsql_query will be made on the active database. + + if the database is protected with a database password, the user must + call fbsql_database_password before selecting + the database. + See also: fbsql_connect, - fbsql_pconnect, and + fbsql_pconnect, + fbsql_database_password and fbsql_query.
[PHP-DOC] cvs: phpdoc /en/functions imap.xml
fmk Tue Dec 4 15:05:15 2001 EDT Modified files: /phpdoc/en/functionsimap.xml Log: Update the documentation foi imap_mail() Index: phpdoc/en/functions/imap.xml diff -u phpdoc/en/functions/imap.xml:1.53 phpdoc/en/functions/imap.xml:1.54 --- phpdoc/en/functions/imap.xml:1.53 Sat Nov 17 22:07:18 2001 +++ phpdoc/en/functions/imap.xmlTue Dec 4 15:05:15 2001 @@ -1,5 +1,5 @@ - + IMAP, POP3 and NNTP functions IMAP @@ -1530,7 +1530,11 @@ - This function is currently only available in PHP 3. + This function allows sending of emails with correct handling of Cc and Bcc +receivers. + The parameters to, cc and bcc are all strings and are all parsed as rfc822 +address lists. + The receivers specified in bcc will get the mail, but are excluded from the +headers. + Use teh rpath parameter to specify return path. This is usefull when using php +as a mail client + for multiple users.
[PHP-DOC] cvs: phpdoc /en/functions iisfunc.xml
fmk Wed Nov 14 14:04:15 2001 EDT Added files: /phpdoc/en/functionsiisfunc.xml Log: Adding basic documentation for the IIS functions. More text to be added. Index: phpdoc/en/functions/iisfunc.xml +++ phpdoc/en/functions/iisfunc.xml IIS Administration functions IIS Functions This extension is available for Win32 only. It provides functions to administrate Microsoft Internet Information Server (IIS). The extension includes function to create web sites and vertual directories as well as configuring security and script mapping. These functions have been added in PHP 4. iis_get_server_by_path Return the instance number associated with the Path Description int iis_get_server_by_path string path Each vertual server in IIS is associated with an instance number. iis_get_server_by_path Finds the instance number from the actual path to the root directory. iis_get_server_by_comment Return the instance number associated with the Comment Description int iis_get_server_by_comment string comment iis_add_server Creates a new virtual web server Description int iis_add_server string path string comment string server_ip int port string host_name int rights int start_server iis_remove_server Removes the virtual web server indicated by ServerInstance Description int iis_remove_server int server_instance iis_set_dir_security Sets Directory Security Description int iis_set_dir_security int server_instance string virtual_path int directory_flags iis_get_dir_security Gets Directory Security Description int iis_get_dir_security int server_instance string virtual_path iis_set_server_rights Sets server rights Description int iis_set_server_rights int server_instance string virtual_path int directory_flags iis_get_server_rights Gets server rights Description int iis_get_server_rights int server_instance string virtual_path iis_set_script_map Sets script mapping on a virtual directory Description int iis_set_script_map int server_instance string virtual_path string script_extension string engine_path int allow_scripting iis_get_script_map Gets script mapping on a virtual directory for a specific extention Description int iis_get_script_map int server_instance string virtual_path string script_extension iis_set_app_settings Creates application scope for a virtual directory Description int iis_set_app_settings int server_instance string virtual_path string application_scope iis_start_server Starts the virtual web server Description int iis_start_server int server_instance iis_stop_server Stops the virtual web server Description int iis_stop_server int server_instance iis_stop_service Stops the service defined by ServiceId Description int iis_stop_service string service_id iis_start_service Starts the service defined by ServiceId Description int iis_start_service string service_id iis_get_service_state/refname> Starts the service defined by ServiceId Description int iis_get_service_state string service_id
[PHP-DOC] cvs: phpdoc /en/functions mssql.xml
fmk Wed Nov 14 14:00:51 2001 EDT Modified files: /phpdoc/en/functionsmssql.xml Log: Adding some description on how to get the Client tools installed. Index: phpdoc/en/functions/mssql.xml diff -u phpdoc/en/functions/mssql.xml:1.19 phpdoc/en/functions/mssql.xml:1.20 --- phpdoc/en/functions/mssql.xml:1.19 Sat Nov 10 16:49:38 2001 +++ phpdoc/en/functions/mssql.xml Wed Nov 14 14:00:48 2001 @@ -1,8 +1,27 @@ - + Microsoft SQL Server functions MS SQL Server + + +The MSSQL extension is available on Win32 systems only. You can +use the Sybase extension to connect to MSSQL databases from +other platforms. + + +These functions allow you to access MS SQL Server database. +The extension requires the MS SQL Client Tools to be installed +on the system where PHP is installed. The Client Tools can +be installed from the MS SQL Server CD or by copying ntwdblib.dll +from \winnt\system32 on the serber to \winnt\system32 on the PHP box. +Copying ntwdblib.dll will only provide access. Configuration of the client +will require installation of all the tools. + + +The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini. + +
[PHP-DOC] cvs: phpdoc /en/functions fbsql.xml
fmk Fri Sep 21 13:21:57 2001 EDT Modified files: /phpdoc/en/functionsfbsql.xml Log: Fixing wrong return type Index: phpdoc/en/functions/fbsql.xml diff -u phpdoc/en/functions/fbsql.xml:1.21 phpdoc/en/functions/fbsql.xml:1.22 --- phpdoc/en/functions/fbsql.xml:1.21 Wed Sep 19 06:25:17 2001 +++ phpdoc/en/functions/fbsql.xml Fri Sep 21 13:21:57 2001 @@ -1,5 +1,5 @@ - + FrontBase functions FrontBase @@ -1858,7 +1858,7 @@ Description - resource fbsql_select_db + bool fbsql_select_db string database_name resource
[PHP-DOC] cvs: phpdoc /en/functions fbsql.xml
fmk Tue Sep 18 19:15:22 2001 EDT Modified files: /phpdoc/en/functionsfbsql.xml Log: Adding documentation for fbsql_commit, fbsql_rollback and fbsql_db_status Index: phpdoc/en/functions/fbsql.xml diff -u phpdoc/en/functions/fbsql.xml:1.18 phpdoc/en/functions/fbsql.xml:1.19 --- phpdoc/en/functions/fbsql.xml:1.18 Sun Aug 19 07:42:10 2001 +++ phpdoc/en/functions/fbsql.xml Tue Sep 18 19:15:22 2001 @@ -1,5 +1,5 @@ - + FrontBase functions FrontBase @@ -48,7 +48,6 @@ - &warn.experimental.func; fbsql_affected_rows returns the number of rows affected by the last INSERT, UPDATE or DELETE query @@ -106,12 +105,20 @@ - &warn.experimental.func; fbsql_autocommit returns the current autocommit status. if the optional OnOff parameter is given the auto commit status will be changed. + With OnOff set to &true each statement will be commited + automatically, if no errors was found. + With OnOff set to &false the user must commit or rollback + the transaction unsing either fbsql_commit or + fbsql_rollback. + See also: + fbsql_commit and + fbsql_rollback + @@ -141,7 +148,6 @@ - &warn.experimental.func; fbsql_change_user changes the logged in user of the current active connection, or the connection given by the @@ -170,7 +176,6 @@ - &warn.experimental.func; Returns: &true; on success, &false; on error. @@ -201,6 +206,39 @@ + + + +fbsql_commit +Commits a transaction to the database + + +Description + + + bool fbsql_commit + resource + +link_identifier + + + + + + Returns: &true; on success, &false; on failure. + + + fbsql_commit ends the current transaction + by writing all insertsm updates and deletes to the disk and unlucking + all row and table locks held by the transaction. + This command is only needed if autocommit is set to false. + + See also: + fbsql_autocommit and + fbsql_rollback + + + @@ -230,7 +268,6 @@ - &warn.experimental.func; Returns a positive FrontBase link identifier on success, or an error message on failure. @@ -292,7 +329,6 @@ - &warn.experimental.func; fbsql_create_db attempts to create a new database on the server associated with the specified link @@ -336,7 +372,6 @@ - &warn.experimental.func; Returns: The database password for the database represented by the link identifier. @@ -372,7 +407,6 @@ int row_number - &warn.experimental.func; Returns: &true; on success, &false; on failure. @@ -440,7 +474,6 @@ - &warn.experimental.func; Returns: A positive FrontBase result identifier to the query result, or &false; on error. @@ -459,6 +492,85 @@ + + +fbsql_db_status +Get the status for a given database. + + +Description + + + int fbsql_db_status + string database_name + resource + +link_identifier + + + + + + Returns: An integer value with the current status. + + + fbsql_db_status requests the current + status of the database specified by database_name. + if the link_identifier is omitted the default + link_identifier will be used. + + + The return value can be one of the following constants: + + + + &false - The exec handler for the host was invalid. This + error will ocour when the link_identifier connects directly to + a database by using a port number. FBExec can be available on the + server but no connection has been made for it. + + + + + FBSQL_UNKNOWN - The Status is unknown. + + + + + FBSQL_STOPPED - The database is not running. Use + fbsql_start_db to start the database. + + + + + FBSQL_STARTING - The database is starting. + + + + + FBSQL_RUNNING - The database is running and can be used to + perform SQL operations. + + + + + FBSQL_STOPPING - The database is stopping. + + + + + FBSQL_NOEXEC - FBExec is not running on the server and it is not + possible to get the status of the database. + + + + See also: + fbsql_start_db and + fbsql_stop_db + + + + fbsql_drop_db @@ -477,7 +589,6 @@ - &warn.experimental.func; Returns: &true; o
[PHP-DOC] cvs: phpdoc /en/functions fbsql.xml
fmk Fri Aug 3 13:06:20 2001 EDT Modified files: /phpdoc/en/functionsfbsql.xml Log: Removed experimental warning Index: phpdoc/en/functions/fbsql.xml diff -u phpdoc/en/functions/fbsql.xml:1.16 phpdoc/en/functions/fbsql.xml:1.17 --- phpdoc/en/functions/fbsql.xml:1.16 Thu Aug 2 13:36:55 2001 +++ phpdoc/en/functions/fbsql.xml Fri Aug 3 13:06:20 2001 @@ -1,9 +1,8 @@ - + FrontBase functions FrontBase - &warn.experimental; These functions allow you to access FrontBase database servers. In order to have these functions available, you must compile php
[PHP-DOC] cvs: phpdoc /en/functions fbsql.xml mssql.xml
fmk Mon May 14 13:22:53 2001 EDT Modified files: /phpdoc/en/functionsfbsql.xml mssql.xml Log: Adding documentation for next_result functions Index: phpdoc/en/functions/fbsql.xml diff -u phpdoc/en/functions/fbsql.xml:1.8 phpdoc/en/functions/fbsql.xml:1.9 --- phpdoc/en/functions/fbsql.xml:1.8 Fri May 11 00:37:44 2001 +++ phpdoc/en/functions/fbsql.xml Mon May 14 13:22:52 2001 @@ -347,7 +347,7 @@ fbsql_select_db ("samp_db") or die ("Could not select database"); -$query = "SELECT last_name, first_name FROM friends"; +$query = "SELECT last_name, first_name FROM friends;"; $result = fbsql_query ($query) or die ("Query failed"); @@ -476,7 +476,7 @@ echo fbsql_errno().": ".fbsql_error()."
"; fbsql_select_db("nonexistentdb"); echo fbsql_errno().": ".fbsql_error()."
"; -$conn = fbsql_query("SELECT * FROM nonexistenttable"); +$conn = fbsql_query("SELECT * FROM nonexistenttable;"); echo fbsql_errno().": ".fbsql_error()."
"; ?> @@ -526,7 +526,7 @@ echo fbsql_errno().": ".fbsql_error()."
"; fbsql_select_db("nonexistentdb"); echo fbsql_errno().": ".fbsql_error()."
"; -$conn = fbsql_query("SELECT * FROM nonexistenttable"); +$conn = fbsql_query("SELECT * FROM nonexistenttable;"); echo fbsql_errno().": ".fbsql_error()."
"; ?> @@ -1090,7 +1090,7 @@ fbsql_connect ("localhost", "_SYSTEM", ""); fbsql_select_db ("wisconsin"); -$result = fbsql_query ("SELECT * FROM onek"); +$result = fbsql_query ("SELECT * FROM onek;"); $fields = fbsql_num_fields ($result); $rows = fbsql_num_rows ($result); $i = 0; @@ -1161,14 +1161,14 @@ fbsql_insert_id returns the ID generated for - an AUTO_INCREMENT column by the previous INSERT query using the + an column defined as DEFAULT UNIQUE by the previous INSERT query using the given link_identifier. If link_identifier isn't specified, the last opened link is assumed. fbsql_insert_id returns 0 if the previous - query does not generate an AUTO_INCREMENT value. If you need to + query does not generate an DEFAULT UNIQUE value. If you need to save the value for later, be sure to call fbsql_insert_id() immediately after the query that generates the value. @@ -1176,22 +1176,10 @@ The value of the FrontBase SQL function LAST_INSERT_ID() always contains the most - recently generated AUTO_INCREMENT value, and is not reset + recently generated DEFAULT UNIQUE value, and is not reset between queries. - - - fbsql_insert_id converts the return type of - the native FrontBase C API function - fbsql_insert_id() to a type of - long. If your AUTO_INCREMENT column has - a column type of BIGINT, the value returned by - fbsql_insert_id will be incorrect. - Instead, use the internal FrontBase SQL function - LAST_INSERT_ID(). - - @@ -1345,6 +1333,50 @@ + + +fbsql_next_result +Move the internal result pointer to the next result + + +Description + + + bool + fbsql_next_result + + int result_id + + + + When sending more than one SQL statement to the server or executing a stored +procedure + with multiple results will cause the server to return multiple result sets. + This function will test for additional results available form the server. if an + additional result set exists it will free the existing result set and prepare to + fetch the wors from the new result set. + The function will return TRUE if an additional result set was + available or FALSE othervise. + + + fbsql_next_result example + + + + + + + fbsql_num_fields @@ -1397,7 +1429,7 @@ $link = fbsql_connect("localhost", "username", "password"); fbsql_select_db("database", $link); -$result = fbsql_query("SELECT * FROM table1", $link); +$result = fbsql_query("SELECT * FROM table1;", $link); $num_rows = fbsql_num_rows($result); echo "$num_rows Rows\n"; @@ -1501,7 +1533,7 @@ - The query string should not end with a semicolon. + The query string shall always end with a semicolon. Index: phpdoc/en/functions/mssql.xml diff -u phpdoc/en/functions/mssql.xml:1.9 phpdoc/en/functions/mssql.xml:1.10 --- phpdoc/en/functions/mssql.xml:1.9 Sun Jul 23 11:15:44 2000 +++ phpdoc/en/functions/mssql.xml Mon May 14 13:22:52 2001 @@ -449,6 +449,50 @@
[PHP-DOC] cvs: phpdoc /en/functions fbsql.xml
fmk Wed May 9 11:53:07 2001 EDT Modified files: /phpdoc/en/functionsfbsql.xml Log: Port numbers is not allowed when specifying the host name, but a specific port number can be specified as insted of the database name. Index: phpdoc/en/functions/fbsql.xml diff -u phpdoc/en/functions/fbsql.xml:1.3 phpdoc/en/functions/fbsql.xml:1.4 --- phpdoc/en/functions/fbsql.xml:1.3 Wed May 9 11:12:22 2001 +++ phpdoc/en/functions/fbsql.xml Wed May 9 11:53:07 2001 @@ -1088,7 +1088,7 @@
[PHP-DOC] cvs: phpdoc /en/functions fbsql.xml
fmk Tue May 1 11:12:13 2001 EDT Added files: /phpdoc/en/functionsfbsql.xml Log: Adding documentation for the frontbase extension. This is a modified copy of the MySQL documentation, as the API's is allmost identical. It still need some work; Changed functions descriptions and new functions. Index: phpdoc/en/functions/fbsql.xml +++ phpdoc/en/functions/fbsql.xml FrontBase functions FrontBase These functions allow you to access FrontBase database servers. In order to have these functions available, you must compile php with fbsql support by using the --with-fbsql option. If you use this option without specifying the path to fbsql, php will search for the fbsql client libraries in the default instalation location for the platform. Users who installed FrontBase in a non standard directory should always specify the path to fbsql: --with-fbsql=/path/to/fbsql. This will force php to use the client libraries installed by FrontBase, avoiding any conflicts. More information about FrontBase can be found at &url.fbsql;. Documentation for FrontBase can be found at &url.fbsql.docs;. fbsql_affected_rows Get number of affected rows in previous FrontBase operation Description int fbsql_affected_rows int link_identifier fbsql_affected_rows returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with link_identifier. If the link identifier isn't specified, the last link opened by fbsql_connect is assumed. If you are using transactions, you need to call fbsql_affected_rows after your INSERT, UPDATE, or DELETE query, not after the commit. If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will return zero. When using UPDATE, FrontBase will not update columns where the new value is the same as the old value. This creates the possiblity that fbsql_affected_rows may not actually equal the number of rows matched, only the number of rows that were literally affected by the query. If the last query failed, this function will return -1. See also: fbsql_num_rows. fbsql_autocommit Enable or disable autocommit. Description bool fbsql_autocommit int link_identifier bool OnOff fbsql_autocommit returns the current autocommit status. if the optional OnOff parameter is given the auto commit status will be changed. fbsql_change_user Change logged in user of the active connection Description int fbsql_change_user string user string password string database int link_identifier fbsql_change_user changes the logged in user of the current active connection, or the connection given by the optional parameter link_identifier. If a database is specified, this will default or current database after the user has been changed. If the new user and password authorization fails, the current connected user stays active. fbsql_close Close FrontBase connection Description int fbsql_close int link_identifier Returns: true on success, false on error. fbsql_close closes the connection to the FrontBase server that's associated with the specified link identifier. If link_identifier isn't specified, the last opened link is used. Using fbsql_close isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution. FrontBase close example See also: fbsql_connect, and fbsql_pconnect. fbsql_connect Open a connection to a FrontBase Server Description int fbsql_connect string hostname string username string password Returns a positive FrontBase link identifier on success, or an error message on failure. fbsql_connect establis
[PHP-DOC] cvs: phpdoc / global.ent
fmk Tue May 1 11:10:18 2001 EDT Modified files: /phpdoc global.ent Log: Adding urls for FrontBase Index: phpdoc/global.ent diff -u phpdoc/global.ent:1.89 phpdoc/global.ent:1.90 --- phpdoc/global.ent:1.89 Wed Apr 25 14:43:52 2001 +++ phpdoc/global.ent Tue May 1 11:10:17 2001 @@ -1,6 +1,6 @@