We launched a new IT training category! Check out the 140+ courses now.

Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Correcting table fields

From: Dynamic Dreamweaver Websites: Creating Login Areas

Video: Correcting table fields

When we went through the Register.php page, which is actually the registration form we were given by the website maintenance people at Scuba2u, to use for our registration form. We discovered that a couple of the fields in our database, that has been setup, are not long enough for the information that needs to go into them. Now, hopefully, this is something that will never occur to you, because this would have all been checked out before the database was created. But I have purposely setup a couple of situations within this course, so I can get you a little more familiar with the PHP My Admin area. This is not something you want to do, generally, when there's data in the database.

Correcting table fields

When we went through the Register.php page, which is actually the registration form we were given by the website maintenance people at Scuba2u, to use for our registration form. We discovered that a couple of the fields in our database, that has been setup, are not long enough for the information that needs to go into them. Now, hopefully, this is something that will never occur to you, because this would have all been checked out before the database was created. But I have purposely setup a couple of situations within this course, so I can get you a little more familiar with the PHP My Admin area. This is not something you want to do, generally, when there's data in the database.

So, we'll go out to manage our database. In order to do that, we need to go out to our Zamp or Mamp control areas. And within the MySQL area, I want to go to the Admin page. And this particular page is setup, so we can administer the database. So, let's open that up, and the database I want to administer is Scuba2u, in the left-hand side.

Now, once I choose a database, I could use this drop down in case I choose the wrong one. So, I can move between databases. The table we need to fix is the log-in table. Now, thankfully, we just have some example log-ins within this database tables. I'm in the Browse tab and I have Log In selected in the left-hand side. You can see there isn't any information in the first name, last name and country areas, and since we need to modify these fields, that's a very good thing.

This is not something you want to be doing once there's a bunch of database data within your website. So, it's very important to make sure this never happens within your site. But I'm going to move over to the Structure tab. Now, the Structure tab is used to add columns or fields within the database. And you can see my last name has 11 characters and my country has 11 characters. Let's correct both of those. So, I'll start with last name.

And this little pencil here, if I highlight it, you can see it says Change. When I click on that Change, it has a length of 11. Now, this particular field is the last name field. We want to allow 40. So, I'm going to change the 11 to 40. This is also setup as an integer. I want it to be whatever characters the user wants to put in. So, I will change this to varchar.

And change the length to 40. In order to change it permanently, I click the Save button down in the bottom right. Now, we have varchar as 40. Our country here, also has that same situation, and I will also go in and just check the type for first name. So, this allows you to get an idea of how we build tables within this table structure. As I mentioned, you do not want to be doing this on a live database with data inside of it. So, I'll click the pencil next to country.

This also say's it's an integer, so I'll change it to varchar. And our country, we set our fields to be 30 wide, within our form. And 30 should cover all countries, if we really want to allow that. So, I will set it to 30 as a length, and click Save. You can see these two are now fixed. So, it isn't that difficult to do this. Now, let's correct first name while we're in here.

I click the pencil for first name. And I have the same situation. I'll change it to varchar. Our length is fine. I'll click Save. We have now corrected those issues. All of these are going to allow plenty of text or whatever character's we want to put in especially for the password field. I can close up this interface, set aside my Control panel. And let's do a refresh over here, of our Databases panel. If I open this up, I should see it corrected within this area. And I want the Log In table.

And there we are. We've corrected those issues within PHP My Admin. So now, our registration form matches up with our database data. So, that is how you can administer your database. Now, if this is a big team environment, it's a company website, things are a little bit different. I, as a developer, am not going to go in and go modifying their database. I just wanted you to get a feel for this because sometimes, as a developer, you're the one who has to build the data base as well.

So, I wanted to give you a taste of how to modify table structure within PHP My Admin and which buttons to click, in order to do that. So, our registration form and our log in forms, should be all set up for our log in process at this point in the course.

Show transcript

This video is part of

Image for Dynamic Dreamweaver Websites: Creating Login Areas
Dynamic Dreamweaver Websites: Creating Login Areas

43 video lessons · 1741 viewers

Candyce Mairs
Author

 
Expand all | Collapse all
  1. 1m 32s
    1. Welcome
      1m 32s
  2. 2m 57s
    1. Course overview
      1m 16s
    2. The course environment
      1m 41s
  3. 26m 58s
    1. Static vs. dynamic requests
      4m 8s
    2. Installing XAMPP on a Windows system
      8m 54s
    3. Installing MAMP on a Mac system
      4m 29s
    4. Using admin consoles
      3m 54s
    5. Installing the course files
      5m 33s
  4. 18m 36s
    1. Overview of the Dreamweaver interface
      6m 22s
    2. Setting up the course site
      6m 20s
    3. Previewing pages
      5m 54s
  5. 33m 38s
    1. Creating PHP pages
      5m 45s
    2. Adding PHP code
      5m 44s
    3. Displaying variables
      4m 45s
    4. Commenting your code
      5m 30s
    5. Working with includes
      5m 58s
    6. Building the course templates
      5m 56s
  6. 35m 13s
    1. What is a database?
      5m 2s
    2. Adding database tables
      7m 34s
    3. Connecting to the database
      8m 28s
    4. Getting data from a database: Part one
      8m 25s
    5. Getting data from a database: Part two
      5m 44s
  7. 1h 16m
    1. Planning the login process
      7m 25s
    2. Creating a login form
      7m 45s
    3. Adding form validation: Part one
      9m 22s
    4. Adding form validation: Part two
      1m 37s
    5. Exploring the registration page
      7m 17s
    6. Correcting table fields
      6m 1s
    7. Setting up the login landing page
      4m 1s
    8. Using server behaviors
      3m 36s
    9. Inserting new members
      8m 48s
    10. User authentication
      10m 3s
    11. Restricting access to pages
      5m 17s
    12. Testing the login
      4m 53s
  8. 1h 6m
    1. Admin area overview
      5m 9s
    2. Adding new users
      5m 19s
    3. Restricting access
      12m 25s
    4. Planning the admin update area
      5m 19s
    5. Building the members table listing
      6m 55s
    6. Building the querystring
      9m 14s
    7. Populating the update form
      6m 33s
    8. Updating the database data
      11m 28s
    9. Testing the admin update process
      3m 47s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Dynamic Dreamweaver Websites: Creating Login Areas.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.