1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Registration form

Discussion in 'PHP' started by moin, Apr 20, 2007.

0
  1. #1
    Hello friends,

    I have used this html form for course registration,

    
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>

 <BODY>
 <form name="mainform" method="post" action="test_3.php">
<select name="course" onchange="document.mainform.c_date.value = this.value">
    <option value="12-01-2007">.NET</option>
    <option value="13-01-2007">J2ee</option>
    <option value="14-01-2007">PHP</option></select>
<input type="text" name="c_date" />
<input type="submit" value="submit"/>
</form>
 </BODY>
</HTML>
    Code (markup):
    I have inserted the values(course and date) in the database, here is the code for this, 
    
<?php
if (!($con = mysql_connect("localhost","root","")))
    die('Could not connect: ' . mysql_error());
else
    mysql_select_db( "my_student7", $con );


$course=stripslashes(trim($_POST['course']));
$date=stripslashes(trim($_POST['date']));

       
    if( mysql_query( "INSERT INTO person2 (course, c_date) VALUES ('$date', '$course')",$con) )
    {
        echo "Your details are added in the database and you can use this id, <b>$id</b>, for furture references";
    }
    else
    {
        echo "Your details could not be inserted at this time, please contact support";
    }

mysql_close($con);
?>
    Code (markup):
    But the main problem is, when I am trying to display the details, i.e course and details from the database only date is displayed but not the course, here is the code for it, 
    
`<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("my_student5", $con);$result = mysql_query("SELECT * FROM person");
  
echo "<table border='1'>";
  while($row = mysql_fetch_array($result, MYSQL_NUM))
  {
  echo "<tr><td>$row[0]</td><td>$row[1]</td></tr>";
  
  }echo "</table>";
  mysql_close($con);
?>
    Code (markup):
    How to display the course.

    How to write the code for it.

    Any help.
     
    moin, Apr 20, 2007 IP
  2. MMJ

    MMJ Guest

    Messages:
    460
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Try this
    
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
	die('Could not connect: ' . mysql_error());
else
	mysql_select_db("my_student5", $con);

$result = mysql_query("SELECT * FROM person2");


echo "<table border='1'>
<tr>
<th>Course</th>
<th>Date</th>
</tr>";

while($row = mysql_fetch_array($result, MYSQL_NUM))
  {
  echo "<tr>";
  echo "<td>" . $row['0'] . "</td>";
  echo "<td>" . $row['1'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
?>
    PHP:
     
    MMJ, Apr 20, 2007 IP
  3. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #3
    In your registration page, you're inserting into a database called person2, and in your other page it's called just person. That could be the problem. Also the database name is different.
     
    nico_swd, Apr 20, 2007 IP
  4. moin

    moin Peon

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I have changed the database name, actually the course value is not displayed.

    if we are using, <select name="course">
    <option value="12-01-12">.NET</option>
    </option>

    Only the date is displayed but not the course.

    how to rectify that.
     
    moin, Apr 20, 2007 IP