Idiots guide to getting started

[beighton]

I have trawled through 100s of posts and have probably been looking in the wrong places but was wondering if there is some idiots guide to setting up a "MySQL database on x10 that can be accessed via a web browser" as I have never done this before.

So far I have joined x10 (and the forum) and set up a MySQL database with one table plus a user and input sample data using a csv file.

Now what do I do?

I presume I have to create a webpage and upload it - does it have to be on x10 or can I put it on my own website.

How does that webpage access the server? What syntax do I use to access it and the database? Where do I put the SQL statement so that it extracts the data?

Where should the files be located on the x10 server so that the browser can see the database?. Do I have to copy the sql database files to one of the other folders which it says are viewable by the public?

Are there any predefined templates or software that I can use and edit to save me having to do all the above whilst I am learning.

Obviously any help would be greatly appreciated, specially if its a very simple to understand manner.

 

[Corey]

Wow that's a lot of questions

Let's first figure out what you are trying to accomplish. Are you trying to set something up just to learn PHP\MySQL? Are you trying to develop your own software? What is your goal?

All files that are publicly visible have to go into the public_html folder on your account.

Let's figure out your goals and go from there.

-Corey

 

[beighton]

Corey, the answer is a bit of both..... I want/need to learn sql/php but also want to use it in a real environment.

The reason being - I run a football club with 14 teams and have a database on my PC which has all sorts of information from the 200+ player details, match fixtures and results though to financial transactions the club makes.

Once I have figured out how to do it, I want to have a webpage that links through to a MySQL database and extracts some of the information currently stored in my PC database (which is running Alpha Five v8) For example, I might want a page which lists all fixtures/results and goal scorers for a particular team which is extracted from the database, currently I have to manually create it in htm the page which lists all this information.

 

[Corey]

Sounds like you would want to transfer your whole database over into a MySQL database.

I would suggest following the tutorial here: http://www.tizag.com/mysqlTutorial/

On starting off with MySQL\PHP. It goes over the basic commands you would use to insert, query, and sort the info from the database.

You would want to upload any PHP files you create into the public_html folder of your account and just use your web browser to access them. There is a MySQL wizard in cPanel that can walk you through creating a new database. After you do that you should use PHPMyAdmin(Also located in cPanel) to administer it.

-Corey

 

[wmm31]

any MySQL link here?
Edit:
I already have MySQL in other site but I think this site is better.. I can start New here or I can also import... It's just that I don't know how to Start here. I'm looking for some link so that I use it. I know how to navigate when I'm in...
Edit:
I don't have don't have MySQL wizard in my cPanel . If I have, i know what to do. please help? how to have MySQL wizard in my cPanel?

 

[Corey]

wmm31 -- It's best to start your own thread instead of posting in someone else's. Please create your own if you need help.

-Corey