Larry

if (empty($_POST['$first_name'])) { You need to get rid of that dollar sign there before "first_name".

I don't regularly use MySQL workbench for queries so I'm not positive what's going on but it sounds like you've hit upon the issue.

I'm fairly certain that search engines rank secure sites more highly. In fact, I think Google is starting to drop non-secure sites from their results. All in all, there's very little reason not to implement HTTPS all the time.

What are the URLs involved? Changing a domain, subdomain, or folder, could be the cause.

Hey Hassan! Thanks for your questions and for the interest in the book. I don't have any plans to make a new edition now, which means it definitely wouldn't be in 2018. I just updated a different book for PHP 7 and there's not much, if anything, that is significantly different for the second edition, especially as it doesn't do any OOP. In short, I think this edition is still fairly current. Let me know if you have any other questions!

Oh, fantastic! Thanks so much for letting us know and kudos!!!

Excellent. Thanks, Abigail!!!!

In what interface are you seeing this? When running a script or when using the command-line MySQL client or...?

You haven't provided much information, but that cursor in the MySQL client indicates you have started a string--you have an opening single quote--and it's waiting for you to complete the string.

Agreed. Thanks for sharing!

No problem, it happens! Let me know if you have any other questions or issues along the way!

view_users (Script 9.4) is https://github.com/LarryUllman/phpmysqlvqp-5ed/blob/master/ch09/script_09_04/view_users.php I think we're talking about two different repos. The link you posted is for the Visual QuickStart Guide. The code for the Visual QuickPro Guide (PHP and MySQL) is https://github.com/LarryUllman/phpmysqlvqp-5ed You'll find the CSS files there, too.

Hey. Thanks for the question and for the nice words. I always try to begin learning any new thing with one, or preferably more, things I want to accomplish. So if I were learning programming, I'd want to make sure I have specific applications, however small, I want to create.

Ah, excellent. Kudos for figuring it out and thanks for sharing your solution!

So sorry for the confusion! Could you confirm an example of a scrip that's explained in the book that's not present in the GitHub repo? I could be mistaken, of course, but I'm fairly sure they're all there. Thanks!

Hmmm...okay, I don't have a great (i.e., obvious) answer here as it's not an issue I've come across before. My inclination is to use a cookie to store the IDs of open child windows. You'd have to remove the IDs upon closing. Then, if the parent window is closed accidentally, upon re-open it could look at the cookie to see what child windows should exist. What do you think? Or you could add an event handler to the close event on the parent window that prevents the closing of the parent window should a child window still be open.

This is just a note to say that I haven't officially created any "Review and Pursue" threads in this forum yet as I didn't know what, exactly, readers would want. So feel free to post your questions as you have them and I'll answer them as they come. In time I may then shuffle things around to create an organized "Review and Pursue" system. Thanks for your interest in the book!

This forum is specific to the fifth edition of the book "PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide", written by Larry Ullman and published by Peachpit Press published in November 2017 (ISBN 0-13-430184-6). If your question pertains to something specifically written in the book, including a particular script or bit of code, please make sure you're posting in the forum for the correct edition. If your question is not related to any book, that's fine, too.

This issue happens when the client MySQL library (e.g., used by PHP) doesn't match the MySQL version. It really surprises me that this would be an issue with MAMP, however. Did you install PHP or MySQL separately, either before or after you installed MAMP?

Yes, that's exactly correct!

Unfortunately MS SQL doesn't necessarily support the same syntax and functions as MySQL. If you look at the image in the book (Figure D, page 220), that command did work exactly as entered for my version of MySQL at the time of the book's writing. Although I just reran it using a more current version of MySQL and now I'm getting the same error as you. Looks like this was a change in MySQL 5.7.5: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by This article talks about the issue more: https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html I tried a couple of things but didn't come up with the obvious answer (aside from disabling ONLY_FULL_GROUP). Will investigate more!

Thanks so much for the very kind words. Really appreciated! And thanks to iromao for helping out!

Hmmm...what version of MySQL are you using?

Sorry about the confusion! Earlier in the book or chapter you'll find a reference to AS, which creates an alias. So just after the bit you posted there will be something like `FROM messages AS m` which simply says "for the sake of simplicity, let's call this table 'm' in most of this query". Just can also create aliases for column names and the results of function calls. Hope that helps!

Sorry for the confusion! Yes, this should be used on *any* user-submitted data. Forms are very easy to manipulate and I could easily provide to your site any value whatsoever as my ZIP code or salutation. I'd always go with the most strict function you can get away with, which normally means strip_tags().