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 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. 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. 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 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 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. 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
Archived
This topic is now archived and is closed to further replies.