如何在網(wǎng)頁(yè)中快速發(fā)布foxpro系列數(shù)據(jù)庫(kù)（How to quickly publish FoxPro series database in web pages）

1、如何在網(wǎng)頁(yè)中快速發(fā)布foxpro系列數(shù)據(jù)庫(kù)（How to quickly publish FoxPro series database in web pages）How to quickly released the FOXPRO series database in the web pageHow to quickly released the FOXPRO series database in the web pageHow to quickly released the FOXPRO series database in the web pageFeng Kaiwei Zhi Ming

2、(344000 in Jiangxi city of Fuzhou province East China Institute of Geology Library)Abstract: This paper through examples, introduces FOXPRO data access method - FOXNET CGI tool for program development, and points out its programming essentials and application prospect.Key words: CGI FOXNET FOXPRO WW

3、W retrievalWith more and more applications of WEB, WWW page has become a dynamic interactive web pages, connect to the WWW website and database becomes more and more important. Refer to the WEB database, people tend to think of first must use MicsoftSQL, SyBase, Oracle and other large database, and

4、that the WEB database = large database. In this wrong view under the guidance of many users in the form of a small WEB database system of their own, to give up the original FOXPRO series of small to large database, database of strange, which brings many difficulties for the development of. In fact,

5、the realization of online publishing of small FOXPRO database we are familiar with, there are a variety of ways, such as the Microsoft FoxWeb is designed for a CGI interface implementation tool of FOXPRO series database published online. Unfortunately, it is foreign goods, which is the English versi

6、on. This paper is to introduce the CGI - FOXNET interface FOXPRO series database online development of the people released. As long as you are familiar with FOXPRO programming, master HTML basis, you can quickly achieve your FOXPRO database published in WEB.The installation and configuration of the

7、system 1.FOXNET is designed for the WWW server FOXPRO users design CGI programming tools. It makes FOXPRO programmers can directly use FOXPRO language to develop WEB network based on FOXPRO database applicationsProgram. FOXNET makes full use of the characteristics of FOXPRO programming convenient, u

8、sing a FOXPRO network programming plug-in DDE bridging technology design, under its support, FOXPRO can be upgraded by the common database WEB database. The way of occupying less system resources, any computer networking WIN9X/NT computer can be used as a WEB database server for providing informatio

9、n inquiry services, is a good choice of individual units, set up the WEB database. At the same time, the installation and configuration of it is very simple.First of all, you can install the FoxNet.zip file download from 8 (57K) trial or directly with the developer He Lingsong (heliso)Whe

10、n you feel good, can be registered, the official version. Before installation, you must first install the Windows9.X Foxpro2.5 For.Windows version of /Visual Foxpro version 3 and WWW server (the official version comes with a WWW server, can also download a trial version of the WWW server).The second

11、 is to install FOXNET, before installation should also decompress FoxNet.zip, create a new directory such as C:FOXNET on your hard disk, and then start the FoxNet.zip.After the start of the file as follows:Foxcgic.exe-CGI program, WWW server and FOXNET communication programFoxNet.fxp-FOXCGI and FOXP

12、RO connection programThe HtmlLib.fxp- homepage design library (to help user homepage design in the program)Help.htm- help file systemExport datas-FOXPRO database folder for storing filesPrgs-FOXPRO in the program folder for storing *.PRG documentsTxt- text fileIn order to ensure the compatibility of

13、 different versions of the FOXPRO database, the program in the software package using the FOXPRO2.5 compiler, youd better use your use of FOXPRO or VFP to all PRG files,And the DBF file for your version upgrade.The last is to install and run FOXNET. FOXNET installation is very simple, the standard C

14、GI path FOXCGIC.EXE Kaodao WWW server, usually /CGI-SHL or /CGI-BIN can be. Is FOXNET the next run, you should first start the WWW server, and then start FOXPRO or VFP, in the FOXPRO command window DoFoxnet.prgThe program, then FOXPRO automatically minimized FOXNET in the network service state, you

15、can run the machine from the Internet on the FOXPRO program, and achieved results. If you do not worry about the introduction, can check the actual effect, the input in your browser address bar: HTTP:/ the IP address of the machine (such as ) /cgi-shl/foxcgic.exe/hello.prg?Such as the retur

16、n of Hello, nice to meet you on the internet. Show that the system is properly installed, otherwise the Foxcgic.exe is not on the standard WWW server CGI path.2, how to extract the information of user terminalFOXNET is designed for FOXPRO users to design the CGI program tool, its working procedure i

17、s to accept the users request, through the implementation of the server and the results returned to the client, as shown below:MediaRequest transfer requestTo return results to return resultsCGITherefore, to achieve the extraction of information of the user terminal, is key to the client and server

18、information exchange. In most cases, the user information is the user through the browser input form. Users fill in the form, click the Submit button to start the server, (submitted) foxcgic.exe procedures, processing form data, and the information is returned to the browser. In order to realize the

19、 FOXCGI correctly, assuming the form data FOXNET by the application server search.prg to receive, you must call the following statement in the browse. server address?(HTML form)3, how to generate and return the results to the userThe users request, the data processing part in the program, it can for

20、m data received by the retrieval of the database, and the search results for formatting, such as the formation of a table or card. The user receives the form information, should be provided by the use of FOXNET (Htmlin) functions, such as user end form data variables more than one, you should use th

21、e whole form input variable HtmlLParlen= definition of n form data item. (n is the number of variables).In the back part of the application, FOXNET will look for a public variable HTML_OUT or search for FOXNET offers to open the current work area in the database all records into a HTML table output

22、function HtmlDbfTable ().Such as c:mydbfbook.dbf USE(=HtmlDbfTable)USESo the FOXNET in the application after the execution is completed, the automatic variable HTML_OUT or HtmlDbfTable () the value returned to the client browser.In order to make the output more in line with the Chinese habit or more

23、 beautiful, FOXNET through the HTML_OUT variable and flexible application of HTML language, realize the rich and varied form output, make the interface full of vitality.4, a simple exampleThe user browser HTML form: bibliographic retrieval East China Institute of Geology library bibliographic retrieval system Please enter the title to be