Shoutbox

Need help in PHP - Printable Version

-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Need help in PHP (/showthread.php?tid=91247)

Need help in PHP by Odin.EXE on 06-28-2009 at 10:35 AM

Hi all, I'm working on a project but the function that I want doesn't work.

There is this button called "add student" and a new row will appear when I clicked that button. However the data I wrote in the previous first row will disappear when I click that button for a 2nd row.

Here is the code

code:
<?php
session_start();
if (isset($_POST['AddStudent'])) {
// If user click on Add new student button
    $temp = $_SESSION['numberOfStudents'];
    $temp = $temp + 1;
    $_SESSION['numberOfStudents'] = $temp;
}
/*else if (isset($_POST['FinalCheckBtn'])) {
// If user click on Final Check button go to Final check page
header('Location: http://localhost/SJAA/final_check.php') ;
}*/
else {
// if User enter this page the first time from "create new class page "
    // the variable that hold the credentials to connect to the database
    $dbserver = "localhost";
    $dbuser = "root";
    $dbpassword = "";
    $dbname = "fyp - sem 1";
    // connect to DB
    mysql_connect($dbserver, $dbuser, $dbpassword) or die(mysql_error());
    // select the correct db.
    mysql_select_db($dbname) or die(mysql_error());


    // Read variables from the $_POST array
    $class_name = $_POST['class_name'];
    $class_venue = $_POST['class_venue'];
    $date_of_lesson =$_POST['date_of_lesson'];
    $time_of_lesson =$_POST['time_of_lesson'];
    $class_duration =$_POST['class_duration'];
    $date_of_exam =$_POST['date_of_exam'];
    $class_in_charge =$_POST['class_in_charge'];   
    $contact =$_POST['contact'];
    $email =$_POST['email'];

    // Prepare the query

    $sql = "INSERT INTO b_class (class_name,class_venue,date_of_lesson,time_of_lesson,class_duration,date_of_exam,class_in_charge,contact,email) VALUES
                ('$class_name','$class_venue','$date_of_lesson','$time_of_lesson','$class_duration','$date_of_exam','$class_in_charge','$contact','$email')";

    // Execute the query
    mysql_query($sql) or die(mysql_error());
    $_SESSION['numberOfStudents'] = 0;
    $_SESSION['class_name']=$_POST['class_name'];
    $_SESSION['class_venue'] = $_POST['class_venue'];
    $_SESSION['date_of_lesson'] = $_POST['date_of_lesson'];
    $_SESSION['time_of_lesson'] = $_POST['time_of_lesson'];
    $_SESSION['class_duration'] = $_POST['class_duration'];
    $_SESSION['date_of_exam'] = $_POST['date_of_exam'];
    $_SESSION['class_in_charge'] = $_POST['class_in_charge'];
    $_SESSION['contact'] = $_POST['contact'];
    $_SESSION['email'] = $_POST['email'];
   

}
?>
<html>
<form enctype="multipart/form-data" action = 'student_details.php' method='post' />
<img style="width: 190px; height: 184px;" alt="" src="images/Picture1.jpg">

<head><title>Students' Particulars</title></head>
<h1>Students' Particulars</h1>
<h3> Please enter student's particulars. All fields are to be filled. </h3>
<table style="text-align: left; width: 333px; height: 144px;"
border="1" cellpadding="2" cellspacing="2">
  <tbody>
    <tr>
      <td><?php
echo "Class Name: ";
echo $_SESSION['class_name'];?> </td>
</tr>
    <tr>
      <td><?php
echo "Class Venue: ";
echo $_SESSION['class_venue'];?> </td>
</tr>
<tr>
      <td><?php
echo "Date of Lesson: ";
echo $_SESSION['date_of_lesson'];?> </td>
</tr>
<tr>
      <td><?php
echo "Time: ";
echo $_SESSION['time_of_lesson'];?> </td>
</tr>
<tr>
      <td><?php
echo "Class Duration: ";
echo $_SESSION['class_duration'];?> </td>
</tr>
<tr>
      <td><?php
echo "Tentative Date of Exam: ";
echo $_SESSION['date_of_exam'];?> </td>
</tr>
<tr>
      <td><?php
echo "Class-In-Charge: ";
echo $_SESSION['class_in_charge'];?> </td>
</tr>
<tr>
      <td><?php
echo "Contact: ";
echo $_SESSION['contact'];?> </td>
</tr>
<tr>
      <td><?php
echo "Email: ";
echo $_SESSION['email'];?> </td>
</tr>
<body>
<table border="1">
<tr>
<th>Name</th>
<th>NRIC no.</th>
<th>Age</th>
</tr>
<br>
<input type="submit" value="Add new Student" name="AddStudent">
</form>
<?php
$cnt = 0;
echo "<form enctype='multipart/form-data' action = 'final_check.php' method='post'>";
while ($cnt < $_SESSION['numberOfStudents']) {
   
   
    $NameCnt = "Name".$cnt;
    $NRICcnt = "NRICno".$cnt;
    $AgeCnt = "Age".$cnt;

    if (isset($_POST[$NameCnt])) {
?>
        <tr>
        <td><input type = 'text' name = 'student_name<?php echo $cnt ?>' value='<?php echo $_POST[$NameCnt] ?>'></td>
        <td><input type = 'text' name = 'nric<?php echo $cnt ?>' value='<?php echo $_POST[$NRICcnt] ?>'></td>
        <td><input type = 'text' name = 'age<?php echo $cnt ?>' value='<?php echo $_POST[$AgeCnt] ?>'></td>
        </tr>
<?php
    }
    else {
?>
        <tr>
        <td><input type = 'text' name = 'student_name<?php echo $cnt ?>'></td>
        <td><input type = 'text' name = 'nric<?php echo $cnt ?>'></td>
        <td><input type = 'text' name = 'age<?php echo $cnt ?>'></td>
        </tr>
<?php
    }

$cnt = $cnt +1;
}
?>

</table>
<br>
<br>
<tr>
            <td></td>
            <table style="text-align: left;"
            <td><input type = 'submit' value = 'Continue' name='FinalCheckBtn'></td>
           
        </tr>
    </table>
</form>
</html>


RE: Need help in PHP by NanaFreak on 06-28-2009 at 10:41 AM

you would need to post the data to the page, and add it back in...

i hope you get that... i dont really feel like creating a page for that...

if you need more explanation just ask...


RE: Need help in PHP by Odin.EXE on 06-28-2009 at 10:48 AM

Hmm sorry to be honest it wasn't me working on this. It was more like my friend. So I have no idea what is it about. :(


RE: Need help in PHP by segosa on 06-29-2009 at 09:36 AM

I think you need to read http://www.tizag.com/mysqlTutorial/mysql-php-sql-injection.php