Want more? Explore the library at https://www.codecourse.com/lessons Official site https://www.codecourse.com Twitter https://twitter.com/teamcodecourse.
source
PHP Tutorials: Selecting and Using Multiple MySQL Databases
Want more? Explore the library at https://www.codecourse.com/lessons Official site https://www.codecourse.com Twitter https://twitter.com/teamcodecourse.
source
33 responses to “PHP Tutorials: Selecting and Using Multiple MySQL Databases”
hey Alex, as always a very useful video, and I like that you took it step by step from the awful way to get the job done, through the OK way and on to the best way. Thanks
old video, mysqli is the way
I don't know why both of your methods don't work in my case! I always get error 500
Well done! That said, the title of this video is misleading. Instead of ". . . Using Multiple MySQL Databases", it should read ". . . Using Multiple MySQL Database Tables".
10:24 Thank you so much, buddy! (y) 😀 Liked and subbed!
Lovely Video..Have you been to Maharashtra ?
Be sure your query is correct. Most likely, you have an error. Check for one using mysql_error(). Btw, using mysql_* functions is old and depreciated
What if you wanted to match a name to a city and output it on one line.
Something like:
Alex is from London
Billy is from New York etc.
And what if it is mysqli?
hello I have a Question is there a way to submit the data to 2 MySQL but only read from one of them?
big up this video! helped me alot! 🙂
Maharashtra is a state lol
great video can you do a tut for reading from 1 table and updating to another table based on session id when a friends button is pressed (its for a pets app, so you can buy pets ie other members)?
Really Great Tutorial … thanks Alex
Great tutorial, found it really useful!
How about multiple databases support system in Object Oriented PHP???
Your technical fail at OOPHP !!
Need Multiple database support system for oophp??
I'm going to upload it soon !!
Is is really necessary to create two different connection variables i.e. $cities_db and $names_db
Can't we just create one connection variable (as both the connections are going to connect same host) and give it to both the mysql_select_db
$con=mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('names', $con) or die(mysql_error());
//some procedure
mysql_select_db('cities', $con) or die(mysql_error());
//some procedure
Why to create two different connection variables?
@Mr1Luciano Whatever…doesn't matter what you use as long as it does the job properly.
@Wiejeben ha. i feel that way about everything in regards to school work
This tutorial is completely useless…you've made 10 minutes of garbage and than displayed common SQL knowledge on end… :S
@Mr1Luciano Python > PHP 😛
The second way seems to to be better way.
Very nice ; )
Hello Alex. As always your time and assistance is greatly appreciated. Thank you for sharing.
@TeenAviator camtasia studio
Lol need to do Dutch homework but this is so much more relevant to my future.
Can't believe I keep liking your vids before the marker reaches 00:03 😀
I was just scouring the internet for this exact type of thing. Alex you are brilliant!
I've been looking for this for so long, thanks man you're the BEST!
is there a way to get text data by limit of 800 words..i have long articles and i would like to put pagination on it so when a user wants to read a data it just comes from mysql but only 800 words and it does not break words..
Brilliant tutorial! What screen recorder do you use? Cheers 😀
This one really helped me out a bunch! Keep it up alex!
What would be cool is a tutorial on making a mysql wrapper class so you can do sql statements using one line without having to make a while loop everytime. It would just do the while loop in the mysql wrapper class you would make.
great tutorial as always. Everything that I know about php is because of phpacademy