Python SQLite Data Entry Form with Tkinter tutorial for beginners - Python GUI project

[@novicetech1]

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.

[@kaduflutist]

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!

[@zettkusanagi6322]

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.

[@AbdolkarimMissaghian]

Tack så mycket. Tydligt och mycket användbart. Lycka till. Thanks so much. Clear and very useful. Good luck.

[@rickyusuf8696]

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.

[@Pattypatpat7122]

Amazing tutorial! I've learnt a lot in such a short period of time

[@MohamedRoudani-q4p]

Iam a newbee, I was looking for this, you nailed it Hala, looking forward to learn more from you, Shukran

[@АлександрБорисенко-ш2в]

Дай бог тебе здоровья God bless you for your video, blyad'

[@jimhess2590]

These videos were very, very helpful. I learned most of everything that I needed to move my project forward. Thanks!!!

[@Foiliagegaming]

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!

[@Frazur]

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

[@codefirstwithhala]

Glad it helped!

[@gregoneill4391]

@@codefirstwithhala is there a possibility of doing a PySimpleGUI version video??

[@jehoshaphatamihere9204]

Thanks very much madam, God bless you, You have made the code very simple to understand you are my python teacher from now onward

[@garymaya1767]

i love you! thank you for the information!

[@Diogene-pl1lq]

Thanks alot Hala, I am improving my skills along your advices and teaching! You are the data's fairy😉

[@fabiomatta1530]

Thank you very much for your work. Love the way you teach.

[@kingmenka2085]

Hala You are amazing keep up the good work

[@zooeymoments8516]

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.

[@julioCesar-qt6wc]

Great tutorial!!!

[@Gareth.W]

Amazing tutorial. Thanks so much for creating this.

[@netreis1]

Perdi algumas horas buscando uma solução para o meu código e neste video ficou esclarecido. Parabéns!

[@AceLozabe-r7e]

I'm so grateful, thank u so much!

[@andresfelipebarrera5110]

Very helpful, finally I could advance in my project, very grateful!!

[@teamup7249]

Nice explanation....I loved the tutorial

[@ziarasuli3102]

This Tutorial is really useful thanks alot.

[@thecubanrelaxshitposting3733]

your videos are sooo great i love it

[@codefirstwithhala]

Thank you so much!

[@2ncielkrommalzeme210]

Your Video with your teaching way is very good thanks İ ant to by a coffe in future.

[@paulsingirok4600]

Thankyou. This was very helpful.

[@perlasaadeh3322]

I'm passing because of you! THANK YOU!

[@codefirstwithhala]

Thank you for your support!

[@deviskalo]

Thanks so much! You really did great work here. I am glad and appreciate your work.

[@fazilelectronics3080]

Thank you so much. I've learned a lot from your video

[@barackuse]

Great Video, what if we wanted to retrieve data from the DB? Will there be video on that?

[@TyphonNeuron]

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.

[@Zak-l7e]

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()

[@ongoing_cake_discussion]

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.

[@sumitkumargupta1720]

Very helpful video. Thanks a lot.

[@Sunilkumar-1564]

thank you so much 👍👍👍👍👍👍

[@infernimus9563]

11:30 why don't you use the executemany method to execute multiple queries?

[@ParadoxCheats]

amazing explanation of everything

[@najibullahrezaee]

very useful tutorials

[@sendog3csendog3c59]

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.

[@eqsciencerayong2678]

thank u. for the best practices.

[@its_code]

😍😍🤩🤩 very helpful 🖤

[@codefirstwithhala]

Glad you think so!

[@its_code]

@@codefirstwithhala 🤗🤩🤩😍

[@vaidheeswaranbharathy87]

Excellent

[@Pythonmailservice]

Thank you!

[@alfiartya23]

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 😄

[@ryder4481]

age = int(user_age_entry.get())

[@vinzenzglenk860]

Great video

[@steamersteamer1003]

I think you are awesome!

[@kapibara2440]

Brilliant tutorial Hala ❤❤❤

[@gregoneill4391]

@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?

[@horsfallprosper5909]

Which text colour editor are you using in your Vs code

[@SuperKevinFS]

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

[@weikang234]

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

[@rzvn111]

Thanks!

[@campfiregames4633]

Thank you

[@codefirstwithhala]

Welcome!

[@autarroy]

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?

[@dmskarunaratne80]

at the end of conn.close() clear data entry form with clear data function??

[@blendid242]

Hi, How change theme color text for sql code plz. I always an orange text :(

[@Rapha_Carpio]

can we put these kind of apps on a html?

[@MohamedShams919]

how can i save the data to excel sheet on sharepoint?

[@2ncielkrommalzeme210]

how can we encrypt our file in sqlite.??????

[@diegovilchesloyola6656]

How can you do an .exe?

[@المثنىزيادطارق]

Using the pyinstaller library

[@sam_100ali_10]

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