I have a code
func profile(w http.ResponseWriter, r *http.Request){
var tampile = template.Must(template.ParseFiles("./template/profile.html"))
table := Showprofile()
var salahe = tampile.ExecuteTemplate(w, "Profile", table)
if salahe!=nil {
fmt.Println( salahe.Error() )
return
}
}
type showregister struct {
Namadepan, Namabelakang, Email, Alamat, Kota, Pekerjaan, Jeniskelamin string
KTP, Nohp, Usia int
}
func Showprofile() []showregister {
db := GetConnection()
defer db.Close()
ctx := context.Background()
rows, err := db.QueryContext(ctx, "select Nama_depan, Nama_belakang, KTP, Email, Alamat, Kota, No_hp, Usia, Pekerjaan, Jenis_kelamin from register")
if err != nil {
}
dataprofile := showregister{}
dataprofilee := []showregister{}
for rows.Next() {
var namadepan, namabelakang, email, alamat, kota, pekerjaan, jeniskelamin string
var KTP, nohp, usia int
err = rows.Scan(&namadepan, &namabelakang, &KTP, &email, &alamat, &kota, &nohp, &usia, &pekerjaan, &jeniskelamin)
if err != nil {
}
dataprofile.Namadepan = namadepan
dataprofile.Namabelakang = namabelakang
dataprofile.KTP = KTP
dataprofile.Email = email
dataprofile.Alamat = alamat
dataprofile.Kota = kota
dataprofile.Nohp = nohp
dataprofile.Usia = usia
dataprofile.Pekerjaan = pekerjaan
dataprofile.Jeniskelamin = jeniskelamin
dataprofilee = append(dataprofilee, dataprofile)
}
defer db.Close()
fmt.Println(dataprofilee)
return dataprofilee
}
func dbProfile(w http.ResponseWriter, r *http.Request) {
table := Showprofile()
for i := range(table) {
data := table[i]
fmt.Fprintf(w,"YESS|%12s|%12s|%12s|%20s|%12s|%12s|%12s|%20s%12s|%12s|\n" ,data.Namadepan ,data.Namabelakang , data.KTP , data.Email, data.Alamat, data.Kota, data.Nohp, data.Usia, data.Pekerjaan, data.Jeniskelamin)
}
}
and the html code
<div class="col-md-9" style="margin-top: 10px">
<input type="text" class="form-control" value=""> <p class="text-black">{{ .Namadepan }} {{ .Namabelakang }}</p>
</div>
when i was run the program, the data from database doesn't appear and there was message
I just want to show data from database to html using Go as backend.
![Can't evaluate field string in type []main.showregister](https://file.115kc.com/storage/eg/image59.jpg)