Jump to content



Photo

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


  • Please log in to reply
5 replies to this topic

#1 marklcfc

marklcfc

    Neowinian

  • 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

marklcfc

    Neowinian

  • Joined: 30-March 05

Posted 04 March 2013 - 19:25

Is there a tutorial for this anywhere?

#3 Kami-

Kami-

    ♫ d(-_-)b ♫

  • Tech Issues Solved: 2
  • 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: 2
  • 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

Haggis

    Neowinian Senior

  • Tech Issues Solved: 10
  • Joined: 13-June 07
  • Location: Near Stirling, Scotland
  • OS: Debian 7
  • Phone: Samsung Galaxy S3 LTE (i9305)

Posted 05 March 2013 - 12:16

you could use any tutorial for data entry

this guestbook one for example

http://www.phpeasyst...m/phptu/15.html

#6 PhilTheThrill

PhilTheThrill

    Neowinian Senior

  • Joined: 28-November 03
  • Location: Canada
  • OS: Win 8.1
  • Phone: WP8

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