CODEWITHSUNDEEP
javascriptphpmysqldatabase
CS Student
CS Student

Reputation: 83

Fetch data from database and send it to javascript function

I am selecting input values from the database and I want to send it to the javascript function addVal() so that I can retrieve this value. I do not want to use echo. It is not working right now and I don't know how I can make it work.

<h1>trial,</h1>
 <div id ="val">   </div>
  <?php
 $name = $_POST['postname'];

$host = 'localhost';
$user = 'root';
$pass = 'root';
$db_name="big";



$conn = new mysqli($host, $user, $pass, $db_name);


if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
echo "connected";
$sql = "SELECT input FROM trial_db";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while( $row = $result->fetch_assoc()) {
        $value = $row['input'];
        addVal ($value);
    }

}
?>

<script>
    function addVal (value){
        document.getElementById("val").innerHTML+= value ;
    }
</script>

Upvotes: 0

Views: 2316

Answers (1)

Niklesh Raut
Niklesh Raut

Reputation: 34914

Calling js function from php will not work remove that code from php.

And change in js.

<script>
  function addVal (){
     var value = "<?php echo $value; ?>";
    document.getElementById("val").innerHTML+= value ;
  }
</script>

Will only work if js and php codes are in same php file.

Upvotes: 1

Related Questions