Пікірлер
@yashdeepsahni
@yashdeepsahni 6 күн бұрын
Can we do this with MySQL ? Saving here and then work on that
@plus2net1
@plus2net1 5 күн бұрын
the code to work on MySQL is same, only the connection string changes. In colab platform you can't get MySQL database however you can take one cloud account in google and work on MySQL. OR use the same code in your local machine with MySQL and use the same code. Only change required in connection string. Let us know if you need any thing here.
@MotasemG
@MotasemG 11 күн бұрын
Thank you bro! 🙏🏽
@plus2net1
@plus2net1 10 күн бұрын
Glad to know you like it, thanks.
@markozaror3532
@markozaror3532 13 күн бұрын
Great tutorial bro
@plus2net1
@plus2net1 13 күн бұрын
Glad you liked it
@digitalmachine0101
@digitalmachine0101 14 күн бұрын
Good job
@plus2net1
@plus2net1 14 күн бұрын
Thanks
@patrickemerysevor7410
@patrickemerysevor7410 23 күн бұрын
I will be pleased if the query is shown whilst explaining
@plus2net1
@plus2net1 22 күн бұрын
yes, that is a good idea, now few more are already uploaded, the next group is on MySQL and we will include this . Thanks.
@plus2net1
@plus2net1 25 күн бұрын
The first link at description will give you the sample code and link to other tutorials, please let us know if any issue is there
@patrickemerysevor7410
@patrickemerysevor7410 25 күн бұрын
No code to show?
@plus2net1
@plus2net1 25 күн бұрын
Link is at description
@wanabuddd001
@wanabuddd001 27 күн бұрын
u have any idea how to add column and get the values from sum of other column in mysql sir?
@plus2net1
@plus2net1 26 күн бұрын
This should work SELECT id, name, class,( social + science + math) AS total FROM student_sum Full details are here . www.plus2net.com/sql_tutorial/sql_sum-multiple.php
@mazharsinging7215
@mazharsinging7215 Ай бұрын
Good 👍
@plus2net1
@plus2net1 Ай бұрын
thanks
@CanalesShame
@CanalesShame Ай бұрын
helpful!
@plus2net1
@plus2net1 Ай бұрын
thanks,
@johnpeterson4635
@johnpeterson4635 Ай бұрын
Thanks a lot! After 3 days I achieved
@plus2net1
@plus2net1 Ай бұрын
Glad to know that, thanks.
@Hafiz07-e5i
@Hafiz07-e5i Ай бұрын
Apakah kamu punya telegram?
@Hafiz07-e5i
@Hafiz07-e5i Ай бұрын
Buatkan saya request text url
@tomarneeesguerra8125
@tomarneeesguerra8125 Ай бұрын
Thank you sir! lets gooo
@KaranSingh-mt8wj
@KaranSingh-mt8wj Ай бұрын
thankyou sir!!
@rahulnahar5587
@rahulnahar5587 Ай бұрын
One more help: Could you please make a video regarding: I want to print a complete application form. Data taken from multiple pages and segregate in one page by clicking print button as well a side a save as pdf button. Student details print application form will be the best example. Because many details like name, father, date of birth, date of admission, parent contact details, upload photo, automatic school stamp seal over the cross photo, email, student contact number, address, district, state, country, pin code etc things need in one page. Please
@plus2net1
@plus2net1 Ай бұрын
sure, working on it.
@plus2net1
@plus2net1 Ай бұрын
kzbin.info/www/bejne/qZmkYqpuYq6LiKM Source code here. www.plus2net.com/python/tkinter-pdf.php
@rahulnahar5587
@rahulnahar5587 Ай бұрын
Hindi nahi aati kya apko?
@plus2net1
@plus2net1 Ай бұрын
Achaa nahi Ata, Bahutu english words a jata hein boleneka smaye.
@mohelha8832
@mohelha8832 Ай бұрын
Hi I need to help how to convert flet python to apk
@plus2net1
@plus2net1 Ай бұрын
Sorry, I have no idea on this.
@jamesrushton3368
@jamesrushton3368 Ай бұрын
You are so great, this is exactly what i need
@plus2net1
@plus2net1 Ай бұрын
Glad to know that , thanks
@jamesrushton3368
@jamesrushton3368 Ай бұрын
great video
@plus2net1
@plus2net1 Ай бұрын
thanks
@supunsameera2654
@supunsameera2654 Ай бұрын
Sir. Its working. But i export as stand along exe. Its not working. The widget doesnt preview. Plz help
@plus2net1
@plus2net1 Ай бұрын
it depends on how it loads the dependant libraries, try with a simple one first without extra libraries.
@kevinwright7931
@kevinwright7931 Ай бұрын
To have the checkbox not selected you can also use the command deselect(), i.e. c1.deselect(). Thanks, with this video I learned how disable a checkbutton.
@plus2net1
@plus2net1 Ай бұрын
Glad to know that, thanks
@krishnamurari88
@krishnamurari88 2 ай бұрын
Sir please make video on python library #dis_bg_remove# for background remove I try many times but code not working please help me sir
@plus2net1
@plus2net1 2 ай бұрын
I just used rembg with PIL and it worked, Just pip install rembg from rembg import remove from PIL import Image input_path = 'D:\\testing\\images\\yanam-raj.png' output_path = 'D:\\testing\\images\\out1.png' input = Image.open(input_path) output = remove(input) output.save(output_path)
@CSINP492
@CSINP492 2 ай бұрын
<label for="where do you eat chicken biryani" style="font-family: Cambria, Cochin, Georgia, Times, 'Times New Roman', serif; font-size:130%;"><b>WHERE DO YOU EAT CHICKEN BIRYANI:</b></label> <input name="where do you eat chicken biryani" list="Select a restaurent u prefer to eat" placeholder="start typing..." size="10"> <datalist id="Select a restaurent u prefer to eat"> <option value="Apple Hotel"> <option value="Orange Restaurant"> <option value="Grapes Grand"> <option value="Water Melon Dabha"> <option value="Guava Hotel"> </datalist> i written this code but datalist items are not coming while the time i click on triangle
@barikam2m891
@barikam2m891 2 ай бұрын
thank you very much for these tutotrials good luck..
@plus2net1
@plus2net1 2 ай бұрын
Glad you like them!
@VaishnaviMahadik-c5g
@VaishnaviMahadik-c5g 2 ай бұрын
Does ReportLab is paid or free library?
@plus2net1
@plus2net1 2 ай бұрын
Both are there, ReportLab Plus is the commercial tool. ReportLab PDF toolkit is the Open source ( we are using for learning and developing ) , when we install like this pip install reportlab We use Open source one only.
@ElyouAhmed
@ElyouAhmed 2 ай бұрын
Thanks that help me
@plus2net1
@plus2net1 2 ай бұрын
Glad to know that , thanks
@sam_100ali_10
@sam_100ali_10 2 ай бұрын
I Add New Font but i am get this error msg File "C:\Users\Samim\AppData\Local\Programs\Python\Python312\Lib\site-packages eportlab\pdfbase\pdfmetrics.py", line 638, in getTypeFace return _typefaces[faceName] ~~~~~~~~~~^^^^^^^^^^ KeyError: 'Arabic'
@plus2net1
@plus2net1 2 ай бұрын
Check these lines , in first line you should have correct file name inside quotes ( 'Arabic.ttf') here the file name is changed. custom_font=os.path.join(folder_font,'Arabic.ttf') # Path to the font file c_font=TTFont('Arabic',custom_font) pdfmetrics.registerFont(c_font) In second line the keyword is registered as 'Arabic' , this should be used like this c.setFont('Arabic', 16) # Note the way 'Arabic' is used.
@sam_100ali_10
@sam_100ali_10 2 ай бұрын
Thank 🤍🤍
@designgoat2023
@designgoat2023 2 ай бұрын
My guy, THANK YOU! You're a hero. 🙌
@plus2net1
@plus2net1 2 ай бұрын
Glad to know that, thanks.
@sam_100ali_10
@sam_100ali_10 2 ай бұрын
Best Teacher
@plus2net1
@plus2net1 2 ай бұрын
Thanks
@sam_100ali_10
@sam_100ali_10 2 ай бұрын
Why are letters replaced with black squares after saving in Arabic?
@plus2net1
@plus2net1 2 ай бұрын
It is the font support that is missing, try to place the Arabic font in font directory and register the same. I will post a detail video on this .
@sam_100ali_10
@sam_100ali_10 2 ай бұрын
@@plus2net1 thanks
@plus2net1
@plus2net1 2 ай бұрын
kzbin.info/www/bejne/iKabd5WEacyNd9E Download the source code here . www.plus2net.com/python/pdf-fonts.php
@MohamedMarzok-y8z
@MohamedMarzok-y8z 2 ай бұрын
best tutorial for pdf from python
@plus2net1
@plus2net1 2 ай бұрын
Glad to know that, thanks
@MohamedMarzok-y8z
@MohamedMarzok-y8z 2 ай бұрын
the tutorial is so helpful
@plus2net1
@plus2net1 2 ай бұрын
Gald to know that, thanks
@mat9813004
@mat9813004 2 ай бұрын
Thankyou, derivations of some of this code here just made my (swearing) assignment work. I can now build off this. (Another swearword).
@plus2net1
@plus2net1 2 ай бұрын
Glad to know that, thanks .
@plus2net1
@plus2net1 2 ай бұрын
Please use bottomup=1 so coordinates to start from bottom, or use 0 to start from top
@raymundofelipeolvera5594
@raymundofelipeolvera5594 2 ай бұрын
Great vide, helped me a lot, only one question, how would you get mixed values as object type ( int and str (100054, 01-0157-52-1) ?
@plus2net1
@plus2net1 2 ай бұрын
Inside the search function all conditions can be combined, by using AND or OR combination. Check the code here . www.plus2net.com/python/tkinter-df-search.php See the code inside the function def my_search(): Inside this based on the columns you have , search can be applied with combinations. You need to extend this line . df2 = df[(str1)] # combine all conditions using | operator
@qamarsiddique794
@qamarsiddique794 2 ай бұрын
Bhi Range(0,0) ka Kya mtlab hy
@plus2net1
@plus2net1 2 ай бұрын
Start value is 0 and end value =0
@gayu-hr6mr
@gayu-hr6mr 2 ай бұрын
thank you sir
@laurolagman3268
@laurolagman3268 2 ай бұрын
sir, how can we disabled the delete row and delete column when we right clicked the mouse. Thank you.
@plus2net1
@plus2net1 2 ай бұрын
www.plus2net.com/python/tkinter-ttkbootstrap-table.php Here check the image, you have option to delete row when the row is selected. Similarly the column can be selected and deleted. Since this is only displaying of records so disable options is not there, If you want more functionality then it is better to go for standard Treeview.
@isidorbonge
@isidorbonge 2 ай бұрын
Great tutorials. How do I put the checkbox on the right instead on the left?
@plus2net1
@plus2net1 2 ай бұрын
There are different ways, simple way is to keep checkbox in right cell of a table so they will be aligned to left in right cell. <tr><td>Text here </td><td>Checkbox here</td></tr> Or use CSS like this. <span id=abc>Text here</span> Checkbox here #abc { display: inline-block; width: 180px; } Try line this so text part will be inside a blck of fixed witdth , then checkbox will go towards right. All depends on how your page layout is and how to integrate with them.
@LeCitoyenX
@LeCitoyenX 3 ай бұрын
What s difference between table and grid in reportlab
@plus2net1
@plus2net1 3 ай бұрын
It is here available ( at the end of the page) . www.plus2net.com/python/pdf-grid.php If you have long structured data then go for table.
@LeCitoyenX
@LeCitoyenX 3 ай бұрын
@@plus2net1 thanks very much. I am from north Africa arabic. What's about RTL fonts in reportlab.i saw your videos so long very interesting and I had use it in my small projects. I use lot of Microsoft excel with python and export pdf. Excuse me for my bad English. Thanks
@plus2net1
@plus2net1 3 ай бұрын
@@LeCitoyenX Just check the reply I gave here. kzbin.info/www/bejne/jGXWZq2ZnJWthdUsi=SHUxPJvjdkuIzomw I will work on that and post.
@plus2net1
@plus2net1 2 ай бұрын
@@LeCitoyenX kzbin.info/www/bejne/iKabd5WEacyNd9E Download the source code here . www.plus2net.com/python/pdf-fonts.php
@MizuHikkari
@MizuHikkari 3 ай бұрын
You saved me 🙏😅❤
@plus2net1
@plus2net1 3 ай бұрын
Thanks
@BuntaBiglangue
@BuntaBiglangue 3 ай бұрын
Thanks. How can write arabic عربي fonts in reportla b
@plus2net1
@plus2net1 3 ай бұрын
First download an Arabic TTF font. Then use pdfmetrics.registerFont() to add the font. I will post some detail tutorial on this.
@plus2net1
@plus2net1 2 ай бұрын
kzbin.info/www/bejne/iKabd5WEacyNd9E Download the source code here . www.plus2net.com/python/pdf-fonts.php
@khushboo-eq9yl
@khushboo-eq9yl 3 ай бұрын
Please help one
@plus2net1
@plus2net1 3 ай бұрын
Sure, what is the issue ?
@khushboo-eq9yl
@khushboo-eq9yl 3 ай бұрын
@@plus2net1 sir me kisi site pe readonly attribute ko hatana chahta hoo koi aisa attributes do Jo usme add kar doo fir ham jo chahe bhar sake submit karne ke bad bhi vahi aaye jo ham bhare
@khushboo-eq9yl
@khushboo-eq9yl 3 ай бұрын
@@plus2net1 sir kya fees he aapkibo le lena
@plus2net1
@plus2net1 3 ай бұрын
@@khushboo-eq9yl What I understand is you want to retain the data in the input. This will happen by default. Submit action will read and take the data from the input box but you have to separately write a code to remove the text or make it blank.
@plus2net1
@plus2net1 3 ай бұрын
@@khushboo-eq9yl Not clear , what is your requirment ?
@khushboo-eq9yl
@khushboo-eq9yl 3 ай бұрын
Hii
@baluandhavarapu
@baluandhavarapu 3 ай бұрын
Use Google Drive integration for Microsoft File Explorer
@deequi77
@deequi77 3 ай бұрын
Should we put break after the for loop?
@plus2net1
@plus2net1 3 ай бұрын
No, not required.
@MrCat80
@MrCat80 4 ай бұрын
Good video man, I need a way to create 1 text of 2 colors where one of those parts can be dynamic while the other is static that is: Amount: 10 where "Amount" is fixed in black and "10" is red and when an operation is performed, for example, if it is subtracted and it becomes 9 then it remains intact in color red, do you know how to do it? thank you :)
@plus2net1
@plus2net1 4 ай бұрын
Use tag for this, www.plus2net.com/python/tkinter-text.php#tag_add One video I created here . kzbin.info/www/bejne/pnazaoCXarp6hrcsi=STffDs4qbfW5OoHV&t=236 use tag_config() to manage colour based on the logic you fix. Let us know if any issue you are facing .
@digitalmachine0101
@digitalmachine0101 4 ай бұрын
Good information
@plus2net1
@plus2net1 4 ай бұрын
Thanks