1. Tired of not being able to see links? Want to chat with other members? Need help?

[RevCMS] #1136 / Values.. [URGENT]

Discussion in 'Habbo Help & Support' started by funkystrainz, Dec 29, 2016.

Tags:
  1. funkystrainz

    funkystrainz Member

    Hey all,

    When I try to run an insert query in my users table, and try to add values, I get either "15 errors found during analysis" or one that says "Column count doesn't match value at row 1".

    Screenshots (from another thread):
    [ Want to see this link? Register ! ]
    [ Want to see this link? Register ! ]

    I'd like to be able to move forward. The only thing I can find in tutorials is for a seckey fix and the CMS already comes with a seckey.

    Thanks
     
  2. JMG

    JMG wut wut Staff Member

    What exactly are you trying to add? Also, next time, post the thread [ Want to see this link? Register ! ].
     
    Last edited: Dec 29, 2016
  3. Core

    Core Member

    You can't just copy a PHP query and expect phpmyadmin to interpret it lmao. Rip.
     
  4. funkystrainz

    funkystrainz Member

    I've been trying a few different things to be able to get my database to update with submitted entries. This is just the only time there was something that communicated with me from the database. I thought if I inserted the matching values from one of my CMS pages, into my users table using a query (written in PHP, from my CMS), that it would somehow allow for the submitted data from placeholders to translate into updated rows in my database.

    I'll keep trying other things. Probably like trying to get the placeholders to submit their information from the reg page. Like with this script:

    Code:
    final public function validName($username)     
        {
            if(strlen($username) <= 25 && ctype_alnum($username))         
             {             
                 return true;         
             }                 
            
             return false;     
        }         
            
        final public function validEmail($email)     
        {         
            return preg_match("/^[a-z0-9_\.-]+@([a-z0-9]+([\-]+[a-z0-9]+)*\.)+[a-z]{2,7}$/i", $email);     
        }         
        
        final public function validSecKey($seckey)
        {
            if(is_numeric($seckey) && strlen($seckey) == 4)
            {
                return true;
            }
            
            return false;
        }
     
  5. Menkz

    Menkz Active Member

    what "page" are you trying to insert values with?
     
  6. Xuxu

    Xuxu Active Member

    dude get a windows vps or computer jesus!
     
  7. funkystrainz

    funkystrainz Member

    The snippet I posted was copied from my class.users. Everything that I've tried to insert as values has also been from a different part of this page.
     
  8. Menkz

    Menkz Active Member

    I know what class.users looks like, but what page, me, index, staff?
     
  9. funkystrainz

    funkystrainz Member

    Oh, I've linked my reg to my index, so I can click from one to the other. I need for the forms in both pages, to submit the info from placeholders, and direct me to the me page. All of this query stuff is so the rest of values update in my db with the success of the form.
     
  10. Menkz

    Menkz Active Member

    login
    Code:
    <form  action="index" method="post">
                >
                  <input type="text" name="log_username" id="username" placeholder="Username">
    
    <input type="password" name="log_password" id="password" placeholder="Password" >
                </div>
                <button type="submit" name="login">Sign in</button>
              </form>
    Register
    Code:
    <form action="register" method="post">
                  
                    <label for="Username">Username</label>
                    <input type="text" name="reg_username" id="username" value="<?php echo $template->form->reg_username; ?>" placeholder="Username">
                  </div>
                  
                    <label for="email">Email</label>
                    <input type="email" name="reg_email" id="email" value="<?php echo $template->form->reg_email; ?>">
                  </div>
                  
                    <label for="pass">Password</label>
                    <input type="password"  name="reg_password" id="password" placeholder="Password">
                  
                  
                    <label for="confpass">Confirm Password</label>
                    <input type="password"name="reg_rep_password" id="retypenpassword" placeholder="Confirm Password">
                  
    
                  <button type="submit" name="register">Submit</button>
                </form>
    edit these how you see fit
     
  11. funkystrainz

    funkystrainz Member

    That just leads me back to here: [ Want to see this link? Register ! ]
    Submitting filled in fields that return as empty when the page refreshes. There is no forward action or communication between the db and the me page. But, the two pages on their own shouldn't be able to do anything
    --- Double Post Merged, Dec 29, 2016, Original Post Date: Dec 29, 2016 ---
    If my forms are written for bootstrap, could that be the problem?
     
  12. Menkz

    Menkz Active Member

    No, as my theme is purely bootstrap.

    What CMS do you use?
     

Share This Page

Loading...