Jump to content

Need Help How to view image file from mysql using autoit


Recommended Posts

i need help from autoit expert . i already upload image to mysql database. the problem how i want view the image file from mysql database using autoit .

This is a example sript i do..

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

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

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

Local $UserName = ""

Local $Password = ""

Local $Database = ""

Local $MySQLServerName = ""

; 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

Problem :

How to view image from $NameImage ?????



Link to comment
Share on other sites

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...