my first website with Php and MySql database

Hi,

I have a website in my mind I would to implement once my db is more
furnished. For now, it's a small db in a form of Excel tables.

Is there a way if I create an access file to export it into my sql with
little work?

Or should I skip access and start direct into mysql php?

You can find a sample of the file there and what the site should be
about.

http://h1k.spreadsheets.google.com/ccc?id=o09362623063316940 048.3845572381750948418.10515899926621056420.287480898204782 1897

I would appreciate a few advices before I ever get started as I know
the basic of my sql but haven't put anything into practice yet.

I have downloaded phpmysql but the version of my sql there is all GUI.
Some books I have bought teach sql with a terminal window such as dos
or unix as far as I know. Is there a way to have that terminal table in
phpmysql?

Thanks for your help,

Pascal

Re: my first website with Php and MySql database

pscbrobotspam@googlemail.com wrote:
> Hi,
>
> I have a website in my mind I would to implement once my db is more
> furnished. For now, it's a small db in a form of Excel tables.
>
> Is there a way if I create an access file to export it into my sql
> with
> little work?
>
> Or should I skip access and start direct into mysql php?

I wouldn't bother with access.
Let Excel export a *.csv (comma seperated file), and you can simply upload
it to the PHPMyAdmin interface.

> You can find a sample of the file there and what the site should be
> about.
>
>
http://h1k.spreadsheets.google.com/ccc?id=o09362623063316940 048.3845572381750948418.10515899926621056420.287480898204782 1897

That's not accessible for me.

> I would appreciate a few advices before I ever get started as I know
> the basic of my sql but haven't put anything into practice yet.
>
> I have downloaded phpmysql but the version of my sql there is all GUI.
> Some books I have bought teach sql with a terminal window such as dos
> or unix as far as I know. Is there a way to have that terminal table
> in
> phpmysql?


Yes, easily, just follow the instructions about where you can find the
process to start from the prompt.
--
Grtz,

Rik Wasmus

Re: my first website with Php and MySql database

pscbrobotspam@googlemail.com wrote:
> Hi,
>
> I have a website in my mind I would to implement once my db is more
> furnished. For now, it's a small db in a form of Excel tables.
>
> Is there a way if I create an access file to export it into my sql with
> little work?
>
> Or should I skip access and start direct into mysql php?
>
> You can find a sample of the file there and what the site should be
> about.
>
> http://h1k.spreadsheets.google.com/ccc?id=o09362623063316940 048.3845572381750948418.10515899926621056420.287480898204782 1897
>
> I would appreciate a few advices before I ever get started as I know
> the basic of my sql but haven't put anything into practice yet.
>
> I have downloaded phpmysql but the version of my sql there is all GUI.
> Some books I have bought teach sql with a terminal window such as dos
> or unix as far as I know. Is there a way to have that terminal table in
> phpmysql?
>
> Thanks for your help,
>
> Pascal
You should split out the description words into a one to many database
link.

Re: my first website with Php and MySql database

Captain Paralytic wrote:
> pscbrobotspam@googlemail.com wrote:
> > Hi,
> >
> > I have a website in my mind I would to implement once my db is more
> > furnished. For now, it's a small db in a form of Excel tables.
> >
> > Is there a way if I create an access file to export it into my sql with
> > little work?
> >
> > Or should I skip access and start direct into mysql php?
> >
> > You can find a sample of the file there and what the site should be
> > about.
> >
> > http://h1k.spreadsheets.google.com/ccc?id=o09362623063316940 048.3845572381750948418.10515899926621056420.287480898204782 1897
> >
> > I would appreciate a few advices before I ever get started as I know
> > the basic of my sql but haven't put anything into practice yet.
> >
> > I have downloaded phpmysql but the version of my sql there is all GUI.
> > Some books I have bought teach sql with a terminal window such as dos
> > or unix as far as I know. Is there a way to have that terminal table in
> > phpmysql?
> >
> > Thanks for your help,
> >
> > Pascal
> You should split out the description words into a one to many database
> link.

Actually (and apologies, CP, if this is exactly what you meant), you
should 'split out' the description words to a many-to-many db link, via
a look-up table, especially so as descriptive words can have more than
one meaning, depending upon context:

keywords(keyword_id*,keyword)
idioms(idiom_id*,idiom_en,idiom_fr)
keywords_idioms(keyword_id*,idiom_id*)

* denotes PRIMARY KEY

Example query:

SELECT i.* FROM idioms i
LEFT JOIN keywords_idioms ki ON i.idiom_id = ki.idiom_id
LEFT JOIN keywords k ON k.keyword_id = ki.keyword_id
WHERE k.keyword = 'attitude'

a more complex query would include other, associated keywords, for the
purpose of filtering the results, but I'll leave that as an exercise
for the reader.

PS: I like this table naming style (where 'keyword' belongs to the
table 'keywords', but it can sometimes make life easier later on to
keep everything in the singular! Just thought I'd mention it as it's a
problem I'm running into just now with exchanging data between a MySQL
db and some XML pages.)

Re: my first website with Php and MySql database

strawberry wrote:
>
> Actually (and apologies, CP, if this is exactly what you meant), you
> should 'split out' the description words to a many-to-many db link, via
> a look-up table, especially so as descriptive words can have more than
> one meaning, depending upon context:

Yes Strawberry, that is exactly what I meant, but unfortunately not
what I said. oops!