Untitled

<html lang="en">
    <head>
        <title>Upload Image Without Page Refresh!</title>
        <script type="text/javascript" src="js/jquery.min.js"></script>
        <script type="text/javascript" src="js/jquery.form.js"></script>

        <script type="text/javascript" >
            $(document).ready(function() {
                $('#submitbtn').click(function() {
                    $("#viewimage").html('');
                    $("#viewimage").html('<img src="img/loading.gif" />');
                    $(".uploadform").ajaxForm({
                        target: '#viewimage'
                    }).submit();
                });
            });
        </script>
                <script type="text/javascript" >
            $(document).ready(function() {
                $('#submitbtn2').click(function() {
                    $("#viewimage2").html('');
                    $("#viewimage2").html('<img src="img/loading.gif" />');
                    $(".uploadform").ajaxForm({
                        target: '#viewimage2'
                    }).submit();
                });
            });
        </script>
        <script type="text/javascript" >
            $(document).ready(function() {
                $('#submitbtn3').click(function() {
                    $("#viewimage3").html('');
                    $("#viewimage3").html('<img src="img/loading.gif" />');
                    $(".uploadform").ajaxForm({
                        target: '#viewimage3'
                    }).submit();
                });
            });
        </script>

    </head>


 <?php
    if(isset($_POST['submit']))
    {
        if (!$_POST['author'] OR !$_POST['name'] OR !$_POST['rotation'] OR !$_POST['class'] OR !$_POST['symbols']){
            echo "Required field was not filled in.";

        }
        else{

            $name = $_POST['name'];
            $author = $_POST['author'];
            $abilinfo = $_POST['abilinfo'];
            $talinfo = $_POST['talinfo'];
            $rotation = $_POST['rotation'];
            $class = $_POST['class'];
            $symbols = $_POST['symbols'];
            $curid = $_POST['curid'];
            $gid = $_POST['gid'];
            $link = mysqli_connect("SERVER","USERNAME","PASSWORD","DATABASE");
            $query = "UPDATE guides
            SET name =  '$name', abilities = '$gid', abilinfo = '$abilinfo', talents = '$gid', talinfo = '$talinfo', rotation =          '$rotation', class = '$class', symbols = '$symbols', rings = '$gid', author = '$author'
            WHERE id = '$curid'";
            $stmt = $link->prepare($query);
            $stmt->execute();
            if (mysqli_connect_errno()){
                exit('Connect failed: ' .mysqli_connect_error());
            } else {
            }
        }
    }else{
        $classes = array('Tank','Knight','Paladin','Support','Alchemist','Lightbinder','DPS','Archer','Berzerker','Cryomancer','Gunner','Kinetic','Monk','Necromancer','Slayer','Witch');
         list($c1, $c2, $c3, $c4, $c5, $c6, $c7) = $classes;
         $servername = "SERVERNAME";
         $username = "USERNAME";
         $password = "PASSWORD";
         $dbname = "DATABASENAME";
         $curid = "0";
         //create connection
         $conn = new mysqli($servername, $username, $password, $dbname);

         //check connection
         if ($conn->connect_error) {
             die("Connection failed: " . $conn->connect_error);
         }
         $conn->select_db("epiz_17275951_guides");
        $sql = "INSERT INTO guides (name, abilities, talents, abilinfo, talinfo, rotation, additional, class, author, symbols, rings)
        VALUES ('a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a')";
         if ($conn->query($sql) == TRUE){
             $sql = "SELECT id FROM guides ORDER BY id DESC LIMIT 1";
             $result = $conn->query($sql);
             while ($row = $result->fetch_assoc()) {
                        $curid = $row["id"];
                        echo $row['name'];

                    }
         }
echo $curid;
echo " <form action='newguide.php' method='post' id='classinfo'></form>
 <center><h1>Make sure you click submit on each image upload before clicking the final submit button at the bottom of the page</h1></center><br><br>
 <h3>Required information:<br>
 <li>Guide name</li>
 <li>Class</li>
 <li>Author</li>
 <li>Abilities screenshot</li>
 <li>Talents screenshot</li>
 <li>Rings screenshot</li>
 <li>Rotation</li>
 <li>Symbols</li>
<h2>Author</h2>
Please put your in-game name.<br>
<textarea name='author' cols='30' rows='1' form='classinfo'></textarea>
<h2>Guide name</h2>
<textarea name='name' cols='50' rows='1' form='classinfo'></textarea>
<h2>Class</h2>
<select name='class' form='classinfo'>
<option value='Alchemist'>Alchemist</option>
<option value='Archer'>Archer</option>
<option value='Berzerker'>Berzerker</option>
<option value='Cryomancer'>Cryomancer</option>
<option value='Gunner'>Gunner</option>
<option value='Kinetic'>Kinetic</option>
<option value='Knight'>Knight</option>
<option value='Lightbinder'>Lightbinder</option>
<option value='<Monk'>Monk</option>
<option value='Necromancer'>Necromancer</option>
<option value='Paladin'>Paladin</option>
<option value='Slayer'>Slayer</option>
<option value='Witch'>Witch</option>
</select>
 <h2>Abilities</h2>
  <form class=\"uploadform\" method=\"post\" enctype=\"multipart/form-data\" action='upload.php' id='abilities'>
                Upload screenshot of abilities <input type=\"file\" name=\"imagefile\" />
                <input type=\"hidden\" name=\"ids\" value='". $curid ."' form='abilities'>
                <input type=\"hidden\" name=\"class\" value=\"Abilities\" form='abilities'>
                <input type=\"submit\" value=\"Submit\" name=\"submitbtn\" id=\"submitbtn\" form='abilities'>
            </form>

            <div id='viewimage'></div>
                        <h3>Additional ability information</h3>
            Input any explanation of abilities in the following textarea.<br>
            <textarea name='abilinfo' cols='100' rows='10' form='classinfo'></textarea>
<h2>Talents</h2>
  <form class=\"uploadform\" method=\"post\" enctype=\"multipart/form-data\" action='upload2.php'>
                Upload screenshot of talents <input type=\"file\" name=\"imagefile\" />
                <input type=\"hidden\" name=\"ids\" value='". $curid ."'>
                <input type=\"hidden\" name=\"class\" value=\"Abilities\">
                <input type=\"submit\" value=\"Submit\" name=\"submitbtn2\" id=\"submitbtn2\">
            </form>


            <div id='viewimage2'></div>
            <h2>Additional Talent Information</h2>
Input any explanation of talents into the following textarea.<br>
<textarea name='talinfo' cols='100' rows='10' form='classinfo'></textarea>
<h2>Symbols</h2>
Put any symbols recommended/required for the class in the following text area. Please specificy which are required, and which are recommended.
<textarea name='symbols' cols='100' rows='10' form='classinfo'></textarea>
            <h2>Rings</h2>
  <form class=\"uploadform\" method=\"post\" enctype=\"multipart/form-data\" action='upload3.php'>
                Upload screenshot of best ring <input type=\"file\" name=\"imagefile\" />
                <input type=\"hidden\" name=\"ids\" value='". $curid ."'>
                <input type=\"hidden\" name=\"class\" value=\"Rings\">
                <input type=\"submit\" value=\"Submit\" name=\"submitbtn3\" id=\"submitbtn3\">
            </form>

            <div id='viewimage3'></div>
<H2>Rotation</h2>
<textarea cols='100' rows='10' form='classinfo' name='rotation'></textarea><br>
            <input type='hidden' name='gid' value='".$curid.".jpg' form='classinfo'>
            <input type='hidden' name='curid' value='".$curid."' form='classinfo'>
            <input type='submit' value='Submit Guide' name='submit' id='submit' form='classinfo'>
    ";
    };
    ?>