是否有任何技术或方法将数据传输到Mysql [英] Is there any technique or way to transfer Data to Mysql

问题描述

我们有大量的硬拷贝数据，可能是寄存器，书籍或其他包含学生，教师和其他记录的内容。



我有什么简单的方法可以使用PHP，以便我们可以将基于纸张或硬拷贝的数据传输到mysql数据库。



这些数据是以记录形式提供的。如果有人在此之前遇到过这个问题，请告诉我是否可行。



如果我不清楚请随时要求更多澄清。



谢谢和问候，

Zeeshan。

Hi,

We have large set of data in form of hard copy that may be registers,books or something else which contains records of students,teachers & other.

Is there any easy way i can do using PHP so that we can transfer that paper based or hard copy data to mysql database.

The data is in record form.If anyone has faced this before please let me know if it is possible or not.

If i am not clear please feel free to ask for more clarifications.

Thanks & Regards,
Zeeshan.

推荐答案

您需要扫描纸质表格，以某种方式对其进行OCR，将字段拆分为单独的字段，然后将它们插入相应的数据库列。



过去我发现雇用某人数据输入数据已被证明更便宜，更准确。



当然没那么有趣：）

You would need to scan the paper forms, OCR them some way, split the fields into individual fields and then insert them into appropriate database columns.

In the past I have found that employing someone to data-entry the data has proven cheaper and more accurate.

Not as much fun, of course :)

Hello Zeeshan，



您无法直接将硬拷贝数据存储到mysql数据库中。为此您可能需要一个软件来扫描那些硬拷贝页面，然后将这些页面转换为excel文件格式或.CSV文件格式，然后可以使用php代码将其插入到mysql数据库中。

Hello Zeeshan,

You can cannot directly store hard copy data into mysql database. For this you might require an software which will scan those hard copy pages and then convert those pages into excel file format or .CSV file format then it can be inserted into mysql database using php code.

And another way is that you can create and basic data entry form in php and insert those hard copy data into data entry form and it will store into mysql database.

你好Zeeshan，



你可以使用Lua-GD，一个用于绘制C的gdlibrary的绑定。



您必须首先安装gd及其所有依赖项，然后安装Lua-GD，如手册所述。



这是执行所需操作的Lua代码：

Hello Zeeshan,

You can use Lua-GD, a binding for C's gdlibrary for drawing.

You must first install gd and all it's dependencies, then install Lua-GD, as the manual says.

Here is the Lua code to do what is requested:

require 'gd'

local f = io.open('file.csv', 'w')

local img = gd.createFromPng('image.png')
for y = 1, img:sizeY() do
    local line = ''
    for x = 1, img:sizeX() do
        local r, g, b = img:getPixel(x, y)
        line = line .. r .. ', ' .. g .. ', ' .. b .. ', '
    end
    line = line:gsub(',

这篇关于是否有任何技术或方法将数据传输到Mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！