Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Marine1969

    Ajax textbox and value

    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>
  2. Marine1969

    Ajax 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...
  3. Marine1969

    Ajax textbox and value

    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...
  4. Marine1969

    Ajax textbox and value

    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...
  5. Marine1969

    AJAX - first attempt

    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...
  6. Marine1969

    AJAX - first attempt

    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
  7. Marine1969

    AJAX - first attempt

    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?
  8. Marine1969

    AJAX - first attempt

    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?
  9. Marine1969

    AJAX - first attempt

    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...
  10. Marine1969

    AJAX - first attempt

    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...
  11. Marine1969

    Export data to spreadsheet

    I got it working. Thanks for all the help!!!!!
  12. Marine1969

    Export data to spreadsheet

    I used the code Olaf posted above and there is no data that is opening in the file.
  13. Marine1969

    Export data to spreadsheet

    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...
  14. Marine1969

    Export data to spreadsheet

    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...
  15. Marine1969

    Inner Join not getting results

    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.
  16. Marine1969

    Inner Join not getting results

    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...
  17. Marine1969

    Inner Join not getting results

    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.
  18. Marine1969

    Inner Join not getting results

    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...
  19. Marine1969

    jSignature

    I changed it to default and it works great! Thank you for the help!
  20. Marine1969

    jSignature

    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...

Part and Inventory Search

Back
Top