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.
tgatifAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tgatifAuthor Commented:
u little genious. thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.