Page 1 of 1

php connect

Posted: Mon Aug 08, 2016 9:30 pm
by Vegan
i have an available database in an unorthox format (MSFT jet) and I can export it, so I was wondering about a specialized database

the idea was for my vegan site which used WP but I am not sure if I can do that is to use the second database to grab nutrition information a food item such as green beans etc

I am not sure if I would have to customize WP or what?

Re: php connect

Posted: Mon Aug 08, 2016 11:56 pm
by requinix
Jet? HA. That's an old one.

Export for sure. Afterwards you either force the database into your existing schema or you store the data someplace new and write WP plugin(s) to do whatever you need with it.

Re: php connect

Posted: Tue Aug 09, 2016 12:04 pm
by Christopher
Vegan wrote:i have an available database in an unorthox format (MSFT jet) and I can export it, so I was wondering about a specialized database
When you say "database" do you mean one table or multiple tables with relations?

Re: php connect

Posted: Tue Aug 09, 2016 12:34 pm
by Vegan
The database came from the old USDA nutrient information system

The program using it does not work with more recent versions of Windows so the tables are now on the USDA web page wit a search box

The file has several tables and it looks like there are some relational links too

Re: php connect

Posted: Tue Aug 09, 2016 6:17 pm
by Christopher
If you mean the USDA National Nutrient Database, it is available for public download. It is very easy to import and easy to automate the import. The delimited files are caret delimited and tilde quoted. You can import it into a database. I recall that the schema and a shell script importer is available.

Re: php connect

Posted: Tue Aug 09, 2016 10:20 pm
by Vegan
Sounds like with some help i can realize my goals of more ntrition information for recipes etc

need to take a break, beat from getting my dasebase up so that i can post more web sites

used to have 20MB now i have 20GB to 2PB as needed and dramatically faster