Jump to content


How do I set up a data entry form for a database?

  • Please log in to reply
5 replies to this topic

#1 marklcfc



  • Joined: 30-March 05

Posted 08 November 2012 - 16:49

The database in itself, is simple enough. I basically want 4 fields on a php page that when data is entered in them, they go into a new row in the specified database on my server. Here are the details

database table = transfersout

and then the following rows where i would enter some information

playerid =
sellto =
selldate =
loan =
loanenddate =

for loan and loanenddate, I would like these to stay as NULL unless I enter something in there.

If this is difficult to achieve is there a tutorial anywhere?

#2 OP marklcfc



  • Joined: 30-March 05

Posted 04 March 2013 - 19:25

Is there a tutorial for this anywhere?

#3 Kami-


    ♫ d(-_-)b ♫

  • Tech Issues Solved: 3
  • Joined: 28-July 08
  • Location: SandBox

Posted 05 March 2013 - 12:07

Which PHP framework are you using? (If not, why not?)

#4 +Nik L

Nik L

    Where's my pants?

  • Tech Issues Solved: 6
  • Joined: 14-January 03

Posted 05 March 2013 - 12:13

Write form in HTML
Form submits submits to PHP script
PHP script connects to database
PHP script calls stored procedure with cleaned form values as parameters

#5 Haggis


    Neowinian Senior

  • Tech Issues Solved: 17
  • Joined: 13-June 07
  • Location: Near Stirling, Scotland
  • OS: Mint 17.1
  • Phone: Samsung Galaxy S5

Posted 05 March 2013 - 12:16

you could use any tutorial for data entry

this guestbook one for example


#6 Sandor


    Neowinian Senior

  • Joined: 28-November 03
  • OS: Win 8.1

Posted 06 March 2013 - 19:30

Pretty easy to achieve but will it be on a live website?

If so you'll need some way to stop random people accessing it