How to allow Candadian Zipcodes in SQL Table

[Topbidder]

I am trying to create a table to allow Canadian Postal Codes as of now the site only takes Zip Codes and that limits the site to only allow people from the United States to register would anyone know the sql i would add to the database to allow Canadian postal codes to register or the table i would use to create it in phpmyadmin

Thank you SO much

[Niheel]

Depends on your application and your database schema. If it's just the application code that restricts certain type of zipcodes, then you can change that in the Code.

Most likely than not, you won't have to change your database. Just edit the application code to allow ZipCodes from other countries.

[Topbidder]

this is the site http://top-bidder.com it is the swoopo but in the general setting i cant find anywhere and when i looked through the DB i didnt see anywhere in there either where to add or change it to canadian postal codes is there a sql i can add to just allow them if you go there and register you will see what i mean it wont take anything other than Zip Codes says to enter a numeric value

[Niheel]

It's not in the SQL, it's your website's code. The code validates the USER input that is then placed into the database.

You'll need to either change your code yourself or hire a developer to do it for you.

[Topbidder]

i found where it says postal code in register.php is this b where i would change the code and if so please let me know what to change it too thank you

<?php
//============================= SUBMIT REGISTRATION INFO======================================
 
 
if($error==1)
    $msg=$lang['username_already_exist'];
if($error==2)
    $msg=$lang['email_already_exist'];
if($error==3)
    $msg=$lang['all_already_exist'];
    //$msg=$lang['mobile_already_exist'];
 
if($user)
    {
 
    /*
    $Sel_Result=$dbh->query("select * from users where username='$login' and deleted='N'"); 
    if(@mysql_num_rows($Sel_Result)==0)    
    {
    $Sel_Result1=$dbh->query("select * from users where email='$email' and username='$login' and deleted='N'"); 
    if(@mysql_num_rows($Sel_Result1)==0)
    {
    */
 
    $Sel_Result2=$dbh->query("select * from users where mobile='$mobile' and email='$email' and username='$user' and deleted='N'"); 
    if(@mysql_num_rows($Sel_Result2)==0)
    {
 
 
    $Dob=$Date_Year."-".$Date_Month."-".$Date_Day;
 
     $sql11=$dbh->query("insert into users (username ,password ,fname ,lname ,email ,sex,city ,postcode ,country ,phone ,mobile ,entrydate, address, network, tell_friend, balance, family_name,user_type) values('$user' ,'$pass' ,'$name' ,'$lname' ,'$email' ,'$sex','$city' ,'$zipcode' ,'$id_country','$phone','$mobile' ,'".$CURRENT_Time."','$address', '$network', '$friendemail','$Signing_up','$family_name','normal')");
 
    $reg_id=mysql_insert_id();
    $dbh->query("insert into amount_transfer (user_id, entrydate, amount, pay_type, reason,credit_type,amount_type) values('$reg_id', '$CURRENT_Time', '$Signing_up', 'Credit', 'Welcome Coupon','C','R')");
 
    $sql12=$dbh->query("insert into my_setting (user_id, newsletter ,auction_bid ,auction_result ,new_auction) values ('$reg_id' ,'$newsletter' ,'$auction_bid' ,'$auction_result' ,'$new_auction')");
 
    if($friendemail!='')
    {
        $dbh->query("insert into amount_transfer (user_id, entrydate, amount, pay_type, reason,credit_type,amount_type) values('$friendemail', '$CURRENT_Time', '$Friend_Bid', 'Credit', 'Tell a friend - Bid','C','T')");
 
         $sql2="update users set balance=balance+'$Friend_Bid' where user_id='$friendemail'";
         $result=$dbh->query($sql2);
    }
    //$Res=$dbh->query("select user_id from users where id order by user_id desc ");
    //$Data=@mysql_fetch_object($Res);        
 
            //$subject=$lang['register_subject'];
            $Link='<a href="'.$SITE_URL.'/index.php?show=active&user_id='.md5($reg_id).'">'.$lang['here'].'</a>';
 
            $Email_info=$functions->Email_info(1);
            $subject=$Email_info['subject'];
             $msgBody1=$Email_info["message"];
 
             $msgBody=str_replace("\\", "", $msgBody1);
            eval("\$msgBody = \"$msgBody\";");
 
            //$Message=$lang['register_mail'];
            //eval("\$Message = \"$Message\";");
 
    $functions->Send_mail($SITE_EMAIL,$SITE_TITLE,$email,$subject,$msgBody);    
    echo '<script>document.location="index.php?show=success";</script>';
 
 
    }
    else
        echo '<script>document.location="index.php?show=register&error=3";</script>';
 
    /*
    }
    else
        echo '<script>document.location="index.php?show=register&error=2";</script>';
    }
    else
        echo '<script>document.location="index.php?show=register&error=1";</script>';
    */
 
    }
//==============================DISPAY LOCATION DROP DOWN ====================================
 
$Country_dropdown=$functions->Get_Country($Default_country);
if($freind_id)
{
    $friend_email=$functions->Get_Friend_Email($freind_id);
    $friend_list='<tr>
                                <td class="contact">
                                '.$lang['tell_frnd'].'&nbsp;&nbsp;&nbsp;</td>
                                <td>:<font color="#FF0000">*</font>&nbsp;&nbsp;</td>
                            <td align="left">'.$friend_email.'</td>
                          </tr>';    
}
 
$Sex_Drop_Down='<select name="sex">
                        <option value="M">'.$lang['male'].'</option>
                        <option value="F">'.$lang['female'].'</option>
                      </select>';    
 
$Month_dropdown=$functions->Get_month('');
$Day_dropdown=$functions->Get_day('');
$Year_dropdown=$functions->Get_Year('');    
 
 
?>

[Atli]

I don't get it. The site doesn't seem to validate the zip code or restrict it to valid US zip code values.

Could you not simply rename the zip code field to something like Zip/Postal code and just use that for both? Or just update the label based on the selection? (Using JavaScript)

[JKing]

There is javascript on the page that validates the zip field allowing only numbers.

This is the javascript function

function isNum(val) {
 
   if (val.value.length != 0) {
 
      for (i = 0; i < val.value.length; i++) 
      {
         var ch = val.value.charAt(i);
 
         if (ch >= "0" && ch <= "9") 
          continue;
          else 
              {
                alert(document.getElementById('Num_value').innerHTML+"\n");
                val.value = "";
                 val.focus();
 
            false;
              }
          }
       }
   return true;
} 
 

References this html for the alert.

<div id="Num_value" style="display:none;">Please enter Numeric value</div> 
 

[Topbidder]

   1. <div id="Num_value" style="display:none;">Please enter Numeric value</div> 
   2.  

so can i edit this to allow character as well as numeric so it takes both postal/zip codes

[JKing]

<td class="memberlogin">Zipcode&nbsp;</td>
                                <td  class="contact">:&nbsp;&nbsp;</td>
                                <td align="left"><input name="zipcode" type="text" value=""  class="input_120" onChange="isNum(this)"></td>
 

That HTML is where the javascript function is called.
You could remove the onChange. You would still need to perform some validation on this field whether it be client or server side.

[Topbidder]

Thank you all so much i am just learning so i am very grateful for all your help and learning all new things is awesome