摘要
教师往往需要将学生完成作业的情况输入到电子表格中。但是,由于原始文档中存在多个班级,学生完成作业的顺序较为混乱,且数据量较大,直接输入费时费力。针对该问题,提出利用PHP设计成绩快速输入系统的解决思路。首先将学生的学号信息导入到MySQL数据库,然后通过PHP页面的文本框接收输入的学号字符串并自动增加新的作业字段,接着通过explode函数对字符串进行分割并提取学号,再根据学号与数据库对比更新当前作业所在字段,最后将数据表导出到电子表格。实践表明,该系统运行速度较快,稳定可靠,能够极大地提高工作效率。
Teachers often need to input student finished jobs into spreadsheet. However, due to the students in the original document belong to different classes, the order of the finished jobs is chaotic, and the amount of data is large, so the direct input is time-consuming and laborious. To solve this problem, a solution of designing a score fast input system with PHP is put forward. Firstly, the student's Student Number Information is imported into the MySQL database, then the string of Student Number Information is received by the text box of the PHP page and the new job field is automatically added. Then the string is segmented by the explode function to extract the Student Number, and the field is updated according to the comparison of the Student Number and the database, and the data table is finally exported to a spreadsheet. Practice shows that the system runs fast,stable and reliable, and can greatly improve the work efficiency.
引文
[1]吴国辉.基于AJAX的便携式作业管理系统的设计[J].电子制作,2014.16:64-65
[2]倪玲玲.高职院校学生成绩管理系统的设计与实现[D].湖北工业大学硕士学位论文,2017.
[3]许广强,贾翠翠,詹念等.基于FPGA和DBN的手写体图像识别算法的实现[J].电子世界,2017.7:69
[4]吴国辉.基于PXF模式快速提升网页视觉效果的研究[J].电子技术与软件工程,2016.14:107,165
[5]丁宁.基于PHP的在线调研系统的设计与实现[D].北京邮电大学硕士学位论文,2017.
[6]phpstudy.phpstudy安装及使用教程[EB/OL].http://www.phpstudy.net/jishu-php-2956.html
[7]李强.基于MySql的物流管理系统的设计与实现[J].西安文理学院学报(自然科学版),2017.20(2):50-54
[8]何晓明,洪亲,蔡坚勇等.基于n-gram中英文字符串分割算法实现[J].电脑知识与技术,2012.8(23):5530-5533