Insert data using postgresql, and html

1

how to insert data using from web form postgresql, javascript and html. any help guys…

2

Firstly, welcome to the forums.

While we are primarily here to help people with their Free Code Camp progress, we are open to people on other paths, too. Some of what you are asking is pretty trivial in the Free Code Camp context, so you might find that if you’re not getting the instruction and material you need in your current studies, the FCC curriculum will really help you get started. At a modest guess I’d say investing a 4-5 hours working through the curriculum here will really pay off. You can find the curriculum at https://www.freecodecamp.org/learn.

With your current questions, we don’t have enough context to know what you already know or don’t know, so it is impossible to guide you without just telling you the answer (which we won’t do).

It is pretty typical on here for people to share a codepen / repl.it / jsfiddle example of what they have tried so that anyone helping has more of an idea of what help is actually helpful.

Please provide some example of what you’ve tried and I’m sure you’ll get more help.

Happy coding :slight_smile:

3

Thanks for an active reply sky020, following is my sample code…

<html>

<head>

<title>Insert Record</title>

</head>

<body>

  <b>Add Record</b></font>

  <p><font size="2" face="Arial, Helvetica, sans-serif">

  <form action="" method="POST" enablecab="Yes" border="">

    Id:<input type="Text" name="id" align="LEFT" required="Yes" 

    size="10" value=""><br><br>

   Name :<input type="Text" name="fname" align="LEFT" required="Yes" 

    size="59" value=""><br><br>

    <input type="button" id="add" name="add" value="Add" align="MIDDLE"><br><br>

  </form>

  

  <script type="text/javascript">

  const {Pool, Client} = require('pg')

 

  const client = new Client({

  user: "postgres",

  host: "localhost",

  database: "testdb",

  password: "pg22020>>",

  port: 5432

  })

client.connect()

var idd=$("#id").int();

var nname=$("#fname").val()

client.query("Insert into company (id,name,) VALUES ('"idd+"','"+fname+"',')",function(err, result)      

//var sql = "INSERT INTO form (name, email,description) VALUES ('"+name+"', '"+email+"','"+username+"')";

</script>

</body>

</html>
4

AFAIK, you must use some sort of backend (Node, PHP, Go, Python etc). Make a HTML form with POST method and send values to an endpoint in the backend and fire a query to Postgresql.

Javascript in a web page is sandboxed and cannot interact with Postgresql directly.

5

i want to save data to postgres database using node.js and html…

6

In html:

<form id="newform" action="/endpoint" method="post">

In node you have the corresponding endpoint and sql query. (sorry I am not familiar with node)

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&ved=2ahUKEwi039mA0LrqAhXxy6YKHUZ4BUMQFjAAegQIAhAB&url=https%3A%2F%2Fmedium.com%2F%40wlodarczyk_j%2Ftutorial-handling-endpoints-in-node-js-and-express-ce26cb550c28&usg=AOvVaw0mOrGnFIOnAtrSe97TpNG0

7

any friends that can help… by the what is your expertise…

8

I am in no way expert, but I am rather familiar with Postgresql and I have just started this journey with Golang (instead of Node) http://94.237.92.101:3030

9

better we are same area of interest…

10

so you mean you are expert in golang and postgres…

11

I mean that I can manage a Postgresql database at semi pro level. And Golang and Javascript at newbie level. And HTML, CSS at newbie+ level.

What I have learned is that portions of all languages (Javascript excluded) are similar in many ways.