Jquery Ajax and PHP MVC Model

Question

I´m building a small application with Jquery and PHP. Jquery (index.html) adds Form Fields for the User and sends those to a PHP Script (pdo.php). The PHP Script fetches Values from the Database and does some calculations with the User given Values and the Values from the DB. The sum is returned to the Form Page.

index.html <-> pdo.php

Thus I am trying to understand the PHP MVC pattern my question is if

a.) this would make sense in this case.

b.) if so, which part would be what. index.html --> view; pdo.php --> model; controller --> ?

thanks for your help,

tony

Cut-out

jquery ... index.html

$(document).ready(function(){
    $("#buttonAjax").click(function(){
        var name = encodeURI($("#name").val());

            $.ajax({
                type: "POST",
                url: "pdo.php",
                data: "name="+name,
                success: function(data){
                    var json = $.parseJSON(data);
                    $("#output").html(json.summe);
                    talk(json.say);
                }
            });

    });

    function talk (say){
        jQuery.noticeAdd({text: say,stay: false});
    }

     });

pdo.php

/* DB Connection */
    $strDbLocation = 'mysql:dbname=test;host=localhost';
    $strDbUser = 'root';
    $strDbPassword = 'root';

    try{
        $objDb = new PDO($strDbLocation, $strDbUser, $strDbPassword);
    }
    catch (PDOException $e){
        echo 'Failure: ' . $e->getMessage();
    }


/* Fetch POST Data */
    $id = $_POST['name'];


/* Build query */
    $dbSelect =  $objDb->prepare("SELECT Age,Name FROM Benutzer WHERE id = :id");
    $dbSelect -> setFetchMode(PDO::FETCH_ASSOC);  
    $dbSelect -> bindParam('id', $id);
    $dbSelect -> execute();


/* Output + Calculate */    
    while($row = $dbSelect->fetch()) {  
        $total =  $row['Age'] / 100 . "<br />";
    }  


/* Return to User */
    if(!empty($total)){ 
        $ret = Array("summe" => "Summe: " . $total, "say" => "all right");
        echo json_encode($ret); }
    else{
        $ret = Array("summe" => "Nothing for you",  "say" => "nothing for you");
        echo json_encode($ret); 
    }

P.S. You should look into real prepared statements instead of emulated ones. Best way to prevent SQL Injection. — PeeHaa
– PeeHaa, Commented Jul 3, 2012 at 7:28

Igbanam · Accepted Answer · 2012-07-03 07:47:51Z

3

In a standard MVC webapp, routes are matched to controller actions. These controller actions may interface with the Model [which in turn interfaced with the database] or performs some other Model-agnostic calculations, and renders a view. It is obvious that the index.html is the view. And I think you have the controller and the model bundled up in pdo.php.

I really recommend PeeHaa's link in the comments. That answer is well written.

That been said, there are many architectural patterns to making a webapp. Yours may not be MVC. Some prominent frameworks that aren't MVC are SproutCore (View-based controllers) and JSP pages (single controller).

answered Jul 3, 2012 at 7:47

Igbanam

6,1025 gold badges49 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PeeHaa Over a year ago

@tschonbuchner: Also note that even though most frameworks state they are doing the MVC pattern. They are in reality doing MVCi ™ (MVC inspired) patterns.

PeeHaa · Accepted Answer · 2012-07-03 07:44:10Z

0

Use of controller is to controll the form elements in html using php . For eg:

/ * Fetch POST Data */
    $id = $_POST['name'];

the use of model is only for db use (insert,select,..)

edited Jul 3, 2012 at 7:44

PeeHaa

73.1k60 gold badges195 silver badges264 bronze badges

answered Jul 3, 2012 at 7:43

Sangeetha Narayana Moorthy

2061 gold badge5 silver badges17 bronze badges

1 Comment

Anatol Over a year ago

Hi together thank you for your reply. I think the part that confused me is the combination of MVC and ajax use and the question if mvc makes sense in this case. but as Yasky writes there are more architectural patterns. I will read the article maybe I find an better fitting one . –

Collectives™ on Stack Overflow

Jquery Ajax and PHP MVC Model

Cut-out

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Cut-out

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related