Link files with one another

Passion_Coder

Hi Coders,
I got confused while linking files...Kindly help me out in this regard...

1.We have a file to get the values from the user register.php
Code as follows:

<form name="register.php" action="registerdb.php" method="post">
<input type='text' name='C1FirstName' id='firstName' placeholder='FirstName' maxlength='30' tabIndex='1'>
<input type='text' name='C1NameOfTheSchool' id='school' placeholder='Name of the School' maxlength='30' tabIndex='2'>
<input type="text" name="EmailAddress" placeholder="eg:mail@mail.com" tabindex="3"/></td>
<input type='submit'  value='Register' class="button" tabIndex='4'/>
</form>

2.Now i want to save the value of this file in database Registerdb.php

session_start();
include 'mysql-connect.php';
$C1FirstName = $_POST['C1FirstName']; 
$C1NameOfTheSchool = $_POST['C1NameOfTheSchool']; 
$C1RandomPassword =substr(md5(rand().rand()), 0, 8);
 $EmailAddress = $_POST['EmailAddress']; 
 $_SESSION['PassVar1']= $C1RandomPassword;
 $_SESSION['EmailAddress']=$EmailAddress;
$sql="INSERT INTO mozhi(FirstName,NameOfTheSchool,RandomPassword,EmailAddress)VALUES('$C1FirstName','$C1NameOfTheSchool','$C1RandomPassword','$EmailAddress');

Password & Email Address of this file has to be passed to mail.php

3.Also I have to show the page pay.php where the payment is done.

 <form name="button.php" action="mail.php" method="post">
<input type="checkbox" name="Banking" onClick="showThis('DC', this)">Debit Card
<input type="text" name="CardHolderName" value=""/>
<input type="Submit" name="Pay" value="Pay" onclick="paydb.php"/>
<input type="button" name="Cancel" value="Cancel"/>
</form>

Once they click the pay button,these values has to be passed to the paydb.php file as well as a mail has to be sent using mail.php

4.Values for mail.php has to be passed from register.php
In mail.php we also have

$myPassVar = $_SESSION['PassVar'];
$myEmailVar = $_SESSION['EmailAddress'];
$mail->MsgHTML($myPassVar);
$mail->AddAddress($myEmailVar);

*In the front end,the user should see...
Register,then payment,Mail sent to your id.
How should i do it?
Your help is greatly appreciated!!!
thanks in advance..
PassionCoder.
[/COLOR]

samuelcook

assuming that the user goes from register.php to pay.php you can add a hidden input on your pay.php page that has the newly created sql insert.

If I'm understanding the flow correctly

So you would be looking at something like:
register.php

<form name="pay.php" action="pay.php" method="post">
<input type='text' name='C1FirstName' id='firstName' placeholder='FirstName' maxlength='30' tabIndex='1'>
<input type='text' name='C1NameOfTheSchool' id='school' placeholder='Name of the School' maxlength='30' tabIndex='2'>
<input type="text" name="EmailAddress" placeholder="eg:mail@mail.com" tabindex="3"/></td>
<input type='submit'  value='Register' class="button" tabIndex='4'/>
</form>

Changes: changed form action and went directly to pay.php

pay.php

<?php
session_start();
include 'mysql-connect.php';
$C1FirstName = $_POST['C1FirstName'];
$C1NameOfTheSchool = $_POST['C1NameOfTheSchool'];
$C1RandomPassword =substr(md5(rand().rand()), 0, 8);
$EmailAddress = $_POST['EmailAddress'];
$_SESSION['PassVar1']= $C1RandomPassword;
$_SESSION['EmailAddress']=$EmailAddress;
$sql="INSERT INTO mozhi(FirstName,NameOfTheSchool,RandomPassword,EmailAddress)VALUES('$C1FirstName','$C1NameOfTheSchool','$C1RandomPassword','$EmailAddress');
$result = mysql_query($sql,$link_identifier);
$id = mysql_insert_id($link_identifier);
?>

 <form name="button.php" action="mail.php" method="post">
<input type="checkbox" name="Banking" onClick="showThis('DC', this)">Debit Card
<input type="text" name="CardHolderName" value=""/>
<input type="Submit" name="Pay" value="Pay" onclick="paydb.php"/>
<input type="button" name="Cancel" value="Cancel"/>
<input type="hidden" name="id" value="<?=$id?>">
</form>

Changes:
1, Combined register.php AND pay.php
2, used mysql_insert_id to retrieve the id of the newly created row
3, added the id to a hidden input to retrieve on next page

mail.php

$id = $_POST['id'];
$result = mysql_query("SELECT * FROM mozhi WHERE id='$id' LIMIT 1");
$result = mysql_fetch_assoc($result);

$myPassVar = $result['password'];
$myEmailVar = $result['email'];
$mail->MsgHTML($myPassVar);
$mail->AddAddress($myEmailVar);

Changes: Retrieved information from database based on ID

I fudged some of the variable names so this code won't work 'as is'..
Additionally there are many approaches that you can take based off this model
a, if your uncomfortable about using id in the hidden input then you might save it in a session
b, if your not using id then you could remain to use the email,password sessions your using

This is just one of the approaches that could be used.

Hope this helps!!

Passion_Coder

Hi Sam,
Thanks for your reply and you got the flow correct(Thanks), it works fine to store the values in the database and no more errors except

1.When i click register,i have the notice and warnings as follows

Line No:
103    		$result = mysql_query($sql,$link_identifier); 
104         $id = mysql_insert_id($link_identifier); 
105     if(!mysql_query($sql,$con))
		{
			echo "Error!!";
		}

The data is getting stored in database, only if(I have a column in database named id) this column is auto increment.

Notice: Undefined variable: link_identifier in C:\xampp\htdocs\matrix\button.php on line 103

Warning: mysql_query() expects parameter 2 to be resource, null given in C:\xampp\htdocs\matrix\pay.php on line 103

Notice: Undefined variable: link_identifier in C:\xampp\htdocs\matrix\pay.php on line 104

Warning: mysql_insert_id() expects parameter 1 to be resource, null given in C:\xampp\htdocs\matrix\pay.php on line 104
Error!!

2.And with the notice,if i enter the payment details to the Payment gateway page and hit pay,
it gives the following error(it doesnt get the email address from the database):

You must provide at least one recipient email address. Mailer Error: You must provide at least one recipient email address.

Passion_Coder

If i use this code after insert,it returns 0,but id has another number.

echo "ID of last inserted record is: " . mysql_insert_id();

samuelcook

If you have not set a link_identifier variable then you will get that error;

Notice this is mysqli:

$conn = new MySQLi('hostname','username','password','database');

Then I can use $conn as the link_identifier;
Additionally, you need an id column (AUTO_INCREMENT) in the database for this to work.

Passion_Coder

Hi Sam,
Thanks for your patient reply....
Now the notices are disappeared.
But the email address is not picked up.
As said in the previous post,when i try to display the id in which it is stored,it displays 0.And the auto_incremented id field is not picked.

Thanks for your reply!
Passion Coder.

Passion_Coder

Thanks for your time Sam,
Its working fine now...Its sending the mail with the password.
Thanks a lot!!!
Pasiion Coder