princeo Posted February 28, 2008 Share Posted February 28, 2008 I have designed a simple database in phpMyAdmin which I can view, but my problem now is, how do i upload it to my server and also how do i connect a search page to it so that a query can be initiated to get data from the db. I have been reading some tutorials but i get confused the more as most examples don't talk about using phpMyAdmin. help needed please. this is the structure: ID | Name | Address | Registration |Date Quote Link to comment https://forums.phpfreaks.com/topic/93481-getting-confused-about-uploading-my-db-into-server/ Share on other sites More sharing options...
aschk Posted February 28, 2008 Share Posted February 28, 2008 Using PHPMyAdmin (which i'm assuming is running on your local machine), export (its an option) the whole database schema to a file, then on your server using the mysql command line tool, or PHPMyAdmin on the server import it. e.g. #> mysql -u @username -p @databasename < yourdatabasefile.sql replace @username and @databasename with the respective parameters that you have. Quote Link to comment https://forums.phpfreaks.com/topic/93481-getting-confused-about-uploading-my-db-into-server/#findComment-478953 Share on other sites More sharing options...
princeo Posted February 29, 2008 Author Share Posted February 29, 2008 Thnks for the help, I have uploaded the file to my server but there is still one issue remaining. I have an index.php page with a search on it, I want you to help me on how to connect to my db to get data to display on my page when someone enter a query. thanks in anticipation. Quote Link to comment https://forums.phpfreaks.com/topic/93481-getting-confused-about-uploading-my-db-into-server/#findComment-479803 Share on other sites More sharing options...
aschk Posted February 29, 2008 Share Posted February 29, 2008 Start here: http://uk3.php.net/manual/en/ref.mysql.php and check out #example 1 Quote Link to comment https://forums.phpfreaks.com/topic/93481-getting-confused-about-uploading-my-db-into-server/#findComment-479848 Share on other sites More sharing options...
princeo Posted March 4, 2008 Author Share Posted March 4, 2008 I have connected my database successfully but I want to be able to query it from a search box, I need a code to do this as every tutorial i have studied gets me confused the more. this is a newbie please. this is the structure of the db ID | Name | Address | Registration |Date Quote Link to comment https://forums.phpfreaks.com/topic/93481-getting-confused-about-uploading-my-db-into-server/#findComment-482725 Share on other sites More sharing options...
aschk Posted March 4, 2008 Share Posted March 4, 2008 Again, check out the link i specified previously, that is as simple as it comes. Example #1 is perfect for you. Quote Link to comment https://forums.phpfreaks.com/topic/93481-getting-confused-about-uploading-my-db-into-server/#findComment-482893 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.