Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Thread Tools Display Modes
Old 01-02-2012, 10:02 PM   #1
Join Date: Dec 2011
Posts: 4
Default Where I am wrong

I made a reset password form; the PHP script is copied here, can someone pls let me know where I am making mistake, the query is not working

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($email, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
  if (PHP_VERSION < 6) {
    $email = get_magic_quotes_gpc() ? stripslashes( $email) :  $email;

  $email = function_exists("mysql_real_escape_string") ? mysql_real_escape_string( $email) : mysql_escape_string( $email);

  switch ($theType) {
    case "text":
       $email = ( $email != "") ? "'" .  $email . "'" : "NULL";
    case "long":
    case "int":
       $email = ( $email != "") ? intval( $email) : "NULL";
    case "double":
       $email = ( $email != "") ? doubleval( $email) : "NULL";
    case "date":
       $email = ( $email != "") ? "'" .  $email . "'" : "NULL";
    case "defined":
       $email = ( $email != "") ? $theDefinedValue : $theNotDefinedValue;
  return  $email;
mysql_select_db($database_conniBroker, $conniBroker);
$query_rsPW = "SELECT membership.Email FROM membership WHERE membership.Email = '$email' ";
$rsPW = mysql_query($query_rsPW, $conniBroker) or die(mysql_error());
$row_rsPW = mysql_fetch_assoc($rsPW);
$totalRows_rsPW = mysql_num_rows($rsPW);

$status = "OK";
error_reporting(E_ERROR | E_PARSE | E_CORE_ERROR);
if (!stristr($email,"@") OR !stristr($email,".")) {
$msg="Your email address is not correct<BR>"; 
$status= "NOTOK";}

echo "<br><br>";
if($status=="OK"){  $query_rsPW="SELECT membership.Email FROM membership WHERE membership.Email = '$email'";
 if ($recs == 0) {  echo "<center><font face='Verdana' size='2' color=red><b>No Password</b><br> Sorry Your address is not there in our database . You can signup and login to use our site. <BR><BR><a href='Registration.php'> Sign UP </a> </center>"; exit;}

$headers.="Reply-to: $headers4\n";
$headers .= "From: $headers4\n"; 
$headers .= "Errors-to: $headers4\n"; 
$headers = "Content-Type: text/html; charset=iso-8859-1\n".$headers;

 if(mail("$em","Your Request for login details","This is in response to your request for login detailst at site_name \n \nLogin ID: $row->userid \n Password: $row->password \n\n Thank You \n \n siteadmin","$headers")){echo "<center><font face='Verdana' size='2' ><b>THANK YOU</b> <br>Your password is posted to your email address . Please check your mail after some time. </center>";}
else{ echo " <center><font face='Verdana' size='2' color=red >There is some system problem in sending login details to your address. Please contact site-admin. <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}


    else {echo "<center><font face='Verdana' size='2' color=red >$msg <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}

Last edited by Corrosive; 01-03-2012 at 07:31 AM..
Arif is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 04:42 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com