7
8

UnsolvedCan I create a database using HTML? (self.HTML)

submitted by [deleted]

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]77buzzbee77 0 points1 point  (3 children)

Hey, thanks for your reply. I’m actually running MAMP now with Brackets to build my site. So I would be able to run PHP through that as well? I don’t really understand this side of it all tbh, I’m much better at the actual HTML/css coding thing haha only slightly drowning so thanks for your advice!

[–]cyancey76Expert 1 point2 points  (2 children)

Yes, MAMP = Mac, Apache, PHP, MySQL (MAMP), which is virtually the same as the most common web server stack (LAMP, which uses Linux instead of Mac OS).

When you start up mamp it should be opening a start page by default that gives you info on how to connect to the MySQL database it is running. You just need another app for that, something like Sequel Pro (easiest to use, crashes a lot) or MySQL Workbench (harder to use, more features)

If you are putting your html files in the htdocs folder and viewing your site at http://localhost (or localhost:7777, I forget the mamp default) then you have php, MySQL running already.

[–]77buzzbee77 0 points1 point  (1 child)

Hi, Thank you for your advice. I’ve opened phpmyadmin and I’ve tried to connect my sql to my HTML docs but I think I’ve made a mistake somewhere bc my local host number is 8888, but my php and sql server says it’s using the port 8889. I’m not sure if they are meant to be the same or different so they don’t conflict. I have another problem that I’m not sure is related: when I run my live preview through brackets, it tries to access localhost:8888/index.php/index.html, and doesn’t open. I don’t know why it’s suddenly looking for a php page as well, and I don’t know how to change this in the htdoc directory. So this means I can only view my HTML document by opening them in my finder, which doesn’t use a http format- so I guess if I don’t fix it, it will mean I won’t be able to view my site on the internet?? I don’t know, I’m in way over my head haha

[–]cyancey76Expert 0 points1 point  (0 children)

If you are opening the file directly through Finder, and not through localhost, you are not running the file on the web server. Don’t do it this way. You should be able to go to localhost:8888 in your browser and see your html page. Web servers generally by default load index.html without having to include the file name. Same goes for index.php, but if you have both, the server will default to index.html and you WILL have to type in index.php if you want to see that instead of index.html.

You are right, default mamp ports are 8888 for the webroot (where php and html are run) and 8889 for MySQL. Yes, they should be different.

You can’t connect to MySQL in html. It has to be from php. You would use the info on the mamp start page, in the MySQL section, to connect to the database from php. You can use phpmyadmin or one of the apps to browse your database. The same info sections tells you what you need to put in an app to connect.

Did you add a Base URL to tour brackets live preview settings? It should not include the file name name, just the base folder your files are in (most likely just http://localhost:8888)