I'm late I know but thanks man! I can't say I fully understand everything and it'll be confusing for a while... but I honestly do not know how you could simplify that if you tried. Much easier to understand when you visually show it so I'm grateful for the content!
Can you create a table in a SQL database with php commands on a secure page of your own website the same as you would insert data, or can tables only be created through the pHpMyAdmin interface?
due to how languages change, you have to add: `subject`, `content` and `date` instead of just: subject, content and date. those marks are not single quotes there are "tick" marks. those are above the tab button and to the left of the #1 button. i've never used them before and when i first had to use them it was a pain in the butt to find out the problem.
Can you please create auto increments for your videos? Great material... it's been awhile since I've done this and it's a great refresher! If you could do a sample contact form and a whole video of creating the table with user specific logins so that security is higher and follow through to how that is written in the php code that would be great as well. Thank you!
Fantastic videos, very clear and understandable English, content which I just need to create my own webpage for school assignment. I wanted to spice things up by using my own server and user/post database. Anyway, I'm going to watch some more of your videos and perhaps even subscribe on patreon, as for YT subscribtion, already did. Good job !
I don't understand the not null How do we make sure it is not empty? in other words which data we can insert to id column? just primary key and auto increment?
Recommendations Yes, it is auto generated, once a row is added the id is automatically put in. Btw the id number is never reused, even if say id 4 is deleted, when another row is entered it will jump to five.
I'm building a multi-language table that includes German and Hindi. When I "SELECT * FROM language", I either get ???? or spades as the output. There is so much useless info on the web, I am wasting too much time on what I know to be a unicode problem. Do you have a fix for this issue: Thanks, Conrad
THE PRO WAY: The professional way to create MySQL databases as well as tables is via the WINDOWS CMD BLACK BOX or WINDOWS POWERSHELL (win 10). The procedure how to connect to the MySQL client (this is the server where your site will run) via CMD is: - first: go to the correct dir: C:\xampp\mysql\bin (where mysql.exe is located) - second: type: .\mysql - root -p (then enter your password. If you don't have a pwrd just type enter) Voilà! Now you are in. To check all your databases type: show databases; For further exploration and examination please check this link: towardsdatascience.com/sql-cheat-sheet-for-interviews-6e5981fa797b
No it is not. There is a dashboard in PhpMyAdmin that allow you to do this easily without coding it. The reason I show how to code it in my lessons is because I want people to learn it thouroughly,
i don't know how a programmer can explaing the things so clear then ever.....Man today you 've made me happy...
I'm late I know but thanks man!
I can't say I fully understand everything and it'll be confusing for a while... but I honestly do not know how you could simplify that if you tried.
Much easier to understand when you visually show it so I'm grateful for the content!
so much thanks. you have made the MySQL and the SQL very easy. God bless you.
Best youtube tutorial guy to walk the planet
i'm simply liking each video in the first 5 seconds, thank you so much for this amazing tutorial! ❤
Can you create a table in a SQL database with php commands on a secure page of your own website the same as you would insert data, or can tables only be created through the pHpMyAdmin interface?
Thank you so much.keep up the good work
The hard way is very ok ;)
due to how languages change, you have to add: `subject`, `content` and `date` instead of just: subject, content and date. those marks are not single quotes there are "tick" marks.
those are above the tab button and to the left of the #1 button. i've never used them before and when i first had to use them it was a pain in the butt to find out the problem.
why is it so important to use those tick marks?
thanks !
Thanks
tysm
Can you please create auto increments for your videos? Great material... it's been awhile since I've done this and it's a great refresher! If you could do a sample contact form and a whole video of creating the table with user specific logins so that security is higher and follow through to how that is written in the php code that would be great as well. Thank you!
Thank you for your nice videos. I love that you are explaining coding so easy.
Great stuff! Remarkable.
Thank you !! You are the best teacher !! :D
Fantastic videos, very clear and understandable English, content which I just need to create my own webpage for school assignment. I wanted to spice things up by using my own server and user/post database. Anyway, I'm going to watch some more of your videos and perhaps even subscribe on patreon, as for YT subscribtion, already did. Good job !
ALWAYS GREAT DEMONSTRATION
its showing error as a symbol name was expected (near )
Explanation is gud and candid
I wanted to know is there a Pagination for Excell sheet Data
Thank you So much Danial
不错不错. 期待更深入的tutorial
thanks very much.
Best tutorial 2020
Still the best!
Lol I'm kinda late I just watched your video about creating a comment box. You said I should watch your videos about creating tables and database..
Very nice tutos, thank you. I thought that Varchar only accepted up to 250 characteres. thank for the info.
thanks alot
best teacher ı have ever seen, thank you so much, is there any way to support you but like and comment :) ?
Helpful
Hi. Wouldn't it be better to use TIMESTAMP instead of DATETIME? Thanks.
great video
Does primary key and auto increment needs to be capitalised?
No, but it is a good practice to capitalised
you are amazing
Can this all be done INSIDE the php files? Without ever having to go into PHPMyAdmin?
Hi! How do you restrict the length of a phone number to only 10 intergers and set a minimum number and maximum number of characters for your password
for some reason on the middle of the screen its displaying :
ERROR IN PROCESSING POST
ERROR CODE 200
ERROR TEXT OK
Thank you so much!!!
I don't understand the not null
How do we make sure it is not empty?
in other words which data we can insert to id column? just primary key and auto increment?
Recommendations Yes, it is auto generated, once a row is added the id is automatically put in. Btw the id number is never reused, even if say id 4 is deleted, when another row is entered it will jump to five.
Watch "thenewboston" channel for more information. It will help you a lot.
i probably still use the easy way but now i atleast understand what the things mean which you should know.
And now they've got the error syntax identifier! Cool! :))). Merci! Vraiment.
How are you saving in this app?
10:30 you will see the full code
How can I create a table using PHP code in my php editor
Warning: #1681 Integer display width is deprecated and will be removed in a future release.
Why am I getting a warning pl rply....(using ammps)
How did you create User table? :/
there is no go option in sql tab...there is nothing inside sql tab..only a text editor
not to worry...working fine in firefox...but not on latest version of chrome....learning well in firefox
I am expecting screen reader speech also but there is not please try to using screen reader to make video
your voice looks like that of Mark Zuckerberg LOL
Do you mean "sounds like", beacause otherwise…
For some reason, I can't copy and save. Doesn't anyone know why?
I'm building a multi-language table that includes German and Hindi. When I "SELECT * FROM language", I either get ???? or spades as the output. There is so much useless info on the web, I am wasting too much time on what I know to be a unicode problem. Do you have a fix for this issue: Thanks, Conrad
0:25
THE PRO WAY:
The professional way to create MySQL databases as well as tables is via the WINDOWS CMD BLACK BOX or WINDOWS POWERSHELL (win 10).
The procedure how to connect to the MySQL client (this is the server where your site will run) via CMD is:
- first: go to the correct dir: C:\xampp\mysql\bin (where mysql.exe is located)
- second: type: .\mysql - root -p (then enter your password. If you don't have a pwrd just type enter)
Voilà! Now you are in.
To check all your databases type: show databases;
For further exploration and examination please check this link: towardsdatascience.com/sql-cheat-sheet-for-interviews-6e5981fa797b
Why do you need to make a table the hard why?
Jelmer #TeamWitteGinger Because later you will need to know how to code the tables and data once we start mixing it with php.
Thanks, but it is not necessary to make the database with SQL?
No it is not. There is a dashboard in PhpMyAdmin that allow you to do this easily without coding it. The reason I show how to code it in my lessons is because I want people to learn it thouroughly,
I asked for the password of Dani948a a couple episodes ago thanks for the password 😁😁😁😁
Remember to not end your file name with .html and put .php instead. I did this and wasted 30 minutes.
You talk a little too fast and your accent makes it hard to understand. But I appreciate and thankful to your tutorials.
i wish he used 69 instead of 11 ...