Hi guys am in the mood to take you guys on php and mysql , mysql and pdo, let's see who is interested before I take off.

hope it wouldn't end up on whatsapp though, the classes?

sonofthunder:
hope it wouldn't end up on whatsapp though, the classes?

no it wount sir.

Let go dia

Before we start hope you guys have xammp or wamp install if not let me know so that will host the file

I have wamp installed

Ok let's start

<ol>
<li>first you must have a basic knowledge on html and css</li>
<li>you must have a working folder where your html and css are been stored</li>


<li>now is to move this folder to your local disk and locate xammp or wamp, for xammp you will see htdocs move your folder there. For wamp is www move your folder there.</li>


<li>now is to setup our xammp or wamp, turn it on by opening wamp for xammp turn on apache and mysql on.</li>
<li>access your localhost wamp or xammp in your browser by typing localhost it will direct to xammp setting , select English and click on security if you which to set username and password and save it, for wamp the username is automatically root and password is empty now we are good to go.</li>



</ol>

WHAT IS PHP , IT is hypertext preprocessor which serves as backend and help to interact with your database for dynamic website. Which php you can be able to build all type of sites like school portal, e ecommerce, blog, ponzi , etc as am talking to you guys have used it to build all this sites. Next is to start our php commands.

weh done sir!! continue and may God bless you

following but explain that ur opening and closing tag.. and won't mind screen shots

Amastermovic:
following but explain that ur opening and closing tag.. and won't mind screen shots

It is nothing , just html style listing

Now let's break it down on what we all learn here.
1. How to interact with mysql database by establishing connections to the backend.
2. How to insert data in database and retrieve it back from backend to front-end.
3. How to update , delete data in mysql database.
4. How to register and login user in php and mysql
5. How to use leftjoin, join, inner join to interact with users like sending messages among them , adding friends, posting updates etc.
6. You can be able to code a forum chat site without any third party software. On next post were are starting with insert but let's look at php , and how to use it print or echo a word. See the syntax

<?php
echo 'you are at nairaland webmaster forum';
?>
Try it out.

In php we normally use if , else, array when retrieving data's or verifying users input in database.

After this you guys will choose the type of site you want to build, we will build one and host it , be it like Facebook or nairaland just any site.

help with a registration site

Ok let's look at html form for registration
. You can style your form with your css


<form action="" method="POST">
<label>username</label>
<input type="" name="" />

<label>email</label>
<input type="" name="" />

<label>password</label>
<input type="" name="" />

<label>confirm password</label>
<input type="" name="" />

<label>Full name</label>
<input type="" name="" />

</form>
Next is to put php code in action , any question before I proced