MySql and php using tables

SirChick · #1 06-12-2007, 11:31 PM

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 · #2 06-12-2007, 11:45 PM

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 · #3 06-12-2007, 11:51 PM

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 · #4 06-12-2007, 11:57 PM

Quote:

Originally Posted by SirChick

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 · #5 06-13-2007, 12:00 AM

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 · #6 06-13-2007, 12:19 AM

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 · #7 06-13-2007, 12:29 AM

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 · #8 06-13-2007, 07:12 AM

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 · #9 06-13-2007, 11:38 AM

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 · #10 06-13-2007, 06:29 PM

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 · #11 06-13-2007, 06:31 PM

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 · #12 06-13-2007, 08:02 PM

Quote:

Originally Posted by horus

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 · #13 06-13-2007, 08:30 PM

Quote:

Originally Posted by SirChick

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 · #14 06-14-2007, 03:26 AM

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 · #15 06-15-2007, 05:14 PM

Quote:

Originally Posted by bobs-pcmall

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?

horus · #16 06-15-2007, 05:22 PM

Yes, what kind of script do I use to update the tables. I only want 1 column to be updated in both tables.

bobs-pcmall · #17 06-15-2007, 10:22 PM

Sorry about the delay on getting back to you.

We've created the database and tables on Access first.
And then done the data entry.
Next we've created the same database and tables with the mysqladmin in cpanel
The one thing you need to be aware of is tables in mysqladmin seem to convert to lower case.
Example 'Wireless_Networking' gets converted to 'wireless_networking'.
Field names don't seem to be affected this way.
And mysqladmin adds it's own ID field for record keepping.
Emport fields must match data types.

Updateing one or two colunms is the problem we are experiancing with Visual.
Parseing the xml into the database to update records.
Right now we're not sure if it's something here to do with the schema or mapping setup.
When we get that figured out we'll be sure to post it in this forum.
We're new at the sql part of this too. Have been working with static page for 5 years up till now.

Hope this helps everyone out. I'll keep you all posted. Cheers.

navaldesign · #18 06-16-2007, 08:16 AM

You cannot usethe "Import "feature of phpMyadmin to update only one column. However, you can upload the csv file onthe server, and then have a simple php script that will look into the uploaded file, and update the MySQL tables accordingly (obviously, you need to set at leat one fild as index key filed, so each value will go in the correct record. )