This MySQL PHP tutorial is suitable for beginners as well as advanced MySQL users. In this lesson we mostly cover selecting data from the tables as well as …
Original source
This MySQL PHP tutorial is suitable for beginners as well as advanced MySQL users. In this lesson we mostly cover selecting data from the tables as well as …
Original source
14 responses to “MySQL PHP Tutorial – Select & Display Data From MySQL Tables”
what is the editor you use ?
@Clever Techie. Your tutorial is so much helpful. Now i want the items to appear in a grid form say after 4 items a row should be automatically created which will contain another 4 items and and so on. How can i achieve that? Thanks
cool stuff dude.teching by actually doing wish everybody did exactly this
Hey Clever Techie! Great tutorial and great tutorial series! Your really cover a great deal of detail and make sure the viewer realize where the tricky sections are. And then you clearly explain those tricky sections. Keep up the good work!! Thanks!
Hello,
I have 5 tables in which I define something with id's and have another table in which I combine that id's in a row. I try to select them with the query below but it works properly but gives me only the first row of the table
"SELECT anlasma.anlasmaID, fakulte.fakulteAdi, bolum.bolumAdi, koordinator.koordinatorAdi, ulke.ulkeAdi, universite.uniAdi FROM anlasma, fakulte, bolum, koordinator, ulke, universite WHERE anlasma.fakulteID=fakulte.fakulteID AND anlasma.bolumID=bolum.bolumID AND anlasma.koordinatorID=koordinator.koordinatorID AND anlasma.ulkeID=ulke.ulkeID AND anlasma.uniID=universite.uniID"
Should I use JOIN to get all the results?
Waiting forward to your respond to that,
Thanks in advance 🙂
Subscribed. Clear, concise – just what I've been looking for.. many thanks.
Great tutorial man! Do you have any tutorials on Udemy?
Great video man, definitely subscribed.
How would you go about then making each title a link to a…movieinfo.php file where the user could view further information about that movie?
I think that would be a lot of fun.
You deserve way more viewers! You're awesome! Thank you!
Is there any way you can help me with my project? I want to make a search bar that I want to link to a database like this. It will be a database about video games. I want the information to be displayed like you've done in this video
If the user wants to vote or rate the movie. Can you add that functionality please?
Please add pagination to this project. 😉
I dare think that I might be able to make them as a class method and call it. since genre code and director codes are simillar structure. I'm gonna try it after work. Thanks!
Good stuff!