Click here to Skip to main content
16,005,181 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: Anybody know how to upload video using ASP.NET? Pin
led mike18-Dec-06 4:54
led mike18-Dec-06 4:54 
GeneralRe: Anybody know how to upload video using ASP.NET? Pin
RichardGrimmer18-Dec-06 5:47
RichardGrimmer18-Dec-06 5:47 
Questionasp.net dropdownlist Pin
hhems15-Dec-06 0:13
hhems15-Dec-06 0:13 
AnswerRe: asp.net dropdownlist Pin
phimix15-Dec-06 0:51
phimix15-Dec-06 0:51 
QuestionHtml tags filter Pin
sudidelaravindra14-Dec-06 19:07
sudidelaravindra14-Dec-06 19:07 
AnswerRe: Html tags filter Pin
Bradml14-Dec-06 20:10
Bradml14-Dec-06 20:10 
GeneralRe: Html tags filter Pin
sudidelaravindra19-Dec-06 18:01
sudidelaravindra19-Dec-06 18:01 
QuestionIs there any good format for registration page and the display page than this? Pin
VinuLite14-Dec-06 17:51
VinuLite14-Dec-06 17:51 
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Registration Page
//////////////////
getTableValue("memberId ","membertable ","m_userName ='$VARS[uname]'")!="")
$errmsg = "User Already Exist";
elseif($dbc->getTableValue("memberId","membertable ","m_emailAddr ='$VARS[email]'")!="")
$errmsg = "E_mail Already Exist";
if (strlen($errmsg)==0) {
$now = time();
$insertArray = array("m_firstName"=>$VARS[fname],"m_lastName"=>$VARS[lname],"m_userName"=>$VARS[uname],
"m_password"=>$VARS[pword],"m_address"=>$VARS[address],"m_emailAddr"=>$VARS[email],
"m_jointDate"=>$now,"m_city"=>$VARS[city],"m_zipcode"=>$VARS[zip],"m_phone"=>$VARS[phone], "m_mobile"=>$VARS[mobile],"m_accountStatus"=>"A","accountType"=>"M");
$dbc->InsertQuery("membertable",$insertArray);
header("location:index.php");
}
echo $errmsg;
}
?>



Member Registration




* Fields are mandatory
First Name*
Last Name*
Address*
City
Zip
Phone
Mobile
Email*
Username*
Password*






function emailok(str,form,inputval)
{

var reg1 = /(@.*@)|(\.\.)|(@\.)|(\.@)|(^\.)/; // not valid
var reg2 = /^.+\@(\[?)[a-zA-Z0-9\-\.]+\.([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$/; // valid
if (!reg1.test(str) && reg2.test(str))
{
return true;
}
else{
alert("\"" + str + "\" is an invalid e-mail!");
form = eval("document."+ form );
eval("form."+inputval+".focus()");


return false;
}
}

function formValidate() {
if(document.frm1.fname.value=="") {
alert("Please enter the Firstname");
document.frm1.fname.focus();
return false;
} else if(document.frm1.lname.value=="") {
alert("Please enter the Lastname");
document.frm1.lname.focus();
return false;
} else if(document.frm1.address.value=="") {
alert("Please enter the Address");
document.frm1.address.focus();
return false;
} else if(Trim(frm1.email.value)==0) {
alert("Please enter Contactemail");
frm1.email.focus();
return false;
} else if (!emailok(frm1.email.value,"frm1","email")) {
return false;
} else if(document.frm1.uname.value=="") {
alert("Please enter the Username");
document.frm1.uname.focus();
return false;
} else if(document.frm1.pword.value=="") {
alert("Please enter the Password");
document.frm1.pword.focus();
return false;
} else return true;
}


////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
To Update the registration details
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$VARS[fname],"m_lastName"=>$VARS[lname],"m_userName"=>$VARS[uname],
"m_password"=>$VARS[pword],"m_address"=>$VARS[address],"m_emailAddr"=>$VARS[email],
"m_updateDate"=>$now,"m_city"=>$VARS[city],"m_zipcode"=>$VARS[zip],
"m_phone"=>$VARS[phone],"m_mobile"=>$VARS[mobile],"m_accountStatus"=>"A",
"accountType"=>"M");
}
else {

$updateArray = array("m_firstName"=>$VARS[fname],"m_lastName"=>$VARS[lname],"m_userName"=>$VARS[uname],
"m_address"=>$VARS[address],"m_emailAddr"=>$VARS[email],
"m_updateDate"=>$now,"m_city"=>$VARS[city],"m_zipcode"=>$VARS[zip],
"m_phone"=>$VARS[phone],"m_mobile"=>$VARS[mobile],"m_accountStatus"=>"A",
"accountType"=>"M");
}

$dbc->UpdateQuery("membertable",$updateArray,"memberId ='$memId'");

$errmsg = "Your profile updated.";

}

$query = "SELECT * FROM membertable WHERE memberId='$memId'";
$result = mysql_query($query);
//$result = $dbc->ExecuteQuery($query);
$row = mysql_fetch_array($result);
?>



Update Profile Details





* Fields are mandatory
First Name* " size="30">
Last Name* " size="30">
Address* <?=$row["m_address"]?>
City " size="30">
Zip " size="20">
Phone " size="20">
Mobile " size="20">
Email* " size="30">
Username* " size="30">
Password*




/////////////////////////////////
To display it in Admin Side.
//////////////////////////////////
";
}elseif($sby=='D'){
$sortquery = " ORDER BY m_firstName DESC, memberId DESC";
$sby="A";
$fnamesortarrow = "";
}

break;

case "lname":// Member lastname sorting...

if ($sby=='A'){
$sortquery = " ORDER BY m_lastName ASC, memberId ASC";
$sby="D";
$lnamesortarrow = "";
}elseif($sby=='D'){
$sortquery = " ORDER BY m_lastName DESC, memberId DESC";
$sby="A";
$lnamesortarrow = "";
}

break;

case "email":// Member email sorting...

if ($sby=='A'){
$sortquery = " ORDER BY m_emailAddr ASC, memberId ASC";
$sby="D";
$emailsortarrow = "";
}elseif($sby=='D'){
$sortquery = " ORDER BY m_emailAddr DESC, memberId DESC";
$sby="A";
$emailsortarrow = "";
}

break;

case "uname":// Member username sorting...

if ($sby=='A'){
$sortquery = " ORDER BY m_userName ASC, memberId ASC";
$sby="D";
$unamesortarrow = "";
}elseif($sby=='D'){
$sortquery = " ORDER BY m_userName DESC, memberId DESC";
$sby="A";
$unamesortarrow = "";
}

break;


case "accstatus":// Member accountstatus sorting...

if ($sby=='A'){
$sortquery = " ORDER BY m_accountStatus ASC, memberId ASC";
$sby="D";
$accstatussortarrow = "";
}elseif($sby=='D'){
$sortquery = " ORDER BY m_accountStatus DESC, memberId DESC";
$sby="A";
$accstatussortarrow = "";
}

break;

default: //Default , it will be in the posted order...
$sortquery = " ORDER BY m_firstName DESC, memberId DESC";
$sby="A";
$namesortarrow = "";
break;


}

$query = "SELECT * FROM membertable WHERE accountType='M' and memberId IS NOT NULL $sortquery ";
//$query = "SELECT mem.*,con.country_name FROM membertable mem LEFT JOIN country_list con
// ON mem.m_country = con.country_id WHERE accountType='M' and memberId IS NOT NULL $sortquery ";
//echo $query ;


//$res=mysql_query($sql);
$result = $dbc->ExecuteQuery($query);

?>


Members List




FirstName LastName Username E-mail Zipcode Status View Edit
','');"> ">View ">Edit







function ChangeStatus(id,status) {
switch(status) {
case "A":
str = "Do you want to de-activate this account?";
break;
case "D":
str = "Do you want to acitvate this account?";
break;
}
if (confirm(str)) {
document.location.href='aord.php?memberId='+id;
}
}

//////////////////
Active or deactive
//////////////////
getTableValue("m_accountStatus","membertable ","memberId ='$id'");
//$accountType = $dbc->getTableValue("accountType","membertable ","memberId ='$id'");
if($status=='A'){

$updateArray = array("m_accountStatus" => "D");
$dbc->UpdateQuery("membertable ",$updateArray,"memberId ='$id'");
}else {
$updateArray = array("m_accountStatus" => "A");
$dbc->UpdateQuery("membertable",$updateArray," memberId ='$id'");
}
//if($accountType=='M')
header("location:display.php");
//else
// header("location:displayadmin.php");
//exit();
?>
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
AnswerRe: Is there any good format for registration page and the display page than this? [modified] Pin
Bradml14-Dec-06 18:45
Bradml14-Dec-06 18:45 
AnswerRe: Is there any good format for registration page and the display page than this? Pin
JimmyRopes16-Dec-06 23:00
professionalJimmyRopes16-Dec-06 23:00 
QuestionAJAX problem with ASP.net (maintain scroll) Pin
Alice@mywonderland14-Dec-06 7:05
Alice@mywonderland14-Dec-06 7:05 
QuestionI gave up and joined them, Style-Wize atleast. Pin
howardjr14-Dec-06 6:03
howardjr14-Dec-06 6:03 
AnswerRe: I gave up and joined them, Style-Wize atleast. Pin
howardjr14-Dec-06 7:13
howardjr14-Dec-06 7:13 
QuestionSoap ReadResponse Exception Pin
phimix14-Dec-06 2:02
phimix14-Dec-06 2:02 
AnswerRe: Soap ReadResponse Exception Pin
Bradml14-Dec-06 2:30
Bradml14-Dec-06 2:30 
AnswerRe: Soap ReadResponse Exception Pin
RichardGrimmer14-Dec-06 5:30
RichardGrimmer14-Dec-06 5:30 
GeneralRe: Soap ReadResponse Exception Pin
phimix15-Dec-06 0:49
phimix15-Dec-06 0:49 
QuestionAmazon API Pin
progman13-Dec-06 22:34
progman13-Dec-06 22:34 
AnswerRe: Amazon API Pin
phimix14-Dec-06 2:00
phimix14-Dec-06 2:00 
GeneralRe: Amazon API Pin
progman14-Dec-06 3:31
progman14-Dec-06 3:31 
QuestionExpert opinion!!! Pin
texan_wiz13-Dec-06 13:04
texan_wiz13-Dec-06 13:04 
AnswerRe: Expert opinion!!! Pin
MatrixCoder13-Dec-06 18:08
MatrixCoder13-Dec-06 18:08 
AnswerRe: Expert opinion!!! Pin
Bradml13-Dec-06 18:47
Bradml13-Dec-06 18:47 
AnswerRe: Expert opinion!!! Pin
Jeremy Falcon16-Dec-06 4:43
professionalJeremy Falcon16-Dec-06 4:43 
Questionflash + javascript Pin
Tamimi - Code13-Dec-06 3:55
Tamimi - Code13-Dec-06 3:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.