if anyone could give me any suggestions on this

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
esandra
Forum Newbie
Posts: 24
Joined: Sun Aug 30, 2009 11:11 pm

if anyone could give me any suggestions on this

Post by esandra »

How to do #3 by a PHP page instead? mainly so
that there wouldn't be a need to
export the sql after doing #2 then
import it into the online phpmyadmin(#3)

#1. Convert database from foxpro to sql
#2. Change some fields in the sql table
#3. Upload to phpmyadmin

Is it possible to create a code to export
from the server and then import the sql online?

like by making use of mysql_fetch_array() and insert into
endyourif
Forum Newbie
Posts: 7
Joined: Wed Jan 26, 2011 6:53 pm

Re: if anyone could give me any suggestions on this

Post by endyourif »

I've done something similar before where you create a simple Foxpro program that loops through the tables and just builds the SQL for you and this can either be saved into your clipboard or outputted on screen for you to copy and paste into something like phpMyAdmin.

Or if you have access to the mysql database from Foxpro, you can just connect directly to the DB and import it from there.
Post Reply