Please I need help on the site

05/04/2011 22:19 sharq#1
Please I need help on the site
I hope to have experience in websites, we do not spare them.
The site works well and I have a problem in the registration page which is in addition Alamil your Registrar in the database, while all evidence that is added be added in the rules of evidence Mady Alaamil this image of the page, followed by programming Page ..
Please help me and either mis-statement and treatment
Thank you.


[Only registered and activated users can see links. Click Here To Register...]

PHP Code:
         <h1 class="pagetitle">Register</h1>
<? 
require("config.php");
?><div class="post">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script type="text/javascript" src="./inc/md5.js"></script>
<style type="text/css">
</style></head>
<DIV align="center"><b class="h2">
</b>
<br />
<table width="299" height="22" border="0" align="center">
  <tr>

  </tr>
</table>
<br />
<form method='post' action='register.php?act=register'>
      <TABLE width="312">
        <TBODY>
        <TR>
          <TD id=GoodStuff style="PADDING-LEFT: 0px; MARGIN-LEFT: 0px">
            <DIV id=theform style="PADDING-LEFT: 0px">
            <TABLE class=body width="323" height="229">
              <TBODY>
              <TR>
                <TD align="left" height="32">UserID:</TD>
                <TD class=it3 height="32">
                <INPUT class=it style="FONT-SIZE: 9pt" name="id" id="id">                </TR>
              <TR>
                <TD align="left" height="37">Password:</TD>
                <TD class=it3 height="37">
                <INPUT class=it id="ipassword" style="FONT-SIZE: 9pt" type=password maxLength=12 name=pass></TD>
                </TR>
              <TR>
                <TD align="left" height="32">Retype Password:</TD>
                <TD class=it3 height="32">
                <input class=it1 id="ipassword" style="FONT-SIZE: 9pt" type=password maxlength=12 name=retpass></TD>
                </TR>
                <tr>
                <TD class=Label align="right" height="32">
                <p align="left"><b>Email:</b></TD>
                <TD class=it3 height="32"> 
                  <input class=it id="email" style="FONT-SIZE: 9pt; font-weight:700" type=email maxlength=24 name=email></TD> 
                </tr>
              <TR>
                <TD align="left" height="32">Type Check Code:</TD>
                <TD class=it3 height="32">
                    <input name='CheckCode' size='20' maxlength='6'class=it style="FONT-SIZE: 9pt"></TD>
                </TR>
              <TR>
                <TD height="25" align="left">Check Code:</TD>
                <TD height="25"><span style="font-size: 9pt"><img src='./inc/img.php' width='200' height='60' alt='Visual CAPTCHA' 
  style='border: 1px solid #000000; padding: 2px;' /></TD></TR>
              <TR>
                <TD></TD>
                <TD style="FONT-SIZE: 14px; VERTICAL-ALIGN: middle">
                <span style="font-size: 9pt"><input type="hidden" name="hash"><input class=Butt type=submit onclick="hash.value = login(pass.value)" value='Register' name=B1></span></TD>
                </TR></TBODY></TABLE>
            </DIV></TD></TR></TBODY></TABLE></FORM>
            <center>
            <?php
            
if($_GET['act'] == "register")
            {
                if(
PhpCaptcha::Validate($_POST['CheckCode']))
                {
                    
mysql_select_db($mydbacc);
                    
$userid trim($_POST['id']);
                    
$password=trim($_POST['pass']);
                    
$passretype=trim($_POST['retpass']);
                    
$hash=$_POST['hash'];
                    if(!
ereg("^[0-9a-z]{4,12}$",$userid))
                    {
                        echo 
"Only letters from \"a\" to \"z\" and numbers, lenght of 4 to 12 characters";
                    }
                    else
                    {
                        if(
$password == $passretype)
                        {
                            if(!
ereg("^[0-9a-zA-Z]{4,12}$",$password))
                            {
                                echo 
"Only letters or numbers, lenght of 4 to 12 characters";
                            }
                            else
                            {
                                
$res mysql_query("select * from account where name = '".$userid."' order by id desc");
                                if(
mysql_num_rows($res) == 0)
                                {
                                    
mysql_query("insert into account (name,Password,Reg_date) values ('".$userid."','".$hash."','".date("y-m-d H:i:s"time())."')");
                                    echo 
"Account registered successfully.";
                                }
                                else
                                {
                                    echo 
"Account Already exists in database.";
                                }
                            }
                        }
                        else
                        {
                            echo 
"Password not equal to Retyped Password.";
                        }
                    }
                }
                else
                {
                    echo 
"Check Code is Wrong";
                }
            }
            
?>
            </center>
</DIV>
</body>
</html>
</div>
05/05/2011 18:09 ~Sword~Stalker~.#2
Quote:
("insert into account (name,Password,Reg_date) values ('".$userid."','".$hash."','".date("y-m-d H:i:s", time())."')");
wrong section

but this is the script connecting both The website and the DB , u might have got account part in another name as account.account etc. just change that and add e-mail to ur acc.

Regards