Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by fatkatie

  1. The public firewall suddenly started blocking access. Turn it off and site is available. So the fix will be to add a rule.
  2. I've been running an xampp apache distribution on a windows 10 box for a year. It's worked just fine. This morning no one could get to it. The site works on the host. Other boxes can ping the ip address. The service starts and stops without new errors ("server certificate does NOT include an ID which matches the server name" is an old friend). Any ideas before I reinstall it? I might just go out and hire a guy too.
  3. Took 2 hours to come to the same conclusion. Clipboard and Excel. It's an exercise in vigilance. Still though I have yet to see a good time recording application. The time 'clocks' at various employers, even the mechanical ones, were in constant need of HR support or breaking down. It was painful to watch employee interaction. There's some money to be made out there. Thank you. (Post it notes ... never)
  4. Has anyone a good example of a job tracking time entry page? Each of our machines have internet access and use it for various things (Yah, I couldn't believe it either first time I saw it. These machines can seriously hurt you and it's a something to see the machine panel running with yahoo on the side. We're looking for something with a start stop field and ability to edit. (Clocks don't always get 'stopped' when the job is complete. Sometimes they aren't started.) We're not afraid of fraud. We want something to keep the whining to a minimum. The job clock can stop but can restart (lunch for example). Thank you.
  5. No, I meant validate as in a legal windows 10 file name; just the name, not a path. This validation would include length, special names and characters ... and who knows what else. Thank you.
  6. Is there a class out there that validates window filenames? Thank you.
  7. All is well. Typo. Working as before. Really thou, is it possible to nuke this post. This was a bogus claim and will just add to the windows update noise. Thanks all for your help. Only took 4 hours to find it. @#$!!
  8. It appears the binding is not allowing empty fields. But why now. The strict is off (or was). in toad's window I can write these two inserts. The first fails. The second does not. insert into info (infoid, infoindex values ('', ''); insert into info (infoid, infotext) value (null, null); both fields are default null. both are ints. C:\xampp\htdocs\csc> mysql -e "SELECT @@sql_mode;" +--------------------------------------------+ | @@sql_mode | +--------------------------------------------+ | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +--------------------------------------------+ Also checked the table. Practice aside, this was working yesterday. .
  9. (every site should have a win10 update section) mysql/php-pdo/xampp insert constructs are suddenly failing (running fine for a year) after an overnight update. Here's the error code. error code: HY093 error msg: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined binding: Array I'm chasing it (cut this part out.....cut that part out) but while I'm doing this I thought I'd see if anyone else is having this experience mysql Ver 15.1 Distrib 10.1.38-MariaDB, for Win64 (AMD64), win10 pro, 1903, 18362.356 Thank you
  10. Yes, the best fix is answering why are two messing about with the same data. The page is a projects 'encompassing' calendar that shows all project schedules. The fix would be to restrict scheduling to the job owner or a master scheduler. But I can't do that now. I'll need to think about this The 1st, the time stamp, is great. I didn't cross my mind; and that last update value is already there. The second could be a lot of work, and given I should really address the access, it would be a waste of time as a temporary fix. Thanks for the quick comeback. Time stamp it is.
  11. I have never had to worry about concurrent users given the size of my audience. But, things have changed on one particular input webpage. I have a webpage that is used by project managers. It is now likely that two managers will concurrently access and modify the same page. For example; Both userA and userB are on this page. userA changes dateInstall and userB changes dateRun. After userA saves his form, userB saves his. userB's unchanged dateInstall overwrites userA's update. And so it goes. I can think of a few ways to stop this but what a mess. How do you professionals deal with this? Thanks.
  12. Op... I think I'm on my way. Feel free to nuke the post if you wish. Thank you.
  13. It's not working , but after a login, can it be this simple? curl_setopt($ch, CURLOPT_URL, $gotoUrl); $content = curl_exec($ch); echo $content;
  14. I'm a little familiar with Perl's lwp and I've scraped a few sites. But I've never logged in remotely AND presented a 'protected' page to the user. Is it possible to login remotely and then open a page for a user via a link? We have the credentials but we're sick of the login dance. I'll invest some time figuring it out if someone can tell me if this is even possible. Thank you.
  15. This is what I wound up with (you need your wits). var next_row_id = e.parentNode.parentNode.nextElementSibling.id Thanks again for the road map.
  16. lol The shampoo routine... wash rinse repeat. No, just a few rows. Thanks. I can't use jQuery but I see what your doing. I'll do a w3schools thing and look at the dom things. And you nailed the html. That's exactly what I'm doing. Thanks again.
  17. Greetings to All, I have a table with multiple rows. These row are added and removed dynamically based on this or that. In row 'A' I have a select box with its onchange event set to a javascript function. I need to discover, from within this function, if the next row has an id with a particular format (id string starts with 'shipping'). How can I get this id? - There is always a next row. It always has an ID. - Additional TD elements may, or may not, follow the TD containing the select box element. - This is a 'single level' table construct (no tables within tables). Thank you.
  18. Being a trigger virgin the new. and old. references confused me, but now I'm off. The code is good enough to almost use verbatim. Thanks for your 'comment'. Thanks again.
  19. So ... Barand... been there done that I see. Thanks. I'll digest this and let you know. Looks good thou at first glance.
  20. Only the project managers have access to their pages (each pm owns his 'record(s)' and no other may edit) The traffic is low. It is unlikely two would hit the table at the same time. It's impossible that two would hit the same record at the same time. The application is web based - login - no table locks are used. This table is read by many other pages/reports - not modified. Thank you.
  21. I'm on a new path here and would appreciate any ideas you pros might have. I think this involves triggers and another table but am not sure. I have a project record that has fields that contain information. It's important to know when some fields change. For example, I have a field call DRAWING which contains a link to a project print. Values in this link change whenever the print is modified. It's important to know the date of the last change. When the project page is opened for review, I want to show, to the right of this field (and a few others), the date/time is was last changed. I want the time information field based, not record based. My initial idea is to trigger after a record update and compare an 'identical' table against the project table. After checking the fields of interest for change I would write the project table associated lastupdate fields with a date and then overwrite this 'identical' table with the new state of things. This all could be done with code but it gets a bit onerous. I was hoping to do it once in a stored procedure. Comments? Thank you. 10.1.38-MariaDB
  22. I know apache writes a log that contains this information. Does php has a function that can obtain apache's last restart time? xampp, w10 (lastest stuff) Thank you.
  23. @#$@#$@! You spend all day on something that has nothing to do with anything. It was a stupid join. mb_check_encoding But, I would like to know if mb_check_encoding() is worth anything. I've relied on binding which has never failed me. Thank you.
  24. while ($pending || $row = $sth->fetch(PDO::FETCH_OBJ)) { $pending = false; $hn = $row->houseid; writeData("READ $hn", __FILE__, __LINE__); } There's the loop. houseid starts repeating. I found the record but I don't see anything wrong yet. Newlines? I'm going to rewrite the record with the check and see what that does.
  25. I just started populating a mysql table with data collected from a form posting. I do the dance ... $post_partnumber_source = html_entity_decode(trim(fvs($_POST['nsel_pnsrc'])));where fvs is function fvs($string){$string = filter_var($string, FILTER_SANITIZE_STRING); return $string; } And then I use PDO and binding. Something has happened. Something bad. My PHP $sth->fetch(PDO::FETCH_OBJ) loops are failing. All the records are not being read (some seem to be read twice)... and it happens around the record when form input was starting to be used. It's got to illegal data messing this up. So, my question is, what now? Will mb_check_encoding() solve this or am I missing something very basic. Thank you. mysql Ver 15.1 Distrib 10.1.37-MariaDB, for Win32 (AMD64), Using configuration as supplied by xampp
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.