duncan2010

It's interesting that you say that, because it's sort of what I was thinking. I like the idea of having OO php code, as that's the way I learnt to code, but the way the databases are accessed from within the php I think it looks easier to just make the traditional procedural type calls. It also seems to me as though mysql is still more widely used by php programmers, although I cannot verify that. Mysqli also has the procedural versions too, so it feels a little bit like it's neither one thing or another. Hmmm!

Just starting to learn php and have come to the stage of introducing databases and a bit stuck with whether to learn mysql or mysqli - as far as I can gather a lot of people still use the procedural mysql. I now that mysqli can also be procedural, so I welcome any advice on what choices people make and why. Also, if anyone knows what will be the most often encountered in the professional market, so that I don't spend time learning something to learn that it's no longer in use. Thanks for any advice.

Thankyou guys. Very useful info. Is the general trend in industry towards mysqli then? Is Mysql being outdated or is it still widely used and just a matter or preference? I originally learnt java so am used to the OO aproach.

I'm sure this is asked a million times, so if it annoys you then just don' answer. I have searched the forums before asking this, but as a newbie to code I see the forum as a quick way to gain knowledge, rather than put all the ground work in from scratch. That said, my question is wheather it's best to learn mysql or mysqli? (in your opinion of course) What is most widely used in the industry? I know that mysqli is newest and supports OO programming, but it would seem that many people still use mysql and therefore procedural style. Any good advice is always welcomed. I don't want to spend ages learning one only to find that later on it will not be as useful. Thanks.

Hi, when I say WAMP I just mean Windows, APache, MySQL and PHP. It's nothing that I have specially downloaded. I am using PHP Version 5.0.0 and MySQL Server 5 I hope that helps. The Mysql Client API is 3.23.57 and Mysqli is 4.1.3-beta. It's annoying, because most of the books say to download the latest version of all the php and mysql, but then when you do (or atleast I thought I did) they aren't compatible or they don't run the code that the book lists. I think I would be happier if I was sure which coding to persue, mysql or mysqli, so that I don't learn one and find that I can only run the other. Sorry if that sounds really simplistic for what I'm sure is a large topic, but bein a newbie I don't understand all too much yet, just want to get some code running.

Hi all, new to this coding business and spent days trying to get apache, php 5 and MySQL working on my windows pc. Finally got there and can only connect to database using mysqli instructions. Problem is that the book I am trying to learn from only has mysql code. I have been into the php.ini and un-commented the mysql extension, which was commented. I am running the following command: $conn = mysql_connect('localhost', 'username', 'pwd'); and it says Client does not support authentication protocol, consider upgrading mysql client. Help!! I downloaded the latest cersion of mysql. Can somebody explain whether I should be learning mysqli or not and what I need to do to be able to run mysql. Any help appreciated.