Creating a Web Survey

[bonfire28]

I am a designer who has been asked to create an online web survey for a company to integrate into thier existing site, as the company does not want to shell out to people like websurveyor etc each time. I can easily create the front end design using html but my experience of php/mysql is limited and general.

Can anyone recommend software that would handle the data on the server side(but still give freedom of designing the survey)?

Or alternatively how difficult would it be to create a Web Database Application using php/mysql for surveys?

[Perad]

This is pretty easy, you create your form in html, handle it with php and store it with mysql.

You would need a mysql server, SQL is very easy, especially for something like this. With this you would set up the relevant tables in the database, in the table you need the columns.

You would use javascript to check that forums had been correctly entered. You then handle the forum with php and input it into the database.

Whats left would be a backend which would display the data.

This should help you

http://www.zend.com/zend/tut/tutorial-jenkins.php

[bonfire28]

Thanks for the advice!

I am slowly getting there but have come across this error when trying to put info into my database.

"Error!
There was an error processing your request. mySQL returned the following:

1046
No database selected"

hoever I have selected my database using the following - (entering in correct details!!)

$dbc = mysqli_connect("localhost", "username", "password", "db_name");
if(!$dbc)
{
die('<span style="color: #F00; font-weight: bold;">Error!</span><br />
There was error connecting. mySQL returned the following:<br /><br />'.
mysqli_connect_errno().'<br />'.mysqli_connect_error());
}

do I need more code to connect properly????

[atlaskid]

To connect to a mysql DB is easy :S

Code: Select all

$username = "user";
$password= "pass";
$host = "localhost";
$db = "dbname";

mysql_connect ($host, $username, $password) or die ("MySQL database could not connect");

mysql_select_db ($db) or die ("Database could not be selected");

Which would be store din a file named connect.php, in all your pages that you need it you just do include('connect.php');