Using Wamp/phpMyAdmin/SQL

Watch
mespannerhanz
Badges: 13
Rep:
?
#1
Report Thread starter 7 years ago
#1
I have been asked to use this system for running a database for a society at uni, and am completely out of my depth, so would appreciate some advice, as am struggling to find anything useful online.

I have downloaded and opened phpMyAdmin, and imported the database, but can't seem to find my way around it, and can't work out how to do enquiries. Has anyone got any experience of this system, as I can't find much online.

thanks
0
reply
mfaxford
Badges: 1
Rep:
?
#2
Report 7 years ago
#2
MySQL will be the database you're using (it's the M in WAMP) and uses a language called SQL to query it (and it fairly common between all large databases - although they usually have slight oddities where they don't quite follow the same standards)

Is there are particular reason for WAMP - or is that just to provide a local environment for you to learn in. The more common approach is LAMP (same thing but on Linux instead of Windows).

If you're new to web design then you'll probably need to learn html and css first (or find someone else to do those parts of the system).

Assuming it's going to be something like a database of members you might also want to ensure you know about the data protection act and ensure than any access to the DB is secure (phpMyAdmin hasn't always been the most secure thing out there)
0
reply
Sgt.Incontro
Badges: 20
Rep:
?
#3
Report 7 years ago
#3
(Original post by mespannerhanz)
I have been asked to use this system for running a database for a society at uni, and am completely out of my depth, so would appreciate some advice, as am struggling to find anything useful online.

I have downloaded and opened phpMyAdmin, and imported the database, but can't seem to find my way around it, and can't work out how to do enquiries. Has anyone got any experience of this system, as I can't find much online.

thanks
This is all very easy.

First of all, I would recommend Xampp over Wamp. Secondly, go on YouTube and start watching mySQL and php tutorial videos, IMO these are the best learning tools available.
0
reply
username909838
Badges: 11
Rep:
?
#4
Report 7 years ago
#4
I use Xampp as well, so I agree with the poster above. Also, there is an easier way than writing the queries yourself, as there is a basic GUI interface to import, export, add, edit, remove etc.
0
reply
DarkWhite
Badges: 17
Rep:
?
#5
Report 7 years ago
#5
There's a difficult answer and a less-difficult answer to this.

The difficult answer is itself a question - what do they want from this setup? What's the society about, what does the database hold, is this for their website or just to maintain a database of something? Everyone starts somewhere with this and that's absolutely fine, but normally questions around *AMP installations are more specific. If somebody is expecting you to code PHP, that is considerably different to someone asking you to maintain a database and off-the-cuff suggesting WAMP.

The less-difficult answer simply tells you how to use phpMyAdmin.

Basics on using phpMyAdmin: http://www.siteground.com/tutorials/phpmyadmin/
The most powerful and useful feature in any database system is the high-level language you can use to query databases. In phpMyAdmin you can enter SQL queries under the 'SQL' or 'Execute' tabs. A good SQL starting tutorial is: http://www.w3schools.com/sql/
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Do you think receiving Teacher Assessed Grades will impact your future?

I'm worried it will negatively impact me getting into university/college (97)
39.43%
I'm worried that I’m not academically prepared for the next stage in my educational journey (27)
10.98%
I'm worried it will impact my future career (18)
7.32%
I'm worried that my grades will be seen as ‘lesser’ because I didn’t take exams (57)
23.17%
I don’t think that receiving these grades will impact my future (30)
12.2%
I think that receiving these grades will affect me in another way (let us know in the discussion!) (17)
6.91%

Watched Threads

View All