1

I have a selectAll function which returns the results as objects. 

$customers = $app['database']->selectAll('customers');

Here is the var_dump for $customers variable just in case:

array(4) { 
    [0]=> object(stdClass)#5 (7) { ["id"]=> string(2) "10" ["name"]=> string(10) "Thisted El" ["address"]=> string(13) "Otto Monsteds" ["city"]=> string(5) "Vej 8" ["phone"]=> string(9) "503982350" ["zip"]=> string(6) "481922" ["notes"]=> string(0) "" } 
    [1]=> object(stdClass)#6 (7) { ["id"]=> string(2) "11" ["name"]=> string(11) "Bibin Vinod" ["address"]=> string(8) "Kottayam" ["city"]=> string(5) "Kochi" ["phone"]=> string(10) "0294294022" ["zip"]=> string(6) "129042" ["notes"]=> string(0) "" }
}

I need to use the 'name' property of these objects for an auto-fill form. I am using the autocomplete script in this link.

In my php file, I have added the above autofill function after the form. Then I use json_encode on this object followed by JSON.parse. I use a loop to add just the names to a javascript array, and finally I pass it to the autocomplete function. 

var js_data = '<?php echo json_encode($customers); ?>';

var js_obj = JSON.parse(js_data);

for (var i = 0; i < arrayLength; i++) 
{
   customername[i] = js_obj["name"];
}

autocomplete(document.getElementById("customers"), customername);

However the autofill form is not working. I'd like help regarding this issue. Thanks.

Improve this question
20
  • You can simplify the first two lines to var js_obj = <?php echo json_encode($customers) ?>; Commented May 15, 2018 at 9:40
  • Did you use this site to create your autocompleet? w3schools.com/howto/tryit.asp?filename=tryhow_js_autocomplete . Could you post your code of your form, with the input field you want to make autocomplete? Also did you debug your code, does customername have values in it? Commented May 15, 2018 at 10:07
  • Yes I used that link for my autocomplete. Here is the relevant part of the form: <form autocomplete="off" method = "POST" action = "database/NewProduct.php"> <div class="form-row"> <div class="autocomplete form-group col-md-3"> <label>Customer</label> <input id="customers" class ="form-control" type="text" name="customers" id="customers" placeholder="Search.."> </div></div> customername is a null array when I debug. Commented May 15, 2018 at 10:12
  • So as I understand the problem lies within the for loop since the array customername is not getting filled properly. Commented May 15, 2018 at 10:18
  • 1
    @mrdeadsven Thanks, it seems the problem was, I had to convert to first convert the php object array to a normal array. Check my answer to see my solution. Thanks a lot for your assistance. It' very much appreciated! Commented May 16, 2018 at 8:18

3 Answers 3

Reset to default
1

I have fixed the problem. First I converted the object array to a normal array in PHP:

$customers = $app['database']->selectAll('customers');

$allCustomers = array();

foreach($customers as $key => $val) 
{
    $allCustomers[] = $val;
}

Then in the javascript part, I used json encode on this variable, and used a for loop to add each 'name' property to a javascript array, and finally passed it to the autocomplete function likewise:

var js_data = <?php echo json_encode($allCustomers) ?>;

var customername = [];

for (var i = 0; i < js_data.length; i++) 
{
    customername[i] = js_data[i]["name"];
}

autocomplete(document.getElementById("customers"), customername);

Thanks a lot everyone for offering your help.

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

Comments

0

Because you simply need to change the input value instead of the div DOM 

document.getElementById("customers").value = customername;
Improve this answer

2 Comments

I do not think this works as I need to use the autocomplete function which lists down suggestions based on what I type in from this array.
there is different answer to this, but it can work you just have to replace the good DOM element. And if you check the function in your link w3schools.com/howto/howto_js_autocomplete.asp he creates a div with the new list. So just regenerate your list and append it at the right place ;)
0

js_obj is an array, you need to index it.

customername[i] = js_obj[i].name;

You could also just create an array of names in PHP. 

$customers = array_map(function($x) {
    return $x->name;
}, $app['database']->selectAll('customers'));

?>
var customers = <?php echo json_encode($customers; ?>;
Improve this answer

8 Comments

Thanks. I have made this change, but it still does not work. I have also modified the code in the original post.
Don't modify the code in the original post, then my answer makes no sense.
Sorry, I did not think about that, I shall keep that in mind next time I post. The console output is as follows: Object { id: "13", name: "ELTECHNO", address: "Knosgaardsvej", city: "aabybro", phone: "20202020", zip: "9250", notes: "ELinstallatror" } newProduct.php:261:1
Just to clarify, if I simply create a string array and pass it to the autocomplete function, it is working. So I think it has something to do with the way I'm converting it.
Correction to my above comment, from the comments on the original post, it seems the problem is within the for loop as the array is not getting filled properly.
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.