从html表单保存数据库中的值

Question

I have a form where the image is getting displayed with a link that is getting carried from behind.

<form action="a_insert_vendor.php" method="post">
    <div class="module_content">
        <article class="stats_graph">
            <div class="module_content">

                <fieldset>
                    <label>Name</label>
                    <textarea rows="2" name="name"><? echo $_GET['fn'];?></textarea>
                </fieldset>     

            </div>
        </article>

        <article class="stats_overview" style=" margin-right:60px; height:120px; width:120px;">
            <img name="image" src="<? echo $_GET['p'];?>" width="120" height="120" alt="word" />
        </article>

        <div class="clear"></div>
    </div>
    <footer>
        <div class="submit_link">
            <input type="submit" name="submit" value="Submit" class="alt_btn">
        </div>
    </footer>
</form>

Everything gets saved or lets say gets carried to next page, in this form i am able to carry the name and save it in database, but in the case of image, it seems that i am not able to fetch and carry it to next page.

i tried this on a_insert_vendor.php page

$image = mysqli_real_escape_string($con, $_POST['image']);
$sql="INSERT INTO vendor(imagee) VALUES ('$image')";
if (!mysqli_query($con,$sql)) 
{
  die('Error: ' . mysqli_error($con));
}

But it showed no result. can anyone guide me

Answer 1

if you want save link to image, you must add hidden field with link value, for example insert in your form:

<input type="hidden" name="image" value="<? echo $_GET['p']; ?>">