PHP/Mysql Reports and Form Tools

Posted on 2006-04-13
Last Modified: 2008-02-01
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.
Question by:tgatif
    LVL 6

    Expert Comment

    I don't really fully understand what do you want, but:

    Maybe you're lookinfg for "phpMyAdmin" (
    Or maybe you're looking for "php Form Builder" (
    Or maybe "PHPMyReport" (
    Or you can create what you need easily be yourself using PEAR packeges (

    Author Comment

    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
    LVL 6

    Expert Comment

    So maybe this is what you're looking for:
    or this:

    Else, imho it's easier to create own class for your needs.
    LVL 6

    Accepted Solution

    Example of form-processing class I wrote here:

    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...

    Author Comment

    u little genious. thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
    Part of the Global Positioning System A geocode ( is the major subset of a GPS coordinate (, the other parts being the altitude and t…
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now