Web Developers

[mangy1983 51]

i just checked this with a fake email that does not exist in my database and l got an error message returned so it seems the query is running correctly, just that the script is not running the email

 

cheers Callum

[John Keswick 119]

Hi guys

I used your form John (thanks again) to input the email address and the following code to sent an email

 

I assume it is working as l am told that l will receive an email with my password but the trouble is no email!

 

I couldn't get the second part of your code to work John so l searched ad found this one instead.

 

Anyone know what could be wrong?

 

cheers Callum

 

 

<?php

session_start();

$dbHost = '';

$dbUser = '';

$dbPass = '';

$dbname = '';

$db = mysql_connect($dbHost,$dbUser,$dbPass);

mysql_select_db($dbname,$db);

$email=strip_tags($email);

if (!preg_match("/^([a-zA-Z0-9])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/", $email=$_POST['email']))

{

die("<font size=5>Please Enter A valid e-mail address</font>");

}

 

$query="SELECT Email_Address,Forename,Password FROM MEMBERS WHERE Email_Address = '$email'";

$st=mysql_query($query);

$recs=mysql_num_rows($st);

$row=mysql_fetch_object($st);

$em=$row->email;// email is stored to a variable

if ($recs == 0) { // No records returned, so no email address in our table

// let us show the error message

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='SIGHNUP.HTML'> Sign UP </a> </center>";

exit;}

 

// formating the mail posting

// headers here

$headers4="admin@someone.net"; // Change this address within quotes to your address

$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;

// for html mail un-comment the above line

// mail funciton will return true if it is successful

if(mail("$em","Your Request for login details","This is in response to your request for login detailst at Holly Faith \n \nLogin ID: $row->Forename \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 emil address . Please check your mail after some time. </center>";}

 

?>

 

What are your database collumn names? for example the collumn where the email addresses are stored, and password etc?

 

Email is Email_Address and password is Password and the table is called MEMBERS

 

cheers Callum

 

tables are all lower case!!!

MEMBER is member

Password is password

Email_Address is email_address

 

I take it you are running this on a live server? If not and you are doing this locally, for it to actually send a email, you will need to setup a smtp server for your php application.

 

Anyway, again i havent tested this, but it should work with the form that setout earlier... You need to fill in the relevant details such as database name, password, username etc

 

<?php

$con = mysql_connect("localhost", "username", "password");

if (!$con)

{

die('<p>There seems to be a problem, please try again soon.</p>');

}

$db_selected = mysql_select_db("databasename",$con);

 

$email= $_POST['email'];

$email= mysql_real_escape_string($email, $con);

$sql=("SELECT * FROM members where email_address='$email'") or trigger_error('<p>There seems to be a problem, please try again soon.</p>');

$result = mysql_query($sql, $con);

$row = mysql_fetch_assoc($result);

if (empty($row['email'])) {echo 'you have entered the wrong email address you numpty'; exit;}

else {

mail("$email", 'password recovery', "\n Your password is $row['password'] ." , "From: changethis" );

}

}

?>

[colint5 47]

imagine going for a nite out with theese two

 

 

 

only kiddin fellas, at least i know who to ask for help when my pc starts acting up

[Guest stewie]

just ask members to write there password down

[mangy1983 51]

Hi John l got it working!

 

thanks for the info and the script but what a nightmare!

 

cheers Callum

[John Keswick 119]

Hi John l got it working!

 

thanks for the info and the script but what a nightmare!

 

cheers Callum

 

 

Its all good fun!

 

[thenose 0]

Degree students these days, can't even work out the simplest problems, muts be spending too much time on extra curriculum activities :snack: :cheers: :snack: :cheers: :cheers: :cheers:

[mangy1983 51]

Degree students these days, can't even work out the simplest problems, muts be spending too much time on extra curriculum activities :snack: :cheers: :snack: :cheers: :cheers: :cheers:

 

Ok buddy

 

Perhaps you could help

 

 

<script>

 

function valForm()

{

 

if(!valid_required(document.ContactForm.name.value))

{

alert("Your name is a required field.")

 

return false

}

 

if(!EmailValid(document.ContactForm.email.value))

{

return false

}

 

if(!valid_required(document.ContactForm.notes.value))

{

alert("A message must be sent in the contact form.")

return false

}

else

{

return true

}

}

 

function valid_required(field)

{

if(field=="")

{

return false;

}

 

return true;

}

 

function EmailValid(email){

if(email=="")

{

alert("Email is required field!")

return false

}

len = email.length

 

if((email.charAt(1)=='@')||(email.charAt(1)=='.'))

{

alert("Invalid Email Please try again!")

return false

}

if((email.charAt(len-2)=='@')||(email.charAt(len-2)=='.'))

{

alert("Invalid Email Please try again!")

return false

}

 

 

 

count=0

dotcount=0

for (i=0; i< email.length; i++)

{

if(email.charAt(i)=='@')

count++

if(email.charAt(i)=='.')

dotcount++

}

 

if((count !=1)||(dotcount !=1))

{

alert("Invalid Email Please try again!")

return false

}

 

return true

}

 

It works perfectly bar one thing!

 

It will let me input a .com prefixed email addy but not a .co.uk email addy

 

Any ideas!

 

cheers Callum

[John Keswick 119]

I would run this through ajax if i were you, it looks cool too!

 

The regex you are looking for is this ^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$^

 

 

 

:laugh:

[mangy1983 51]

I would run this through ajax if i were you, it looks cool too!

 

The regex you are looking for is this ^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$^

 

 

 

:laugh:

 

thanks for the advice John I have tried to implement an empty field validate for other fields plus a check on the email format. I have used this code on a similar page but when l try to mix them with my last post code it stops working

 

 

<script language="javascript">

 

function validateemail(){

 

var ck_email = /^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/;

if (document.PassRecover.email.value.search(ck_email)==-1)

{alert("That email address is not valid.");return false}

 

return true}

 

</script>

 

cheers Callum

 

 

[John Keswick 119]

I would run this through ajax if i were you, it looks cool too!

 

The regex you are looking for is this ^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$^

 

 

 

:laugh:

 

thanks for the advice John I have tried to implement an empty field validate for other fields plus a check on the email format. I have used this code on a similar page but when l try to mix them with my last post code it stops working

 

 

<script language="javascript">

 

function validateemail(){

 

var ck_email = /^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/;

if (document.PassRecover.email.value.search(ck_email)==-1)

{alert("That email address is not valid.");return false}

 

return true}

 

</script>

 

cheers Callum

 

 

 

I am not so good with javascript, my forte is php!

 

I have a script running that does exactly what you are after but i use ajax to run it on the fly as the user enters the email, as soon as they offclick the input field, php checks to see if the email is a valid one, ie has a @ sign, a . and either a com, or co.uk or net etc

 

But as with all things, you need to run a check that the user hasnt altered the input before submitting the form.

 

What level of programming are you at? Not taking the piss just interested as this is a hobby of mine (boring i know) but also part of my job!

[mangy1983 51]

I would run this through ajax if i were you, it looks cool too!

 

The regex you are looking for is this ^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$^

 

 

 

:laugh:

 

thanks for the advice John I have tried to implement an empty field validate for other fields plus a check on the email format. I have used this code on a similar page but when l try to mix them with my last post code it stops working

 

 

<script language="javascript">

 

function validateemail(){

 

var ck_email = /^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/;

if (document.PassRecover.email.value.search(ck_email)==-1)

{alert("That email address is not valid.");return false}

 

return true}

 

</script>

 

cheers Callum

 

 

 

I am not so good with javascript, my forte is php!

 

I have a script running that does exactly what you are after but i use ajax to run it on the fly as the user enters the email, as soon as they offclick the input field, php checks to see if the email is a valid one, ie has a @ sign, a . and either a com, or co.uk or net etc

 

But as with all things, you need to run a check that the user hasnt altered the input before submitting the form.

 

What level of programming are you at? Not taking the piss just interested as this is a hobby of mine (boring i know) but also part of my job!

 

Hi John I would say I'm a learner to intermediate with javascript and php. Css I only started looking into last month for a drop down menu but that is it as far as script languages go

 

cheers Callum

[John Keswick 119]

I would run this through ajax if i were you, it looks cool too!

 

The regex you are looking for is this ^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$^

 

 

 

:laugh:

 

thanks for the advice John I have tried to implement an empty field validate for other fields plus a check on the email format. I have used this code on a similar page but when l try to mix them with my last post code it stops working

 

 

<script language="javascript">

 

function validateemail(){

 

var ck_email = /^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/;

if (document.PassRecover.email.value.search(ck_email)==-1)

{alert("That email address is not valid.");return false}

 

return true}

 

</script>

 

cheers Callum

 

 

 

I am not so good with javascript, my forte is php!

 

I have a script running that does exactly what you are after but i use ajax to run it on the fly as the user enters the email, as soon as they offclick the input field, php checks to see if the email is a valid one, ie has a @ sign, a . and either a com, or co.uk or net etc

 

But as with all things, you need to run a check that the user hasnt altered the input before submitting the form.

 

What level of programming are you at? Not taking the piss just interested as this is a hobby of mine (boring i know) but also part of my job!

 

Hi John I would say I'm a learner to intermediate with javascript and php. Css I only started looking into last month for a drop down menu but that is it as far as script languages go

 

cheers Callum

 

No probs, i will help where i can, but in truth the only way to really learn this stuff is to do it. I am self taught, no college lessons here...

 

CSS is a peice of piss and you will learn it really quick, i havent really had the need to get heavily involved with javascript as i find that normally what i need can be either found on the net or done better with php.

I would say that i am now middle of the road as a php programmer, not a learner neither a fully fledged programmer that could go and work for facebook! But i get by!

 

If you already know some java then you should find ajax easier than i did, its a mix of both java and php together. You must have noticed the new google search where you start typing the search query and the page changes its results as you add more letters? Thats ajax, if you take a look at my site, the link in my signature, on the right of the page you will see a search box, start typing something into it and see what happens

 

This is the future of the web so LEARN IT!

[mangy1983 51]

I would run this through ajax if i were you, it looks cool too!

 

The regex you are looking for is this ^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$^

 

 

 

:laugh:

 

thanks for the advice John I have tried to implement an empty field validate for other fields plus a check on the email format. I have used this code on a similar page but when l try to mix them with my last post code it stops working

 

 

<script language="javascript">

 

function validateemail(){

 

var ck_email = /^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/;

if (document.PassRecover.email.value.search(ck_email)==-1)

{alert("That email address is not valid.");return false}

 

return true}

 

</script>

 

cheers Callum

 

 

 

I am not so good with javascript, my forte is php!

 

I have a script running that does exactly what you are after but i use ajax to run it on the fly as the user enters the email, as soon as they offclick the input field, php checks to see if the email is a valid one, ie has a @ sign, a . and either a com, or co.uk or net etc

 

But as with all things, you need to run a check that the user hasnt altered the input before submitting the form.

 

What level of programming are you at? Not taking the piss just interested as this is a hobby of mine (boring i know) but also part of my job!

 

Hi John I would say I'm a learner to intermediate with javascript and php. Css I only started looking into last month for a drop down menu but that is it as far as script languages go

 

cheers Callum

 

No probs, i will help where i can, but in truth the only way to really learn this stuff is to do it. I am self taught, no college lessons here...

 

CSS is a peice of piss and you will learn it really quick, i havent really had the need to get heavily involved with javascript as i find that normally what i need can be either found on the net or done better with php.

I would say that i am now middle of the road as a php programmer, not a learner neither a fully fledged programmer that could go and work for facebook! But i get by!

 

If you already know some java then you should find ajax easier than i did, its a mix of both java and php together. You must have noticed the new google search where you start typing the search query and the page changes its results as you add more letters? Thats ajax, if you take a look at my site, the link in my signature, on the right of the page you will see a search box, start typing something into it and see what happens

 

This is the future of the web so LEARN IT!

 

 

 

Lol thanks for the tip John

 

Found this so My link lm going to try to implement the code into my form

 

cheers Callum

[John Keswick 119]

I would run this through ajax if i were you, it looks cool too!

 

The regex you are looking for is this ^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$^

 

 

 

:laugh:

 

thanks for the advice John I have tried to implement an empty field validate for other fields plus a check on the email format. I have used this code on a similar page but when l try to mix them with my last post code it stops working

 

 

<script language="javascript">

 

function validateemail(){

 

var ck_email = /^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/;

if (document.PassRecover.email.value.search(ck_email)==-1)

{alert("That email address is not valid.");return false}

 

return true}

 

</script>

 

cheers Callum

 

 

 

I am not so good with javascript, my forte is php!

 

I have a script running that does exactly what you are after but i use ajax to run it on the fly as the user enters the email, as soon as they offclick the input field, php checks to see if the email is a valid one, ie has a @ sign, a . and either a com, or co.uk or net etc

 

But as with all things, you need to run a check that the user hasnt altered the input before submitting the form.

 

What level of programming are you at? Not taking the piss just interested as this is a hobby of mine (boring i know) but also part of my job!

 

Hi John I would say I'm a learner to intermediate with javascript and php. Css I only started looking into last month for a drop down menu but that is it as far as script languages go

 

cheers Callum

 

No probs, i will help where i can, but in truth the only way to really learn this stuff is to do it. I am self taught, no college lessons here...

 

CSS is a peice of piss and you will learn it really quick, i havent really had the need to get heavily involved with javascript as i find that normally what i need can be either found on the net or done better with php.

I would say that i am now middle of the road as a php programmer, not a learner neither a fully fledged programmer that could go and work for facebook! But i get by!

 

If you already know some java then you should find ajax easier than i did, its a mix of both java and php together. You must have noticed the new google search where you start typing the search query and the page changes its results as you add more letters? Thats ajax, if you take a look at my site, the link in my signature, on the right of the page you will see a search box, start typing something into it and see what happens

 

This is the future of the web so LEARN IT!

 

 

 

Lol thanks for the tip John

 

Found this so My link lm going to try to implement the code into my form

 

cheers Callum

 

If your looking to validate input, its just a case of running "if" statments against the input.

if (empty($email)) {echo 'you havent filled in the email address you numpty'; exit;}

 

etc

 

But if you want full marks for your assignment, i was thinking about your original question, i would go with my first reply and impliment both ways of doing things, do one way with an encrypted password. Then setup a password reset form, with a unique code.

You can use a timestamp to generate a unique code then md5 it

send that 32 bit code as a link using the "get" method and compare against the database.

 

If your tutor says you are waisiting your time, get him to phone me, and will tell him he is a kunt :laugh: