StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
13515918
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-11-22T15:33:12.650
FavoriteCount
0
LastActivityDate
2012-11-22T15:43:54.717
LastEditDate
2012-11-22T15:43:54.717
LastEditorUserId
1839900
OwnerUserId
1839900
ParentId
13514903
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
I'd say put those views in a template and you can load that template. It makes things look a bit neater. Your index function should look like this <pre><code> function index() { $data['page_title'] = 'Sign up page'; $data['central_content'] = "sign_up"; $this->load->view('template'); } </code></pre> In your template don't forget to load content, like thus; <pre><code><?php $this->load->view($central_content); ?> </code></pre> Rearrange you register function to look like this; <pre><code>function register() { #you should be autoloading these helpers tbh $this->load->helper(array('form', 'url')); $this->load->library('form_validation'); $this->form_validation->set_rules('username', 'Username', 'required|min_length[5]|max_length[12]|trim'); $this->form_validation->set_rules('password', 'Password', 'required|md5|trim'); $this->form_validation->set_rules('username', 'Username', 'callback_usernameTaken'); if ($this->form_validation->run()) { $username = $this->input->post('username'); $password = $this->input->post('password'); #Learn to use flashdata, it helps. if($this->membership->newUser($username, $password)){ $this->session->set_userdata('status', 'OK'); $this->session->set_userdata('username', $username); redirect('home'); } }else{ $this->index(); } } #You specified a callback but there's no callback function in your class? Here's how you go about it. Public function usernameTaken(){ #callbacks should return true or false if ($this->membership->usernameTaken($username)) { return true; } else { #You can set your own validation message in the case it's false. $this->form_validation->set_message('usernameTaken', 'The selected username already exists'); return false; } } </code></pre> Your model is ok, try change the the funcs to this <pre><code> function newUser($username, $password) { $newMember = array('username' => $username, 'password' => $password); return ($this->db->insert('membership', $newMember)) ? true : false; } function usernameTaken($username) { #your query, requires a select * in a case where it's clearly not needed. Little things like this slow down your query.Try, $query = $this->db->where('username', $username)->get('membership'); #Also num_rows() return ($query->num_rows() > 0) ? false : true; } </code></pre> Just wrote this on here, so you'd have to test it out, but i'm sure it should be fine. Sorry i could't indent it properly though, it's a pain to do it on here :)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow do i stop duplicate entries going into my membership database?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USTommy Adey
UserOwnerUserId
1. USTommy Adey
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
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.