Warning suppression?
Folk, I'm not having a lot of success with my provider, so I'll ask here. Is there any way to turn _show warnings_ off from script? I cant seem to find anything relevant. I'm getting a warning that, Supplied argument is not a valid MySQL result resource . . .. I don't see any way to test for this. Have I overlooked something? Or can I disable the warnings from PHP? Or am I just stuck with this? Make a good day . . . . . . barn ~ If you can't beat them, arrange to have them beaten. -George Carlin ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Warning suppression?
this is more a php question then mysql, but if you put a @ before the commands that are giving you warnings, it should cause it to not show them Didn't start happening until the provider upgraded the MySQL engine, and the _show warnings_ is a MySQL configuration, according to the MySQL docs. The warnings don't show up on my development server, just on the provider's server and just since the upgrade. 'Preciate the @ hint, but I'm trying to avoid that - too much work, I'll miss somehting, and I have no idea what other warnings could pop up, so I won't always know where to place the @s. Thanks for the reply, though. Make a good day . . . . . . barn ~ No trumpets sound when the important decisions of our life are made. Destiny is made known silently. --Agnes De Mille, Dancer ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is there a way to time queries?
Folk, Two or three years ago, I was using ASP to access SQL Server 7 and MS Access databases. There was a stopwatch dll made by CapRock Software that allowed me to time various elements of my ASP scripts, particularly the database queries. I found several SQL problems that way, and made my queries much faster as a result. Is there anything similar to that stopwatch dll that I could run in my PHP scripts to check the time on my MySQL queries? I'm seeing some slowdowns, but can't quite nail them down, and would like to determine if it is PHP or MySQL that I need to address. Any help would be appreciated. Make a good day . . . . . . barn ~ Housework is what a woman does that nobody ever notices unless she doesn't do it. -- Anonymous ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Anyone have MySQL/PHP running from CD?
Folk, A friend has asked me to help her to create some business card CDs (with her web on them) that she can use to promote her business. The web uses PHP, with MySQL for the database engine . . . it hasn't been published yet, still in the throes [up] of creation. I've found MicroWeb, which purports to do just what we need, but it's a bit steep for a startup on a shoestring budget - $300 for a developer's license. Haven't checked it out yet, so I cannot speak to its effectiveness. Anyone know of anything else that might do the job, preferably at a lower cost, open source or maybe freeware? It would need to run transparently, i.e., autorun or run one executable that would fire up PHP, MySQL, and the default web browser for the machine using the CD. 'Twould be nice if it was OS/platform independent, but it'll need to run on Windows 9x/NT/2K at the least, and should work with Win ME/XP as well. 'Preciate any aid on this. Make a good day . . . . . . barn ~ Wear a smile and have friends; wear a scowl and have wrinkles. ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to use LAST_INSERT_ID() or mysql_insert_id() ?
Folk, I know this is an old query, but still, problems . . . I've tried these both, but something is amiss - probably my interpretation. Every time I try to use LAST_INSERT_ID() I get a complaint that the query has a problem. E.G., $qry=$qry.;select LAST_INSERT_ID(); will blow up on me every time I've evaluated $qry, and it works just fine until I append the piece that should let me recover the auto increment value that was created during the insert process. I'm using, according to phpinfo(), MySQL 3.23.32 and PHP 4.0.5 on Win2K with IIS 5.0. I've dredged up everything I could find, but nothing I've tried seems to work. I've created tables specifically for the purpose of testing, with no more than an ID field and a character field, to ensure that I wasn't encountering some other insert problem. I'm quite at wit's end here, and hope that one or more of you can show me where I've gone astray. Make a good day . . . . . . barn ~ Some men are discovered, others are found out!! ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Soliciting best approach for storing passwords . . .
Folk, I need some input on how best to store username/password combinations online. My preference would be to store a one-way encrypted value, but that is not possible in this situation. The constraint is that we have to make provision for giving the user's password back to the user after a forgot my password link has been clicked. (Oh, a secondary input would be on the best way to accomplish the password return to the user grin /.) Normally, I store passwords as a one-way hash, then encrypt input to see if it matches, but I can't do that this time: I have to store a clear text or decryptable value. I've seen several approaches to this, but don't see any clear 'best practice'. Right now I'm leaning toward a multiple table design, but I have no real idea if this is a better model than a single table design. I'd really appreciate input from some of you who have wrestled with this problem before. If it matters, the development box is Win2K/IIS5, PHP 4.0.5, MySQL 3.23.32, and the implementation box is *nix/Apache 1.3.22, PHP 4.1.1, MySQL 3.23.47. I'd appreciate any suggestions for a best resolution. Thanks. Make a good day . . . . . . barn ~ If you're not confused, you're not paying attention ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Soliciting best approach for storing passwords . . .
Thanks, César, But this is not an option that is negotiable for me. The client mandate is very clear, and the reason behind it has a strong business case from their standpoint. I'm not about to get them to change their minds . . . they and I have been over this way too many times already. Make a good day . . . . . . barn ~ It is my ambition to say in ten sentences what others say in a whole book. - Friedrich Nietzsche ~ (sql, query) I asked the same question couple of weeks ago and all the answers I got pointed to one way encryption. Actually, I had the same need that you, but understood that it was better to reset the password when a Forgot password was made, send it to the user and ask them to change the password at the next login. . . . After all the responses I've get regarding this issue, I never got the answer to how do a two way encrypting so, if this doesn't help you... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Soliciting best approach for storing passwords . . .
Thanks, Peter, Yeah, I had looked at ENCODE()/DECODE() and ABS_ENCRYPT()/ABS_DECRYPT() as possible tools, as well as some inherent PHP functionality. My real question is more about database design than about the mechanics of encryption. But I do appreciate the feedback. Make a good day . . . . . . barn ~ Save a tree. Eat a beaver. ~ (sql, query) regarding two way encryption see http://www.mysql.com/doc/M/i/Miscellaneous_functions.html and ENCODE(str,pass_str) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote MySQL administration problem . . .
. . . Folk, Is there a good PHP product that allows for remote MySQL administration? I'm trying to use phpMyAdmin v2.2.26, but it keeps throwing up errors ab. functions not being available. I'm new to this venue, so I'm probably missing something, likely in great chunks, but I've yet to find a way to make it work in browse/edit mode. I'm trying to set up a MySQL database on a hired server, and the only way they will let it work is to use localhost, which means I have to admin the database from within PHP scripts, at least as far as I understand it. Is there something other than phpMyAdmin that will let me do this? Or am I going to have to groan / write my own manager? 'Preciate any help. Make a good day . . . . . . barn ~ If life deals you lemons, make lemonade; if it deals you tomatoes, make Bloody Mary's. ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php