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 Andrzejek 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: cmayo
  • Order by date
  1. cmayo

    Migrating VM Pro MS SQL database to MySQL, and creating a web interface to update database

    @ipohead I checked there before posting here. Their forum sections are quite specific about the topics under discussion and none of the defined areas seemed appropriate. Edit: I actually just stumbled onto the Avaya support forums (https://support.avaya.com/forums/index.php) which seem more...
  2. cmayo

    Migrating VM Pro MS SQL database to MySQL, and creating a web interface to update database

    I'm a retired web developer who's been asked to help someone migrate their MS SQL IP Office database to MySQL, and to create a web interface where the client's staff can make database updates without having to involve their technical people (the example given was modifying the database to set a...
  3. cmayo

    Is PHP/PEAR MDB2 dead? Which PHP abstraction layer should I use?

    I'm retired now and the only system I still work on uses MDB2 for PHP database abstraction. That client has recommended me to someone else for some dev work and while I'm still happy with MDB2, I'd prefer not to write a new system using a dead abstraction layer. So is MDB2 still kicking and/or...
  4. cmayo

    Need contact forms processing recommendation

    I've been given to understand by our hosting company that contact forms are vulnerable to spamming and can be exploited for use as a bulk mail relay. I turned up one possible method at (https://jonathannicol.com/blog/2006/12/09/securing-php-contact-forms/). I haven't done a lot of research into...
  5. cmayo

    Need contact forms processing recommendation

    I'm looking to implement Google's reCAPTCHA v2 "I am not a robot" captcha on several web forms, which will integrate best for us if it submits to a PHP (vs. PERL) script. Our contact/info forms are currently submitting to a 2004 PERL script, NMS FormMail, which seems to just line up form keys...
  6. cmayo

    Piping email to PHP - how does PHP read STDIN?

    We pipe incoming email through a PHP script for distribution in our CMS. After processing, we save the raw mail to the filesystem for later debugging, if necessary. Occasionally, PHP will miss a mail attachment and complain that it can't be found, but if we run the mail parser on the saved raw...
  7. cmayo

    ZipArchive::close is terribly slow when executed by Apache2

    I think I've determined that the bottleneck lies with my shared hosting provider. The code runs in 20 seconds on my home Ubuntu box. I've opened a ticket with them.
  8. cmayo

    ZipArchive::close is terribly slow when executed by Apache2

    Thanks for the reply! I got my hopes up for a minute, but it looks like setCompressionName was introduced as of PHP 7 and we're still on 5.6. I probably should have mentioned that in my post.
  9. cmayo

    ZipArchive::close is terribly slow when executed by Apache2

    I'm creating a zip archive using PHP's ZipArchive functions. My code performs well enough on small archives but on larger jobs, the time difference between running the PHP script from the shell and running it from a browser is just ridiculous. The script below, for instance, executes in ~37...
  10. cmayo

    LIKE with wildcard where the string being matched ends with a non-digit

    Perfect, thanks feherke. I figured some kind of regex voodoo would do the trick, but I've never had any success trying to learn regular expressions.
  11. cmayo

    LIKE with wildcard where the string being matched ends with a non-digit

    How can I write a query using LIKE with a wildcard where the string being matched ends with a non-digit? For instance, I need a match on "LIKE 'Stale Ticket #13530%'" which will match the following values: Stale Ticket #13530 Stale Ticket #13530 | Notice 4 But not these values...
  12. cmayo

    PHP Comparing Base 64 strings

    If that's the case, I'm going to have a problem searching for like values in the database. MySQL provides a FROM_BASE64() function for use in queries, but that would only partially decode the values. I guess I'll try reversing the encoding process before I insert into MySQL and insert the...
  13. cmayo

    PHP Comparing Base 64 strings

    It seems like after the initial encoding, the base 64 value is just a string, to which other base 64 strings are appended as the thread grows. If the base 64 strings are never re-encoded but simply appended to other base 64 strings, how would the original string change? I do intend to do much...
  14. cmayo

    PHP Comparing Base 64 strings

    Thanks, all. As I understand it, the original value, i.e. AdH1tsVUVHkXt/ZLS4eksRmXC4Q5Ig==, becomes a pseudo-unique identifier and is never re-coded during the process. As the email thread grows, additional 5-byte values are appended to the original value to indicate subsequent mails' position...
  15. cmayo

    PHP Comparing Base 64 strings

    Bear with me... I think my question really is about comparing base 64 encoded strings... In a mail parsing app, I've come across incoming mail where the In-Reply-To and References headers have been stripped out and replaced by a Microsoft/Outlook Thread-Index header, and need to start...
  16. cmayo

    Do PHP file uploads perform any kind of integrity checking?

    These were PDFs which, a couple years after being uploaded via an HTML/PHP upload form, couldn't be opened in Acrobat. We're also missing a few files (90 out of ~57,000). The number of problem files is very, very low (0.015%) but still, it would be good to know if the missing/corrupted files...
  17. cmayo

    Do PHP file uploads perform any kind of integrity checking?

    >> Not unless you [or the author of the code] wrote something into the script to do so. Simple enough for in-system operations once the file's been uploaded, but I guess I'm more concerned with verifying that user files aren't corrupted during the upload. I won't have any way of generating a...
  18. cmayo

    Do PHP file uploads perform any kind of integrity checking?

    I've recently found some corrupted files in an upload directory, leading me to wonder whether the upload process does any checksum comparisons while it's handling uploaded files. For instance, when a file is uploaded from a user PC to the server's temp directory, is any checking...
  19. cmayo

    WGET is getting my IP blocked on remote server - how to avoid rapid reconnections?

    I decided to move from wget to rsync, which seems to have solved the problem. When I originally chose wget, I wasn't able to find a Windows implementation of rsync which didn't require a complete Cygwin installation. I've since found cwRsync which requires only two EXE files and a smattering of...
  20. cmayo

    Linux Script or Cronjob

    Can you post a log excerpt showing the data you'll be searching for?

Part and Inventory Search

Back
Top