LebGeeks

Parabola

Member

Database.

I was wondering if some one could give me tips to create a database.

Thanks.

rolf

Member

Re: Database.

Uh sure man. You're using what, mySql?
For mysql under windows you do:
start->run command
cd c:mysqlbin
mysql
create database databasename;

rolf

Member

Re: Database.

I can help you but tell me exactly what you

rolf

Member

Re: Database.

want

mahdoum

Member

Re: Database.

lol or just us Ms Access

mahdoum

Member

Re: Database.

just noticed this is in webdevelopment, just use phpmyadmin.

Parabola

Member

Re: Database.

I thought of using Access and PHP. what do you think guys?

mahdoum

Member

Re: Database.

well if its on a website i would recommend mysql and php ;)

Parabola

Member

Re: Database.

Yeah it's for a website. So I guess i'll start learning mysql. Can you tell why do you recommend mysql and php instead of access and php?

mahdoum

Member

Re: Database.

well first off I'm not sure how you would incorporate access and php, secondly most hosting packages come bundled with mysql as the main database and thirdly you'll find a lot and i mean a lot of tutorials to help you out with mysql and php, since it is so easy to use.

rolf

Member

Re: Database.

I thought of using Access and PHP. what do you think guys?

If you have an easy way to do it, why not. The only way I'm aware of is through ODBC. I dont like ODBC, I'd rather use PHP + MySql like everyone else.
plus you'll be able to transfer your website to a linux server.

Parabola

Member

Re: Database.

Hmmm okay, thanks guys. I'll start learning MySql. If I face any problem i'll post in here. Thanks again.

samer

Admin

Re: Database.

· Learn basic MySQL queries
· Learn how to connect to a MySQL DB through PHP
· Learn retrieving your data, and sorting it.
good luck bola :)

Parabola

Member

Re: Database.

Thanks Samer, I already started doing that.

fnzahar

Member

Re: Database.

well, for me i also prefare mysql instead of access for multiple reasons, but my reply post ain't for that only...

by the way, when you study mysql, you are studying the basics of any database thanks for the standard of sql.

don't forget a good database, is a good relational data base respecting the constraint rules (primary keys, foreing keys, unique and others).

by the way, i also recommand , that you should learn a new way of storing informations and verry fast and standard, it's the xml w3c standards...
trust me, a verry fast connections, no problems, but need some time to be a pro on it, i/m working on xml from a year by now...

check a site that i developed in the xml theory: http://www.ssccbauchrieh.com

you could create a php code to generate an xml file, and then create a xsl file to use a specific sql for xml called xql and retreave informations on a web page using html inside the xsl file.

trust me a verry fast database, and you could create your own logic , dtd and schema, and there are a lot of object libraries called DOM to manipulate the xml data with phpcode or javacode or javascript.