Jump to content

Session user ID

yddib

By yddib
in PHP Coding Help

Recommended Posts

yddib Member

yddib

Posted
Posted

When people register on the site, there is an autonumber generated in the database. I am trying to insert this into 2 other fields in different tables. When I tried this is stopped inserting anything to the database. Please help! This is the code.

 

<html>
<head>
<title>4grads - Register Now</title>
<link rel="stylesheet" href="style1.css" type="text/css" />
<style type="text/css">
form.pos {position:absolute; left: 250px}
</style>
<script language="javascript">
function open_win() 
{
window.open("terms.html")
}

var x;
var firstname;
var lastname;
var gender;
var email;
var pass;
var at;
var dot;
var location;
var occupation;
var check1;
var birth_month;
var birth_day;
var birth_year;
var address1;
var county;
var country;
var phone;

function validate1()
{
	x=document.myForm;
	at=x.myEmail.value.indexOf("@");
	dot=x.myEmail.value.indexOf(".");
	firstname=x.myname.value;
	lastname=x.myname1.value;
	gender=x.gender.selectedIndex;
	email=x.myEmail.value;
	pass=x.pass.value;
	location=x.location.value;
	occupation=x.occupation.value;
	check1=x.check1.checked;
	birth_month=x.birthm.selectedIndex;
	birth_day=x.birthd.selectedIndex;
	birth_year=x.birthy.selectedIndex;
	address1=x.address1.value;
	county=x.county.value;
	country=x.country.value;
	phone=x.phone.value;
	course=x.course.value;


if(firstname =="")
{
alert("Please enter your first name");
x.myname.focus();
return false;
}

else if(isNaN(firstname)== false)
	{
	alert("Please enter your name correctly");
	x.myname.focus();
	return false;
	}
else if(lastname =="")
	{
	alert("Please enter your last name");
	x.myname1.focus();
	return false;
	}
else if(isNaN(lastname)== false)
	{
	alert("Please enter your name correctly");
	x.myname1.focus();
	return false;
	}
else if(gender == 0)
	{
	alert ("Please Select Gender");
	x.gender.focus();
	return false;
	}


else if(birth_month == 0)
	{
	alert ("Please Select Month");
	x.birthm.focus();
	return false;
	}

else if(birth_day == 0)
	{
	alert ("Please Select Day");
	x.birthd.focus();
	return false;
	}

else if(birth_year == 0)
	{
	alert ("Please Select Year");
	x.birthy.focus();
	return false;
	}
	else if(email=="")
	{
	alert("Please enter a valid e-mail address");
	x.myEmail.focus();
	return false;
	}

else if(at==-1)
	{
	alert("Please enter a valid e-mail address");
	x.myEmail.focus();
	return false;
	}

else if(dot==-1)
	{
	alert("Please enter a valid e-mail address");
	x.myEmail.focus();
	return false;
	}
else if(pass =="")
	{
	alert("Please choose a password");
	x.pass.focus();
	return false;
	}
else if(pass.length<6==true)
	{
	alert("Your password must be at least 6 characters long");
	x.pass.focus();
	return false;
	}

else if(address1 =="")
	{
	alert("You must complete the Address field");
	x.address1.focus();
	return false;
	}

else if(county =="")
	{
	alert("You must enter your county/state")
	x.county.focus();
	return false;
	}

else if(country =="")
	{
	alert("You must complete the country field");
	x.country.focus();
	return false;
	}

else if(isNaN(country)== false)
	{
	alert("Please enter your country correctly");
	x.country.focus();
	return false;
	}

else if(isNaN(phone)== true)
	{
	alert("Please enter your phone number correctly");
	x.country.focus();
	return false;
	}
else if(phone =="")
	{
	alert("You must enter a phone number");
	x.country.focus();
	return false;
	}
else if(course =="")
	{
	alert("You must complete the Course field");
	x.course.focus();
	return false;
	}
else if(location =="")
	{
	alert("You must complete the Location field");
	x.location.focus();
	return false;
	}

else if(occupation =="")
	{
	alert("You must complete the Occupation field");
	x.occupation.focus();
	return false;
	}
else if(check1 == false)
	{
	alert("You must read the terms and conditions");
	return false;
	}

return true;
}
</script>
</head>
<body>
<div id="sidebar">
<a href="index.html"><img src="translogo.jpg" alt="4Grads Logo" /></a><br /><br /><br /><br />
<div id="menu" style="width: 170; height: 220">
</div>

</div>

<div id="content">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" background="bannercreator-nu2.gif" height="55">
  <tr>
    <td width="20%" height="55" align="center">
<td width="20%" height="55" align="center">
    <font color="#FFFFFF" size="3">Register</font></td>
    <td width="20%" height="55" align="center"></td>
    <td width="20%" height="55" align="center"> </td>
    <td width="20%" height="55" align="center">
    <font color="#FFFFFF" size="3"></font></td>
    <td width="20%" height="55" align="center">
    <a href="help.html"><font color="#FFFFFF" size="3">Help </font></a></td>
  </tr>
</table>


<br /><br />
<form name="myForm" action="subscribe.php" method="post" onSubmit="return validate1();" class="pos">
<b><font color="#800000">First Name: </font>
<br />
<input type="text" name="myname" size="40" />
<br />
</b><font color="#800000"><b>Last Name:
<br />
<input type="text" name="myname1" size="40" />
<br />
Gender:
<br />
<select name="gender" id="gender" >
<option value="0" > Gender </option>
<option value="Male" name="Male"> Male </option>
<option value="Female" name="Female"> Female </option>
</select><br />
Birthdate:
<br />
<select name="birthm" id="birthm" class="date" >
<option value="0" id="month_option">Month</option>
             
<option value="1" name="1">January</option>
             
<option value="2" name="2">February</option>
             
<option value="3" name="3">March</option>
             
<option value="4" name="4">April</option>
             
<option value="5" name="5" >May</option>
             
<option value="6" name="6">June</option>
             
<option value="7" name="7">July</option>
             
<option value="8" name="8">August</option>
             
<option value="9" name="9">September</option>
             
<option value="10" name="10">October</option>
             
<option value="11" name="11">November</option>
             
<option value="12" name="12">December</option>
</select>
<select tabindex="6" name="birthd"  id="birthd"  class="date">
<option value="0" id="day_option">Day</option>
<option value="1" name="1">1</option>
<option value="2" name="2">2</option>
<option value="3" name="3">3</option>
<option value="4" name="4">4</option>
<option value="5" name="5">5</option>
<option value="6" name="6">6</option>
<option value="7" name="7">7</option>
<option value="8" name="8">8</option>
<option value="9" name="9">9</option>
<option value="10" name="10">10</option>
<option value="11"name="11" >11</option>
<option value="12" name="12">12</option>
<option value="13" name="13">13</option>
<option value="14" name="14">14</option>
<option value="15" name="15">15</option>
<option value="16" name="16">16</option>
<option value="17" name="17">17</option>
<option value="18" name="18" >18</option>
<option value="19" name="19">19</option>
<option value="20" name="20">20</option>
<option value="21" name="21" >21</option>
<option value="22" name="22" >22</option>
<option value="23" name="23">23</option>
<option value="24" name="24">24</option>
<option value="25" name="25">25</option>
<option value="26" name="26" >26</option>
<option value="27" name="27">27</option>
<option value="28" name="28">28</option>
<option value="29" name="29">29</option>
<option value="30" name="30">30</option>
<option value="31" name="31">31</option>
</select>               
<select tabindex="8" name="birthy"  id="birthy" class="date">
<option value="0" id="year_option">Year</option>
<option value="2000" name="2000" >2000</option>
<option value="1999" name="1999">1999</option>
<option value="1998" name="1998">1998</option>
<option value="1997" name="1997">1997</option>
<option value="1996" name="1996" >1996</option>
<option value="1995" name="1995">1995</option>
<option value="1994" name="1994">1994</option>
<option value="1993" name="1993">1993</option>
<option value="1992" name="1992">1992</option>
<option value="1991" name="1991">1991</option>
<option value="1990" name="1990">1990</option>
<option value="1989" name="1989">1989</option>
<option value="1988" name="1988">1988</option>
<option value="1987" name="1987">1987</option>
<option value="1986" name="1986">1986</option>
<option value="1985" name="1985">1985</option>
<option value="1984" name="1984">1984</option>
<option value="1983" name="1983">1983</option>
<option value="1982" name="1982">1982</option>
<option value="1981" name="1981">1981</option>
<option value="1980" name="1980">1980</option>
<option value="1979" name="1979">1979</option>
<option value="1978" name="1978">1978</option>
<option value="1977" name="1977">1977</option>
<option value="1976" name="1976">1976</option>
<option value="1975" name="1975">1975</option>
<option value="1974" name="1974">1974</option>
<option value="1973" name="1973">1973</option>
<option value="1972" name="1972">1972</option>
<option value="1971" name="1971">1971</option>
<option value="1970" name="1970">1970</option>
<option value="1969" name="1969">1969</option>
<option value="1968" name="1968">1968</option>
<option value="1967" name="1967">1967</option>
<option value="1966" name="1966">1966</option>
<option value="1965" name="1965">1965</option>
<option value="1964" name="1964">1964</option>
<option value="1963" name="1963">1963</option>
<option value="1962" name="1962">1962</option>
<option value="1961" name="1961">1961</option>
<option value="1960" name="1960">1960</option>
<option value="1959" name="1959">1959</option>
<option value="1958" name="1958">1958</option>
<option value="1957" name="1957">1957</option>
<option value="1956" name="1956">1956</option>
<option value="1955" name="1955">1955</option>
<option value="1954" name="1954">1954</option>
<option value="1953" name="1953">1953</option>
<option value="1952" name="1952">1952</option>
<option value="1951" name="1951">1951</option>
<option value="1950" name="1950">1950</option>
<option value="1949" name="1949">1949</option>
<option value="1948" name="1948">1948</option>
<option value="1947" name="1947">1947</option>
<option value="1946" name="1946">1946</option>
<option value="1945" name="1945">1945</option>
<option value="1944" name="1944">1944</option>
<option value="1943" name="1943">1943</option>
<option value="1942" name="1942">1942</option>
<option value="1941" name="1941">1941</option>
<option value="1940" name="1940">1940</option>
<option value="1939" name="1939">1939</option>
<option value="1938" name="1938">1938</option>
<option value="1937" name="1937">1937</option>
<option value="1936" name="1936">1936</option>
<option value="1935" name="1935">1935</option>
<option value="1934" name="1934">1934</option>
<option value="1933" name="1933">1933</option>
<option value="1932" name="1932">1932</option>
<option value="1931" name="1931">1931</option>
<option value="1930" name="1930">1930</option>
<option value="1929" name="1929">1929</option>
<option value="1928" name="1928">1928</option>
<option value="1927" name="1927">1927</option>
<option value="1926" name="1926">1926</option>
<option value="1925" name="1925">1925</option>
<option value="1924" name="1924">1924</option>
<option value="1923" name="1923">1923</option>
<option value="1922" name="1922">1922</option>
<option value="1921" name="1921">1921</option>
<option value="1920" name="1920">1920</option>
<option value="1919" name="1919">1919</option>
<option value="1918" name="1918">1918</option>
<option value="1917" name="1917">1917</option>
<option value="1916" name="1916">1916</option>
<option value="1915" name="1915">1915</option>
<option value="1914" name="1914">1914</option>
<option value="1913" name="1913">1913</option>
<option value="1912" name="1912">1912</option>
<option value="1911" name="1911">1911</option>
<option value="1910" name="1910">1910</option>
<option value="1909" name="1909">1909</option>
<option value="1908" name="1908">1908</option>
<option value="1907" name="1907">1907</option>
<option value="1906" name="1906">1906</option>
<option value="1905" name="1905">1905</option>
<option value="1904" name="1904">1904</option>
<option value="1903" name="1903">1903</option>
<option value="1902" name="1902">1902</option>
<option value="1901" name="1901">1901</option>
</select>
<br />
E-mail: **
<br />
<input type="text" name="myEmail" size="40" />
<br />
Choose Password: (at least 6 characters)
<br />
<input type="password" name="pass" size="40" />
<br /><br />

Address: **
<br />
<textarea name="address1" cols="40" rows="3" />
</textarea>
<br />
County/State: **
<br />
<input type="text" name="county" size="40" />
<br />
Country: **
<br />
<input type="text" name="country" size="40" />
<br />
Phone Number: **
<br />
<input type="text" name="phone" size="40" />
<br /><br />
Location:
<br />
<input type="text" name="location" size="40" />
<br />
Course/Qualification:
<br />
<input type="text" name="course" size="40" />
<br />
Occupation:
<br />
<input type="text" name="occupation" size="40" />
<br />
<br />
<input type="checkbox" name="check1">I have read the <a onclick="open_win()" /><u>Terms and Conditions</u></a>
<br /><br />
<input type="reset" value="Reset" />
<input type="submit" value="Subscribe" />
<h6>
** This information will not be displayed on your profile
</h6>
</form>
</body>
</html>

 

and

 

<?php 
session_start();
$id = $_SESSION['id'];
?>
<html>
<head>
<title>4grads - Contact Us</title>
<link rel="stylesheet" href="style1.css" type="text/css" />
<style type="text/css">
form.pos {position:absolute; left: 250px}
</style>
<meta HTTP-EQUIV="REFRESH" content="0; url=http://www.4grads.net">
</head>
<body>
<div id="sidebar">
<a href="index.html" /><img src="translogo.jpg" alt="4Grads Logo" /></a><br /><br /><br /><br />
<div id="menu" style="width: 170; height: 220">
</div>

</div>

<div id="content">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" background="bannercreator-nu2.gif" height="55">
  <tr>
    <td width="5%" height="55" align="center">
<td width="40%" height="55" align="center">
    <font color="#FFFFFF" size="3">Registration Successful</font></td>
    <td width="15%" height="55" align="center"></td>
    <td width="20%" height="55" align="center"> </td>
    <td width="20%" height="55" align="center">
    <font color="#FFFFFF" size="3"></font></td>
    <td width="20%" height="55" align="center">
    <a href="help.html"><font color="#FFFFFF" size="3">Help </font></a></td>
  </tr>
</table>

<?php
  
mysql_connect("host", "user", "pass") or die(mysql_error());
//connects to the blacknight server
mysql_select_db("db")or die(mysql_error());


$fname=$_POST['myname'];
$lname=$_POST['myname1'];
$email=$_POST['myEmail'];
$pass=$_POST['pass'];
$gender=$_POST['gender'];
$birthm=$_POST['birthm'];
$birthd=$_POST['birthd'];
$birthy=$_POST['birthy'];
$address1=$_POST['address1'];
$county=$_POST['county'];
$country=$_POST['country'];
$phone=$_POST['phone'];
$location=$_POST['location'];
$course=$_POST['course'];
$occupation=$_POST['occupation'];


mysql_query("INSERT INTO gradinfo (f_name,l_name,email,pass,gender,birthm,birthd,birthy,address1,county,country,telephone,location)
VALUES ('$fname','$lname','$email','$pass','$gender','$birthm','$birthd','$birthy','$address1','$county','$country','$phone','$location')");//Set SQL
mysql_query("INSERT INTO gradcoll (u_course)
VALUES ('$course')");
mysql_query("INSERT INTO gradcoll (u_id)
VALUES ('$id')");
mysql_query("INSERT INTO gradwork (occupation)
VALUES ('$occupation')");
mysql_query("INSERT INTO gradwork (u_id) 
VALUES ('$id')");

echo '<br /><br />Congratulations!! You have successfully joined <i>4Grads</i>';

echo '<br /><br />Please Login <a href="index.html">HERE</a>'

?>


</body>
</html>

 

Everything was fine before I entered 

]<?php 
session_start();
$id = $_SESSION['id'];
?>

 

and 

mysql_query("INSERT INTO gradcoll (u_id)
VALUES ('$id')");

Link to comment
https://forums.phpfreaks.com/topic/123457-session-user-id/
Share on other sites
akitchin Regular Member

akitchin

Posted
Posted

the easiest way to start debugging queries is by adding a die clause:

 

mysql_query('stuff') or die(mysql_error());

 

this will force PHP to spit out any MySQL error and exit in the case of a failed query.  nonetheless, your problem is most likely with a duplicate key entry.  if u_id is a unique or primary key, it will get upset with you when you try to insert a value that already exists.  since your $id is coming from a session variable, i assume you're fetching that from the db which implies that it already does exist in the table.

Link to comment
https://forums.phpfreaks.com/topic/123457-session-user-id/#findComment-637661
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.