So I'm finally able to get back to this. How do I need to modify the js to get the results on seperate lines? Below is the code that calls the script that gets the data.
<script>
$(function() {
$( "#product" ).autocomplete({
source: 'search.php'
});
});
</script>
I have an ajax script that has an Inner Join and I would like to search on 2 different fields. The issue should be on the execute line however I am not sure how to implement it. The fields I need to search on are from products.name (which is what it currently is) and clientvendors.producer...
Hi Vacunita,
The problem I had was somewhere in my dbconnection.php page. I just created a connection in my script page and it worked. Thanks for all the help.
1. Can you direct me where to look to figure out how to process the returns so that each one is on its own line?
2. I was able to...
I finally got my ajax working but not quite getting the desired result. Below is the search page. There are 3 questions here...
1. The ajax results make the textbox wider that the screen. So rather than creating 1 result per line it keeps going until it runs out of room and then then returns...
Correct, I get no auctocomplete for any letters.
Version 65.0.3325.181 (Official Build) Built on Ubuntu , running on LinuxMint 18.3 (64-bit)
Firefox Quantum 59.0.1 (64-bit)
Just for grins I moved the files up to the localhost folder and changed the path for the db but still no luck.
Also, I...
As I ran this test in FF it did not work there either (normally in Chrome).
This is what I got....
https://files.engineering.com/getfile.aspx?folder=25c40d31-c3c8-46f3-92a8-f5be9d1f560e&file=Screenshot_from_2018-09-06_12-19-55.png
Yes they are both in the same folder on the localhost. And the only error I get is...
/favicon.ico Failed to load resource: the server responded with a status of 404 (Not Found)
I'm not even using a favico. Either way,would this stop it from working?
I ran it with the "master #" (UGH) It worked, there was an export of the products. So the php script is working? Is there a special textbox I need to be using?
Below is the result from the terminal. When I run the webpage I don't get any errors, but also no autocomplete. I am running linux mint with chrome browser. Hope this helps.
$ master # ( echo '<?php $_GET["term"]="e"; ?>'; cat search.php ) | php
No command 'master' found, did you mean...
I am trying to create an autocomplete textbox using ajax php and mysql, this is the first time I am trying this. I have found many websites but cannot get them to work. I have 2 pages, textbox.html and search.php. My database I use an include for "db_connect.php" and within it has a table...
I took Olaf's advice and made it a .csv with the code changes. The data is there with interesting results. And I should mention that I am running Linux Mint 17 which might explain why the SS was blank. Now I am getting css code in the csv file and I have customers with a comma in the name...
I found a script online to export my data to excel but when it opens the spreadsheet is blank. I have modified the top of the script to get the data that I need and the array is ok. This is the first time I am exporting data to a ss and am having a little trouble finding the issue. Is there...
Found the issue. In the 'And' the idclient needed to have the table added. Thanks guys. Spamjim, I never thought to take that screen output and put into workbench. Doing that told me where the issue was.
spamjim,
I am pretty much self taught and always looking to learn to be a better programmer. In this case I am not inserting into the db so I am not concerned about injection here. Should I be? I will check out the links this weekend.
Vacunita,
The code technically runs without returning...
Actaully, I have the results in MYSQL but I am trying to code the PHP to display in my webpage. It is the PHP code that is not working. I have removed the echo from the code box.
I am trying to use an inner join to display a report but am not getting any results. I have the sql in workbench and the results show up there so I'm not sure why I am not getting it through the php. Below is the code that I am echoing to the screen. $d1 and $d2 are beginning and ending dates...
Success!
I am trying to display it now and am only getting the html default image when the image is not there. I know the recordset is correct because I can display other fields from the table. The "signature" field has...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.