MySql and php using tables

[SirChick]

Would i be able to create tables on Microsoft Access and all the needed fields and links to each table etc and then use the SQL Code that it creates which you can view then import that into my PHP and HTML or is that not physically possible?

Just wondering cos like Access is very good GUI program better than coding..

[Girlonthehill]

Re: MySql and php using tables

Oooh, I'd be interested to find out the answer to your question. I will keep popping back ... hope you get an answer soon.

[SirChick]

Re: MySql and php using tables

I'd be shocked if no one has thought of it... cos it does seem logically possible but i dont wana work all day on it and find out you can't so im hoping some one else has figured it out :P

If you can it be a dream come true and a time saving moment !

[Girlonthehill]

Re: MySql and php using tables

I'd be shocked if no one has thought of it... cos it does seem logically possible but i dont wana work all day on it and find out you can't so im hoping some one else has figured it out :P

If you can it be a dream come true and a time saving moment !

I'd be delighted! I know how to use MSAccess. Lol The other stuff leaves me feeling clueless. Fingers crossed but you may have to be the one to test it. Lol

[Karen Mac]

Re: MySql and php using tables

I would assume that you can as i do it via Excel all the time. As long as the mysql viewed the format as acceptable you should be able to import it. Not sure if you would have to set up the headers to import to or not first tho. Id have to login and look to see if you could create a database and then import the headers totally.

Karen

[SirChick]

Re: MySql and php using tables

Does that mean your going to check or are you suggesting that is what i should do. Wasnt sure then :P

I dont own my own server yet mind. So for me testing would be a bit pointless cos i could not get an answer.

[Karen Mac]

Re: MySql and php using tables

Well... im not off to look this moment! I was suggesting thats what you could do. Perhaps if you were voda host customer, I might make the xtra journey, but I dont have a reason to log in and look at mysql and find out. For now I would assume that you can at least import it to a table that you create and use the import to populate the table.

Karen

[horus]

Re: MySql and php using tables

Hi, I want to make my table so that if I add a value into one column it will add the same value to another table.

Ex. Table customers
memberid

Table customers2
memberid

If I add a value into memberid in the customers table it will also be added to customers2 memberid.

How can I accomplish this?

[SirChick]

Re: MySql and php using tables

Karen Mac - I would be a vodahost customer if i knew it was possible.. no point in buy a host if i dont know weather i can achieve it yet.

And horus make your own thread youll get more responses aimed at you that way.

[Andy128]

Re: MySql and php using tables

Yes it is possible. However it takes lot of php knowledge to do this. At current the only one I know that have that kind of knowledge is Naval, Watdaflip and Davidunalica. Both Naval and Watdaflip will take on the job for a nominal fee. David- you'd have to ask.

I am currently learning php and have discoverd how to store info in a flat file and then create a php script that will read the info in the flat file and place it in a display table in any manner I wish. When complete- it will cut my website directory from 150 pages to about 5 or so. So I know it is possible.

Perhaps contact either of the members above for more solid input.

Andy

[Karen Mac]

Re: MySql and php using tables

SirChick..

As I said, as long as you export in a compatible mode, it should be possible to populate a mysql database with a feed. If i go from excel you should be able to go from access same way. You may have to import it to excel or make a pivot table and then export it, but it shouldnt be a problem to manipulate it. You will still have to create the database before populating it in mysql then go to php my admin and do the import.

Karen

[navaldesign]

Re: MySql and php using tables

Hi, I want to make my table so that if I add a value into one column it will add the same value to another table.

Ex. Table customers
memberid

Table customers2
memberid

If I add a value into memberid in the customers table it will also be added to customers2 memberid.

How can I accomplish this?

This is not automatically done by MySQL itself. It is your script that needs to update both tables. How do you update the tables ? Meaning what kind of script you use ?

[navaldesign]

Re: MySql and php using tables

Karen Mac - I would be a vodahost customer if i knew it was possible.. no point in buy a host if i dont know weather i can achieve it yet.

And horus make your own thread youll get more responses aimed at you that way.

It is possible: export from Access to Excel. Then export again as CSV, so you can import it into the database.

[bobs-pcmall]

Re: MySql and php using tables

navaldesign:

We use MS Office Access Professional 2003.
We are able to export directly from Access into csv type text.
By right clicking on the Table, Query, or Forms. Note " Item can not be open or in design view"
Select Export ::
When New Window Opens "Export Form 'Name of Datbase Opened By Access' "
From the dropdown Save as type. Here we select as ' Text Files (*.txt;*.csv;*.tab;*.asc) '
If Encode Window Pops Up "Encode As Unicode (UTF-8 then select OK.
The Next Window Should Be Export Text Wizard;
Select Delimited. Then Next. Here we prefer to use Semicolon, and Text Qualifier; We use the Broken Bar {Alt+0166}
We use broken bar because some items in text fields contain qoutes.
These seem to import fine into MySql Tables. We have used Include Field Names on First Row; but don't always get the results we
wanted.
It's Best to create database and tables first, then import.

Hope this was helpful.

[SirChick]

Re: MySql and php using tables

navaldesign:

We use MS Office Access Professional 2003.
We are able to export directly from Access into csv type text.
By right clicking on the Table, Query, or Forms. Note " Item can not be open or in design view"
Select Export ::
When New Window Opens "Export Form 'Name of Datbase Opened By Access' "
From the dropdown Save as type. Here we select as ' Text Files (*.txt;*.csv;*.tab;*.asc) '
If Encode Window Pops Up "Encode As Unicode (UTF-8 then select OK.
The Next Window Should Be Export Text Wizard;
Select Delimited. Then Next. Here we prefer to use Semicolon, and Text Qualifier; We use the Broken Bar {Alt+0166}
We use broken bar because some items in text fields contain qoutes.
These seem to import fine into MySql Tables. We have used Include Field Names on First Row; but don't always get the results we
wanted.
It's Best to create database and tables first, then import.

Hope this was helpful.

So create the database and tables in access first or create them on the server first?