StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POquestions about MVC architecture in web application
primarykey
Id
17909577
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-07-28T15:02:30.540
FavoriteCount
0
LastActivityDate
2014-03-08T22:56:46.160
LastEditDate
2014-03-08T22:56:46.160
LastEditorUserId
1310929
OwnerUserId
982959
ParentId
0
PostTypeId
1
Score
1
ViewCount
122
LastEditorDisplayName
text
Body
<p>I have certain questions since I'm doing a web app, and I feel kinda confused about keeping the mvc structure in a web application without using any frameworks.</p> <p>Here is the structure of my app.</p> <p>index:</p> <pre><code><!DOCTYPE html> <head> <meta charset="utf-8">  <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.js"></script> <script src="js/functions.js"></script> <script> $(document).ready(function() { loginSend(); }); </script> <title></title> </head> <body> <div id="login"> Username: <input type="text" id="username" name="username"><br> Password: <input type="password" id="password" name="password"><br> <input id="send" type="button" value="Enviar"> </div> </body> </html> </code></pre> <p>The loginsend function sends the data to service.php </p> <pre><code><?php include('server/main.php'); $action = $_POST['action']; switch($action){ case "loginCheck": $username=$_POST['username']; $password=$_POST['password']; $users = new users(); echo $users->loginCheck($username,$password); break; } ?> </code></pre> <p>And the service uses some classes I defined in main.php</p> <pre><code><?php class db{ public function conn() { try{ $dbhost = "localhost"; $dbname = "eout"; $dbuser = "root"; $dbpass = ""; if($conn = new PDO("mysql:host=".$dbhost.";dbname=".$dbname, $dbuser, $dbpass)){ return($conn); } } catch (Exception $e){ echo "Se ha presentado un error al conectar con la base de datos".$e; } } } class users{ function loginCheck($username, $password) { try{ $db = new db(); $conn = $db->conn(); $pass_encriptada = md5 ($password); $SQL_LOGIN_CHECK = "SELECT * FROM users where username='".$username."' and password='".$pass_encriptada."' and deleted='0'"; $conn->prepare($SQL_LOGIN_CHECK); foreach($check = $conn->query($SQL_LOGIN_CHECK) as $row) { $username_check = $row['username']; if ($username_check == $username){ session_start(); $_SESSION['logged'] = 1; $_SESSION['user_id'] = $row['id']; $_SESSION['username'] = $row['username']; $_SESSION['namelastname'] = $row['name'] ." ".$row['lastname']; $usertype_id = $row['usertype_id']; if ($usertype_id == 1 ){ //problema $_SESSION['teacher'] = 1; $response = "teacher"; $json = json_encode($response); echo $json; } if ($usertype_id != 1 ){ //problema $response = "user"; $json = json_encode($response); echo $json; } } } } catch(Exception $e){ echo "Se ha presentado un error en loginCheck".$e; } } } ?> </code></pre> <p>In this case, I understand that index.php its my view, however I have certain doubts about the model/controller part. I understand in my example that the main file is the one that interacts with data, so it must be the model... in my case... its service.php my controller? Since is the one that interacts with the model? I feel kinda confused about this. In case I am wrong. How can I make a controller?</p> <p>Thanks in advance.</p>
Tags
<model-view-controller>
Title
questions about MVC architecture in web application
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USNathan Dawson
UserOwnerUserId
1. USSolar Confinement
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POquestions about MVC architecture in web application
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COSorry man, that's not even MVC-like. You need to learn some OOP, first of all....
  singulars
  PostPostId
  POquestions about MVC architecture in web application
  UserUserId
  USYang

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.