PHP Tutorial – 23 – Adding Tables to MySQL Database




Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ – https://plus.google.com/+BuckyRoberts LinkedIn – https://www.linkedin.com/in/buc…

Original source


39 responses to “PHP Tutorial – 23 – Adding Tables to MySQL Database”

  1. how come there are times we get a "This is not a number" error message? and there was nothing I done otherwise in the table creation window… only I used a double data type for monetary values in my custom table.

  2. Love your tutorials but I do know of a field can and should have null ability. One example is Address2 If you don't have an apartment number or suit, there is no need for that field to be populated. Another might be MiddleInit. Not every one has a middle name. The examples could go on quite detailed but it is a needed function. Keep up the good work.

  3. null filed means that they CAN be empty (they are null by default)
    so when you creating some form in php with optional fields, values inputed by user can be empty and no error will apper when he press sumbit button because database does not require value in this field

  4. Hey, I actually do have something that uses null fields. I'm making a dictionary with conjugation and declension tables. Some words are defective, such as the word "can" which has no future tense, so all of its future tense fields will be null.

  5. why would anyone make a null field, well the answer is simple bucky..
    think of it this way, u have few employees and some of them will have null as a value for commission that means they will never get commission,while some others will have a value of 0, meaning that they will have commission sometime while they work, but not at the current time.

  6. The reason for NULL is so that that value doesn't have to be assigned at any given time so say in a social network if you used NOT NULL on comments or friends you would have to set it as soon as you make a user or something( the value could be empty/0 though ). Allot of PHP developers don't know actual SQL just the essentials.

Leave a Reply