[when i try to create the table users (on page 573), i got the following error. but i do not know the reason. please help]

You have a typo. For the email you have "VARHCAR" when it should be "VARCHAR". 

[Date_format function not working.]

Glad that's working for you and thanks for letting me know about the emails. I'll look into it. Cheers!

[Date_format function not working.]

My inclination is it's either not being stored or retrieved in a format that PHP can use. I'd check/confirm your column type. Also, it's best not to use "Date" as a column name since it's also a keyword in MySQL.

That being said, I'd have MySQL return the data in the format you want, rather than ask PHP to convert it. 

[Separating numbers and alphanumerics]

Hey Max. Kudos for figuring it out and thanks for sharing the solution. The first thought that came to my mind would be to store the coordinates in separate columns. In other words, split the coordinates upon receipt and then store them in two columns. That'll make future work easier to do. 

[Using Msmtp + gmail in Php and mail function how can I see the email address of the sender when I receive the email?]

Hey Nick, are you setting a "from" address when you send the email?

Also, it may help if you use placeholder values when describing the problem here. I'm not 100% sure I understand the distinctions you're trying to make (e.g., sending the email to me vs receiving an email or all the uses of "me"). 

[Fatal error: Uncaught Error: Failed opening required '../mysqli_connect.php' (include_path='D:\xampp\php\PEAR') in D:\xampp\htdocs\phpmysql4_scripts\ch09\view_users.php:10]

So you have the script D:\xampp\htdocs\phpmysql4_scripts\ch09\view_users.php which is including ../mysqli_connect.php. The ../ bit means "go up one directory from the current directory". Up one directory from D:\xampp\htdocs\phpmysql4_scripts\ch09 is D:\xampp\htdocs\phpmysql4_scripts, so the code is looking to include D:\xampp\htdocs\phpmysql4_scripts\mysqli_connect.php. 

[Deleting User]

Hey Marie. From what you describe, if the problem isn't with the database then it's with your code. In other words, it could be giving you that error message for the wrong reason.

Looking through the downloaded code, I don't think this book uses a "form functions" file but it does use a login functions file. 

[Python Book in the offing?]

Thanks so much for the kind words and for the interest in a Python book. I truly appreciate it. Unfortunately I'm not well versed in Python, so that's not in the cards. Thanks again, though!

[Possible Errata , or improvement. + a question]

Yes, that would be my assumption: that it's doing a conversion. If it wasn't, then the SHA2() function would return an error for an improper argument.

[Transactions, a more deep dive]

Thanks for your questions and for the nice words. For the first question, when executing queries like this, there really is no "automatic". In a real application these queries would be executed by code that verifies the results as part of the process. For example, using PHP you could start a transaction, fetch the balances, adjust the balances, fetch the new balances, verify, and then commit. 

For the second question, what you describe is called a "race condition" and can be prevented by implementing locks. So you'd lock the row, run one update, and then unlock the row. A subsequent query that would theoretically make a quantity negative (assuming that wasn't allowed) would then fail. 

[Yii book second edition]

Thanks for your question, and for your patience! Mostly it's just hard--nearly impossible--to have a full-time job and a family and a house, etc. and work on the book. This is part of the reason why I don't spend any time on social media, too.

However, finishing the Yii book is always on my mind. In fact, I took two weeks of vacation last month and spent that on the Yii book. I got a rough draft of half of what was remaining done. I still have the last five chapters to rough out, and then polish these last eight. So the short answer is: yes, it's still being worked on and I just made some decent progress by using my vacation time, but it may still be a while before I complete it. 

[I can't apply css rules to a tag in a php page]

Yeah, that'll do it. Kudos for figuring it out and thanks so much for sharing the solution! 

[Inserting Records into multiple tables]

It might be best if you start coding by documenting what you want to do and then convert those comments into code. For example:

1. Add a record to the products table.
2. Get the product ID for the record just added.
3. If there are sizes, add one record to product2size for each size. This uses the product ID already fetched and the size ID, which comes from the HTML.
4. If there are product categories, add one record to product2pcat for each category. This uses the product ID already fetched and the category ID, which comes from the HTML.

So with that written out like so you can see for starters that you don't need to fetch the product ID multiple times, just once will do. You'll also see that steps 3 & 4 are parallel, not dependent upon each other (from what I can tell). But your code for step 4 includes "isset($sizeError)". I don't see why that's there. That may be why the third query isn't running? From the code and your comments it looks like the second and third queries could be executed in either order as neither depends upon the other. 

There's nothing particularly special about running these three queries. I think you have some logic issues. As I recommended before, if you use a slew of print statements you could see what is or is not true or happening. It's a blunt debugging tool, but it works.

Another likely cause of confusion is you're using both prepared statements and non-prepared statements. That's not really a good idea, from the point of comprehension. Moreover, you're not using prepared statements for the two queries that would benefit the most from the prepared statements. By using prepared statements the second and third queries can be executed within the foreach loops, nicely. 

 

 

 

[Inserting Records into multiple tables]

One issue I can see is that you call `$product_id = $stmt->insert_id;` a second time, but you already have the $product_id value, so that shouldn't be necessary. And there's a good chance `$stmt->insert_id` won't return anything a second time it's called, but I could be wrong about htat. 

[Inserting Records into multiple tables]

Could you be more specific than "the query did not run"? Did PHP attempt to execute the query but it didn't succeed? And, if so, what was the MySQL error? Or is it not getting to that point in your code where PHP is even trying to execute the query? You may want to litter your code with print statements to see what is or isn't happening, and what values exist where. 

[Chapter 13 - Securing Passwords with PHP]

Yes, there's a typo there that's my fault--sorry!--in that you should be selecting the password from the database, too. 

You have that in place in your code now. From your debugging work it seems that 

if (password_verify($p, $row['pass'])) {

is returning false. That means the problem is either with $p or with $row['pass']. I would start by registering a new user with a new password--just "password"--and testing that, just to rule out that you haven't mistakenly used the wrong password (i.e., the code is actually working properly!). I'd also print out the value of password_hash('your password') and make sure that entire value is being stored in the database (using phpMyAdmin or the like). 

[Chapter 8: Working with Date and time - fatal error]

Ah, your code uses `if define()` when it should be `if defined()`. That's what your error means: define() requires two arguments, the constant name and the value, but you're only providing one (because you meant to use defined()). 

[Chapter 17 - Code Producing Error Message]

Ah! Kudos for figuring it out and thanks for sharing what the cause was!

[Chapter 17 - Code Producing Error Message]

Thanks for the nice words. Yeesh on this error message, though! That command creates four keys (or indexes): on user_id, on username, on email, and on the combination of username and pass. None of those seems to be 100 bytes! My hunch is it's the login key that's causing the problem. Try removing that from the command (and delete the comma after `UNIQUE (email)` and try it again. 

[Paypal Button Creation]

This is great! Kudos and thanks for sharing!

[A Big Thanks!]

You're most welcome. I'm glad to hear it and thanks for posting this!

[Does starting Sessions on Checkout Page mess with Google Analytics Enhanced Ecommerce?]

Aside from the use of a cookie, the sessions are an entirely server-side thing, and the method in the book just uses a different cookie. I can't imagine this is messing up Google Analytics. 

How do you know you can't reach Step 3 without Step 2? Keep in mind that even if Step 3 checks that Step 2 happened and reports an error message if it didn't, that still counts as a page view for Step 3. 

[Script 10.1 Yahoo Quote]

Yeah...sometimes with free things you get what you pay for! There are alternatives, though, such as: https://rapidapi.com/apidojo/api/yahoo-finance1 That requires signing up for an account and using their SDK. Offhand I don't know of a free comparable to the Yahoo! Finance API. 

[Larry Ullman it's not cool putting SQL Scripts in DS_STORE file. I can't access it!]

Ah, right. Sorry for the confusion and my mistake. Chapters 12 & 13 are the only ones that interact with a database. Chapter 12 has a script that creates the database. Chapter 13 has a single CREATE TABLE command, which is in the book. That's why there's no dedicated SQL file in the download. With 20+ books, I had forgotten which books had what. 

But the download contains a README file and 13 folders of scripts. There's more than just the .DS_STORE file, correct? 

[Ex1 Drop Down Menus]

Thanks for all the info. This is almost certainly a CSS issue, although there's a small chance there's an HTML problem. Most likely the path to your CSS file is incorrect. What URL are you using for your site? And where did you put the CSS files? And what paths are you using for your CSS files?