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 Chriss Miller 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: *

  • Users: rogerte
  • Content: Threads
  • Order by date
  1. rogerte

    How to parse associative array

    I have a json_decoded string passed by AJAX array in the format : Array ( [dta] => [ { "a" : 1, "b" : "string" , "c" : ""}, { "a" : 8, "b" : "string 2" , "c" : "12/12/2022"} ] [vars] => [ 7, 12 ] ) The items pointed to by dta need to be looped through...
  2. rogerte

    Code that works on Windows, Android and Iphone

    I have written a program for internal use using, mainly, PHP, but also has a lot of Javascript. It works absolutely fine using WIndows devices (including Windows phones), Android phones, and for the most part iPhones, but there are some items that don't work properly using the latter. Generally...
  3. rogerte

    Javascript updating form control not working

    Have form that has a select list, change button, textarea and submit button. When page is loaded PHP sets up variables, and the textarea and submit button are disabled with the textarea displaying placeholder text. What should happen is when the user selects an item from the list and then...
  4. rogerte

    How to have several datepickers on same HTML page

    During this lockdown period I have decided to help a local sports charity by finishing-off an online management system written using, primarily bootstrap 4 and php. One thing I want to do is a system to set up dates that sessions will be available for forthcoming term. So I set up a form with 6...
  5. rogerte

    Saving table data to MySQL

    I have just about finished my first ever PHP project (a Sports Club Management System converted from a Del[phi app) and I am left with one thing to complete. The attendance register. More specifically saving the data back to the MySQL table. Everything else works fine Basically the attendance...
  6. rogerte

    SELECT Query works in phpMyAdmin but not in PHP program

    Hi, If I enter the following SELECT statement in phpMyAdmin it works ok SELECT A.class_id, A.attend, A.mem_id, B.firstname, B.lastname FROM attendance AS A INNER JOIN memberdetails AS B ON B.mem_id = A.mem_id WHERE A.class_id=5 ORDER BY B.lastname, B.firstname ASC but if I try the following...
  7. rogerte

    Unselected Listbox values

    Another newbie question! I know you can get the option value of selected items in a listbox from the $_POST variable, but is it possible to determine all items in a listbox (selected and unselected) following a post submit. What I am trying to achieve is: A form has 2 listboxes. By selecting...
  8. rogerte

    best way to update mysql database

    Relatively new to PHP (and now retired so teaching myself as I go) I am trying to go down the PDO route, as I think it is more secure than mysqli. I have been looking at example code and when it comes to form actions (ie. loading data from table, updating table or deleting rows) some examples...
  9. rogerte

    Trying to sum time values

    I have a worksheet that contains three columns Columns A and B contain identifier strings, and column C contains a time value in the format hh:mm I am trying to write a function that stores, on a separate summary sheet, the total time where columns A and B contain specific data (e.g. if there...
  10. rogerte

    How to set/get a bootstrap select items index

    Just started using PHP/MySql to convert old Access program. Using Bootstrap to speed things up. Generally it is going ok, except for using the Select input In the data table dayofweek is stored as an integer (1=Monday etc). I can get back that value ok, but am struggling with trying to show it...
  11. rogerte

    Porting an Apex application

    Not sure if this is the correct place, but hopefully it is. I have ported a simple sports club membership system from Access to Application Express, and it works fine on my PC. I have now been asked to see if it can be put on the Club's website host server, so can be used by other Club...
  12. rogerte

    CDO - Excel 2007 Transport Error

    Hi. We have an excel 2007 that emails out PDF invoices. It uses CDO code that has been working fine for the last 2 years using gmail as the email system. We have now changed to our own website address, and have changed the parameters to those required by the ISP. Have tried ports 25, 465 and...
  13. rogerte

    How to create a virtual gift wall

    I have created a website for a small charity. Now they want to start a fundraising page based on the standard buy a brick campaign, where every sponsor will have their name added to a brick. Initially they want a virtual wall on the website, that will be transferred to a physical wall when the...
  14. rogerte

    Excel 2007 Row indicator changed

    Hi, Have been given a strange problem to solve. A user has somehow managed to change the row indicator font and color, making it extremely difficult to read. Everything else, including column headers, use the default Calibri font. I have been unable to work out how to change the row indicator...
  15. rogerte

    CSV file import failing since Windows 10 update

    Hi, I am using Excel 2007, and have used a daily CSV import routine for the last 6 years on Win 7 and 8.1 with no problems. Since the PC updated to Win 10 (I didn't mean to, but pressed wrong button!) it has failed during the import routine at the TextFilePlatform line, with an Invalid...
  16. rogerte

    Excel VBA to create thunderbird email with attachment

    If have an Excel 2007 workbook that on one page holds holds invoice data (name, invoice items and eMail address) and the other page contains an Invoice template. I have created a VBA macro that runs through every line of the invoice data worksheet, filling the template with the required data...
  17. rogerte

    Excel VBA to create email

    If have a workbook that on one pag holdse holds invoice data (name, invoice items and eMail address) and the other page contains an Invoice template. I have created a VBA macro that runs through every
  18. rogerte

    Displaying contents of text file

    Now that Twitter has changed their API we can't use that medium to create "news items" for our website. So rather than have to update HTML pages I thought we would go down the "upload simple text file and let javascript take care of it" route. I threw together a javascript file (news.js)...
  19. rogerte

    Is it possible to delete the workbook you have opened?

    Hi I have created a Workbook_Open macro that reads in the contents of a text file, makes some modifications, saves the modified spreadsheet, without the VBA code, to another workbook without the VBA code in it, and then closes the workbook. This all works ok! Private Sub Workbook_Open() Dim...
  20. rogerte

    Finding a component and setting its font properties

    Hi, Simple button click handler that applies to several buttons on a page. The code determines which (speed)button is pressed (all have a numeric suffix (e.g. MainButton1, MainButton2 etc) and then displays a corresponding Tabsheet. That bit works ok, but I am also trying to set the font...

Part and Inventory Search

Back
Top