Hi, I'm looking to create a PHP+MYSQL website. I'm just looking for a tutorial site which will take me through step by step what I need to do to connect to the database and extract data. I have a database already made for the site (and a means of updating it), so I don't need any help there. Also is there any standards I should be sticking to when coding in PHP like this? As there are standards for XHTML, CSS and other languages I just thought i'd ask. Thanks in advance, TS
This is really a very expansive subject, and the answer to your question fills several large books. I suggest that you purchase a book on the subject if you are really clueless, or if you have more time and pick things up quickly look at some online tutorials, Google has plenty of regular and video tutorials. Alternatively you could always hire a coder and make one of the conditions the inclusion of clear and extensive code commenting. This works well as you can put the code and the comments into context very easily. When its your own website and data that the code is working with you can grasp concepts far faster than with a random tutorial. So while you will have to pay initially you will get a leg up on the PHP learning ladder and should be able to start learning by tweaking your own site.
I know coding concepts, i'm just unsure about PHP's syntax to be more precise. I have used databases before in other programming languages, i'd just like to know how to use php. I already use PHP on my site slightly, it's just not connecting to databases, which is what I want to know how to do. Connecting to a database can't be hard, what is it, a few lines of code? Extracting data can't be any harder than i've done before (I know some SQL...enough to extract what I want and order it how I want, etc). It's just the syntax for it all, and if there are any standards i'd like to at least be aware of them. I really don't see why I would need to hire a coder to do that for me, maybe a book, I was just looking for something on the internet first. Thanks