Query script

[Warlock]

How do i make query script where i will be able to select boxes and define what i want to see as output?Something like on this site:
(MOD: Link removed due to content of external site)
Since that should'nt be to hard i am sure there are such script on hotscripts.com but i dont know how to describe script.

[cahva]

Well it wouldnt be hard to make this on your own. If you check that examplesites source, you can see that all the checkboxes have array-like names and thats very easy to go through them using foreach or similar function.

Heres your "hot script" 😉

<?php
if (isset($_POST['show'])) {
    if (!empty($_POST['foo']))
        print_r($_POST['foo']);
    else
        echo 'None selected';
}
?>
<form method="post" action="<?php echo $_SERVER['SCRIPT_NAME']; ?>">
<input type="checkbox" name="foo[]" value="Test 1" />Test 1<br />
<input type="checkbox" name="foo[]" value="Test 2" />Test 2<br />
<input type="checkbox" name="foo[]" value="Test 3" />Test 3<br />
<input type="submit" name="show" value="Show" />
</form>

[Warlock]

cahva wrote:

Well it wouldnt be hard to make this on your own. If you check that examplesites source, you can see that all the checkboxes have array-like names and thats very easy to go through them using foreach or similar function.

Heres your "hot script" 😉

<?php
if (isset($_POST['show'])) {
    if (!empty($_POST['foo']))
        print_r($_POST['foo']);
    else
        echo 'None selected';
}
?>
<form method="post" action="<?php echo $_SERVER['SCRIPT_NAME']; ?>">
<input type="checkbox" name="foo[]" value="Test 1" />Test 1<br />
<input type="checkbox" name="foo[]" value="Test 2" />Test 2<br />
<input type="checkbox" name="foo[]" value="Test 3" />Test 3<br />
<input type="submit" name="show" value="Show" />
</form>

That is html code howmuch i see what with code which connect to mysql database ?

[cahva]

Well you didnt specify your skills. Previous script shows how you can fetch the checkboxes. This really scares me if you dont know how to connect to database at all. You should really read the Mysql section from PHP manual. In most cases the manual is your best friend. Theres lots of examples when you look at the functions.

I encourage you to try create this thing from scratch. You will learn a lot in the process(form handling, mysql etc.) and this is very good practice.

Design the tables in your database. This thing needs atleast 2 tables: one for categories and one for content. For example:

CREATE TABLE `category` (
`id` INT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM ;

CREATE TABLE `content` (
`id` INT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`category_id` INT( 8 ) UNSIGNED NOT NULL ,
`content` TEXT NOT NULL ,
INDEX ( `category_id` )
) ENGINE = MYISAM ;

That would create you 2 tables:

category       content
--------       -------
id             id
name           category_id
               content

Before I go any further, does anything I wrote to you make any sense? 🙂 Have you done any work with mysql/php before? In order to write php/mysql stuff you would need to understand mysql syntax as well.