Apache Friends Support Forum

i need to selfstudy xampp and i really really having a hard time

Where is your problem exactly?

ahhm.. i don't know exactly.. but i'm confused.. this is my first time on using xampp and i was planing to make an OPAC.. but .. i don't know how to make a database for it using xampp

What is an OPAC?

online public access catalog.. this is for library purposes.. just like a search engine for books

do you have any idea on constructing a database.. ehe.. can u post it.. so i can read it tomorrow.. thankyou in advance .. if that would happen you would be a really big help for our software project

Open phpmyadmin (part of Xampp Menu) and create a new database (you will find the appropriate buttons and fields).

You might be best getting a book on mysql. I use php and mysql for dynamic web sites. If you havent done databases before you are going to stuggle without it. Knowing what to set the field types to, knowing how to access it and how to populate it. There are packages for your task which would do it all for you. Without knowing your skill level its hard to suggest where to start.

If you are just having a problem creating the database and know all about it after that then i would use sqlyog i find it far better than phpmyadmin.

Sounds like some type of script you want to run there. Create a database as shown, in phpmyadmin. Done.

The installer for the script will ask this database name, as well as the root name and pass for mysql.
These are the basics for any webmaster, you don't need a book on mysql unless you plan on working the data within in a table, and clearly, you don't.

Itzs wrote:If you are just having a problem creating the database and know all about it after that then i would use sqlyog i find it far better than phpmyadmin.

Are you kidding? You advise a 139,-$(!!) Tool for the most simple task of creating a database? A simple "Create database 'databasename'" in a mysql console will do the job.

there is a fully free version of sqlyog, a trial version and a paid version i am using free version with out limits from what i can see. You do get a buy message on loading and on exit but the gui is far better than phpmyadmin for most tasks.

Its called the community version link here

http://code.google.com/p/sqlyog/downloa ... e&can=2&q=

all of which is irrelavant if hes just creating database and running a script wish i hadnt tried to help now, but link above for others if they want a look.

I agree with Itzs -

If your plan is to create a database design from scratch AND build an interface for it, that is a considerable task. Some books and perhaps an online class or training videos would be a good investment. It will also reduce your frustration and increase your chance of success.

Good Luck

maybe that would help.. thanks for your reply guys.. my teacher is a real freak giving us a project we didn't even know how to use the appropriate language for it.. .. thanks guys.. out for a while now..