Today, I managed to install Xampp. My intent is to be able to test all my code on my local machine before moving it to my web hosting service; thus avoiding using the web host to test my code. I still have much to learn about this process, but I can do no testing until I have a database and some sample data created.
The first thing I tried to do with Xampp was create the tables needed for my database. I was able to get phpMyAdmin to create the name of the database and one table. The table will have 20+columns. I got phpMyAdmin to display a screen with the number of columns and even entered all the datanames, types, lengths, etc. I saved it and got an error.
The error
The column it burped on has type=date with a length of 10. I guessed at this length, but the error says nothing to indicate to me that the length value is wrong. I then found and clicked on ther Save button. I got no error.
Now, when I try to display the database to see that it did set up all the columns, I find there are only 2 columns of the 20+ that I entered. This tells me tht Save command failed, but there were no errors.
3 things:
- Can anyone suggest what I failed to do or did wrong to lose all the work creating that first table?
- Can anyone tell me where Xampp stored the database I created? I cannot find it in File Explorer
- Is there a better ui for creating tables in the SQL that comes with Xampp thn the phpMyAdmin ui?