我正在尝试使用Node JS和Angular(Material UI)开发全栈应用程序。
我遇到了以下问题。
我正在制作一个小型的Web资源管理应用程序。 我目前正在将数据注册并发送到Mysql数据库中。
我遇到了以下错误:
TypeError:无法读取未定义的属性“name”
以下是我的代码:
const express = require('express');
const app = express();
var cors = require('cors');
var mysql = require('mysql');
const body = require("body-parser");
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '',
database : 'totale',
});
app.use(cors());
app.get('/', function (req, res) {
res.send('Hello World!');
console.log(req);
});
app.get("/inscription",(req,res)=>{
var nom = req.body.name;
var prenom = req.body.prenom;
var mail = req.body.email;
var password = req.body.password;
connection.connect();
connection.query('INNSERT INTO inscription set nom = ?, prenom = ? ,mail = ? ,password = ? ',[nom,prenom,mail,password],function(err, rows) {
if (err) throw err;
console.log('The solution is: ', rows[0].solution);
});
//res.send('iok');
//connection.end();
});
app.listen(3000, function () {
console.log('app listening on port 3000!');
});
这是我的代码:TypeScript
import { Component, OnInit } from '@angular/core';
import { FormControl, Validators } from '@angular/forms';
import { User } from './../User';
import { Router } from '@angular/router';
import { FormBuilder, FormGroup } from '@angular/forms';
import { HttpClient } from '@angular/common/http';
import {tap} from 'rxjs/operators';
@Component({
selector: 'app-inscription',
templateUrl: './inscription.component.html',
styleUrls: ['./inscription.component.css']
})
export class InscriptionComponent implements OnInit {
signupForm;
results;
//email = new FormControl('', [Validators.required, Validators.email]);
constructor (private http: HttpClient, private formBuilder: FormBuilder)
{}
ngOnInit() {
this.signupForm = this.formBuilder.group({
email:"",
name: "",
lastname: "",
password : "",
});
}
public onFormSubmit() {
const configUrl = 'http://localhost:3000/inscription';
this.http.post(configUrl,this.signupForm.value)
.pipe(
tap(
data => console.log(configUrl, data),
error => console.log(configUrl, error)
)
)
.subscribe(results => this.results = results);
}
}