auto generate and populate tables script.?

aron

hi all.
i have built a admin interface for my work. from here whenever we get a new client we set them up through this. what i want to know is that every client we make (after getting the hosting/database details from the isp) has 2 default tables in there datatabse. 1. tblpages 2.webstats what im doing now is manualy going into mysql and running these 2 .sql files to populate and create the tables. can i do this automaticlay say after i enter all ther info from the admin area after it writes there details (to OUR companys datatabse)it auto runs the .sql files and creates the details in THERE database. ***our admin area records the nessasery info eg. database name,server username,password.

cheers aron.

onion2k

Creating the database tables is easy enough, just make a string of the SQL as you would with any query and chuck it into a mysql_query(); (Open the .sql files and read them into said string if need be). Obviously you'd need to use the correct mysql database and user, but theres no reason it wouldn't work. I don't think you can actually run "source c:/blah" mysql commands from php.. but someone may know better.

Don't code yourself out of a job mind.. 😉

aron

cause i think with pho nuke and php weblog you can do this. im sure ther is a setup screen that askes you to enter you database info then hit submit it then check it and if its ok it creates the tables and poplates them.

ill keep looking
cheers.
aron.