How to add new database use existing php

Question

andyliany 0 Newbie Poster

12 Years Ago

Somebody can help me? I want to edit my register page, i want to add new value to my database. Like Bank name, Phone number, address and other, below here is my existing register.php.

<?php
	
	function _generate_user_id(){
		$istnieje = false;
		do{
			$losuj = mt_rand(100,999).mt_rand(0,9).mt_rand(0,9).mt_rand(100,999).mt_rand(0,9);
			$result = mysql_query("SELECT `id` FROM `xeon_users` WHERE `x_username_2` = '$losuj' LIMIT 1;") or die( _OP_ERROR(mysql_error(), __FILE__ ,__LINE__) );;
			
			$istnieje = (mysql_num_rows($result) > 0);
		}
		while($istnieje);
		return $losuj;
	}

	if(CORE){ _redirect("{$config['url']}?v=c"); }

# REGISTER
	if($_SERVER['REQUEST_METHOD'] == 'POST'){	
	
	# USERNAME CHECK        
        if($_POST['user'] != ''){
			
			if(isValid('username', $_POST['user'])){
					
				$query = mysql_query("SELECT COUNT(1) FROM `xeon_users` WHERE `x_username` = '".mysql_real_escape_string($_POST['user'])."' LIMIT 1;");
				$query = mysql_fetch_array($query);
				
				if($query[0] > 0){
					echo 'Sorry, username ( <b>'.$_POST['user'].'</b> ) is already taken.';
				} else {
					echo 'Username ( <b>'.$_POST['user'].'</b> ) is available to register.';
				}
		
			} else {
				echo 'You must enter a valid username.';
			}
			exit;
		}
        
		if(isset($_COOKIE['xCORU'])){
            echo 'Already have an account!'; exit;
		}
	
	# VALIDATIONS

        if(isset($_POST['username_available'])){
            if($_POST['username_available'] == 1){
                die('Do not open more accounts, if you lost your username or password please forgot it.');
            }
        }
        
        $bValid = true;
			
		$bValid = $bValid && isValid('username', $_POST['username']);
		$bValid = $bValid && isValid('pin', $_POST['year']);
		$bValid = $bValid && $_POST['password'] == '' ? false : true;
		$bValid = $bValid && $_POST['repassword'] == '' ? false : true;
		
        if(!$bValid){
			
			echo 'Error, blank fields or invalid entry!'; exit;
			
		}
		
		# TOKEN
        if(dracon_CodeEnc(strtoupper($_POST['code'])) != $_SESSION['captcha']) {
            echo 'Please enter a valid Verification Code!'; exit;
        }
		
	# DATA BASE CHECK
		$xUSERNAME = COUNT_ROW('xeon_users', 'x_username', mysql_real_escape_string($_POST['username']), '=', 1);
		$xPERSONAL = COUNT_ROW('xeon_users', 'x_personal'   , mysql_real_escape_string($_POST['email']), '=', 1);
		$xPAYMENT_AP  = COUNT_ROW('xeon_users', 'x_payment_alertpay', mysql_real_escape_string($_POST['alertpay']), '=', 1);
		$xPAYMENT_PP  = COUNT_ROW('xeon_users', 'x_payment_paypal', mysql_real_escape_string($_POST['paypal']), '=', 1);
		$xUSER_IP  = COUNT_ROW('xeon_users', 'x_ip', $_SERVER["REMOTE_ADDR"], '=', 1);
		
		if($xUSERNAME > 0){
			echo 'Sorry, username ( <b>'.$_POST['username'].'</b> ) is already taken!'; exit;
		}
		
		if($xPERSONAL > 0){
			echo 'Personal email alerady exist in our database!'; exit;
		}
		
		if($xPAYMENT_AP > 0){
			echo 'AlertPay email alerady exist in our database!'; exit;
		}
		
		if($xPAYMENT_PP > 0){
			echo 'PayPal email alerady exist in our database!'; exit;
		}
		
		if($xUSER_IP > 0){
			echo 'Sorry, IP ( <b>'.$_SERVER["REMOTE_ADDR"].'</b> ) has been registered in our database!'; exit;
		}
	
	# UPLINE CHECK
		$cREFERER_STR = mysql_real_escape_string($_POST['referer']);
		$xREFERER_SQL = mysql_query("SELECT * FROM `xeon_users` WHERE `x_username` = '$cREFERER_STR' OR `x_username_2` = '$cREFERER_STR' LIMIT 1;") or die( _OP_ERROR(mysql_error(), __FILE__ ,__LINE__) );;
		
		if(mysql_num_rows($xREFERER_SQL) > 0){
			
			$xUPLINE_DAT = mysql_fetch_assoc($xREFERER_SQL);
			$xUPLINE_INT_SQL = mysql_query("SELECT * FROM `xeon_users` WHERE `r_referer` = '{$xUPLINE_DAT['x_username']}';") or die( _OP_ERROR(mysql_error(), __FILE__ ,__LINE__) );;
			$xUPLINE_INT = mysql_num_rows($xUPLINE_INT_SQL);
			
			if($xUPLINE_DAT['s_referals_direct'] != $xUPLINE_INT){
				//mysql_query("UPDATE `xeon_users` SET `s_referals_direct` = '$xUPLINE_INT' WHERE `id` = {$xUPLINE_DAT['id']} LIMIT 1;") or die( _OP_ERROR(mysql_error(), __FILE__ ,__LINE__) );;
			}
			
			if( $xUPLINE_INT < $xUPLINE_DAT['s_referals_direct_limit'] ){
			
				$xUPLINE = $xUPLINE_DAT['x_username']; # ADDED
			
			} else {
				$xUPLINE = ''; # NOT ADDED LIMIT
			}
			
		} else {
			
			$xUPLINE = ''; # NOT ADDED UPLINE NO EXIST
	
		}
		
	# ZMIENNE
		$country = _db_ipToCountry();
		
		$MYSQL['username']     = mysql_real_escape_string($_POST['username']);
		$MYSQL['username_2']   = _generate_user_id();
		$MYSQL['password']     = sha1($_POST['password']);
		$MYSQL['personal']     = mysql_real_escape_string($_POST['email']);
		$MYSQL['payment']      = mysql_real_escape_string($_POST['alertpay']);
		$MYSQL['payment_ap']   = mysql_real_escape_string($_POST['alertpay']);
		$MYSQL['payment_pp']   = mysql_real_escape_string($_POST['paypal']);
		$MYSQL['ip']           = $_SERVER["REMOTE_ADDR"];
		$MYSQL['country_iso2'] = $country['country2'];
		$MYSQL['country_iso3'] = $country['country3'];
		$MYSQL['country_full'] = mysql_real_escape_string($country['country']);
		$MYSQL['come']         = mysql_real_escape_string($_COOKIE['xHT']);
		$MYSQL['year']         = mysql_real_escape_string($_POST['year']);
		$MYSQL['time']         = time();
		$MYSQL['upline']       = $xUPLINE;
	
		mysql_query("
			INSERT INTO `xeon_users` (
				`x_username`,
				`x_username_2`,
				`x_password`,
				`x_contry`,
				`x_country_iso2`,
				`x_country_full`,
				`x_come`,
				`x_register`,
				`x_year`,
				`x_ip`,
				`x_personal`,
				`x_payment`,
				`x_payment_alertpay`,
				`x_payment_paypal`,
				`r_referer`,
                `e_payment`,
				`config_username`,
				`config_autopay`,
				`config_autorec`,
                `s_referals_direct_limit`,
                `s_referals_rented_limit`
			) VALUES (
				'{$MYSQL['username']}',
				'{$MYSQL['username_2']}',
				'{$MYSQL['password']}',
				'{$MYSQL['country_iso3']}',
				'{$MYSQL['country_iso2']}',
				'{$MYSQL['country_full']}',
				'{$MYSQL['come']}',
				'{$MYSQL['time']}',
				'{$MYSQL['year']}',
				'{$MYSQL['ip']}',
				'{$MYSQL['personal']}',
				'{$MYSQL['payment']}',
				'{$MYSQL['payment_ap']}',
				'{$MYSQL['payment_pp']}',
				'{$MYSQL['upline']}',
                '0:".CASHOUT_WAIT_TIME_ST.':'.CASHOUT_MINIMUM_1."',
				'1',
				'aOF',
				'rOF',
                '".ZEUS_REFERRALS_LIMIT_DIRECT_0."',
                '".ZEUS_REFERRALS_LIMIT_RENTED_0."'
			);
		") or die( _OP_ERROR('<pre>'.print_r($MYSQL, true).'</pre><br>'.mysql_error(), __FILE__ ,__LINE__).'Upss error, please refresh page and try again.' );
		
		mysql_query("INSERT INTO `xeon_users_history` (`user`,`date`,`type`,`value`) VALUES ('{$MYSQL['username']}','{$MYSQL['time']}','0','');") or die( _OP_ERROR(mysql_error(), __FILE__ ,__LINE__) );;
		
		if(strlen($MYSQL['upline']) > 0){
			mysql_query("UPDATE `xeon_users` SET `s_referals_direct` = `s_referals_direct` + '1' WHERE `x_username` = '{$MYSQL['upline']}' LIMIT 1") or die( _OP_ERROR(mysql_error(), __FILE__ ,__LINE__) );;
			mysql_query("INSERT INTO `xeon_users_history` (`user`,`date`,`type`,`value`) VALUES ('{$MYSQL['upline']}','{$MYSQL['time']}','2','{$MYSQL['username']}');") or die( _OP_ERROR(mysql_error(), __FILE__ ,__LINE__) );;
			
			$QUERY_SQL = mysql_query("SELECT * FROM `xeon_users` WHERE `x_username` = '{$r['user_by']}' LIMIT 1;") or _OP_CRON_RENTED_ERROR(mysql_error(), __FILE__, __LINE__);
			$QUERY_DAT = mysql_fetch_assoc($QUERY_SQL);
			_OP_PROFIT_INSERT($xUPLINE_DAT['x_username'], $xUPLINE_DAT['id'], $xUPLINE_DAT['s_referals_direct'], $xUPLINE_DAT['s_referals_rented'], 's_new_direct', 1, 1);
		
		}
		
		config_update('users_total', config('users_total')+1);
		
		require_once($_SERVER["DOCUMENT_ROOT"].'/includes/php/class.phpmailer.php');
		$mail = new PHPMailer();
		
		$body = '
			<p>Thank you for your interest in '.$config['site'].' Program. We know you have numerous options and look forward to earning your trust and welcoming you as our exclusive partner.</p>
			<p>For your convenience, below we have listed your login information for the '.$config['site'].' site.</p>
			
			<p>Your login informations:<br />
			<p>Username: <b>'.$MYSQL['username'].'</b><br />
			Password: <b>'.$_POST['password'].'</b>
			</p>
			Regards,<br />
			'.$config['site'].' Team
		';
		
		$mail->AddReplyTo(SITE_INFO_SUPPORT, SITE_INFO_NAME);
		$mail->SetFrom(SITE_INFO_SUPPORT, SITE_INFO_NAME);
		$mail->AddReplyTo(SITE_INFO_SUPPORT, SITE_INFO_NAME);

		$mail->AddAddress($MYSQL['personal'], '');
		$mail->Subject = $config['site'].' - Login Details.';
		$mail->MsgHTML($body);

		if(!$mail->Send()){}
        
        if(config('users_total') < config('extended_accounts')){
            mysql_query("UPDATE `xeon_users` SET `e_account` = '1:0', `s_referals_direct_limit` = '".ZEUS_REFERRALS_LIMIT_DIRECT_1."', `s_referals_rented_limit` = '".ZEUS_REFERRALS_LIMIT_RENTED_1."' WHERE `x_username` = '".$MYSQL['username']."' LIMIT 1;");
            config_update('extended_accounts', (config('extended_accounts')-1));
        }
		
		setcookie('xCORU', mt_rand(1, 100000), (time() + (86400*368)), '/', '', 0);
        
        echo '_redirect'; exit;

    } else if($_GET['rr'] == 'r'){
	
?>
<div class="pg-core">
    <div style="width:360px;" class="pg-core-first ui-state-active zx-content-shadow ui-corner-all">
        <div class="pg-core-second ui-widget-header ui-corner-all">
            <div><span class="ui-icon flo-l ui-icon-color-white ui-icon-info"></span><span class="pg-core-info">Registration Complete! You may login now.</span></div>
        </div>
        <div id="pb" timeout="120" url="?v=l"></div>
    </div>
</div>
<script type="text/javascript">
$(function(){

    $('.pg-core').position({
        my:'center',
        at:'center',
        of:$('#zx-center')
    });
    
});
</script>
<?php
	
    } else {
    
?>
<style type="text/css">
<!--
.zx-register{}
.zx-register a:hover{text-decoration:underline;}
.zx-register .zx-register-item{position:relative;margin:0 0 10px 0;}
.zx-register .zx-register-item #captcha{position:absolute;top:30px;left:208px;}

.zx-register .zx-register-item .item-left{position:relative;float:left;width:130px;padding:2px 5px 2px 15px;line-height:16px;font-weight:normal;}
.zx-register .zx-register-item .item-left .ui-icon{position:absolute;top:2px;left:0px;}
.zx-register .zx-register-item .item-center{float:left;margin:0 0 0 5px;padding:0;line-height:16px;}
.zx-register .zx-register-item .item-center .input,
.zx-register .zx-register-item .item-center .input:focus{width:198px;margin:0;padding:2px 5px;line-height:16px;outline:none;background:#FFF;}

.zx-register .zx-register-item .item-right{float:right;padding:2px 5px;line-height:16px;font-weight:normal;cursor:help;}
-->
</style>
    
    <div class="zx-register">
        <div class="zx-register ui-helper-clearfix ui-widget-header zx-content-shadow ui-corner-top" style="width:399px;margin:0 auto;padding:10px;border-width:1px 1px 0 1px;">
            Register new account ...
        </div>
        <div style="width:400px;margin:0 auto;padding:10px;font-size:11px;" class="ui-helper-clearfix ui-widget-zx-content-page zx-content-shadow">

<form id="form-reg" action="/" method="post" onsubmit="return false;">

            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="username">Username:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><input type="text" name="username" id="username" class="input ui-widget-zx-content-page" value="" /></div>
                <div title="Your username.<br/>5-16 alphanumeric/underscore." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="password">Choose password:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><input type="password" name="password" id="password" class="input ui-widget-zx-content-page" value="" /></div>
                <div title="Your password.<br/>6-50 all characters." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="repassword">Re-enter password:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><input type="password" name="repassword" id="repassword" class="input ui-widget-zx-content-page" value="" /></div>
                <div title="Re-enter your password.<br/>6-50 all characters." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="email">Personal email:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><input type="text" name="email" id="email" class="input ui-widget-zx-content-page" value="" /></div>
                <div title="Valid personal email address." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="alertpay">AlertPay email:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><input type="text" name="alertpay" id="alertpay" class="input ui-widget-zx-content-page" value="" /></div>
                <div title="Valid AlertPay email address." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="paypal">PayPal email:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><input type="text" name="paypal" id="paypal" class="input ui-widget-zx-content-page" value="" /></div>
                <div title="Valid PayPal email address." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="referer">Referrer:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><?php echo strlen($_COOKIE['r']) > 0 ? '<input readonly="readonly" type="text" name="referer" id="referer" class="not input ui-widget-zx-content-page" value="'.$_COOKIE['r'].'" />' : '<input type="text" name="referer" id="referer" class="not input ui-widget-zx-content-page" value="" />'; ?></div>
                <div title="Valid referrer username." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="year">Birth year:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><input type="text" name="year" id="year" class="input ui-widget-zx-content-page" value="" maxlength="4" /></div>
                <div title="Your birth year.<br/>eg. 1980." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="tos">Terms Of Service:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><select id="tos" size="1" class="ui-widget-zx-content-page" style="width:210px;height:22px;"><option value="0" selected="selected">I do not accept.</option><option value="1">Yes I agree.</option></select></div>
                <div title="Check if you read and understand our T.O.S." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix">
                <div class="item-left ui-widget-header zx-content-shadow ui-corner-left"><label for="code">Verification Code:</label><span class="ui-icon ui-icon-color-white ui-icon-triangle-1-e"></span></div>
                <div class="item-center zx-content-shadow"><input type="text" name="code" id="code" class="input ui-widget-zx-content-page" value="" maxlength="5" style="text-transform:uppercase;" /></div>
                <div title="Enter verification Code." class="item-right tipTip ui-widget-header zx-content-shadow ui-corner-right"><span class="ui-icon ui-icon-color-white ui-icon-help"></span></div>
                <div style="position: absolute; top: 28px; left: 185px;"><?php require_once dirname(__FILE__).'/../includes/img/image/captcha/index.php'; ?></div>
            </div>
            
            <div class="zx-register-item ui-helper-clearfix" style="width:128px;margin:10px 0 5px 25px;">
                <input type="hidden" value="0" name="username_available" id="username_available" />
                <button id="request-reg" class="ui-button ui-widget-header zx-content-shadow ui-corner-all ui-button-text-icon">
                    <span class="ui-button-icon-primary ui-icon ui-icon-color-white ui-icon-circle-triangle-e"></span>
                    <span class="ui-button-text">Register</span>
                </button>
            </div>

</form>

        </div>
        <div class="zx-register ui-helper-clearfix ui-widget-zx-content-page zx-content-shadow ui-corner-bottom" style="width:230px;margin:-1px auto 0 auto;padding:10px;background:#CCCCCC none;border-width:0 1px 1px 1px;text-align:center;;font-size:11px;-moz-box-shadow:3px 3px 3px rgba(0,0,0,0.4);-webkit-box-shadow:3px 3px 3px rgba(0,0,0,0.4);box-shadow:3px 3px 3px rgba(0,0,0,0.4);">Already have an account? <a href="/?v=l"><b>Login</b></a>!</div>

    </div>
    
<script type="text/javascript">
function _reload(){
    $('#captcha').optoken({
        u:window.location.protocol+'//'+window.location.host+'/',
        t:'ll',
        r:mt_rand(100,1000)
    });
}

$(function(){
    
    $('#captcha').optoken({
        u:window.location.protocol+'//'+window.location.host+'/',
        t:'ll',
        r:mt_rand(100,1000)
    }).click(function(){
        $(this).optoken({
            u:window.location.protocol+'//'+window.location.host+'/',
            t:'ll',
            r:mt_rand(100,1000)
        });
    });
    
    $('.zx-register-item .item-center select').menu().css({'border-radius':'0','-moz-border-radius':'0','-webkit-border-radius':'0'});
    
    $('.zx-register .ui-button').css({'font-weight':'normal'}).hover(function(){
        $(this).addClass('ui-state-hover');
    }, function(){
        $(this).removeClass('ui-state-hover');
    });
    
	$('#request-reg').click(function(){
		
        var bV = true;
        var username=$("#username"),password=$("#password"),repassword=$("#repassword"),email=$("#email"),alertpay=$("#alertpay"),paypal=$("#paypal"),referer=$("#referer"),year=$("#year"),tos=$("#tos"),code=$("#code"),t=$("tempnouse"),Fields=$([]).add(username).add(password).add(repassword).add(email).add(alertpay).add(paypal).add(referer).add(year).add(tos).add(code);if(_isset(CB_Cookie.get('TWCOME'))){if(CB_Cookie.get('TWCOME').length > 0){$('#username_available').val('1');}}

		Fields.removeClass('ui-state-error');
        
        bV=bV&&_c_Length(t,username,"username",5,16);
		bV=bV&&_c_Regexp(t,username,/^([0-9a-z_])+$/i,"Username may consist of a-z A-Z 0-9, case sensitive and underscores.");
		bV=bV&&_c_Length(t,password,"password",6,50);
		bV=bV&&_c_Length(t,repassword,"password",6,50);
		bV=bV&&_c_Clone(t,password,repassword,'Password fields do not match.');
		bV=bV&&_c_Length(t,email,"email",6,80);
		bV=bV&&_c_Regexp(t,email,/^((([a-z]|\d|[!#\$%&'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+(\.([a-z]|\d|[!#\$%&'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+)*)|((\x22)((((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(([\x01-\x08\x0b\x0c\x0e-\x1f\x7f]|\x21|[\x23-\x5b]|[\x5d-\x7e]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(\\([\x01-\x09\x0b\x0c\x0d-\x7f]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))))*(((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(\x22)))@((([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.)+(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.?$/i,"Invalid email: eg. admin@example.com");
		
		bV=bV&&_c_Length(t,alertpay,"alertpay",6,80);
		bV=bV&&_c_Regexp(t,alertpay,/^((([a-z]|\d|[!#\$%&'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+(\.([a-z]|\d|[!#\$%&'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+)*)|((\x22)((((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(([\x01-\x08\x0b\x0c\x0e-\x1f\x7f]|\x21|[\x23-\x5b]|[\x5d-\x7e]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(\\([\x01-\x09\x0b\x0c\x0d-\x7f]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))))*(((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(\x22)))@((([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.)+(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.?$/i,"Invalid email: eg. admin@example.com");
		bV=bV&&_c_Length(t,paypal,"paypal",6,80);
		bV=bV&&_c_Regexp(t,paypal,/^((([a-z]|\d|[!#\$%&'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+(\.([a-z]|\d|[!#\$%&'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+)*)|((\x22)((((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(([\x01-\x08\x0b\x0c\x0e-\x1f\x7f]|\x21|[\x23-\x5b]|[\x5d-\x7e]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(\\([\x01-\x09\x0b\x0c\x0d-\x7f]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))))*(((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(\x22)))@((([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.)+(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.?$/i,"Invalid email: eg. admin@example.com");
		
		bV=bV&&_c_Regexp(t,referer,/^([0-9a-z_])+$/i,"Referer may consist of a-z A-Z 0-9, case sensitive and underscores.");
		bV=bV&&_c_Multi(t,username,referer,'This fields must be unique!');
		bV=bV&&_c_Length(t,year,"birth year",4,4);
		bV=bV&&_c_Regexp(t,year,/^([0-9])+$/,"Birth year field only allow : 0-9");
        
        bV=bV&&_c_Length(t,code,"verification Code",5,5);
		bV=bV&&_c_Regexp(t,code,/^([0-9A-Za-z])+$/,"Verification Code field only allow : A-Z");
        
        if(!bV){return false} else {
			
    		if( $('#tos option:selected').val() == 0){
            	$.jGrowl('Confirm that you accept our Terms Of Service.',{header:"Error!",sticky:true});
            	tos.addClass('ui-state-error');
                return false;
    		}
            
            $.ajax({type:'POST',url:window.location.protocol+'//'+window.location.host+_uri,data:$('#form-reg').serialize(),cache:false,
				success:function(html){
					if(html == '_redirect'){
						window.location.href = 'http://'+document.location.hostname+'/?v=r&rr=r';
					} else {
						_reload(); $.jGrowl(html,{header:"Important!", sticky:true});
					}
				}
			});
		}
	});
	
	<?php
		if(isset($_SESSION['register_error'])){
			echo '$.jGrowl("'.$_SESSION['register_error'].'",{header:"Error!",sticky:true});';
			unset($_SESSION['register_error']);
		}
	?>
    
});
</script>
<?php
	
    }
    
?>

I want to add new form field for bank name, phone number and address too.
Thank you, i hope someone could help me here.

php

2 Contributors
3 Replies
293 Views
1 Day Discussion Span
Latest Post 12 Years Ago Latest Post by cereal

All 3 Replies

cereal 1,524 Nearly a Senior Poster

12 Years Ago

The fields you want to add are already on the database table?
If no, use alter command from mysql client to add it, an example:

alter table `xeon_users` add `phone` varchar(50) not null;
alter table `xeon_users` add `bankName` varchar(255) not null;
alter table `xeon_users` add `address` varchar(255) not null;

Then just add input fields to your html form and update the insert and update queries. For example:

1) on line 143 add: $MYSQL['phone'] = $_POST['phone']; 2) on line 166, add a comma, go to new line an write: `phone` 3) on line 188 do the same, add a comma, and write: '{MYSQL['phone']}' Remember to backup your database, or at least the interested table, before performing changes. And work always on a copy of your script.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

andyliany 0 Newbie Poster · Answer 1 · 2011-09-03T15:01:12+00:00

Thanks bro cereal, it's work i can add more value now. Good job, Thank you.

cereal 1,524 Nearly a Senior Poster Featured Poster · Answer 2 · 2011-09-03T15:29:17+00:00

cereal 1,524 Nearly a Senior Poster

12 Years Ago

You're welcome, bye :)

How to add new database use existing php

Recommended Answers Collapse Answers

All 3 Replies

Recommended Answers