Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

PHP/Mysql Reports and Form Tools

I am looking for a tool in php and mysql which can easily run on shared hosting.

Ok. This is what i want.

I want users or admins to create forms which will be actuaklly report forms. Some othe rusers will come and enter the data in forms and submit.

Then i want the admins to come and see the data and run queries on that.

Any quick ideas. I dont mind spending upto 20 bucks for a tool.
open source is always great.
  • 3
  • 2
1 Solution
I don't really fully understand what do you want, but:

Maybe you're lookinfg for "phpMyAdmin" (http://www.phpmyadmin.net/)
Or maybe you're looking for "php Form Builder" (http://sourceforge.net/projects/pfb)
Or maybe "PHPMyReport" (http://sourceforge.net/projects/phpmyreport)
Or you can create what you need easily be yourself using PEAR packeges (http://pear.php.net/)
tgatifAuthor Commented:
these are table reports.
I m lookingf or a quick like system. in which i create questions for people in php forms. they answer.
i go and check what everyone answered.
i will have 100s of them so want a tool
So maybe this is what you're looking for:
or this:

Else, imho it's easier to create own class for your needs.
Example of form-processing class I wrote here: http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Databases/Q_21776115.html

So when you create a form you can then store answers data in database all answers in one field of text type in xml-like style:
For example, you can create two tables:
one to store questions, for example:
mysql> CREATE TABLE `questions` (`qid` int(11), `questions` text, `date` date, primary (`qid`));
and one to store answers:
mysql> CREATE TABLE `answers` (`aid` int(11), ``qid` int(11), `date` date, `answers` text, primary (`aid`));

so in `answers`.`answers` you can store somthing like this:
        <answer no=''>....</answer>

and in `questions`.`questions` you can store:
        <question no ''>...</question>

It's simple to parse this data then...
tgatifAuthor Commented:
u little genious. thanks

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now