pastisucess Posted November 22, 2011 Share Posted November 22, 2011 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 Link to comment Share on other sites More sharing options...
Spiff59 Posted November 22, 2011 Share Posted November 22, 2011 This seems an unusual approach... Why not keep the images in a directory and just plug the image file or path name into the database? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now