This is the page I want to replicate. http://www.diversionsdance.co.uk/conten ... D=26&lID=1
My dad's webdesign company "Imaginet" is being really akward and I want to replicate the entire site with some of my own mods ( http://phpman.frih.net/div ) but I havn't been able to duplicate that oviously because of the server side PHP and MySql (presumably) code. I want to have my computer able to access entered data through "access". How would I go about doing this?
I want a form to save user's data to a database
Moderator: General Moderators
Re: I want a form to save user's data to a database
First of all, congratulations on your redesign. You obviously know how to design a nice looking web page. But if I understand what you want to do, there are a whole host of new skills you will need to learn. And you will have to have the cooperation of whoever hosts your frih.net site. Does it support PHP or ASP? Does it support MySQL or MS Access? So the first step is for you to find out what kind of support is available from frih.net. The diversionsdance.co.uk host obviously supports PHP (looking at source code, it calls a .php script in the form action attribute). If frih.net is a Linux/Apache/MySQL/PHP site, that's one thing, but if it's a Microsoft site, you'll need to learn some ASP (VBScript or Javascript) and MS Access (although the details of using different database engines are mostly trivial).m0u53m4t wrote:This is the page I want to replicate. http://www.diversionsdance.co.uk/conten ... D=26&lID=1
My dad's webdesign company "Imaginet" is being really akward and I want to replicate the entire site with some of my own mods ( http://phpman.frih.net/div ) but I havn't been able to duplicate that oviously because of the server side PHP and MySql (presumably) code. I want to have my computer able to access entered data through "access". How would I go about doing this?
Assuming that frih.net supports PHP and MySQL, you will need the sysadmin to set up a MySQL username and password for you. Then you will need to create your database and table(s). Probably you'll need only one table.
After that, you can begin to write the PHP code required to connect to your new database and allow visitors to create records in it. You should be keenly aware of the potential mis-use of your user interface by malicious visitors or by bots. For that reason, you will need to add data validation code to your PHP scripts.
Have you ever written HTML pages that contain a <FORM>? You'll need to know how to do that.
If you succeed in getting a MySQL username and password, my advice to you is to set aside your nice new page for awhile and create a very simple page, so you can learn and test out the process of connecting to a database, writing 2 or 3 fields to a table, and reading and displaying that data. If you try to do that in your beautiful, but complicated web page, you'll just make it harder for yourself.
Good luck.