<?php

    error_reporting(E_ALL);
    ini_set("display_errors", 1);

    $dbhost = "localhost";
    $dbname = "musicstore";
    $dbuser = "root";
    $dbpass = "root";

    mysql_connect ($dbhost, $dbuser, $dbpass) or die("Could not connect: ".mysql_error());
    mysql_select_db($dbname) or die(mysql_error());

    $playlist = $_POST['v'];
    $user = $_POST['u'];

    // Create playlist
    $createplaylist = "INSERT INTO playlist(Name) VALUE('$playlist')";
    mysql_query($createplaylist) or die("Playlist error: " .mysql_error());
    $inserted_playlistid = mysql_insert_id();

    // Create userplaylist
    $createuserplaylist = "INSERT INTO userplaylist(UserID, PlaylistID) VALUES('$user','$inserted_playlistid')";
    mysql_query($createuserplaylist) or die("User playlist error: " .mysql_error());

    echo json_encode($inserted_playlistid);

?>