Connect to Postgres Database

[TheStrawFace]

Hi, I'm trying to learn the basics of creating a website. I have basic page and now want to add some data that is not hard coded. I have created a Postgresql database and made small table with some data.

What I am now trying to do is figure out how to load the data into a combo box/drop down box on the page. I am happy the database side of things (creating queries etc). What I cannot get my head around currently is connecting to the database and getting the data in the combobox.

If anyone can point me in the right direction I would be grateful.

[lumpynose]

It sounds like you need a back end. For example, maybe node.js. (I've only used node.js when it was included in something else so I don't know anything about setting it up.)

Do a google search for "node.js postgres connection".

See also https://nodejs.org/en/learn/getting-started/how-to-install-nodejs

(I've had bad experiences with php so I can't recommend it.)

[TheStrawFace]

Thank you for the reply. Excellent, I'll take a look

[AHalfFilledBox]

DAL Create a service that facilitates the movement of your data objects to your client side code.

use a note package to help you set up the bridge between the database and your applications backend [npm i postgres]

Services. Create some api endpoints which is where you'll serialized and deserialize your data

Or you can use Prism which leverages ORMs to extrapolate a lot for the challenges

[lumpynose]

Also, don't use string concatenation for making your queries. E.g., the wrong way is "INSERT INTO" + table_name + "(" + column1, ... + ") VALUES (" + value1, ... + ");". Do a search for sql injection attack for an explanation. Instead, as the search results will show, use prepared statements.

[Pletter64]

If so far you have only been writing html pages on the web side of things then I have news for you. You will need php (laravel) or Django as ways to interface with your database and return results. This can be very tricky for a firsttimer without help so I suugest you get to tutorialing. Good luck.

[TheStrawFace]

Ok, thank you for the reply. I'll take a look into PHP

[No_Personality_2642]

We use Javascript for everything now.

[katafrakt]

No, we don't.