Edward

Usually when i created a Yii app on the localhost, i have this arrangement C:/xampp/htdocs/yii-1.1.10 C:/xampp/htdocs/testapp (testapp being generated by Yiic at the Yii application) I can see that this folder yii-1.1.10 has to be there for the framework to be able to run as well at the yii files i have in the testapp which was generated. But if i install this on a hosting server i don't want to have to put www.mydomain.com/testapp/index.php to be able to run it i would prefer to run this from www.mydomain.com/index.php. So my question is it safe to have the yii-1.1.10 folder in the same area as the index.php for testapp. Or how should we go about doing this? Do we also need to change file permissions of every folder or is the way Yii default has them already okay? These may seem dumb questions but this is my first time with a live host.

I hope this will not offend anyone i should of probably kept this till Halloween but i have a nice way to remember Foreign Keys. Well the fact is with foreign keys is that if there are constraints say with say a user having a Bank Account (parent) and possibly having one or two loans (children). If you try to delete the users Bank Account (parent) first without deleting the loans (children) first you will always get an error due to the constraint. So the way to remember is "You must kill the children first before you kill their parents", this may sound horrible and its definitely not something i would do in the real life, but i thought it was cool way to remember this stuff. FOREIGN KEYS - "You must always remember to kill the Children first before you kill their Parents" "HeHeHe"

Well you could think of i this way, the less information you can provide a hacker the better. They will already have the user name to work with, and if you give them a user_id also they have two.

Yes and Admin on a major site can have user_id of 0 or 1 in the database, so people know what to look for. I like the ENUM data type so you that way you can distinguish between a member and the administrative side.

Its says. "This join is selecting three columns from the messages table (aliased at m) and one column from the forums table (aliased as f) under two conditions." I see only two columns selected for message table message_id and subject, so where is the third? I understand the join clause is the forum_id in both tables.

Larry do you watch the TV series 'The Walking Dead'? Season 3 is starting in the Fall, that's around the time that your new Advanced PHP book is coming out.

The REQUIRE can cause a fatal error, it means that the files cannot be found and the script will stall at that point and no longer run like it would if you have a INCLUDE. You need to check you have the mysql.inc.php script in the correct folder, check files on the server make sure the URI is correct and order of folders. That's usually what leads to this kind of error.

Well that makes it a lot easier for us then, thanks Larry

I was checking out Ebay.com and i saw the time on some items in PDT, then i checked ebay.com.sg Singapore, it shows the time in SGT. Does that mean Ebay will store the times in UTC and then convert with the SQL CONVERT_TZ function to the location of where the ebay site is located? I tried the CONVERT_TZ on my localhost but i got the NULL reading back, i guess i will leave that for later on installing the UTC times.

Excellent i am pressing on with your books today, i will let you know when i am finished with the PHP and MySQL for Dynamic Websites 4th Edition.

Thanks for addressing that, I am sorry I don't want to be a pain here but on pg.174, pg.177 and pg.178 we have the diagrams with only the dashed lines. Is that an error or is there a different meaning between solid and dashed lines?

I apologize i should of been more articulate, pg 176 chapter 6, diagram H. Why is there a dashed line on the far left side between the publishers and the books table but not between books_authors and authors. What is the different between dashed and solid line?

Thanks for taking your time to answer my question, i like to hear your opinion. Well it appears that your books will be out in the time frame in which i require them, so i am very happy about that. You commented "Frankly, I don't know how you remember anything going through as many different books as you do!" Well part of that will come down to the temporal lobe and hippocampus of my brain. I also have to believe in myself which results in a positive mental attitude. I am aware that reading many books can make your broad but it won't make you exact. To become exact you need to practice. I wish i was just able to read one book, put a smile on my face and then happily start coding, but unfortunately this is not the case. Even if i were to read and practice every book you had, i am sorry to say it is not enough for me to complete what it is i have to do. And neither on the market there is any single book that can gear me up for such a website i wish to complete. I believe in staying positive and reading as much as i can, i don't forget everything, i remember the important points which relate to my project from each book, and i am aware were these points are and in which book. So later I will come back to reference these points at each stage of the project. You mentioned being in a muddle if start to build in yii when i learn, well i can tell you i did almost finish the yii book that was out, but again, that book does doesn't cover even 10% of what i need to do. And i don't believe any books that come out are going to be enough. So i believe regardless of doing the books or not, the muddle is going to come whether i like it or not. I love to read your books more than any of the authors, but as you know they are just starting points, and at some point you will have to get your hands dirty.

No bother at all.

Larry when is the Yii book due to come out? And also when do you think you will finish PHP 5 Advanced: Visual QuickPro Guide (2nd Edition) 3rd Edition, I really want to do this new book instead of the 2nd Edition that i have. Larry if you have planned your project all the database design and functionality, would it be a good idea to start building that in Yii along side learning Yii. Rather than going through all the three Yii books, and may be forgetting stuff and going back again to do them all? (Just one thing i want to add, i will not start Yii books until i have finish David Powers, all of Matt Zandstra and lastly your new OOP Advanced PHP book, i am a man of integrity) Another question i have is if you are doing a big website is it best to leave out the javascript first and get it to work with MySQL and PHP first then add in the javascript later? Lastly i worked through your SQL stuff in the last two days, they were awesome chapters packed with more stuff than you can imagine. Ive actually know people before to do all the date formatting in php rather than using the SQL functions to do it, so it was good to see that being done on the lower level. I hope Yii has a way to incorporate the low level SQL stuff.

Thanks i want to be clear what Larry has to say about this in relation to the book i am reading.

Hi Larry, can you explain what the different is between the solid line and dashed line on the relational database diagrams. I didn't see anything mentioned on the dashed line, thought it may be way of representing relationship between key's but in some of your examples it didn't seem to follow in that particular case.

The list() function can take as many array elements as are returned from the array in any function. So yes you are correct.

Yeah, and i definitely won't be starting my project until Ive completed the new Larry Yii book. I hope to be starting sometime in 2013 when Ive learn't all this stuff so i am in no rush.

I am ordering the comics because the TV series is based on them, so want to give them a read to compare, awesome series. What i am surprised about is how Rick Crimes "Andrew Lincoln" main actor is from England but can but that cool american country cowboy accent on, just seems strange why America is such a big country but they picked him. Characters are and so in the series are supposed to resemble the comic book characters. I have been writing code Antonio, i done most of my practice in the David Powers OOP book first section, but now i paused on that book after section 1 to get the Larry PHP and MySQL book done, i am also doing review and persue sections in there all the questions and exercises. Last week i wrote the biggest sticky forum i have ever done with all the inputs in, it was fun and i got it all to work 100%. I do want to do my study in the correct order, After the book i am on now i will go onto finish the Coffee shop in Effortless E-commerce. I noticed that Larry is changing the Advanced PHP book, so i may do some other books until this one comes out, maybe go back to finish David powers, that new book Larry he has coming out is awesome, its stages you up for the frameworks, and i saw he will have introduction to Zend Framework. I am going to learn Yii, because i believe it to be better than the other frameworks, and you can also incorporate Zend framework into it, it also handles jquery, which code ignitor does not do as well. There was some people at Rackspace that supported me on the fact that Yii was the right way to be going. I am getting the Javascript book, i have worked through say 1.5 books on it already, i am not sure when i am going to study that book right now, the problem is i have learned some stuff then forgotten it, so that's why i was concerned with the order i was learning in so i can pull all together at once, let alone css and html, css which is tough. I want to make a multiple user E-commerce site, a German programmer told me to look more closely at factory patterns. Its difficult to really discuss design patterns at this point, i will need to finish Larry's books and the Yii books and those design patterns books, plan my databases and write down all the site functionality and then start to figure out which ones to use. I actually wanted to say looking at the design pattern books available, i think matt zandstra maybe the best one, because he has examples and also shows those patterns in practice and with PHP. I didn't have a problem understanding all the stuff in his book. I come from a background of higher Maths, so i understand well algebra and manipulation of variables, which seems to be the most part of coding. Ive checked out some of JREAMdesign video's before, i saw some design patterns video's on Youtube but unfortunately i find the Indian accents very frustrating. I like this one of building a basic MVC by Johny White:

Hey Antonio, I'm about to make my purchase on Amazon today for the new Larry's Javascript book and also these design patterns book you are recommending "Design Patterns" by Christoffer G. Is there anything else you recommend i get before i put my order in? I'm also going to order The Walking Dead "Robert Kirkman" comics books to see what they are like while waiting for Season 3 to start in the fall.

Its a big book, i haven't seen it yet or mentioned in the Index. It's just when i was working through the Knowledge is Power Site i did get some duplicate database records with it, so thought it was something that wasn't covered, ill keep my out for it. Thanks for your help! Keep up your good work!

I went through a lot of online help which ended up not working, so i decided to call it quits and just completely reinstall a new version of XAMMP. After the installation phpunit worked out fine. I thought with that Jeffrey Winesett book that some of the phpunit testing was quite trival, and the application could of just been tested the usual way we do by simple debugging, so be quite honest phpunit seemed a little over the top. Much of the debugging work comes is all about a good level of common sense.

Duplicate form submission is something that is really bugging me, ive seen this problem happening on some major php websites. Where someone will submit a form and maybe double click the submit button or click it multiple times, therefore we end up with multiple records in the database. Ive also seen this happening when people either reload the page after submitting by clicking the browers back button. I am aware if you are in using javascript with your forms that you can get around this problem by disabling the button elements after an onclick event, but on the other hand if the user has javascript disabled in their options it will still happen. I have seen in the O'rielly Php Cookbook a method they use where you can add a token into an sql lite database and then recall the value to see if the token was already submitted. So Larry and others here, how do you handle such problems on website with multiple transactions. And Larry, this would be something very useful for people useful if added to a later addition of this book.

Thanks, i got quite a bit through your PHP and MySQL for Dynamic Web Sites last week, there were quite a lot of good points that were not in the other book i done last year, so it was worth repeating. I must admit out of all the books ive read your's are by far the easiest to follow.