Creating a form to update JSON Data with MySQL

Question

This is the output I need:

{
    "album": "Text_Input",
    "artwork": "DefaultURL/http://www.ggcc.tv/ArmyoftheLord/Army%20of%20the%20Lord.png/OR Overwrite with Uploaded Image",
    "church": "City Name And State Wich can be selected from Dropdown Menu",
    "cityartwork": "Default URL Will Be Set/ This input is hidden",
    "des": "Text_Input_For_Description",
    "release_date": "February 24th 2013 ",
    "tracks": [
        {
            "name": "Text_Input",
            "url": "File Upload of .MP3 which should be saved on server and its new url should be inputed here by the script"
        },
        {
            "name": "Text_Input",
            "url": "File Upload of .MP3 which should be saved on server and its new url should be inputed here by the script"
        },
        {
            "name": "Text_Input",
            "url": "File Upload of .MP3 which should be saved on server and its new url should be inputed here by the script"
        },
        {
            "name": "Text_Input",
            "url": "File Upload of .MP3 which should be saved on server and its new url should be inputed here by the script"
        },
        {
            "name": "Text_Input",
            "url": "File Upload of .MP3 which should be saved on server and its new url should be inputed here by the script"
        },
        {
            "name": "Text_Input",
            "url": "File Upload of .MP3 which should be saved on server and its new url should be inputed here by the script"
        }
    ]
}

I need a form that will collect all this information, save it to a database and output the collected entries in a single JSON file on the server, so that I can use that .json file in the app I'm working on.

Is the number of tracks constant or variable?

Fallexe
– Fallexe

2013-06-03 03:21:41 +00:00
Commented Jun 3, 2013 at 3:21 — Fallexe
– Fallexe, Commented Jun 3, 2013 at 3:21

Dave Chen · Accepted Answer · 2013-06-03 04:15:10Z

Try this:

<?php
$minimum_tracks=1;
$maximum_tracks=10;

$tracks=isset($_GET['tracks'])?$_GET['tracks']:0;

if (is_numeric($tracks) && $tracks>=$minimum_tracks && $tracks<=$maximum_tracks) {
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        $_POST['cityartwork']="Default Set from PHP";
        $_POST['tracks']=array();
        $_POST['artwork']='http://www.ggcc.tv/ArmyoftheLord/Army%20of%20the%20Lord.png';
        if ($_FILES['artwork']['size']!=0) {
            move_uploaded_file($_FILES['artwork']['tmp_name'],"artworks/".$_FILES['artwork']['name']);
            $_POST['artwork']=$_SERVER['HTTP_HOST']."/artworks/".$_FILES['artwork']['name'];
        } 
        for ($i=0;$i<$tracks;$i++) {
            $filename="tracks/".$_FILES['tracks']['name'][$i];
            $_POST['tracks'][$i]=array(
                "name"=>$_POST['track_names'][$i],
                "url"=>$_SERVER['HTTP_HOST']."/".$filename
            );
            move_uploaded_file($_FILES['tracks']['tmp_name'][$i],$filename);
        }
        unset($_POST['track_names']); 
        echo json_encode($_POST);
        exit;
    } else {
        ?><!DOCTYPE html>
<html>
    <head>
        <title>New Album</title>
    </head>
    <body>
        <form method="post" action="" enctype="multipart/form-data">
            Album Name: <input type="text" name="album"><br>
            Artwork: <input type="file" name="artwork"><br>
            Church: <select name="church"><option value="New York NY">New York NY</option><option value="Los Angeles CA">Los Angeles CA</option></select><br>
            Description: <br><textarea name="des"></textarea><br>
            Release Date: <input type="date" name="release_date"><br>
            Tracks: <br><br><?php
                for ($i=1;$i<=$tracks;$i++) {
                    echo 'Track '.$i.'<br><input type="text" name="track_names[]"><input type="file" name="tracks[]"><br><br>';
                }
                ?>
            <input type="submit">
        </form>
     <?php 
        exit;
     }
} else {
?>
<!DOCTYPE html>
<html>
    <head>
        <title>New Album</title>
    </head>
    <body>
        How many tracks are in this album?
        <form action="" method="get">
            <select name="tracks">
            <?php
                for ($i=1;$i<$maximum_tracks;$i++) {
                    echo '<option value='.$i.'>'.$i.'</option>';
                }
            ?>
            </select><br>
            <input type="submit">
        </form>
    </body>
</html>
<?php
}
?>

Shoan · Accepted Answer · 2013-06-03 03:28:49Z

2

You can create a form with the form elements named with an array index ex: <input type="text" name="record[album]"/> and so on.

After the form is posted to the server, you can use json_encode($_POST['record']), after validation of course, to get the desired json output.

answered Jun 3, 2013 at 3:28

Shoan

4,0881 gold badge29 silver badges31 bronze badges

Comments

Fallexe · Accepted Answer · 2013-06-03 03:33:38Z

1

To add to Shoan's answer: You also need to create a button with a javascript handler to create more inputs so the user can add more tracks as needed. The additional inputs need to look like this:

<input type="text" name="record[tracks][n][name]"/>

Where n is the number for the next track.

answered Jun 3, 2013 at 3:33

Fallexe

5962 silver badges11 bronze badges

Collectives™ on Stack Overflow

Creating a form to update JSON Data with MySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related