2nd Web Development Tutorial : Basic Concept of PHP, HTML, MySQL, Javascript, CSS

As I mentioned in the previous post, basically, there are three main things to understand in web development.

  1. Server-side scripting (PHP, Python, Pearl, Java, C++, etc)
  2. Client-side scripting (HTML, Javascript, CSS, etc)
  3. Database (Oracle, MySQL, etc)

For server-side and database scripting, commonly, you only need to understand only one of the languages. For example, with a very simple understanding of PHP and MySQL, and a little bit of client-side scripting knowledge, you can already create a very powerful site.

As we can see in the picture above, Client Side is really in the client side, but developer must also create the code for them. This is because although we develop something in the server side, the server will process the code and send it to clients. One basic thought that we must consider is that server side script will convert itself to client side script based on how we create it to do so. So, users in the client side won’t be able to see our PHP script at all. What they see is just codes of HTML, CSS, Javascript, and other client side scripts. For instance, we create a code like this in our index.php page :

<?php
echo 'This is my beautiful website.';
?>

Whenever a user requested index.php page, the server is not going to send that code to client. Instead, PHP will convert it to client side code. In this case, the code above will convert to HTML code below.

As you can see, clients can only see HTML code, not the PHP code. They can only see other client side scripts such as javascript, CSS, and HTML. For those who wonder how to see raw HTML code as seen above, simply right click on any area in your browser, then click Inspect.

Now let’s dig in deeper into the collaboration of Server, Client, and Database scripting. Let’s create a simple PHP code below called simpleweb.php.

<!DOCTYPE html>
<html>
<head>
<style>
    table {
        width: 100%;
        border-collapse: collapse;
    }
    
    table, td, th {
        border: 1px solid black;
        padding: 5px;
    }
    
    th {text-align: left;}
</style>
<script>
  alert('Hey, JS is working here');
</script>
</head>
<body>

<?php
$con = mysqli_connect('localhost','root','','test');
if (!$con) {
    die('Could not connect: ' . mysqli_error($con));
}

mysqli_select_db($con,"test");
$sql="SELECT * FROM tb_user";
$result = mysqli_query($con,$sql);

echo "<table>
    <tr>
    <th>Firstname</th>
    <th>Lastname</th>
    <th>Age</th>
    <th>Hometown</th>
    <th>Job</th>
    </tr>";
    while($row = mysqli_fetch_array($result)) {
        echo "<tr>";
        echo "<td>" . $row['firstname'] . "</td>";
        echo "<td>" . $row['lastname'] . "</td>";
        echo "<td>" . $row['age'] . "</td>";
        echo "<td>" . $row['hometown'] . "</td>";
        echo "<td>" . $row['job'] . "</td>";
        echo "</tr>";
    }
    echo "</table>";
    mysqli_close($con);
?>
</body>
</html>

Code above contains all client side programming languages I mentioned earlier (HTML, Javascript, and CSS), and PHP and MySQL code. Let’s see how it looks like in the client side.

At first, because we added javascript in our code containing Alert function, Chrome interprets it as an alert to be shown first before showing other things. Let’s see the rest of the response it received after I clicked OK in the alert box.

From picture above, we can see that there is no more PHP or MySQL code at all. What wee see is just a bunch of HTML, Javascript, and CSS code based on how we code on PHP. The table is nicely styled in CSS, and the content is like being hard coded, although actually it is taken directly from MySQL database, which is very dynamic.

So that is a very simple understandings on how server, client, and database scripts works in web development. I recommend you to try yourself using my code above in order to understand it very well. After this, I will post another interesting topic to learn deeper about each individual languages. So, keep learning and don’t forget to code.

19,132 comments

  1. agen slot online

    Oh mmy gooⅾness! Incredible article dude! Thanks, Howeνer I am going
    throuvh issues wіth your RSS. I dоn’t սnderstand wһy I can’t subscribe to it.
    Is there ɑnybody else getting similar RSS problems? Anyone who knows
    thе solutionn ᴡill you kindly respond? Thanx!!

    Also visit my web-site: agen slot online

  2. tour nam du 3n2d

    Tôi mᥙốn ⅾành сả đờі mình để đi đến những nơі xxa lạ, nếu như tôі ⅽó thể mượn một đờі kháⅽ ở đâu đó để sau đó ѕống ở nhà.

    Аlso visit my site :: tour nam du 3n2d

  3. 카지노

    Thanks for finally talking about > 2nd Web Development Tutorial : Basic Concept of PHP, HTML, MySQL, Javascript,
    CSS – Dryan Christoph Personal Website < Liked it!

  4. tỷ lệ cược

    I am in fact glad to read this webpage posts which contains lots of useful data, thanks
    for providing these statistics.

  5. ベラ ジョン カジノ 出 金 方法

    Your style is so unique in comparison to other folks I’ve read stuff from.
    Thanks for posting when you’ve got the opportunity, Guess I will just bookmark this site.

  6. tại w88

    Hello, I enjoy reading through your post. I wanted to write a
    little comment to support you.

  7. русское порно

    Hey I know this is off topic but I was wondering if you knew of any widgets I
    could add to my blog that automatically tweet my newest twitter updates.
    I’ve been looking for a plug-in like this for quite some
    time and was hoping maybe you would have some experience with something like this.
    Please let me know if you run into anything. I truly
    enjoy reading your blog and I look forward to your new updates.

  8. tai mau binh

    I was excited to uncover this great site. I want to to thank you for your time for
    this wonderful read!! I definitely enjoyed every little bit of it
    and i also have you bookmarked to see new information on your website.

  9. renovation island

    hey there and thank you for your info – I have certainly picked up
    anything new from right here. I did however expertise some technical issues using this site, as I
    experienced to reload the web site lots of times previous to I
    could get it to load properly. I had been wondering
    if your hosting is OK? Not that I’m complaining, but sluggish loading instances times
    will often affect your placement in google and could damage your high quality score if advertising and marketing with Adwords.

    Anyway I am adding this RSS to my email and could look out for much more
    of your respective intriguing content. Ensure that you update this again very soon.

  10. สาวกีฬา

    Pretty! This has been a really wonderful post. Thank you for providing
    this information.

  11. 우리카지노

    It’s a pity you don’t have a donate button! I’d most certainly donate to this fantastic
    blog! I suppose for now i’ll settle for book-marking and
    adding your RSS feed to my Google account. I look forward to new updates
    and will share this website with my Facebook group. Talk soon!

  12. 10bet japan

    This is my first time visit at here and i am actually happy to read everthing
    at alone place.

  13. 온라인 카지노

    I just could not leave your website prior to
    suggesting that I extremely loved the usual info an individual supply for
    your visitors? Is going to be again incessantly
    to check up on new posts

  14. https://mltusyg86.blogspot.com/

    My brother recommended I would possibly like this blog.

    He was totally right. This publish actually made my day.

    You cann’t imagine just how a lot time I had spent for this
    information! Thank you!

  15. カジノ ディーラー

    Appreciating the commitment you put into your blog and in depth information you present.

    It’s awesome to come across a blog every once in a while that isn’t the same unwanted rehashed information.
    Excellent read! I’ve saved your site and I’m including your RSS feeds to my Google account.

  16. Skiurlaub

    Die Dominikanische republik ist ein beliebtes Karibik-Ziel für deutsche Urlauber.
    Pauschalreisende zieht es etwas weniger Strände von Punta Cana und Puerto Plata.
    Die frohe Kunde: Touristen aus Deutschland können derzeit einreisen. Sie benötigen nicht einmal einen PCR-Test, zeigen die Reisehinweise des Auswärtigen Amtes (AA).
    Nötig ist zudem ein E-Ticket für Ein- und Ausreise.
    Eventuell wartet am Flughafen dann aber eine Gesundheitskontrolle.

    Hier mahnt das AA aber aktuell noch: Das Gesundheitssystem sei überlastet.
    Das Land ist derzeit Hochrisikogebiet. Eine Alternative könnte Kuba werden. Für die
    Einreise sind PCR-Tests vor und nach der Ankunft erforderlich.

    Und: Individualtouristen müssen nach der Einreise für mindestens
    fünf Tage in ein Quarantänehotel. Mitte November könnte es Plänen zufolge Erleichterungen geben, sofern dann
    große Teile der kubanischen Bevölkerung geimpft sind. Ein ebenso beliebtes wie vielseitiges Winterziel ist auch Mexiko.
    Die Besonderheit: Das Land hat ausländischen Reisenden während der gesamten Pandemie kaum nennenswerte Beschränkungen auferlegt.
    Die Grenzbehörden verlangen weder Impfnachweise noch negative Tests.

  17. https://j6k6v7r91.blogspot.com/

    Hey, I think your site might be having browser compatibility issues.

    When I look at your blog in Chrome, it looks fine but when opening in Internet Explorer,
    it has some overlapping. I just wanted to give you a quick heads up!
    Other then that, very good blog!

  18. slot gacor hari ini

    Thanks for ones marvelous posting! I tгuly enjoyed readijng it, yoս cօuld be a gгeat author.I
    ԝill remember to bookmark your blog annd wil cοme back att ѕome ρoint.
    І want to encourage that you continue youг grеɑt writing, have a
    nice evening!

    Ⅿy site; slot gacor hari ini

  19. https://ibxq895hx.blogspot.com/

    Howdy, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam responses?
    If so how do you prevent it, any plugin or anything you can advise?
    I get so much lately it’s driving me crazy so any help
    is very much appreciated.

  20. 007카지노

    I believe everything published made a ton of sense. However, think on this, suppose you wrote a catchier post
    title? I ain’t saying your content is not good, however what if you added a headline to possibly get people’s attention? I
    mean 2nd Web Development Tutorial : Basic Concept of PHP, HTML, MySQL, Javascript, CSS – Dryan Christoph Personal Website is a little plain. You should look at Yahoo’s home page and see how they create post titles to get people interested.
    You might add a related video or a related picture or two to get readers interested
    about what you’ve written. In my opinion, it might make
    your posts a little bit more interesting.

  21. rogue online poker

    Ӏ visit every day some blogs and sites to rеad articles, but this ѡеbpage preѕents qualіty based wrіting.

    Here іs my blog post; rogue online poker

  22. ku casino

    Fine way of describing, and nice paragraph to get data concerning my presentation focus, which i am going to deliver in school.

  23. W88

    It’s the best time to make some plans for the future and it’s time to be happy.

    I have read this post and if I could I desire to suggest you few interesting things or suggestions.
    Maybe you can write next articles referring to this article.

    I wish to read more things about it!

  24. https://williamsabby581.blogspot.com/

    Hello every one, here every person is sharing such familiarity, so it’s nice to read this blog, and I used
    to go to see this website everyday.

  25. online slots

    This paragraph provides clear idea for the new users of blogging, that actually how to do blogging
    and site-building.

  26. VXt1ptm5S/KoB6uX9V7

    This text is worth everyone’s attention. When can I find out more?

  27. verizon smart home

    Aw, this was an extremely nice post. Taking a few minutes and actual effort
    to create a top notch article… but what can I say… I put things off
    a whole lot and never seem to get nearly anything done.

Leave a Reply

Your email address will not be published. Required fields are marked *