Jump to content

Recommended Posts

Posted

Need Help from autoit expert. i already done upload image to mysql database , the problem how i want view the image file(jpg) using autoit.

This is a example script i done.

Local $TesterID, $PM_CalibDate, $PM_PMDate, $TimeCheck, $UserName

Local $SQLInstance, $SQLInstance, $TableContents, $NameList, $PM_CalibDate, $SQLCode, $NamePosition

Local $NameDateDue, $NameEmp, $NamePosition, $NameSupervisor, $NameWorkcell, $NameImage

Local $UserName = ""

Local $Password = ""

Local $Database = "operator"

Local $MySQLServerName = "tdesvr"

; GUICtrlSetState($InputTesterID, $GUI_FOCUS)

$TesterID = GUICtrlRead($Form_Operator_Input1)

;MsgBox(0, "", "" & $TesterID)

; GUICtrlSetData ($Picture_Load, $TesterID)

; $TesterID = "00030597"

$SQLInstance = _MySQLConnect($UserName,$Password,$Database,$MySQLServerName)

$SQLCode = "SELECT * FROM `"&$Database&"`.`operatorid` WHERE `Employee_No` LIKE '"&"%"&$TesterID& "%"&"'"

MsgBox(0, "", "" & $SQLCode)

$TableContents = _Query($SQLInstance,$SQLCode)

With $TableContents

While Not .EOF

$NameEmp &= .Fields (1).value

$NameList &= .Fields (2).value

$NameWorkcell &= .Fields (3).value

$NamePosition &= .Fields (4).value

$NameSupervisor &= .Fields (5).value

$NameDateDue &= .Fields (6).value

$NameImage &= .Fields (9).value

Need helfpul from autoit expert. I already done upload image to mysql the how i want view the

image file use autoit.

The problem the value from $NameImage can read but it show the binary code not image.

Regards

Helmy

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...