Thank you very much, greetings from Brazil. Your class cleared up doubts I had months of and countless attempts to complete. It was simple, practical and objective. Unfortunately, the links to the codes no longer exist, but this is good because it forces us to do it step by step. May God bless and protect you.
I am so thankful to you for giving the source code. Many people have uploaded the videos but there is no source code like this. I am a slow learner and I need this kind of source file so I can easily follow and do this by myself. Thank you sir. I am subscribing to your channel right now. Blessings.
I have a work project too. It's about a crud list of users (name, email, password, department, datetime) and departments (name, description, datetime). I'm so confused, please help, any good tutorial videos? (PHP and MySQL)
Thog I got it to work - I didn’t use that method. Of course I’m sure the context of our applications where slightly different (: something that worked for you in your context might not always work in the instance of my program, which is understandable. Much success to you
Hi, I am a novice. I got created a database with four tables and a query in Phpmyadmin. I wish to display it in the browser. Your tutorial seems helpful to me. Please let me know how to get the black screen window to type the html code? I could not figure out in the PHPMyAdmin window. Thank you.
hey great video for whatever reason the actual values from my table arent displaying. the html table headers show and ive tested my php installation and that is working too. im wondering if somehow mysql isn't connecting properly but its not displaying a connection error at all any ideas? thanks
I managed to get it to work but with regard to doing a responsive table, I added overflow-x:auto; but this only works for some tables and not all. Should it work for all the tables?
God i do not know what I am doing.. copied this code but im unsure how to link it to my mysql database/ table that i am trying to import, have a university in deadline in the morning. Any help would be appreciated
i have a row for messages, so, if i write a long message, it creates one long line, and i have to scroll to read it. how can i limit the words to break at some point? i tried "word-wrap:break-word;" and "table-layout: fixed;" and it works but it creates long white spaces in each row
@@CodeAndCourse i.imgur.com/bsJmUKL.jpg Hi, as you can see, the message section is really long and i have to scroll horizontally to read the whole message, i want the text to break the line automatically
Hey, I don't know if you're still active but I have a question. Is there a way to display data on the webpage live from the database? Preferably without refreshing the page? Thanks
Thank you very much. I'm not going to lie, but I had a little trouble understanding your accent, but I still got the gist. Thank you for being efficient and to the point.
great!!! how to to that not just with table "login" ? maybe i have another table to show in html, just fill in next select-option? but really great video
Why do you need to add dot before and after the variable because i thought you only do this if you are joining to something else.. I also guess that because you open the table outside the while loop.. you need to closed it after the while loop?
I appreciate your quick reply! When should I use a dot versus a comma? For the following codes, should I use a dot or comma? echo' Category',htmlspecialchars($row['category']),'
Sub Category',htmlspecialchars($row2['sub_category']),'
Creator',htmlspecialchars($row['user_uid']),'
Date Created',htmlspecialchars($row['date_created']),' '; I thought a dot is used to join things?
Make sure the table name in mysql database is in uppercase or in lowercase. Because you are selecting with lower case but in row[] you are using uppercase
hey there! I had an error, php echoed "0 result". I managed to find that I called the table: table1-a. The troubl ewas, that I had there a "-" sign, and php could not read it. After changing the name to table1a, the error has gone. Thx for a great video ;-)
localhost is a keyword referring to your local machine where you are working on when you host the database on the pc your running the php code on (for example over XAMPP) you can use localhost or the IP 127.0.0.1 when you want to connect to a database that is hosted on another server on the web you have to replace localhost with the appropriate server IP. Also you need to replace the username ("root" in this example) and password with the one provided by the server provider
Hi, is there a way of using php and MySQL databases without having to learn all the code with a more "visual way", like you would do HTML with a CMS such as wordpress? I'm trying to get a proof of work with a concept, but I'd like to not get into too much code learning because it takes a lot of time (I can do it but i'd like a faster way just to try something out)
no codesolutions seem to be rubbish with table / data base problems but you can use table2sheets to connect a google sheet to a nice looking table for a poc
thank you for this good tutorial , i have a problem i m using a template from web the table d'ont show me result but print my code as string ... i try to make my code external in new php file the table its working and print my data from data base !! can you help me please
Sir please bataye please kaise connect kare php se MySQL ko maine bhot try Kiya lakin nahi horaha db name or table name direct put Kiya tha Maine nahi ho raha hai
Subscribed! Do make more videos :) More tutorial on web development or android would be nice. Also, thank you for providing the source code. You deserve more subscribers!
Hi, great video! I have followed every step and it has worked ALMOST perfectly; the column names or headings as you call them aren't appearing. I can't figure out why. Have you any idea why it could be?
look through a code and figure it out, for a table, a code is from where to where copy that then pastes it just after the end of the first table then you got two table
Hi, it is possible to display the data of the database in the terms of the input in an input field (not a single entry but can go up to 20 fields), my vision of that is a table with multiple entries and an exit next to the one that shows the value each time ?
Ask your question in our new forum forum.codeandcourse.com/viewforum.php?f=4
Great video!! Wish everyone's was as straight forward and concise as yours!
thank u jazakallah
That had to be the simplest most efficient video on PHP that i've EVER seen. Much appreciated!
Most of stackoverflow "solves" are stupid and very hard to understand. This video guide is the one which helped me A LOT! Thank you so much!
Simple, direct, and no unnecessary stuffs. Thank you very much, mate!
I never tried your tutorials but I will based on the comments that's why you got me, I already subscribe
Thank you very much, greetings from Brazil.
Your class cleared up doubts I had months of and countless attempts to complete. It was simple, practical and objective.
Unfortunately, the links to the codes no longer exist, but this is good because it forces us to do it step by step.
May God bless and protect you.
I don't have words man !!!! You just saved me from my EXTRA STRICT professor 😭❤ thank you so much !!!!!!!!!!
Honestly I must confess, this is so so good. Like where has this channel been.
So straight forward.
Thanks sir 👍👍👍
welcome
Perfect For PHP Lovers !
Thank you very much. I learned lots of things
You are welcome!
Software Engineering to its simplest form.... Excellent work and thanks for sharing.
it works perfectly, you sir are a scholar and a gentleman, a sub from me
Good starting point for getting data using PHP. Thanks.
Straight to the point, no bullshit. Thank you so much bro!!
I am so thankful to you for giving the source code. Many people have uploaded the videos but there is no source code like this. I am a slow learner and I need this kind of source file so I can easily follow and do this by myself. Thank you sir. I am subscribing to your channel right now. Blessings.
Thank you so much for this comment, your comment made by day
After two days I found this gem, thank you!
OMG THANK YOU MAAAAAN, you helped me to write my project work with this tutorial!!!!!!!!!
I have a work project too. It's about a crud list of users (name, email, password, department, datetime) and departments (name, description, datetime). I'm so confused, please help, any good tutorial videos? (PHP and MySQL)
diky bro, bez ucit na nasi skolu
2021 and still the best video!
thank you :)
I have been searching EVERYWHERE for a video like this, thank you so much!
U saved me!!🙂....keep uploading such videos
I have this type of error 👉Trying to get property 'num_rows' of non- object .
Is there any solutions
same here...
saaaameeeeeeee
This is the kind of videos everyone needs... Simple and direct... like and subscribe!!!...
Hello i have a question, writing passwords on the html file couldn't be a security problem?
Yes, that may be a security problem
You are THE MAN 💪🏋️♂️
Thank you
hi, can i check whether if you have a guide for insert , delete update tutorial?
new subscriber here! God bless bro! Thank youu!
how did u directly executed that php code in web browser instead of changing the path of php file to local host?
hi, i need particular row to display like a form page ....please tell what are function are needed for that
Notice: Trying to get property 'num_rows' of non-object Help please
i believe it should be if(mysqli_num_rows($result) >0) { }
@@thog6007 That doesn't seem to work.
@@baref0ot455 it worked for my website 🤷♂️
Thog I got it to work - I didn’t use that method. Of course I’m sure the context of our applications where slightly different (: something that worked for you in your context might not always work in the instance of my program, which is understandable. Much success to you
@@thog6007 not working either , anyone got any other codes?? I'm a biginner pls help
Thank YOU very much bro. You helped me to complete my First project.
Glad to hear that
Hi, I am a novice. I got created a database with four tables and a query in Phpmyadmin. I wish to display it in the browser. Your tutorial seems helpful to me. Please let me know how to get the black screen window to type the html code? I could not figure out in the PHPMyAdmin window. Thank you.
Do you mean by Sublime Text
@@CodeAndCourse Thank you , I downloaded.
Thank you bhai!, Love from USA!
hey great video for whatever reason the actual values from my table arent displaying. the html table headers show and ive tested my php installation and that is working too. im wondering if somehow mysql isn't connecting properly but its not displaying a connection error at all any ideas? thanks
Thank you so much !! You're a life saver my guy 😭
No problem 👍
short and simple🙏thank you brother.
You are welcome
Thank you so much. It helped me much.
I managed to get it to work but with regard to doing a responsive table, I added overflow-x:auto; but this only works for some tables and not all. Should it work for all the tables?
is there a way to display a specific row by id input?
Thank you so much I used ur code....am a fresher..thanks dear
You are welcome 😊
Very helpful video🎥📹
Thanks
I have a question if i am required to use trigger in my sql is it allowed in this ??
God i do not know what I am doing.. copied this code but im unsure how to link it to my mysql database/ table that i am trying to import, have a university in deadline in the morning. Any help would be appreciated
This was awesome but I get error at line 16, Can you please tell why?
is num_rows a built in function? i didnt see you create it?
Yes, it is
Thanks a lot.
Superb Video 🌟
Most welcome 😊
Will this code work for older version of xampp?? Because mine is 32 bit system!!
I want to get some input (let contact no.) from user and based on that value display only associated row from database
This one works. even the query also works thank you buddy
i have a row for messages, so, if i write a long message, it creates one long line, and i have to scroll to read it. how can i limit the words to break at some point? i tried "word-wrap:break-word;" and "table-layout: fixed;" and it works but it creates long white spaces in each row
Can you send me a screenshot of
what is your expected output?
What problem you are facing?
@@CodeAndCourse
i.imgur.com/bsJmUKL.jpg
Hi, as you can see, the message section is really long and i have to scroll horizontally to read the whole message, i want the text to break the line automatically
Check this out www.w3schools.com/cssref/css3_pr_overflow-x.asp
this may helpful for you.
Hey, I don't know if you're still active but I have a question. Is there a way to display data on the webpage live from the database? Preferably without refreshing the page? Thanks
did u find any?
Thank you! After hours of searching, I found this amazing video!
Hi, I need some help.
Can I do this using a div structure?
If the answer is yes, do you have any video in your channel about it or a link?
Thanks
Thank goodness for the closed captions. Not a single comment on the unintelligibility of the accent?
facing an array to string conversion error. I have an address column in my table
Thank you very much. I'm not going to lie, but I had a little trouble understanding your accent, but I still got the gist.
Thank you for being efficient and to the point.
How to run the php code? Is the db file and php file to be on the same folder????? Pls repyyyyyy
Hi! Do you know how to include “edit, add, delete” functions on the webpage to allow updating of data in the database ?
Need to use php and define functions
Then call
thank you so much ,it is great video,in case of adding email field how can I link it to a Gmail when showing the table???
Thanks a lot... Got exactly what I wanted....
Most welcome 😊
You guys are the best!!!!! Thank you
Im getting an error "Trying to get property 'num_rows' of non-object" how can i solve this?
great!!! how to to that not just with table "login" ? maybe i have another table to show in html, just fill in next select-option?
but really great video
Where should I put the php file so it can be seen by my localhost? i dont know and understand
Why do you need to add dot before and after the variable because i thought you only do this if you are joining to something else..
I also guess that because you open the table outside the while loop.. you need to closed it after the while loop?
dot help to separate string and variable
yes table is close after a while loop is finish
I appreciate your quick reply! When should I use a dot versus a comma? For the following codes, should I use a dot or comma?
echo'
Category',htmlspecialchars($row['category']),'
Sub Category',htmlspecialchars($row2['sub_category']),'
Creator',htmlspecialchars($row['user_uid']),'
Date Created',htmlspecialchars($row['date_created']),'
';
I thought a dot is used to join things?
i haven't use comma yet but if it is work for you then that was fine
maybe this will help you www.w3schools.com/php/php_echo_print.asp
I have a problem Notice: Trying to get property of non-object on line 36, if ($result->num_rows > 0) {, help me? pls
Paste your code here
is the same code
i've just copy and paste
Table with database
table {
border-collapse: collapse;
width: 100%;
color: #588c7e;
font-family: monospace;
font-size: 25px;
text-align: left;
}
th {
background-color: #588c7e;
color: white;
}
tr:nth-child(even) {background-color: #f2f2f2}
Id
Administradoras
Credito
Make sure the table name in mysql database is in uppercase or in lowercase. Because you are selecting with lower case but in row[] you are using uppercase
Search Results
i managed to fix it thank you bro :)
@@jamesyan2016 how? please help i have same problem
Thank you very much 💞.
Please add a search options in this php
I try to add but i found err in results.
Please help me ..
Mine is unable to connect with the database ...and it is giving a warning:
Attempt to read property "num_row" on book in the file .☹️... what to do???
The first data entered in the table is not showing in the output page. Please help!!
simple and clean easy to understand
hey there! I had an error, php echoed "0 result". I managed to find that I called the table: table1-a.
The troubl ewas, that I had there a "-" sign, and php could not read it. After changing the name to table1a, the error has gone. Thx for a great video ;-)
How can i achieve this with my database in my GOOGLE CLOUD INSTANCE? local host doesn't seem to work
Interesting but I haven't tried this.
ok thank you :)
localhost is a keyword referring to your local machine where you are working on when you host the database on the pc your running the php code on (for example over XAMPP) you can use localhost or the IP 127.0.0.1 when you want to connect to a database that is hosted on another server on the web you have to replace localhost with the appropriate server IP. Also you need to replace the username ("root" in this example) and password with the one provided by the server provider
i followed the ur pervious code and succesly connected the databse with a images also. kindly help to display the same on webpage
Hello! How can I turn over the table? I want to put the new datas on the top! How can I do it?
For that you have to watch my MySQL tutorial video
@@CodeAndCourse thank you! I solved it by the way with ordering by date!
brother .. i have value of td in an array can help me to create table with it ?
in php
It worked bro thanks🤟
Enjoy
PERFECT Thanks. How do you code it to show only a like 5 or 10 rows?
limit 5 or limit 10 at end of sql statement.
sorry its a late answer tho.
Can you explain for me ? why we need dot operator in td tags
Hi, is there a way of using php and MySQL databases without having to learn all the code with a more "visual way", like you would do HTML with a CMS such as wordpress? I'm trying to get a proof of work with a concept, but I'd like to not get into too much code learning because it takes a lot of time (I can do it but i'd like a faster way just to try something out)
Found it yet?
no codesolutions seem to be rubbish with table / data base problems but you can use table2sheets to connect a google sheet to a nice looking table for a poc
Thank you so much for this video! It has helped me massively and I greatly appreciate how clear and easy to follow it was!
Glad to hear that
when is english version coming out?
Thanks a lot, It worked!
Great!
thank you for this good tutorial , i have a problem i m using a template from web the table d'ont show me result but print my code as string ... i try to make my code external in new php file the table its working and print my data from data base !! can you help me please
Sir please bataye please kaise connect kare php se MySQL ko maine bhot try Kiya lakin nahi horaha db name or table name direct put Kiya tha Maine nahi ho raha hai
Subscribed! Do make more videos :)
More tutorial on web development or android would be nice.
Also, thank you for providing the source code. You deserve more subscribers!
Thank you so much for your support
very useful, straight to the point! thanks man
Trying to get property of non-object ....how i solve this error
please guide me
add the name of the database in this part $conn = new mysqli_connect("localhost", "root", " ", databasename");
hello man, can I ask? I just started out php and stumbles to this amazing quick video. But i can't seem to activate
If we write an HTML code inside quotation of HTML then we get no colour.
ah i see, when i follow your code it still works all the way through. thanks man
do you have any video how to attach simple templates we download to our table?
Hi, great video! I have followed every step and it has worked ALMOST perfectly; the column names or headings as you call them aren't appearing. I can't figure out why. Have you any idea why it could be?
See carefully the video. In the initial, the column names/headings are written manually as ID ... and so on and then , after that the
Do you realize how amazing you are? :-) Thanks very much!
Thank you bro it worked 2020👍👍❤❤❤
Simple codes 100% efficient working thank fella🤗
👏
🤝
🤜🤛
Enjoy
Sir i want to display "No data found" if there is no data in the sql table ... How can I do this ?
Thanks dear
Pleas how select card images with information
I can't figure out how to add 3 separate tables here... Instead of having one table, how would I do this? Can I share with you my code here?
look through a code
and figure it out, for a table, a code is from where to where
copy that then pastes it just after the end of the first table
then you got two table
Excellent sir
Do you have any suggestion for a new video?
Full web side furnt and backend login password also my squel in hindi
Hi, it is possible to display the data of the database in the terms of the input in an input field (not a single entry but can go up to 20 fields), my vision of that is a table with multiple entries and an exit next to the one that shows the value each time ?
Thank you so much, its working.........God bless you !!!!!!!!!!!!!!!!!!!!!!!!
saved my life hoenstly. thank you
Sir i am not getting result in proper way it showing data above and then my column name