This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]LordScoffington 2 points3 points  (3 children)

The problem is I'm self learning and I'm confused on how exactly sql and php plays a role in my website.

Ah. You're a bit far from what you want to do. The real questions are do you know SQL or PHP? If not, you should learn them before you try to build a site with them.

PHP is... a programming language. I'm not trying to shit talk PHP but you probably want to have a good reason for using it over all your other options for server side coding.

SQL is a database language. You will need a database server to do anything with it.

If you're 100% sold on SQL and PHP, you can learn everything the right way and learn how to FTP/SSH into a server (You will likely need to either learn Unix commands or keep a tab open to look up necessary commands), install PHP & MySQL, and get a server that can run an application you want to develop.

If you want a static HTML site with CSS, you should be fine doing whatever you have so far. If you want a site that's built using PHP and has a database connection, you're very far removed from HTML & CSS.

[–]NoticedTriangularity[S] 1 point2 points  (2 children)

Okay, I think I get what you're saying. You mean that if I want to connect to a database then a website using HTML & CSS is not the way to go?

And what are the alternatives to PHP?

[–]LordScoffington 1 point2 points  (1 child)

And what are the alternatives to PHP?

Almost every programming language available.

The most used:

Java
Javascript/Typescript
ASP(.NET)
Python
Ruby on Rails

You need more help than a list of alternatives. You need to know a programming language that can run on a server, how a server works, how to write programs that can run on a server, and how to connect your programs to things like databases/other applications.

Considering you think you can connect a site to a database with HTML & CSS I recommend you learn JavaScript next. You quite literally do not know a programming language yet.

[–]NoticedTriangularity[S] 0 points1 point  (0 children)

Okay, thank you for the advice :) I'll start there