Jump to content


  • Posts

  • Joined

  • Last visited

pukster's Achievements


Newbie (1/7)



  1. I suggest checking out this article over at StackExchange. The OP addresses several issues that all PHP tutorials have http://stackoverflow.com/questions/2119083/php-tutorial-that-is-security-accuracy-and-maintainability-conscious#comment12179568_2119083
  2. Sorry for the long absence. I understand you are only supposed to teach the concepts, but look at the CSS tutorial. It gives several examples highlighting the different ways to accomplish, for example, floating elements around with the float:left/right command. The SQL tutorial I find lets you design your database (well it takes experience to design it well) but it does a bad job of telling you how to update that database. It would be like if you taught someone the language specification of ANSI C, but then didn't tell them that they had to put the code in a text file with the '.c' ending, and that they had to issue the command 'gcc'. I found I built my database, then tried to retrieve rows of data, but didn't know how to do it. For example, if I get the ids of all users with the name 'john', how do I iterate those ids?
  3. I understand that. All I am saying is that, from the point of view of a novice SQL programmer, the tutorials aren't as helpful as the HTML, javascript, PHP tutorials. With those, I feel they give you all the tools you need to get started. With SQL, I come away feeling like I didn't learn anything at all.
  4. The tutorial for SQL is good, don't get me wrong. I just felt like I just came out of college and all of my knowledge didn't apply to the real world. It's one thing to know how to use Foreign IDs CREATE TABLE IF NOT EXISTS person(ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),)ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS file(ID INT NOT NULL AUTO_INCREMENT,OWNERID INT NOT NULL,PRIMARY KEY(ID),FOREIGN KEY (OWNERID) REFERENCES person(ID))ENGINE=InnoDB; CREATE TABLE IF NOT EXISTS picture(ID INT NOT NULL AUTO_INCREMENT,FILEID INT NOT NULL,PRIMARY KEY(ID),FOREIGN KEY (FILEID) REFERENCES file(ID))ENGINE=InnoDB; But it's another entirely to remove a picture if it belongs to a certain user. Also it's hard to get the person ID associated with a picture. I don't mean the row, I mean the actual text ID/name associated with a person.
  • Create New...