how to post textarea value into database

Question

I'm having trouble with posting values typed into textarea. everything else works well, any idea how to make it work?

HTML:

<form id="formData2" action="artistuploader.php" method="post" 
enctype="multipart/form-data">

        <input type="hidden" name="size" value="1000000"></input>
        <br/>
        <input id="inputField" type="text" name="actname" placeholder="Act Name" >
        <br>
        <input id="inputField" type="text" name="fullname" placeholder="Full Name" >
        <br>
        <input id="inputField" type="text" name="genre" placeholder="Genre" >
        <br>
        <textarea id="inputField" name="biography" form="formData2" placeholder="Biography"<?php echo $biography; ?>></textarea>
        <br>
        <input id="inputField" type="file" name="artistImage" placeholder="Artwork" >
        <br>
        <input id="inputField" type="text" name="imagepath" placeholder="Image path URL" >
        <br>
        <input id="submitButton" type="submit" name="uploadArtist" value="Register Artist">

    </form>

PHP

<?php

$msg = "";

//if Upload button is pressed
if (isset($_POST['uploadArtist'])){
    $target = "uploads/artistPics".basename($_FILES['artistImage']['name']);


    //connecting to our database
    $db = mysqli_connect("127.0.0.1", "user", "pass", "tablename");
    $tmp_name = $_FILES['artistImage']['tmp_name'];
    $name = $_FILES['artistImage']['name'];
    //getting the submitted form data
    $ActName = $_POST['actname'];
    $FullName = $_POST['fullname'];
    $Genre = $_POST['genre'];
    $ArtistPhoto = $_FILES['artistImage']['name'];
    $imageURLpath = $_POST['imagepath'];
    $Biography = $_POST['biography'];//having problem with this line here

    //saving submitted data into database table songsDB
    $sql = "INSERT INTO  artistsdb (ActName,FullName,Genre,ArtistPhoto,Biography,imageURLpath) VALUES ('$ActName','$FullName','$Genre','$ArtistPhoto','$Biography','$imageURLpath')";
    mysqli_query($db, $sql); //stores the submitted data into table

    //now moving the uploaded image to uploads folder
    if(move_uploaded_file($_FILES['artistImage']['tmp_name'], $target)){
        $msg = "Uploaded Successful";
    }else{
        $msg = "There was a problem uploading Data";
    }
}

//header("refresh:1; url=index.php"); ?>

Where have you set the variable $biography that you are outputting in textarea? — Ahsan Ali, Jan 01 '18 at 09:47
im new to php, this is my attempt of piecing it up together. so do i have to set a variable "biography" to make it work? im not sure where to go from here. — user8525625, Jan 01 '18 at 09:52
Then please go along and read some tutorials about it. Your code is open for [SQL vulnerabilities](https://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php?rq=1) — Nico Haase, Jan 01 '18 at 09:54
im asking for help mate and you are telling me to go read about it, but anyway thanks. — user8525625, Jan 01 '18 at 10:00
It depends on you if you want to set any value to textarea than you can. Or you may check it like this `` — Ahsan Ali, Jan 01 '18 at 10:01

score 0 · Answer 1 · answered Jan 01 '18 at 09:32

0

Replace your textarea with

 <textarea id="inputField" name="biography" form="formData2" placeholder="Biography"><?php echo $biography; ?></textarea>

answered Jan 01 '18 at 09:32

Ahsan Ali

4,951
2
17
27

hi, i replaced the textarea, and issue persisted, – user8525625 Jan 01 '18 at 09:37
the browser says theres an issue with this line in my PHP, $Biography = $_POST['biography']; – user8525625 Jan 01 '18 at 09:38
I think the issue is with `$biography` variable that you are outputting in `textarea`. replace it with `` – Ahsan Ali Jan 01 '18 at 10:11

how to post textarea value into database

1 Answers1