highly educated question regarding website polls...
Home > Home Recording Forum > Computers & Software > highly educated question regarding website polls...
Posted on Jan 29, 2007 11:03 pm
zekthedeadcow
Eat Spam before it eats YOU!!!
Member Since: May 11, 2002
I need a poll on my website... running Linux/Apache ... how the heck do I set one up?
[ Back to Top ]
Jan 30, 2007 05:02 am go to www.hotscripts.com and grab a poll/survey script and use it. hotscripts.com/PHP/Script...ting/index.html
I am just gonna venture a guess and hope you already have PHP installed, and hopefully MySQL...you'll need a database of some sort unless you wanna store your stuff in a flatfile (yuck).
Surveys can actually be very complex scripts, I know since I work for an opinion survey and data reporting company and develop their web tools...but we run all legacy Classic ASP and now Java for the newer apps...
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 30, 2007 07:41 am yeah, php works fine but I'm oblivious on how to use MySQL...
Jan 30, 2007 08:02 am You want to look for a simple little flatfile type thing then. If it's a small single question poll or something it'll be OK, if it's a big survey it'll get fugly.
neoificIdiot KidMember
Since: Sep 27, 2006
Jan 30, 2007 10:09 am Do you have a control panel setup? I remember webmin had an auto-install thing that worked with redhat.
Then, you'll have to install mod-mysql for PHP or else it wont support the mysql commands needed (This is assuming you didn't build it with it already enabled).
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 30, 2007 10:54 am ok I got a flatfile poll going, didn't need much. However I would still like to get MySQL going as it is something I should have in the futire.
I don't have a graphical interface for contoling apache. I've just been editing the httpd.conf file and restarting. I 'think' the apache version is 2.2... it's the standard slackware 11 version... and in the httpd.conf file there is no Include for a mod_mySQL though mySQL is mentioned in the mod_php section.
# ==> mod_php configuration settings <==
#
# PACKAGES REQUIRED: openssl-solibs (A series) and/or openssl (N series),
# mysql (AP series), gmp (L series), mhash (L series),
# and apache (N series)
#
Include /etc/apache/mod_php.conf
# ==> mod_ssl configuration settings <==
#
# PACKAGES REQUIRED: apache (N series) and openssl (N series)
#
#Include /etc/apache/mod_ssl.conf
so I'm assuming that mysql supprt is included in mod_php...
however when the server starts up the MySQL process shuts down usually before I can even log in. I think it's because theres no databases listed in some config file.
pjkPrince CZAR-mingMember
Since: Apr 08, 2004
Jan 30, 2007 11:47 am create a php file, with just the command
<?
phpinfo()
?>
in it, and nothing else. open this file in your browser, and you should see boatloads of stuff, regarding the running of php.
Somewhere on that list should be a mysql section. If it's there, then you're all set. If not, then you'll have to see about installing it, regarding what distro you're using.
If it's working, I'd advise installing PhpMyAdmin. This is a graphical front end to your mysql databases. It's the bomb-diddly, and I use it much. I can get in and command-line in mysql, but i'm not too inclined to do it, when phpmyadmin working so well.
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 30, 2007 04:29 pm ok, I think I got it going now, but user admin isn't working..I tried installing db's Curium CMS... and had to go with the root accout to get it working... and still in regestration it's giveing a "A CAPTCHA error has occured!"
I had to manaually ..err... open in a text editor and do find/replace... for all the #PreFiX# stuff...
hmm...
pjkPrince CZAR-mingMember
Since: Apr 08, 2004
Jan 30, 2007 05:16 pm I kinda ran into the same thing. I looked through there, and was doing something wrong, or didn't see the right thing, cuz I didn't get it going either.
I ended up pulling some inet scripts to do the things I wanted done.
Let me know if you want to get into mysql, as I've gotten a few db running on different projects for work / home. We can do it offline, if preferred.
I'm sure there's people on here more experienced at it, but i've got time on my hands here and there through the day, so I can chime in with helpers.
neoificIdiot KidMember
Since: Sep 27, 2006
Jan 30, 2007 05:50 pm mod-mysql is for php, not apache.
You don't need a graphical environment. Find a copy of mod-mysql, read the readme on what to add to php.ini, and then build it.
Restart apache for epic win, and you are good to go.
Jan 30, 2007 06:10 pm CAPTCHA requires the GD libraries and freetype support...just turn those off.
And for the love of god, don't use root...
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 30, 2007 06:30 pm heh but root gets things done :)
where do I disable CAPTCHA?
Jan 30, 2007 06:41 pm Yeah, until your config file gets hacked or something and the user/pass they get from it is the ROOT!
CAPTCHA is in the setup manager...
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 30, 2007 07:31 pm hmm...when I go to log in after creating the admin user is just keeps reloading the login page
Jan 30, 2007 07:34 pm I would suspect your cookie domain in the options.php is goofed...try the IP, or, just leave it empty.
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 30, 2007 07:39 pm yep that was it. w00t :)
Jan 30, 2007 08:44 pm in a following version I hope to sometime have a survey system built into Curium...
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 31, 2007 11:50 am ok one last terribly insignificant thing DB... how the heck are forums set up?
I've added a forum module page... and then another forum module page as a subforum... and then two more under that... but nothing allows posting and all I get are "No forums currently available."
www.track100.com
Jan 31, 2007 11:53 am set up categories for the forum groups and subcategories for each forum within the groups.
Awesome idea for a site.
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 31, 2007 12:15 pm I think thats what I'm stuck on... how do I mark something as being a catagory?
in the consol manager I have:
4 Forums
5 <tab> test
6 <tab><tab> work
6 <tab><tab> work2
Jan 31, 2007 12:25 pm Go into the forum module and add the ctaegories there, just like any other module.
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 31, 2007 12:56 pm yeah, thats what I've been doing ( think). added a forum module called forum that is in the top level... added a form module test who's heirarchy is forum... added a a forum module called work and set heirarchey to forum-test.
they are showing up as subcatagories but there's no 'post new topic' etc.
Jan 31, 2007 01:03 pm Not in the management console...in the forum module, which you should see in the bottom modules list if you have given yourself permissions for it.
zekthedeadcowEat Spam before it eats YOU!!!Member
Since: May 11, 2002
Jan 31, 2007 01:12 pm ahhhh...oookk... I see now... I didn't give myself permission.
