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

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

PHP/Mysql Reports and Form Tools

Hi,
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.
0
tgatif
Asked:
tgatif
  • 3
  • 2
1 Solution
 
ixtiCommented:
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/)
0
 
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
0
 
ixtiCommented:
So maybe this is what you're looking for:
http://sourceforge.net/projects/phptransform
or this:
http://sourceforge.net/projects/fproc

Else, imho it's easier to create own class for your needs.
0
 
ixtiCommented:
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:
<answers>
    <person>
        <name>...</name>
        <birthdate>..</birthdate>
    </person>
    <data>
        <answer no=''>....</answer>
    </data>
</answers>

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

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

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