Is this possible...

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.

Hi All,

This is what I'm being asked to do and I am not sure wether there is an ability to
do it.

Basically I need to be able to capture a signature from a "Signature Tablet" and
have that image saved in a MySQL database.

I'm thinking the capturing ... or even displaying that signature image on the web
interface is going to be the tough part. Does anyone have any ideas on this??

I'd very much appreciate it if you could point me in the right direction.

Thanks,

Faithful

Joined: 11/28/2008
User offline. Last seen 43 weeks 3 days ago.
Could you save the signature

Could you save the signature as a gif or jpg or something.... then put the "location" of the image in the db, not the image itself and then reference the database to display it?

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
I'll need to have that be

I'll need to have that be done on the page ....
basically it is a form that is being filled out and a user
will need to "Sign" it. So, it could be stored as a Gif or JPG,
but I have to have a way of saving it from the web interface.

Any ideas? Anyone?

Faithful

Joined: 11/28/2008
User offline. Last seen 1 year 33 weeks ago.
Java, activex or even flash

Java, activex or even flash but each input device is different and without knowing like the manufacturer I can't help you /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" />

Well its time to head out
Gotta find my place to rest
Before the sun goes down
In the darkness of the west - Day Of Fire

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
The company we purchase these

The company we purchase these signature pads from is Topaz Systems.

Does that help?

Thanks,

Faithful

Joined: 11/28/2008
User offline. Last seen 1 year 2 days ago.
Topaz Systems has web based

Topaz Systems has web based manuals from their site:

http://www.topazsystems.com/software/download/web/index.htm

That is where I would start.

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
Looks like there might be

Looks like there might be some hope here. I'll further research this. Thanks,

Faithful

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
Can someone tell me if this

Can someone tell me if this can also be done completely in PHP? Or do I need to use JavaScript to do part of this?

Is it possible to capture the displayed image as a JPEG instead of a long alphanumeric signature, or is there a benefit in using the signature?

If I use the signature, it seems to me that it would be best to display the picture as a JPEG ... is this possible from using the signature that is captured??? Thanks!

Faithful

Joined: 11/28/2008
User offline. Last seen 1 year 2 days ago.
Seeing as this is a very

Seeing as this is a very system specific piece of technology, I think that you might have to set this up the way the manufacturer intended. I would first get it working to specifications, and then start playing around with it seeing what can and can’t be done.
I would dare say that not too may people would be able to help with this simply because we don’t have the signature capture pad. (Speaking for me, somebody else might have it.)

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
Okay, but the signature will

Okay, but the signature will show up in that embedded object box .... can PHP parse that into a JPG?

Faithful

Joined: 11/28/2008
User offline. Last seen 1 year 33 weeks ago.
ditto to what paul said

ditto to what paul said

Well its time to head out
Gotta find my place to rest
Before the sun goes down
In the darkness of the west - Day Of Fire

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
I understand that, but does

I understand that, but does anyone know if you take an embedded object and have PHP parse it into an image?

Thanks,

Faithful

Joined: 11/28/2008
User offline. Last seen 1 year 34 weeks ago.
PHP GD (image library only

PHP GD (image library) only handles actual physical .jpg .gif or .png files (you can get other libraries that can do more formats, but that's what's included with the free GD2.0).

So I don't know what this {embed} obj will look like coming from that touch-sensitive signature tablet. If that software used for the tablet can create .jpgs from the signature, then PHP can certainly import them and save them in binary format inside of MySQL database tables.

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
Well, ASP can do it ....

Well, ASP can do it .... apparently it is done by using this script:

CODE
<HTML>
<HEAD>

</HEAD>
<BODY>

<%
'SigPlus must be installed on the server for this to function!
Dim sigObj
Set sigObj = CreateObject("SIGPLUS.SigPlusCtrl.1")
sigObj.InitSigPlus ''''initialize SigPlus first
sigObj.SigCompressionMode = 1
sigObj.SigString = Request.Form("SigField")

sigObj.ImageFileFormat = 4 ''''4=jpg, 0=bmp, 6=tif
sigObj.ImageXSize = 500 ''''width of resuting image in pixels
sigObj.ImageYSize =165 ''''height of resulting image in pixels
sigObj.ImagePenWidth = 11 ''''thickness of ink in pixels
sigObj.JustifyMode = 5 ''''center and fit signature to size
sigObj.WriteImageFile Server.MapPath ("/sigsample.jpg")
%>

</BODY>
</HTML>

Does that help??

Thanks,

Faithful

Joined: 11/28/2008
User offline. Last seen 1 year 33 weeks ago.
If you can figure out how to

If you can figure out how to deal with the sigstring format, I am sure you could use the GD graphics library. You need to be able to convert it into an array (2D) of 24-bit integers.

Paul Davey
Whitford Church
"Everyone who calls on the name of the Lord will be saved." Romans 10:13
"For all have sinned and fall short of the glory of God, and are justified

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
Hi All, BobbyMac and I were

Hi All, BobbyMac and I were working on this issue via MSN messenger.

This is how far I am on this. I now am able to tap in to the activeX control sometimes (I think) and it will sometimes write out a JPEG file, but other times I get an error. (very strange). Any help would be much appreciated. This is what BobbyMac and I came up with in converting the ASP to PHP .....
*If you want to compare, you can view the ASP Code in my above post*

CODE
<HTML><HEAD></HEAD><BODY>
<?php
$aConn = new COM("SIGPLUS.SigPlusCtrl.1");
$aConn->InitSigPlus;
$aConn->SigCompressionMode = 1;
$aConn->SigString = $_POST[SigField];
$aConn->ImageFileFormat = 4; //4=jpg, 0=bmp, 6=tif
$aConn->ImageXSize = 500; //width of resuting image in pixels
$aConn->ImageYSize =165; //height of resulting image in pixels
$aConn->ImagePenWidth = 11; //thickness of ink in pixels
$aConn->JustifyMode = 5;  //center and fit signature to size
$aConn->WriteImageFile("C:\\Inetpub\\OtherApps\\testweb\\test.jpg");

?>
</BODY></HTML>

Sometimes I get a rectangular box that gets saved out to the correct path but it is all black. The signature is not viewable as it is solid black.

Other times I get this error:

PHP has encountered an Unhandled Exception Code -1073741676 at 09D0270C

I feel like I am sooooo close! But, I don't know what could be causing this. If anyone has any suggestions, I'd appreciate them!! Thanks so much!

Faithful

Joined: 11/28/2008
User offline. Last seen 1 year 33 weeks ago.
Hi KevinThis is a small

Hi Kevin

This is a small thing, but PHP can be good at not reporting it as an error depending on your level of error reporting:

CODE
$aConn->InitSigPlus;

Should be

CODE
$aConn->InitSigPlus();

Paul Davey
Whitford Church
"Everyone who calls on the name of the Lord will be saved." Romans 10:13
"For all have sinned and fall short of the glory of God, and are justified

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
BobbyMac is the bomb!

BobbyMac is the bomb! BobbyMac is the bomb! BobbyMac is the bomb! BobbyMac is the bomb!

I cannot believe it was that simple as two parethesis!!!
Yipes!!!

Thanks you Thank you, Thank you Mr. BobbyMac!!!!!!!!!!!!!!!!!!!!!

It works!!!!!

Joined: 11/28/2008
User offline. Last seen 5 weeks 5 days ago.
Thank you all again for your

Thank you all again for your help.

Look they posted my code !!! Woo hoo!!! Now they have a PHP option!

http://www.topazsystems.com/software/download/web/index.htm

Joined: 11/28/2008
User offline. Last seen 1 year 34 weeks ago.
sweet.

sweet.

TJ SINGLETON

Sandeep
Sandeep's picture
My website is hosted outside

My website is hosted outside and I can't install SigPlus on the server. Using the above script I get error:

Fatal error: Class 'COM' not found in...

how do I deal with that??? help!

Joined: 11/28/2008
User offline. Last seen 20 weeks 4 days ago.
Whats up! I don't know if it

Whats up! I don't know if it has been answered but I would go about it by making a flash app. You can make a flash app that allows the user to draw their signature... Then you can send the BitmapData in a $_POST request to php that would in return store it as binary data in the database or a JPG externally with a url in the database.

WARNING: No exposure to the Son will cause burning!

Portfolio Site | Production Blog |

Joined: 07/01/2010
User offline. Last seen 4 weeks 10 hours ago.
Faithfulman, how did you get it working with php?

I have the same issue where the applicants will sign the form online and I need to capture the signature. I tried to use the .php file but it didn't work. The forms will be signed at Windows machines and will be processed on a Linux server. Need to know the steps to do this. Thanks.