// section for subscriber
$query="Select source, header from ynfx_mis_ir WHERE id=$id_i";
$result=mysql_db_query($DATABASE,$query);
if(mysql_error()) error("Unexpected Error");
if(mysql_num_rows($result))
{
while($row=mysql_fetch_row($result))
{
$source_t=unserialize($row[0]);
$header=$row[1];
$s="";
$c=0;
for($i=0;$i'$header'";
if($submit1)
{
$date_app=mktime_to_mysqltime(time());
if(!$cardno)
{
$error.="Please enter your Credit Card No.";
}
if ((intval(strlen($cardno))!=16))
{
$error.="The credit card number should be 16 digits and numeric";
}
if(!$expmonth)
{
$error.="Please select your Credit Card Expiry Month.";
}
if(!$expyear)
{
$error.="Please select your Credit Card Expiry Year.";
}
if(!$cardtype)
{
$error.="Please select your Credit Card type.";
}
if (!$digback)
{
$error.="Card Verification Number is mandatory";
}
else
{
if (strlen($digback)!=3)
{
$error .="Card Verification Number has to be the 'last three numbers' of the multidigit number at the back of your card";
}
}//end of if NOT (!$email)
if($zipc)
{
// begining of if ($zip)
### Giving number and alphabet validation to zip because in UK the zip contains alphabets
if(eregi("[^0-9a-z-]",$zipc))
{
$error .="Invalid Zip";
}
}//end of if ($ccbills_zip)
if ($telephonec)
{
if(eregi("[^+0-9-]",$telephonec))
{
$error .="Invalid Telephone";
}
}//end of if NOT (!$telephone)
$chrtocheck="^[A-Za-z0-9\._-]+@([A-Za-z0-9][A-Za-z0-9-]{1,62})(\.[A-Za-z][A-Za-z0-9-]{1,62})+$";
$chrtocheck1 ="^[A-Za-z0-9\._-]+@([A-Za-z][A-Za-z0-9-]{1,62})(\.[A-Za-z][A-Za-z0-9-]{1,62}) (\.[A-Za-z]{1,2})+$";
if($emailc)
{
if((!ereg("$chrtocheck",$emailc))&&(!ereg("$chrtocheck",$emailc)))
{
$error.="Please enter valid email address of you credit card information.";
}
}
if(!$error)
{
$name=addslashes($name);
$cname=addslashes($cname);
$email=addslashes($email);
$tel=addslashes($tel);
$sql="insert into ynfx_ir_archive_subscribe values(null, '$login', '$id_i', '$price', '$date_app', 'C', 'U', 'N', 0)";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) echo ("Unexpected Error".mysql_error());
$idcc=mysql_insert_id();
if(mysql_error()) echo ("Unexpected Error".mysql_error().$sql);
$cardno=ereg_replace ('[^0-9]+', '', $cardno);
$string = $cardno;
$key ="altufaltu" ;
$enc_text = encrypt($string,$key);
$dec_text = decrypt($enc_text,$key);
$card_no=$enc_text;
$h= date("H", mktime() );
$i= date("i", mktime() );
$s= date("s", mktime() );
$expdate=1;
$stamp_exp=mktime($h,$i,$s, intval($expmonth), intval($expdate), intval($expyear));
$date=mktime_to_mysqltime(time());
$namec=addslashes($namec);
$card_no=addslashes($cardno);
$streetc=addslashes($streetc);
$cityc=addslashes($cityc);
$statec=addslashes($statec);
$zipc=addslashes($zipc);
$login="";
$sql = "insert into creditcard_ir values('', '$login', '$namec', '$card_no', '$cardtype', '$stamp_exp', '$price', '$countryc', '$date', '$digback', '$streetc', '$cityc', '$statec', '$zipc', '$telephonec', '$emailc', '$idcc', 'Y')";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
$query="Select header from ynfx_mis_ir WHERE id=$id_i";
$result=mysql_db_query($DATABASE,$query);
if(mysql_error()) error("Unexpected Error");
if(mysql_num_rows($result))
{
while($row=mysql_fetch_row($result))
{
$header=$row[0];
}//end of while
}//end of if
$comment="The report '$header' will be delivered to you soon";
?>
|
echo $comment ?>
|
|
}//end of if error
}
if(!$submit1)
{
?>
}
?>
|