Part 1: How to Build PHP and MySQL CMS Website Software

In this part of the lesson we create our MySQL database and quickly set up a default layout in Dreamweaver CS4, and tinker with the looks through CSS.

[miXn]

Wow, I have never worked in Dreamweaver ... and now I know WHY! :D Hate that Designmode ... but I think it's just about getting used to it. Thanks for the Tut so far, can't wait for the next parts.

[AdamKhoury]

@1337sweden - I AM using CSS in this tutorial. I only use DIVs when I do not require an easy to make tabular layout, or if I feel gay that day.

[shakaama]

OK Adam, i went and lurnt me some PHP so now I can watch all your videos and understand stuff... cuz stuff needs to be understood, to do stuff.

[cedomirovic]

You are the best, but where is the part 2.... Hi from Belgrade (Serbia)

[Nemenemenes]

When using variables, double quotes (") are not required in the mysqli_connect function. And I think it will be better to remove them. Because as a person who is used to code with single quotes, I spent almost an hour trying to figure out why my single quoted mysqli_connect didn't work.

[cuasatar]

Oh my god, I couldn't avoid laughing a lot when you said about the web site design: "It's ugly but it works" XD

[AdamKhoury]

@mjroot2006 Yep Queens NY... good ear!

[gramgram]

Hi, Great tutorials, first time for PHP and MYSQL.
i am having trouble connecting to my database using mysqli on my online server everything works on my local machine but when i transfer the files and change the connect_to_mysql.php file i get errors, i have rested tables to confirm connection using mysql but mysqli throws up errors and the server is version 5.0.83 any ideas where i can start looking ???

[backbreaker]

hi i was wondering if u knew how to make a points thing on a website like if u login it gives u 2 points and u can redeem it i need help!

[grandmasterb]

hay mjroot2006 how did you make that table your using

[batotype]

It's custom? No Drupal or other crap like that? Everything built ground-up?! :D Seriously? Man, are you a genius?

[JeremyEngram]

You live in Asheville right Adam? - I used to live there... GREAT PLACE!

[mapleKeenanb]

Deprecated. Link is gone, so should the video. Please remove as you're no longer helping anyonne with this guide.

[winfrk]

Can you please give us the HTML code? I haven't got dreamweaver, so...

[VizuaaLOG]

Content Management System. Something like wordpress or joomla

[AlexBowers]

You dont need dreamweaver to write it.

[daviesere]

I can honestly say i did kinda got confused you have skipped parts like that table and the data base parts

[BMXDANNNY]

Search for "custom search API" in google

[Hector]

every place has its ghettos. Its one of the 5 boros (county) of ny which has its Ghettos.. lol. Everyplace on the planet has its good areas and bad.. London has some SLUUUMS too. :)