How to create a Website with PHP and MySQL (Part 2: Using MySQL and phpMyAdmin)

In this video we will create the MySQL database and tables for a PHP powered Content Management System (CMS). We will also make a start on the PHP scripts.

The source code used in this video is available from my Website: http://goo.gl/cywKw

[ In the next video we will create a page editor so that pages can be edited through the user's browser. ]

Category:

Education

Tags:

• website
• xampp
• php
• mysql
• mysqli
• apache
• httpd
• web
• server
• web server
• content
• management
• system
• cms
• content management system
• howto
• instructions
• tutorial
• programs
• diy

[rednivog50]

What type is "id"? or do we keep it as INT?

[adamdmasi]

@rednivog50 Yes, it stays as INT.

[DaGrizzWonch]

where do we put index.php?

[adamdmasi]

@DaGrizzWonch sorry for the late reply. index.php goes in the "cms" folder you made.

[adamdmasi]

@Zykew Hi, if the Admin button doesn't work, in your browser, go to "localhost/phpmyadmin" minus the quotes.

[vaideekam]

this is find useful but it is very fast in times and some times the required place where the mouse cursor is doing some function can't be seen, thank you

[SpyzProductions]

One of the best tutorials on this subject i found so far

[Zykew]

One question. I ran the XAMPP Control Panel as an administrator and when I start Apache and MySql and try to click admin on Mysql like the video said nothing happens. Help Please :3