zzrabbit Posted March 21, 2011 Share Posted March 21, 2011 Hi all Complete noob here..... What I have to do is create a new database every year, but I can't just import last years data completely, only records when needed. I can do it myself in PHPMyAdmin, but I don't want my employees touching mysql directly. What I am trying to do is write a php script that will serach for a reocrd in last years database and if it exists insert it into the new database if it doesn't exists bring up a form so it can be entered. Any help would be greatly appreciated. Thanx ZZ Quote Link to comment https://forums.phpfreaks.com/topic/231265-records-from-one-database-to-another/ Share on other sites More sharing options...
ManiacDan Posted March 21, 2011 Share Posted March 21, 2011 Ok...do that. Which part do you not know how to do? If you don't know any PHP, you'll need a "learn php" book. I personally recommend "Web Database Applications with PHP & MySQL" from O'Reilly press. -Dan Quote Link to comment https://forums.phpfreaks.com/topic/231265-records-from-one-database-to-another/#findComment-1190260 Share on other sites More sharing options...
zzrabbit Posted March 21, 2011 Author Share Posted March 21, 2011 I do know some of both php and mysql, but not enough to put it all together. I have tried some things, I can search for a record and write the record to a text file. I tried this but couldn't figure out how to insert the record from text to Mysql or what to do if the record doesn't exist in the old data. ZZ Quote Link to comment https://forums.phpfreaks.com/topic/231265-records-from-one-database-to-another/#findComment-1190314 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.