StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POIs it my jquery or php?
primarykey
Id
4298318
data
AcceptedAnswerId
4298912
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2010-11-28T18:37:51.663
FavoriteCount
0
LastActivityDate
2010-11-28T20:31:11.473
LastEditDate
2010-11-28T20:24:47.653
LastEditorUserId
506784
OwnerUserId
506784
ParentId
0
PostTypeId
1
Score
0
ViewCount
126
LastEditorDisplayName
text
Body
<p>Edit: for some reason it seems like its refreshing the page upon hitting the submit button... any ideas?</p> <p>working on this simple chatroom script using ajax and kohana php framework. I can't seem to get my script working for creating a new user though and I have terrible debugging skills in php and javascript. Anyway I don't know if there's anything else to say.. here's my code:</p> <p>heres the code for the user class:</p> <pre><code>class Model_User extends Kohana_Model { var $_loaded = false; var $session = false; var $username = false; var $loginkey = false; function __construct() { $this->session = Session::instance(); } function new_user($username) { if($this->username_exists($username)) return false; $this->username = $username; $this->generate_key(); return $this->update_db(); } function username_exists($username) { if(DB::select()->from('users')->where('username', '=', $username)->execute()->count()<1); return false; return true; } //helper methods private function generate_key() { if( ! $username) return false; $this->loginkey = md5($username.((int)mt_srand()*1000)); $this->session->set('loginkey',$this->loginkey); return true; } private function update_db() { if(DB::insert('users', array('username'=>$this->username, 'loginkey'=>$this->loginkey))->execute()) return true; return false; } } </code></pre> <p>and heres the code to handle the json request:</p> <pre><code>public function action_new_user(){ $user = new Model_User(); $json['username_exists'] = "true"; $username = $_POST['username']; if(isset($username)) { if($user->username_exists($username)) { echo json_encode($json); return; } $user->new_user($_POST['username']); $json['username_exists'] = "false"; } $this->request->response = json_encode($json); } </code></pre> <p>and heres the jquery and html</p> <pre><code><div id="chat_entry_errors"> </div> <form id="new_chat_entry" name="posttest"> <input type="text" name="username" /> <input type="submit" name="submit" value="New User" /> </form> $(document).ready(function(){ $('#new_chat_entry').submit(function(){ $.post('json/new_user', $('#new_chat_entry').serialize(), function(data){ if(data.username_exists=='true'){ $('#chat_entry_errors').html('<div class=\"error\">Sorry that username is currently unavailable. Please choose another.</div>'); } else { $('#chat_entry_errors').html('<div class=\"error\">Success!</div>'); } } ); }); }); </code></pre>
Tags
<jquery><json><kohana><chatroom>
Title
Is it my jquery or php?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USTyler
UserOwnerUserId
1. USTyler
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. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

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.