外文翻譯--通用html表單處理器將網(wǎng)絡(luò)上收集到的數(shù)據(jù)保存到mysql數(shù)據(jù)庫的多功能php腳本（英文）

1、In the last decade, the execution of experiments and sur- veys via the World-Wide Web has become an established method (see Birnbaum, 2001, 2004a, 2004b; Kraut et al., 2004). Several reviews have concluded that the qua

2、lity of data achieved in online studies can be comparable to, and sometimes better than, that obtained by more tradi- tional methods involving a lab, paper questionnaires, or telephone interviews (Birnbaum, 2001; Kran

3、tz McGraw, Tew, Göritz Reips, 2002). An example of an HTML Web form is given in Birn- baum (2000). Such an HTML page can be placed on a server, where the participant can view it and fill in answers by typing in

4、information and clicking on choices. When the participant is finished, he or she can then click on a button to send the data. Birnbaum’s (2000) surveyWiz and factorWiz are freely available programs that make it easy

5、 to create HTML forms for simple surveys and within- subjects factorial experiments. Reips and Neuhaus (2002) have developed WEXTOR, which is useful for generat- ing Web experiments that utilize (for instance) between-s

6、ubjects factorial designs with multiple pages for different conditions.Sending Data From an HTML Form There are three methods of receiving data that have been collected through an HTML form. The first method is to use

7、 the “get” method and extract the form input from the server log files (see Birnbaum & Reips, 2005).1 A second method is to have the form data e-mailed to the researcher. This can be done by means of the HTML form

8、’s action attribute—for example,?form action?“mailto:you@your.domain.net” method?“post” enctype?“text/plain”?.However, some systems refuse such an action attribute if, for example, no e-mail client is set up (as might

9、 be the case for, e.g., computers in a public library). More- over, some browsers issue a more or less draconian alert, which the participant has to confirm for the data to be e-mailed. Most problematic for large effo

10、rts, though, is the fact that each submission generates its own e-mail, so data need to be extracted from thousands of individual e-mails and merged into one data file. Thus, whereas the e-mail method might be useful

11、 during testing of a form 703 Copyright 2005 Psychonomic Society, Inc.This work was supported by a University of Erlangen-Nuremberg postdoctoral scholarship (HWP) and by National Science Foundation Grants SES-9986436

12、and BCS-0129453. Correspondence concerning this article should be addressed to A. S. Göritz, Organizational and Social Psychology, University of Erlangen-Nuremberg, Lange Gasse 20, 90403 Nuremberg, Germany (e-mai

13、l: anja.goeritz@wiso.uni-erlangen.de).Generic HTML Form Processor: A versatile PHP script to save Web-collected data into a MySQL databaseANJA S. GÖRITZ University of Erlangen-Nuremberg, Nuremberg, GermanyandMICHA

14、EL H. BIRNBAUM California State University, Fullerton, CaliforniaThe customizable PHP script Generic HTML Form Processor is intended to assist researchers and students in quickly setting up surveys and experiments that

15、can be administered via the Web. This script relieves researchers from the burdens of writing new CGI scripts and building databases for each Web study. Generic HTML Form Processor processes any syntactically correct H

16、TML form input and saves it into a dynamically created open-source database. We describe five modes for usage of the script that allow increasing functionality but require increasing levels of knowledge of PHP and Web

17、 servers: The first two modes require no previous knowledge, and the fifth requires PHP programming expertise. Use of Generic HTML Form Processor is free for academic purposes, and its Web address is www.goeritz.net/br

18、mic.Behavior Research Methods 2005, 37 (4), 703-710GENERIC HTML FORM PROCESSOR 705andpsych.fullerton.edu/mbirnbaum/programs/ factorWizRB4.htm.Besides the basic functionalities of creating a database and saving the fo

19、rm input into this database, Generic HTML Form Processor can point respondents to omit- ted questions in the HTML form. Also, the researcher can choose whether the HTML input will be written into the database in chron

20、ological or alphanumeric order. More- over, the wording of feedback messages to participants (e.g., the text to be displayed upon omission of an item or the thank-you message that appears after submission of the quest

21、ionnaire) can be customized. To enable the iden- tification of multiple submissions (i.e., most likely sub- missions from the same IP address within a short period of time) and of nonserious participants (e.g., those wh

22、o filled out the questionnaire too fast or too slowly), the date, IP address, and browser information are logged, along with the submission time stamps of each questionnaire page. The script supports both one-page an

23、d multipage ques- tionnaires. Researchers with access to a PHP-enabled Web server with MySQL can use Generic HTML Form Proces- sor on their own server at no cost. They are also free to further customize the script. Res

24、earchers without access to a server can use Generic HTML Form Processor and a MySQL database on a dedicated server at the first author’s university.As a result of this spectrum of possible usage, we will now describe

25、 five modes of use that require different lev- els of knowledge of PHP and server issues. 1. The easiest mode for using Generic HTML Form Pro- cessor is with one-page HTML questionnaires designed to save data on a serve

26、r at the first author’s university. For this purpose, no knowledge of PHP and Web servers is re- quired. The only preparation necessary is to set the action attribute of your HTML form to the URL (Internet ad- dress) o

27、f Generic HTML Form Processor. The HTML file itself can reside on any server. Let us look at an example HTML form called sample.htm. It contains most of the existing HTML input field types (see Figure 1). The HTML cod

28、e of sample.htm can be found in List- ing 1. Note the action attribute in the form tag?form method?“post” action?“http://www.goeritz .net/brmic/generic.php”?,which is printed in bold in Listing 1. To use the script on ou

29、r server, leave this line (the action attribute) as it is. If you would like to have the order of items or alternative answers in your HTML form random- ized or rotated, you can use Birnbaum’s (2000) factor- Wiz or inc

30、lude a special JavaScript program (Birnbaum & Wakcher, 2002).2To obtain your study data from our server, call up the display script display_generic.php by typing the URL www.goeritz.net/brmic/display_generic.php i