Cougar

Thanks, Megan, My problem with the source that you listed is that it doesn't explain things that I know will be important to me as a newbie, such as defining the statement commands and the results commands and how to interact with the connection pool. However, it's a great API, and provides a good reference for required parameters, etc. In my continued searching, I found someone on a support forum who was referring to code that he had found in the book "PHP and MySQL Web Development, 4th Edition," by Luke Welling and Laura Thomson which was full of mysqli commands. I found this on Scribd at this link: http://www.scribd.com/doc/15016825/PHP-and...ent-4th-Edition and on Scribd, it is listed as having a Attribution Non-commercial Copyright, which I can't confirm or deny. I don't know if this book answers my questions completely, but starting on page 270 in Chapter 11, mysqli commands are used in the tutorial examples, as well as the production project examples that start on page 583, Chapter 27. I hope this information is helpful to other people. If anyone else has anything to offer to this discussion, please add it, because there really is a dearth of good instruction with the mysqli extensions. I guess even a newbie like myself can share useful information with the open source PHP community--even before I really know anything about what I'm learning. Thanx, Cougar

I've spent a bunch of money on new PHP books, and I've inherited three more that also cover PHP 5. Then after I began reading them, I discovered that best practices are that we don't use mysql programming, but that we upgrade to mysqli programming. Unfortunately, not one of the books I bought covers the MySQLi extension and how to program with it. When I Google for a book that covers the "improved" mysql, and when I go to Amazon and use the "search inside" feature, it's only covered in an appendix or an occasional mention, like an afterthought. Although I'm a newbie at PHP, I was a senior technical writer at Fujitsu and Brodia in the pre-crash economy, I wrote sections about programming in a book about Cold Fusion, I wrote a production-ready JDBC class and JavaScript adapter for it while at Fujitsu, and I did hobby programming in C#, VB6, and Java. So I'm no slouch. But I do not find the manual at mysql.com to be very helpful, because it doesn't explain enough: See http://dev.mysql.com/doc/refman/5.1/en/apis-php-mysqli.html The best resource I've found on the internet is the php manual on the phpbuilder.com website, but it also doesn't explain things that I, as a newbie, need to know: http://phpbuilder.com/manual/en/book.mysqli.php These materials aren't really very good tutorials. The phpbuilder materials are the best of all of them, but there's a lot that is not well explained, and I'm still struggling to just learn the basics. All of the groovy new books I've bought are with the old version of coding. So I'm trying to learn PHP and simultaneously translate all of the mysql commands into the best practices improved mysqli. Is there anything that you can recommend to me? A book in which ALL of the sample coding is done with the mysqli extensions? A book that doesn't require me to crawl through it translating clear samples into samples that don't work until I've worried it to death? Why isn't this need obvious in the industry? On the NetBeans site, there's a CRUD example using the older version, and there's a button at the bottom of each page to provide feedback. So I left a very polite suggestion that perhaps the sample coding on the NetBeans site should use what MySQL.com says is best practices, and the person who responded was initially annoyed with me for making that suggestion (and then apologized, when I pointed this out). How do I learn this stuff? Does the industry disagree with the MySQL development team that says that using the mysqli extension is best practices? Why am I getting this strange response when I'm trying to avoid starting out my work using obsolete coding practices? What can you recommend? Thanks in advance.

Thanx. That worked.

Oh, yeah, when I first tried to sign in from the command line as root with no password as suggested in the O'Reilly book, I was no more successful. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Sorry for the wrong title, but I had a bunch of questions, most of which I resolved by searches and other things. What's left makes me crazy in that it's so basic. So when I originally posted this post I forgot to change the title, and for whatever reason, I'm not seeing the button or other control to delete the post and start over. I apologize in advance for my lack of what may be common information. I'm a newbie on a huge programming mission that will take me several years, I don't work as an IT professional, and my time is limited by being a caregiver for a disabled person. I've done the CRUD tutorial on the NetBeans site and the first half of PHP for Dummies, so I have a UniServer v5 Nano system that's working--from within NetBeans. Now I'm working my way through the O'Reilly Learning PHP, MySQL, and JavaScript book. I have four more PHP books as well, but none of these helps me with real simple questions that I'm supposed to be smart enough to figure out. The O'Reilly book wants me to learn how to access MySQL as root from the command line with no password. However, this doesn't work. {ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: YES)} When I try to use the common passwords that I would normally use, it doesn't work as well. When I go into phpMyAdmin, I find a place to change my password as root, but I'm afraid to do so for fear that I'll break all the things that are working right now. I've verified my password at C:\PHP\UniServer\htpasswd\home\admin\www\.htpasswd and C:\PHP\UniServer\htpasswd\home\ssl\.htpasswd. How can I log into MySQL from the command line without breaking the system that I've put together that is working for all other things? This seems like sort of basic information. Sorry for being such a non-techie.