Any pro or hobbyist web developers out there is Fab land? Looking for some info......
I have a website, which has a contact form on it which simply forwards the the input as an e-mail to me. I want to step things up and I am looking to store the details in a database for future reference/marketing?
What is the easiest way to do this, can it be done automatically using code?
For the concerned out there, I do have a published Privacy Policy  |
Reply privately, Reply in forum +quote
or View forums list | |
 |
By *ipsTeaserCouple
over a year ago
here and there, thereabouts |
Php is a good start. Can be done using notepad our better still notepad++. Use MySQL database for storing data. No license costs involved and plenty of help out there
Me personality,I prefer c# asp.net and sql server for the database but there are costs for visual studio involved
Bugs |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
May i just ask, do you ever test the fucking things yourself? Make it more useable by the viewer.
You know, like when you're trying to find a holiday and you have to keep inserting the saem date several times over? |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
There are many ways, simplest and cheapest is MySQL & php if you have a proper website these are usually avAilable in the package.
How you go about it depends on your level of ability or budget.
PM me if you want more specific assistance. |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
SQL Express would be better than MySQL,
but if you're not a techy, then you need to pay one to do it for you.
as I'm sure you know, people dont work for free |
Reply privately, Reply in forum +quote
or View forums list | |
|
By (user no longer on site)
over a year ago
|
"Cheers for the replies guys.
Was hoping it would be straight forward using the SQL packages that come with web hosting, so will look into it a bit further now."
It is quite straight forward'ish... Most paid hosting companies offer some form of database in the package, usually MySQL as it's much cheaper to host than even the free SQL Express rivals (lower hardware and support costs)
But to be honest unless you are receiving thousands of contacts per minute any old database will be just fine.
If you have a basic knowledge of HTML then search for a PHP guestbook script, this usually consists of a data form to take the user input, which is written to the database, and a separate form for reading data back from the database.
Use the code from the input side which will validate the data, and store it in the database. create a page around it using your graphics / text.
Then to be fancy have a search for JQuery Scripts for guestbook entry which will tart up the input at the user end...
Use the output for yourself only with appropriate security to read back and display the data.
Breakdown is
Backend Database, can be same server often isn't but is on same Domain.
PHP operates on the server BEFORE the web page is sent to the user, hard to hack (nothing is impossible) as it only sends it's output over the Internet.
JavaScript operates on the users browser so real time but very hackable... but gives the most interactive feel to the user. (N.B. often doesn't work on office PC's or XP running older browsers, so be sure the basics still function without the JavaScript)
|
Reply privately, Reply in forum +quote
or View forums list | |
» Add a new message to this topic
