★ wanayoo — archive 1999 http://www.php.net/manual/ref.dbase.phpNouvelle recherche | Portail wanayoo

PHP Home Page

Manual Table of Contents
Up to Function Reference
Quick Reference
German version of this pageJapanese version of this pageItalian version of this pageFrench version of this pageHungarian version of this page
Function Reference
* Apache
* Arrays
* Aspell
* BC math
* Calendar
* CCVS
* COM
* Classes/Objects
* ClibPDF
* CURL
* Cybercash
* dba
* Date/time
* dBase
* DBM
* Directories
* Dyn.loading
* DOM XML
* filePro
* Filesystem
* FDF
* FTP
* gettext
* HTTP
* Hyperwave
* ICAP
* Graphics
* IMAP
* Informix
* InterBase
* LDAP
* Mail
* Math.
* MCAL
* mcrypt
* mhash
* MS SQL Server
* Misc.
* mSQL
* MySQL
* Network
* ODBC
* Oracle
* OCI8
* PDF
* Verisign Payflow Pro
* PHP options/info
* POSIX
* PostgreSQL
* Program Execution
* Pspell
* readline
* Recode
* PCRE
* Regexps
* Semaphore
* Sessions
* SWF
* SNMP
* Strings
* Sybase
* URLs
* Variables
* Vmailmgr
* WDDX
* XML
* YAZ
* YP/NIS
* Zlib
Manual: dBase functions
View the source code for this pageSearch the site



Previous page
 strtotime
 Updated
Sat, 12 Aug 2000
dbase_create 
Next page


XIV. dBase functions

These functions allow you to access records stored in dBase-format (dbf) databases.

There is no support for indexes or memo fields. There is no support for locking, too. Two concurrent webserver processes modifying the same dBase file will very likely ruin your database.

Unlike SQL databases, dBase "databases" cannot change the database definition afterwards. Once the file is created, the database definition is fixed. There are no indexes that speed searching or otherwise organize your data. dBase files are simple sequential files of fixed length records. Records are appended to the end of the file and delete records are kept until you call dbase_pack()().

We recommend that you do not use dBase files as your production database. Choose any real SQL server instead; MySQL or Postgres are common choices with PHP. dBase support is here to allow you to import and export data to and from your web database, since the file format is commonly understood with Windows spreadsheets and organizers. Import and export of data is about all that dBase support is good for.

Table of Contents
dbase_create — Creates a dBase database
dbase_open — Opens a dBase database
dbase_close — Close a dBase database
dbase_pack — Packs a dBase database
dbase_add_record — Add a record to a dBase database
dbase_replace_record — Replace a record in a dBase database
dbase_delete_record — Deletes a record from a dBase database
dbase_get_record — Gets a record from a dBase database
dbase_get_record_with_names — Gets a record from a dBase database as an associative array
dbase_numfields — Find out how many fields are in a dBase database
dbase_numrecords — Find out how many records are in a dBase database

User Contributed Notes: dBase functions


mpesv94@student.vxu.se
09-Dec-1999 08:02
Hi, I have been a DBase developer for almost a year. Although dBase is not the best database in the world it has a lot more functionality than it is described in the introduction here. For example: it is very possible to alter the structure of the tables and locking mechanisms are ofcourse standard. Just because PHP does not support dBase enough there are no reason to be dishonest about dBase! Be fair! MP


mpesv94@student.vxu.se
20-Dec-1999 03:44
I am annoyed with these lies, still being here...

Indexing with NTX is also very common and ofcourse necessary. Memo-fields are not fixed. Concurrency is also implemented and necessary.

I have been using DBF for several large programs. There are no complaints about the database, except for that it may be slow when retrieving large amounts of data.



usselmann.m@icg-online.de
26-Feb-2000 06:19
This is not about dbase features but about PHP support for dbase...


robby@vikingsystems.com
18-May-2000 05:44
reguardless of dbase's inherant attributes (neither good nor evil, just there), I find my self with a small db that needs reading.

Is there anyone out there who can point me in the direction of some code I could use to read memo fields.

or perhaps some info on how the .dbf file references .dbt or .fpt files?

robby



andreas.brunner@rubner.com
07-Jul-2000 01:27
Is there any possibility to access datarecords from a DBFile with SQL?
Canīt find any function under PHP!
/andreas



andrea@credibleweb.com
13-Jul-2000 02:43
Try using the PHP commands to import the Dbase file into a MySQL database. You can then update/manipulate the records in the database rather than the Dbase file.


knijff@bigfoot.com
17-Jul-2000 11:54
We can not find the dBase support in the Wondows version.
dBase has a few features which make it very handy for saving and restoring session info - it supports a recno() feature, has a fixed record length structure and is very fast indeed on such records.
A basic support would be a good feature.



jg4smile@jgisystems.intranets.com
25-Jul-2000 05:59
Although dBase and other xBase DBMS have more functionality than listed in the above article, the writer is absolutely correct in the limitations that exist with this database format. It is formatted like other "non-dynamic" dinosaurs like COBAL, etc. Memo and datetime binary fields are stored in such a way that multi-platform or middle-tier application are nearly imposible to use. Legacy systems that need a more powerful engine to run their "data marts" or "data warehouses" will be limited in their use of xBase systems. When reaching a certain "level" of database needs, xBase related DBMS's are not the answer. Thanks for keepin' it real PHP.


pinto@chip2pc.com
27-Jul-2000 01:37
It's a shame for PHP not to have manners with xBase 'like' file. We currently work with a program for Commercial proposes that uses xBase file, and we want to access this data, but seems the awser is perl, witch comes with SELECT style for xBase files, slow but very useful. Sorry for my English...


 About Notes


Previous page
 strtotime
 Updated
Sat, 12 Aug 2000
dbase_create 
Next page





Who's responsible for this?
Top of this page

Site
Hosting:



Located in
United States
Elements of this website are subject to copyright.
Questions about installing or using PHP should be directed to one of the mailing lists.
Only questions about the website should be directed to webmaster@php.net.