Absolutely outstanding tutorial! Thank you so much. I have been away from Python since 2018. I was only ever really interested in doing things with Tkinter and SQLite. When I finally got back to it this year (2023), I was shattered to discover that most of my knowledge was gone (that kinda comes with age). In an effort to review, I stumbled across your videos. I am so grateful to you. I now feel like I am back on my feet again with these technologies. Thank you, thank you, thank you.
Thank you for this series. You go straight to the point and are very clear on instructions. I was able to understand Tkinter Layout thanks to your teaching. I am now checking other of your projects.
Great video. I started following along and I was running into an error with the database where it was saying that a column did not exist. After staring at the code for to long trying to pin down what it was (assuming it was a typo) I called it quits for the day. Today I had the same error for a different column but was able to find the problem and it worked! Thank you!
Jazaaki Allahu khairan for the wonderful video! It was a great refresher for me, and the way you explained it was very easy to follow along and make sense of it.
Brilliant video, just another way of coding: conn = sqlite3.connect('test1.db') c = conn.cursor() c.execute( "CREATE TABLE IF NOT EXISTS Student_Form (Title string, First Name TEXT, Surname TEXT, Age INTEGER, " "Nationality TEXT, Num_courses INTEGER, Num_semesters INTEGER)") c.execute("INSERT INTO Student_Form VALUES (?,?,?,?,?,?,?)", (title, first_name, last_name, age, nationality, num_courses, num_semesters)) conn.commit() conn.close()
I was going to mention the method you spoke about as well. Thanks for adding it and sharing. Def seems a tad easier using the "c.execute" method IMO. However, when you use "conn.commit" you do not need to use "conn.close" as "conn.commit" takes away that requirement. It doesn't hurt, just not needed at that point.
Thanks for the tutorial so far. Can you continue with this data entry form and sqlite3 to show how to delete data from tables or how to export the table data into csv or json formats? Great videos, nice, celar explanations. Thanks again.
@Code First with Hala Hi I am trying to do this with a form for my project but it was with pysimplegui, I can get some success with this but I cant seem to get it to store the values in it. do you have a pysimplegui version of this?
Hi, I would like to say thank you with this video. It really helpful for my project. But I want to ask, when I want to take example user age which is a number/integer. Should I use .get() or convert it into int() that user age entry? because every entry input will always return string value. Thank you 😄
Hi Hala. Nice tutorial. I am an amateur in Python programing, I found your video a voila everything become understandable. Thank. In another topic I think am doing something similar wrong. I got the following message: sqlite3.OperationalError: near "EXIST": syntax error. Hope you can help me.
HI thanks for a great course. I do not know how to connect sqlite (i use subline) and DB browser sqlite could you kindly point me in the right directions there is not much on this aspect of SQLITE thank u
Hello Hala, First of all I would like to thank you for your kind explanation. I'm doing exactly what you did but I get a question mark when creating my .db Could you help me?
![Convert Tkinter Python App to Executable (.Exe) File [pyinstaller]](http://i.ytimg.com/vi/Iv_dECet_oM/mqdefault.jpg)
![Convert Tkinter Python App to Executable (.Exe) File [pyinstaller]](/img/tr.png)
![Python Excel Data Entry Form with Tkinter tutorial for beginners - Python GUI project [openpyxl]](http://i.ytimg.com/vi/fvIThtPt6Nc/mqdefault.jpg)
Absolutely outstanding tutorial! Thank you so much. I have been away from Python since 2018. I was only ever really interested in doing things with Tkinter and SQLite. When I finally got back to it this year (2023), I was shattered to discover that most of my knowledge was gone (that kinda comes with age). In an effort to review, I stumbled across your videos. I am so grateful to you. I now feel like I am back on my feet again with these technologies. Thank you, thank you, thank you.
Thank you for this series. You go straight to the point and are very clear on instructions. I was able to understand Tkinter Layout thanks to your teaching. I am now checking other of your projects.
Thank you, Hala! You're an excellent instructor and coach. I'm so thankful and grateful for your time and expertise. Keep doing this great job!
Iam a newbee, I was looking for this, you nailed it Hala, looking forward to learn more from you, Shukran
Great video. I started following along and I was running into an error with the database where it was saying that a column did not exist. After staring at the code for to long trying to pin down what it was (assuming it was a typo) I called it quits for the day. Today I had the same error for a different column but was able to find the problem and it worked! Thank you!
Tack så mycket. Tydligt och mycket användbart. Lycka till.
Thanks so much. Clear and very useful. Good luck.
Дай бог тебе здоровья
God bless you for your video, blyad'
Totally helpful. I learned a lot.
Could be able to make new video how to retieve, edit and save back to database. It will mean a lot.
Jazaaki Allahu khairan for the wonderful video! It was a great refresher for me, and the way you explained it was very easy to follow along and make sense of it.
Amazing tutorial! I've learnt a lot in such a short period of time
11:30 why don't you use the executemany method to execute multiple queries?
Nice explanation....I loved the tutorial
Hala
You are amazing keep up the good work
i love you! thank you for the information!
Brilliant video, just another way of coding:
conn = sqlite3.connect('test1.db')
c = conn.cursor()
c.execute(
"CREATE TABLE IF NOT EXISTS Student_Form (Title string, First Name TEXT, Surname TEXT, Age INTEGER, "
"Nationality TEXT, Num_courses INTEGER, Num_semesters INTEGER)")
c.execute("INSERT INTO Student_Form VALUES (?,?,?,?,?,?,?)",
(title, first_name, last_name, age, nationality, num_courses, num_semesters))
conn.commit()
conn.close()
I was going to mention the method you spoke about as well. Thanks for adding it and sharing. Def seems a tad easier using the "c.execute" method IMO. However, when you use "conn.commit" you do not need to use "conn.close" as "conn.commit" takes away that requirement. It doesn't hurt, just not needed at that point.
Great Video, what if we wanted to retrieve data from the DB? Will there be video on that?
Great tutorial!!!
This was super helpful. Even though I am using mySQL, the syntax is almost the same. This really help guide me in the right direction
Glad it helped!
@@codefirstwithhala is there a possibility of doing a PySimpleGUI version video??
Which text colour editor are you using in your Vs code
These videos were very, very helpful. I learned most of everything that I needed to move my project forward. Thanks!!!
your videos are sooo great i love it
Thank you so much!
This Tutorial is really useful thanks alot.
at the end of conn.close() clear data entry form with clear data function??
Amazing tutorial. Thanks so much for creating this.
Thank you very much for your work. Love the way you teach.
Perdi algumas horas buscando uma solução para o meu código e neste video ficou esclarecido. Parabéns!
Thanks very much madam, God bless you, You have made the code very simple to understand
you are my python teacher from now onward
I'm so grateful, thank u so much!
Thanks for the tutorial so far. Can you continue with this data entry form and sqlite3 to show how to delete data from tables or how to export the table data into csv or json formats? Great videos, nice, celar explanations. Thanks again.
Thanks alot Hala, I am improving my skills along your advices and teaching!
You are the data's fairy😉
@Code First with Hala Hi I am trying to do this with a form for my project but it was with pysimplegui, I can get some success with this but I cant seem to get it to store the values in it. do you have a pysimplegui version of this?
Hi, I would like to say thank you with this video. It really helpful for my project. But I want to ask, when I want to take example user age which is a number/integer. Should I use .get() or convert it into int() that user age entry? because every entry input will always return string value. Thank you 😄
age = int(user_age_entry.get())
Hello Hala, can i check what are the extensions you use in VS Code for your Python? Mine does not have the same color coding as yours
Your Video with your teaching way is very good thanks İ ant to by a coffe in future.
Very helpful, finally I could advance in my project, very grateful!!
amazing explanation of everything
Thankyou. This was very helpful.
Hi Hala. Nice tutorial. I am an amateur in Python programing, I found your video a voila everything become understandable. Thank. In another topic I think am doing something similar wrong. I got the following message: sqlite3.OperationalError: near "EXIST": syntax error. Hope you can help me.
Excellent
Hi, How change theme color text for sql code plz. I always an orange text :(
can we put these kind of apps on a html?
Brilliant tutorial Hala ❤❤❤
very useful tutorials
Very helpful video. Thanks a lot.
how can we encrypt our file in sqlite.??????
I'm passing because of you! THANK YOU!
Thank you for your support!
how can i save the data to excel sheet on sharepoint?
Thanks so much! You really did great work here. I am glad and appreciate your work.
😍😍🤩🤩 very helpful 🖤
Glad you think so!
@@codefirstwithhala 🤗🤩🤩😍
Great video
thank you so much 👍👍👍👍👍👍
HI thanks for a great course. I do not know how to connect sqlite (i use subline) and DB browser sqlite could you kindly point me in the right directions there is not much on this aspect of SQLITE thank u
Thank you so much. I've learned a lot from your video
thank u. for the best practices.
Hello Hala,
First of all I would like to thank you for your kind explanation.
I'm doing exactly what you did but I get a question mark when creating my .db Could you help me?
I think you are awesome!
Thank you!
How can you do an .exe?
Using the pyinstaller library
Thank you
Welcome!
Thanks!
Why don't you present your content in the language of your country instead of using the English language to publish the content, silly girl