Navigate to the htdocs folder of your XAMP installation directory(Usually located in C:\xamp\httdocs\, if you haven’t changed during the installation). INSERT INTO `quiz` (`id`, `question`, `optionA`, `optionB`, `optionC`, `optionD`, `answer`) VALUES (‘1’, ‘sample Question’, ‘choice one’, ‘choice two’, ‘choice three’, ‘choice four’, ‘choice one’) Insert values using phpmyadmin UI: Figure 03 : Insert Value into table You can do this with mySql queries or phpmyadmin. Once you login you will see the screen as shown below: figure 01 : Create DataBase Figure 02 : Design a tableįor retrieving the values from database, lets insert some values into table. By default username is root and there is no password (leave the password field empty). This will prompt you for inputting username and password. Lets create a ‘quiz database’.Open your browser. You can create a database and table for storing the data for the project with required number of fields depending on what project you creating. Create an database using “SQL Query” or ‘phpmyadmin’ interface as showing below. Local Database : if you are using local database, open browser and type and create databse and table as below 1. Remote Database: go to the phpmyadmin or mySql from cPanel of your hosting account and create database and table as below You can follow the steps regardless of your database on hosted locally or remotely. How To Install and Configure Web server on your local Machine ? Setup local web server on your laptop will be really useful to test your project before you uploading to your online server. Just go through the link below and learn how to setup a web server locally on your windows computer.
There are few things you should know before you begin, if you are using local database. This article will he useful even if you are using remote database or local database. Package de. import import import import import import import article will help you to retrieve your data from database and display the same into your android project. Before you buying an hosting account you can simply test your android project locally.
0 kommentar(er)
