Sending an array from PHP to javascript

Question

In the PHP file can anyone help me directly making a for loop where I don't know the number of rows that are going to be selected.

<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "mydb";//database details
    $conn = new mysqli($servername, $username, $password, $dbname);

    if ($conn->connect_error) 
    {
        die("Connection failed: " . $conn->connect_error);
    } 

    $sql = "SELECT * FROM mytable";
    $result = $conn->query($sql);
    $myarray = array();
    $index = 0;

    if ($result->num_rows > 0) 
    {
        // output data of each row
        while($row = $result->fetch_assoc()) 
        {
            $myarray[$index] = $row["firstname"];
            $index++;
            $myarray[$index] = $row["lastname"];
            $index++;
            $myarray[$index] = $row["email"];
            $index++;
        }
    } 
    else 
    {
        echo "0 results";
    }
    $conn->close();
?>

The Javascript code contains javascript of a search bar suggestion code and here i didn't mention the typeahead javascript file

var substringMatcher = function(strs) {
    return function findMatches(q, cb) {
        var matches, substringRegex;

        // an array that will be populated with substring matches
        matches = [];

        // regex used to determine if a string contains the substring `q`
        substrRegex = new RegExp(q, 'i');

        // iterate through the pool of strings and for any string that
        // contains the substring `q`, add it to the `matches` array
        $.each(strs, function(i, str) {
            if (substrRegex.test(str)) {
                matches.push(str);
            }
        });

        cb(matches);
    };
};

$('#the-basics .typeahead').typeahead({
    hint: true, //here i used typeahead js code though i didnt mentioned here
    highlight: true,
    minLength: 1
}, {
    name: 'states',
    source: substringMatcher(states)
});

if you don't know the number of rows, you have to make a while loop — ᴄʀᴏᴢᴇᴛ
– ᴄʀᴏᴢᴇᴛ, Commented Feb 1, 2017 at 8:36

Manoj Sharma · Accepted Answer · 2017-02-01 08:47:47Z

0

You can simplify the PHP a little bit here when you read in the values as you dont need to increase the index:

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mydb";//database details

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);//making a connection
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT * FROM mytable";
$result = $conn->query($sql);
$myarray = array();
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        $myarray[] =$row["firstname"];
        $myarray[] =$row["lastname"];//storing in the array
        $myarray[] =$row["email"];
    }
} else {
    echo "0 results";
}
$conn->close();
?>

You could echo in the results to the Javascript where you require them, echo($myarray[0]) for example.

Your Javascript may look something like this:

var matches = <?php echo($myarray[0]); ?>

edited Feb 1, 2017 at 8:47

Manoj Sharma

1,4552 gold badges13 silver badges20 bronze badges

answered Feb 1, 2017 at 8:40

Philip Thomson

17310 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

luci thomas Over a year ago

thanks and can u plz help me how can i connect the php file to the html or js file and i need the php file to run on loading the page and thanks in advance

Philip Thomson Over a year ago

You can put PHP in with HTML code, just ensure the file is .php

luci thomas Over a year ago

thanks but can u plz tell me how it can be done as i have to do in different files and how do i have to pass the array and if i need to write on same file how should it be done and thank you very much

luci thomas Over a year ago

all i need is to bring that "myarray" in php file to javascript file as soon as the page gets loaded.thanks in advance

Philip Thomson Over a year ago

var firstname = <?php echo($myarray[0]); ?> will load the firstname into javascript variable, the PHP has to be in the same file as javascript for this

Community · Accepted Answer · 2017-05-23 11:45:29Z

-1

There are 4 ways you can do to insert dynamic content to your javascript code.

Make the javascript inline to your PHP page. That is, putting your js code inside <script> tags
Make the dynamic js variables global and populate them in your php page. Your separate JS files will be able to read these global js variables.
If you want to have a separate file for JS, you have to generate it everytime (because you cant have PHP code in javascript. The browser cannot interpret it, and the server cannot interpret it)
If you want to force the server to interpret PHP code in JS files, add a handler so that .js is handler by the php interpreter (whether php module or php-cgi) see Clean links to PHP-generated JavaScript and CSS

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Feb 1, 2017 at 8:41

Kyle Domingo

5311 gold badge4 silver badges14 bronze badges

Collectives™ on Stack Overflow

Sending an array from PHP to javascript

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related