mardi 16 juin 2015

WX.EVT_LISTBOX_DCLICK click for get diffrent information from database

I have a problem when I do click on the listbox, In my program, I did click on the listbox will appear a video and explain about the video. I made a sample in the database are "name_link" which will appear in the listbox. expl1, expl2, expl3. Of each name_link have different information. However, that happens every time I click on one of these name_link, video that appears only Video3 and system never show the explain about video. When I click name_link video1 video2 emerging or always Video3. I am so stuck in this section.

this section during click :

tb4 = wx.StaticText(self, -1, label='explain', pos=(20, 145))
    wx.TextCtrl(self, -1, pos=(80, 145), size=(220, 120))

self.opt = wx.ListBox(pan1, -1, pos=(10, 210), size=(480, 250), style= wx.TE_MULTILINE | wx.BORDER_SUNKEN)

def playFile(self, event):
self.player.Play()

def OnEnter(self, event):
self.opt.SetLabel(self.PatMatch()) 

def PatMatch(self):
con = sqlite3.connect('test.db')    
with con:
    cur = con.cursor()
    for row in cur.execute("Select * From Video"):
        klmt = self.inpt.GetValue()
        if row[1] in klmt.lower():  
            self.opt.Append(row[2])         
           self.player.Load(row[4])
    return self.Bind(wx.EVT_LISTBOX_DCLICK, self.playFile, self.op)

The data base like this :

id  word        name_link   explain     link
--- ------      ----------- ---------   --------

1   python      Video1      test        C:\Users\Ihsan\Downloads\Video1.MP4
2   python      Video2      test1       C:\Users\Ihsan\Downloads\Video2.MP4
3   python      Video3      test2       C:\Users\Ihsan\Downloads\Video3.MP4

Aucun commentaire:

Enregistrer un commentaire