Posted by Christo on 10/30/69 11:18

ok i know some basic php

I have done a bit of C++ and it seems very similar, basically what i want
is, someone or somewhere on the net that will give me a very clear guide to
the ways which i can take the contents of a form and then add those contents
into a database (mysql)

also how to construct the database (i have phpmyadmin) i really only want 4
fields in the database they are listed below...

Number
Name
Email Address
Location

and i just want to create a form interface that will add the contents of the
form into the database, for example

Name
Email Address
Location

I want the number to be incremented automatically in the database, so for
example say John Smith was to enter his information

John Smith
john@smith.com
England

his number (John Smith) would be 0001

then if Joe bloggs was to enter his details

Joe Bloggs
joe@bloggs.com
USA

joe bloggs number would be 0002

I want to then display these entries on a page, displaying them like this

0001 John Smith john@smith.com England
0002 Joe Bloggs joe@bloggs.com USA

I would really prefer only displaying about 250 entries per page, so say
there was 500 entries in the database, then I would prefer a button at the
bottom of the first page of 250 names etc that gives the user the option to
go to page 2, or links along the top

<< 1 | 2 | 3 | 4 >>

if you know what i mean.

does this system sound hard to create? I am a bit of a novice with PHP and
would appreciate any help i can get at all, I know the basics of programming
so I should be fine grasping any new concepts, its just getting the stuff
from the form into the database then from the database onto a page/pages

I must emphasize the need for splitting the list up into pages, I am
expecting at least 4000 entries, and having this amount on one page would be
crazy!

Thanks In Advance


--

Christo

[Back to original message]