文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >如何将html格式的数据输入导出到.csv文件？

问如何将html格式的数据输入导出到.csv文件？
EN

Stack Overflow用户
提问于 2018-01-15 08:24:57
回答 2查看 19K关注 0票数 5

我是新手，根据自己的需要从互联网上搜索和编辑了一些代码，但现在我想将html格式的数据输入保存到data.csv文件中，当我点击submit按钮时，应该将内容以新的方式保存到data.csv中，每次单击submit按钮。这个html代码我只运行本地计算机。我不知道这怎么可能是MWE。预先感谢您的帮助

代码语言：javascript
复制
 <html>

   <head>

   <script type="text/javascript" src="validate.js"></script>

   </head>

   <body>

   <form action="#" name="StudentRegistration" onSubmit="return(validate());">


 <table cellpadding="2" width="20%" bgcolor="99FFFF" align="center"

   cellspacing="2">

 <tr>

   <td colspan=2>

   <center><font size=4><b>Student Registration Form</b></font></center>

   </td>

   </tr>

 <tr>

   <td>Name</td>

   <td><input type=text name=textnames id="textname" size="30"></td>

   </tr>

 <tr>

   <td>Father Name</td>

   <td><input type="text" name="fathername" id="fathername"

   size="30"></td>

   </tr>

   <tr>

   <td>Postal Address</td>

   <td><input type="text" name="paddress" id="paddress" size="30"></td>

   </tr>

 <tr>

   <td>Personal Address</td>

   <td><input type="text" name="personaladdress"

   id="personaladdress" size="30"></td>

   </tr>

 <tr>

   <td>Sex</td>

   <td><input type="radio" name="sex" value="male" size="10">Male

   <input type="radio" name="sex" value="Female" size="10">Female</td>

   </tr>

 <tr>

   <td>Stream</td>

   <td><select name="Stream">

   <option value="-1" selected>Select..</option>

   <option value="ARTS">ARTS</option>

   <option value="COMMERCE">COMMERCE</option>

   <option value="SCIENCE">SCIENCE</option>

   </select></td>

   </tr>

 <tr>

   <td>Core-1</td>

   <td><select name="Core-1">

   <option value="-1" selected>Select..</option>

   <option value="English">English</option>

   </select></td>

   </tr>
 <tr>

   <td>Core-2</td>

   <td><select name="Core-2">

   <option value="-1" selected>Select..</option>

   <option value="Alternative English">Alternative English</option>

   </select></td>

   </tr>

 <tr>

 <td>Elective-1</td>

   <td><select name="Elective-1">

   <option value="-1" selected>Select..</option>

   <option value="MIL (Hindi)">MIL (Hindi)</option>
   <option value="MIL (Bengali)">MIL (Bengali)</option>
   <option value="MIL (Nepali)">MIL (Nepali)</option>
   <option value="Political Science">Political Science</option>
   <option value="Education">Education</option>
   <option value="Economics">Economics</option>
   <option value="History">History</option>
   <option value="Geography">Geography</option>
   <option value="Sociology">Sociology</option>
   <option value="Logic & Philosophy">Logic & Philosophy</option>
   <option value="Advance Assamese">Advance Assamese</option>
   <option value="Advance Bengali">Advance Bengali</option>
   <option value="Physics">Physics</option>
   <option value="Chemistry">Chemistry</option>
   <option value="Biology">Biology</option>
   <option value="Mathematics">Mathematics</option>
   <option value="Computer Science & Applications">Computer Science & Applications</option>
   <option value="Accountancy">Accountancy</option>
   <option value="Business Studies">Business Studies</option>
   <option value="Banking">Banking</option>
   <option value="Statistics">Statistics</option>
   </select></td>

   </tr>

   <tr>

   <td>Elective-2</td>

     <td><select name="Elective-2">

   <option value="-1" selected>Select..</option>

   <option value="MIL (Hindi)">MIL (Hindi)</option>
   <option value="MIL (Bengali)">MIL (Bengali)</option>
   <option value="MIL (Nepali)">MIL (Nepali)</option>
   <option value="Political Science">Political Science</option>
   <option value="Education">Education</option>
   <option value="Economics">Economics</option>
   <option value="History">History</option>
   <option value="Geography">Geography</option>
   <option value="Sociology">Sociology</option>
   <option value="Logic & Philosophy">Logic & Philosophy</option>
   <option value="Advance Assamese">Advance Assamese</option>
   <option value="Advance Bengali">Advance Bengali</option>
   <option value="Physics">Physics</option>
   <option value="Chemistry">Chemistry</option>
   <option value="Biology">Biology</option>
   <option value="Mathematics">Mathematics</option>
   <option value="Computer Science & Applications">Computer Science & Applications</option>
   <option value="Accountancy">Accountancy</option>
   <option value="Business Studies">Business Studies</option>
   <option value="Banking">Banking</option>
   <option value="Statistics">Statistics</option>
   </select></td>

   </tr>

   <tr>

   <td>Elective-3</td>

     <td><select name="Elective-3">

   <option value="-1" selected>Select..</option>

   <option value="MIL (Hindi)">MIL (Hindi)</option>
   <option value="MIL (Bengali)">MIL (Bengali)</option>
   <option value="MIL (Nepali)">MIL (Nepali)</option>
   <option value="Political Science">Political Science</option>
   <option value="Education">Education</option>
   <option value="Economics">Economics</option>
   <option value="History">History</option>
   <option value="Geography">Geography</option>
   <option value="Sociology">Sociology</option>
   <option value="Logic & Philosophy">Logic & Philosophy</option>
   <option value="Advance Assamese">Advance Assamese</option>
   <option value="Advance Bengali">Advance Bengali</option>
   <option value="Physics">Physics</option>
   <option value="Chemistry">Chemistry</option>
   <option value="Biology">Biology</option>
   <option value="Mathematics">Mathematics</option>
   <option value="Computer Science & Applications">Computer Science & Applications</option>
   <option value="Accountancy">Accountancy</option>
   <option value="Business Studies">Business Studies</option>
   <option value="Banking">Banking</option>
   <option value="Statistics">Statistics</option>
   </select></td>

   </tr>

   <tr>

   <td>Elective-4</td>

     <td><select name="Elective-4">

   <option value="-1" selected>Select..</option>

   <option value="MIL (Hindi)">MIL (Hindi)</option>
   <option value="MIL (Bengali)">MIL (Bengali)</option>
   <option value="MIL (Nepali)">MIL (Nepali)</option>
   <option value="Political Science">Political Science</option>
   <option value="Education">Education</option>
   <option value="Economics">Economics</option>
   <option value="History">History</option>
   <option value="Geography">Geography</option>
   <option value="Sociology">Sociology</option>
   <option value="Logic & Philosophy">Logic & Philosophy</option>
   <option value="Advance Assamese">Advance Assamese</option>
   <option value="Advance Bengali">Advance Bengali</option>
   <option value="Physics">Physics</option>
   <option value="Chemistry">Chemistry</option>
   <option value="Biology">Biology</option>
   <option value="Mathematics">Mathematics</option>
   <option value="Computer Science & Applications">Computer Science & Applications</option>
   <option value="Accountancy">Accountancy</option>
   <option value="Business Studies">Business Studies</option>
   <option value="Banking">Banking</option>
   <option value="Statistics">Statistics</option>
   </select></td>

   </tr>

   <tr>

   <td>Compulsory</td>

     <td><select name="Compulsory">

     <option value="-1" selected>Select..</option>

       <option value="Environmental Education">Environmental Education</option>

     </select></td>

     </tr>



   <tr>

     <td>Institute</td>

     <td><select name="Institute">

     <option value="-1" selected>Select..</option>

     <option value="Institute-1">Institute-1</option>

     <option value="Institute-2">Institute-2</option>

     <option value="Institute-3">Institute-3</option>

     </select></td>

   </tr>

   <tr>

     <td>State</td>

     <td><select Name="State">

     <option value="-1" selected>select..</option>

     <option value="New Delhi">NEW DELHI</option>

     <option value="Mumbai">MUMBAI</option>

     <option value="Goa">GOA</option>

     <option value="Bihar">BIHAR</option>

     </select></td>

     </tr>

     <tr>

     <td>PinCode</td>

     <td><input type="text" name="pincode" id="pincode" size="30"></td>

   </tr>

     <tr>

     <td>EmailId</td>

     <td><input type="text" name="emailid" id="emailid" size="30"></td>

     </tr>

   <tr>

     <td>DOB</td>

     <td><input type="text" name="dob" id="dob" size="30"></td>

     </tr>

   <tr>

     <td>MobileNo</td>

     <td><input type="text" name="mobileno" id="mobileno" size="30"></td>

     </tr>

     <tr>

     <td><input type="reset"></td>


     <td colspan="2"><input type="submit" value="Submit Form" /></td>

     </tr>

     </table>

     </form>

     </body>

     </html>

以下是上述html代码的输出：

​

​

我根据比尔的建议创建了一个.php作为proces.php文件，但内容不是写的，而是只给出，，，

代码语言：javascript
复制
 <?php
 $fieldA = $_POST["textnames"];
 $fieldB = $_POST["fathername"];
 $fieldC = $_POST["paddress"];
 $fieldD = $_POST["personaladdress"];
 $fieldE = $_POST["sex"];
 $fieldF = $_POST["Stream"];
 $fieldG = $_POST["Core-1"];
 $fieldH = $_POST["Core-2"];
 $fieldI = $_POST["Elective-1"];
 $fieldJ = $_POST["Elective-2"];
 $fieldK = $_POST["Elective-3"];
 $fieldL = $_POST["Elective-4"];
 $fieldM = $_POST["Compulsory"];

 $keys = array($fieldA,$fieldB,$fieldC,$fieldD,$fieldE,$fieldF,$fieldG,$fieldH,$fieldI,$fieldJ,$fieldK,$fieldL,$fieldM); //THIS IS WHERE YOU PUT THE FORM ELEMENTS ex: array('$fieldA','$fieldB',etc)
 $csv_line = array();
 foreach($keys as $key){
     array_push($csv_line,'' . $_GET[$key]);
 }
 $fname = 'data.csv'; //NAME OF THE FILE
 $csv_line = implode(',',$csv_line);
 if(!file_exists($fname)){$csv_line = "\r\n" . $csv_line;}
 $fcon = fopen($fname,'a');
 $fcontent = $csv_line;
 fwrite($fcon,$fcontent);
 fclose($fcon);
 ?>

并将原来的html代码从<form action="#" name="StudentRegistration" onSubmit="return(validate());">编辑到<form name="StudentRegistration" action="proces1.php" method="post">，下面是我的新的html代码。

代码语言：javascript
复制
 <html>

   <head>

   <script type="text/javascript" src="validate.js"></script>

   </head>

   <body>

   <form name="StudentRegistration" action="proces.php" method="post">


 <table cellpadding="2" width="20%" bgcolor="99FFFF" align="center"

   cellspacing="2">

 <tr>

   <td colspan=2>

   <center><font size=4><b>Student Registration Form</b></font></center>

   </td>

   </tr>

 <tr>

   <td>Name</td>

   <td><input type=text name=textnames id="textname" size="30"></td>

   </tr>

 <tr>

   <td>Father Name</td>

   <td><input type="text" name="fathername" id="fathername"

   size="30"></td>

   </tr>

   <tr>

   <td>Postal Address</td>

   <td><input type="text" name="paddress" id="paddress" size="30"></td>

   </tr>

 <tr>

   <td>Personal Address</td>

   <td><input type="text" name="personaladdress"

   id="personaladdress" size="30"></td>

   </tr>

 <tr>

   <td>Sex</td>

   <td><input type="radio" name="sex" value="male" size="10">Male

   <input type="radio" name="sex" value="Female" size="10">Female</td>

   </tr>

 <tr>

   <td>Stream</td>

   <td><select name="Stream">

   <option value="-1" selected>Select..</option>

   <option value="ARTS">ARTS</option>

   <option value="COMMERCE">COMMERCE</option>

   <option value="SCIENCE">SCIENCE</option>

   </select></td>

   </tr>

 <tr>

   <td>Core-1</td>

   <td><select name="Core-1">

   <option value="-1" selected>Select..</option>

   <option value="English">English</option>

   </select></td>

   </tr>
 <tr>

   <td>Core-2</td>

   <td><select name="Core-2">

   <option value="-1" selected>Select..</option>

   <option value="Alternative English">Alternative English</option>

   </select></td>

   </tr>

 <tr>

 <td>Elective-1</td>

   <td><select name="Elective-1">

   <option value="-1" selected>Select..</option>

   <option value="MIL (Hindi)">MIL (Hindi)</option>
   <option value="MIL (Bengali)">MIL (Bengali)</option>
   <option value="MIL (Nepali)">MIL (Nepali)</option>
   <option value="Political Science">Political Science</option>
   <option value="Education">Education</option>
   <option value="Economics">Economics</option>
   <option value="History">History</option>
   <option value="Geography">Geography</option>
   <option value="Sociology">Sociology</option>
   <option value="Logic & Philosophy">Logic & Philosophy</option>
   <option value="Advance Assamese">Advance Assamese</option>
   <option value="Advance Bengali">Advance Bengali</option>
   <option value="Physics">Physics</option>
   <option value="Chemistry">Chemistry</option>
   <option value="Biology">Biology</option>
   <option value="Mathematics">Mathematics</option>
   <option value="Computer Science & Applications">Computer Science & Applications</option>
   <option value="Accountancy">Accountancy</option>
   <option value="Business Studies">Business Studies</option>
   <option value="Banking">Banking</option>
   <option value="Statistics">Statistics</option>
   </select></td>

   </tr>

   <tr>

   <td>Elective-2</td>

     <td><select name="Elective-2">

   <option value="-1" selected>Select..</option>

   <option value="MIL (Hindi)">MIL (Hindi)</option>
   <option value="MIL (Bengali)">MIL (Bengali)</option>
   <option value="MIL (Nepali)">MIL (Nepali)</option>
   <option value="Political Science">Political Science</option>
   <option value="Education">Education</option>
   <option value="Economics">Economics</option>
   <option value="History">History</option>
   <option value="Geography">Geography</option>
   <option value="Sociology">Sociology</option>
   <option value="Logic & Philosophy">Logic & Philosophy</option>
   <option value="Advance Assamese">Advance Assamese</option>
   <option value="Advance Bengali">Advance Bengali</option>
   <option value="Physics">Physics</option>
   <option value="Chemistry">Chemistry</option>
   <option value="Biology">Biology</option>
   <option value="Mathematics">Mathematics</option>
   <option value="Computer Science & Applications">Computer Science & Applications</option>
   <option value="Accountancy">Accountancy</option>
   <option value="Business Studies">Business Studies</option>
   <option value="Banking">Banking</option>
   <option value="Statistics">Statistics</option>
   </select></td>

   </tr>

   <tr>

   <td>Elective-3</td>

     <td><select name="Elective-3">

   <option value="-1" selected>Select..</option>

   <option value="MIL (Hindi)">MIL (Hindi)</option>
   <option value="MIL (Bengali)">MIL (Bengali)</option>
   <option value="MIL (Nepali)">MIL (Nepali)</option>
   <option value="Political Science">Political Science</option>
   <option value="Education">Education</option>
   <option value="Economics">Economics</option>
   <option value="History">History</option>
   <option value="Geography">Geography</option>
   <option value="Sociology">Sociology</option>
   <option value="Logic & Philosophy">Logic & Philosophy</option>
   <option value="Advance Assamese">Advance Assamese</option>
   <option value="Advance Bengali">Advance Bengali</option>
   <option value="Physics">Physics</option>
   <option value="Chemistry">Chemistry</option>
   <option value="Biology">Biology</option>
   <option value="Mathematics">Mathematics</option>
   <option value="Computer Science & Applications">Computer Science & Applications</option>
   <option value="Accountancy">Accountancy</option>
   <option value="Business Studies">Business Studies</option>
   <option value="Banking">Banking</option>
   <option value="Statistics">Statistics</option>
   </select></td>

   </tr>

   <tr>

   <td>Elective-4</td>

     <td><select name="Elective-4">

   <option value="-1" selected>Select..</option>

   <option value="MIL (Hindi)">MIL (Hindi)</option>
   <option value="MIL (Bengali)">MIL (Bengali)</option>
   <option value="MIL (Nepali)">MIL (Nepali)</option>
   <option value="Political Science">Political Science</option>
   <option value="Education">Education</option>
   <option value="Economics">Economics</option>
   <option value="History">History</option>
   <option value="Geography">Geography</option>
   <option value="Sociology">Sociology</option>
   <option value="Logic & Philosophy">Logic & Philosophy</option>
   <option value="Advance Assamese">Advance Assamese</option>
   <option value="Advance Bengali">Advance Bengali</option>
   <option value="Physics">Physics</option>
   <option value="Chemistry">Chemistry</option>
   <option value="Biology">Biology</option>
   <option value="Mathematics">Mathematics</option>
   <option value="Computer Science & Applications">Computer Science & Applications</option>
   <option value="Accountancy">Accountancy</option>
   <option value="Business Studies">Business Studies</option>
   <option value="Banking">Banking</option>
   <option value="Statistics">Statistics</option>
   </select></td>

   </tr>

   <tr>

   <td>Compulsory</td>

     <td><select name="Compulsory">

     <option value="-1" selected>Select..</option>

       <option value="Environmental Education">Environmental Education</option>

     </select></td>

     </tr>



   <tr>

     <td>Institute</td>

     <td><select name="Institute">

     <option value="-1" selected>Select..</option>

     <option value="Institute-1">Institute-1</option>

     <option value="Institute-2">Institute-2</option>

     <option value="Institute-3">Institute-3</option>

     </select></td>

   </tr>

   <tr>

     <td>State</td>

     <td><select Name="State">

     <option value="-1" selected>select..</option>

     <option value="New Delhi">NEW DELHI</option>

     <option value="Mumbai">MUMBAI</option>

     <option value="Goa">GOA</option>

     <option value="Bihar">BIHAR</option>

     </select></td>

     </tr>

     <tr>

     <td>PinCode</td>

     <td><input type="text" name="pincode" id="pincode" size="30"></td>

   </tr>

     <tr>

     <td>EmailId</td>

     <td><input type="text" name="emailid" id="emailid" size="30"></td>

     </tr>

   <tr>

     <td>DOB</td>

     <td><input type="text" name="dob" id="dob" size="30"></td>

     </tr>

   <tr>

     <td>MobileNo</td>

     <td><input type="text" name="mobileno" id="mobileno" size="30"></td>

     </tr>

     <tr>

     <td><input type="reset"></td>


     <td colspan="2"><input type="submit" value="Submit Form" /></td>

     </tr>

     </table>

     </form>

     </body>

     </html>
php
html
export-to-csv
EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2018-01-15 14:19:19

感谢现在的每个人，在编辑proces.php脚本之后，我终于得到了输出，将行从$csv_line = array();改为$csv_line = $keys;，从if(!file_exists($fname)){$csv_line = "\r\n" . $csv_line;}更改为if(!file_exists($fname)){$csv_line = $csv_line."\r\n" ;}，这是我的最后一个.php文件。

代码语言：javascript
复制
 <?php
 $fieldA = $_POST["textnames"];
 $fieldB = $_POST["fathername"];
 $fieldC = $_POST["paddress"];
 $fieldD = $_POST["personaladdress"];
 $fieldE = $_POST["sex"];
 $fieldF = $_POST["Stream"];
 $fieldG = $_POST["Core-1"];
 $fieldH = $_POST["Core-2"];
 $fieldI = $_POST["Elective-1"];
 $fieldJ = $_POST["Elective-2"];
 $fieldK = $_POST["Elective-3"];
 $fieldL = $_POST["Elective-4"];
 $fieldM = $_POST["Compulsory"];

 $keys = array($fieldA,$fieldB,$fieldC,$fieldD,$fieldE,$fieldF,$fieldG,$fieldH,$fieldI,$fieldJ,$fieldK,$fieldL,$fieldM); //THIS IS WHERE YOU PUT THE FORM ELEMENTS ex: array('$fieldA','$fieldB',etc)
 $csv_line = $keys;
 foreach( $keys as $key ){
     array_push($csv_line,'' . $_GET[$key]);

 }
 $fname = 'data.csv'; //NAME OF THE FILE
 $csv_line = implode(',',$csv_line);
 if(!file_exists($fname)){$csv_line = $csv_line."\r\n" ;}
 $fcon = fopen($fname,'a');
 $fcontent = $csv_line;
 fwrite($fcon,$csv_line);
 fclose($fcon);
 ?>
票数 0
EN

Stack Overflow用户

发布于 2018-01-15 08:37:10

这篇文章应该能帮你找到你该去的地方.

How to export html form to csv file

那里的答案很好地解释了脚本的工作原理。

编辑:您需要创建一个PHP文件，并在点击submit表单时传递数据，请注意POST和.php文件。

代码语言：javascript
复制
<form action="NAMEOFFILE.php" method="post">

NAMEOFFILE.PHP将在所附链接中包含表单数据和导出到CSV脚本。如果不确定如何传递数据，这是一个简单的解释。https://www.tutorialrepublic.com/php-tutorial/php-get-and-post.php

代码语言：javascript
复制
<?php
$fieldA = $_POST["textnames"];
$keys = array('id_number','first_name'); //THIS IS WHERE YOU PUT THE FORM ELEMENTS ex: array('$fieldA','$fieldB',etc)
$csv_line = array();
foreach($keys as $key){
    array_push($csv_line,'' . $_GET[$key]);
}
$fname = 'file_to_write_to.csv'; //NAME OF THE FILE
$csv_line = implode(',',$csv_line);
if(!file_exists($fname)){$csv_line = "\r\n" . $csv_line;}
$fcon = fopen($fname,'a');
$fcontent = $csv_line;
fwrite($fcon,$csv_line);
fclose($fcon);
?>

该文件将以"file_to_write_to.csv“的名称保存在服务器上。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/48259204

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档