sugarplum_19 Posted January 5, 2011 Share Posted January 5, 2011 I have a form where it ask the user to select the student ID, course ID, enter the grades and comments. The Student ID and CourseID is selected from a drop down menu, but when the data is sent to PHPMYADMIN it enters a 0 into the SID and CID How to I get it save the numbers which has been selected Quote Link to comment Share on other sites More sharing options...
denno020 Posted January 5, 2011 Share Posted January 5, 2011 Post your code. Seriously, how do you expect to get help by just saying that you have the wrong number being entered in to the database? Denno Quote Link to comment Share on other sites More sharing options...
sugarplum_19 Posted January 5, 2011 Author Share Posted January 5, 2011 <?php require("db_config.php"); class db_studentcourse { private $conn; function getResult($sql) { $result = mysql_query($sql, $this->conn); if($result) { return $result; } else { die("SQL Retrieve Error: ".mysql_error()); } } function insert_studentcourse($SID, $CID, $grade, $comments) { $esc_SID = mysql_real_escape_string($SID, $this->conn); $esc_CID = mysql_real_escape_string($CID, $this->conn); $esc_grade = mysql_real_escape_string($grade, $this->conn); $esc_comments = mysql_real_escape_string($comments, $this->conn); $sql = "INSERT INTO studentcourses(SID, CID, grade, comments) VALUES ('{$esc_SID}', '{$esc_CID}', '{$esc_grade}', '{$esc_comments}')"; $result = mysql_query($sql, $this->conn); if (!$result) { die("SQL Insertion error: " . mysql_error()); } else { $numofrows = mysql_affected_rows($this->conn); return $numofrows; } } function insert_student($sid, $sname, $address, $post_code) { $esc_sname = mysql_real_escape_string($name, $this->conn); $esc_address = mysql_real_escape_string($address, $this->conn); $esc_post_code = mysql_real_escape_string($post_code, $this->conn); $sql = "INSERT INTO students (sid , sname, address, post_code) VALUES ('{$sid}', '{$sname}', '{$address}', '{$post_code}')"; $result = mysql_query($sql, $this->conn); if (!$result) { die("SQL Insertion error: " . mysql_error()); } else { $numofrows = mysql_affected_rows($this->conn); return $numofrows; } } function openDB() { $this->conn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); { if (!$this->conn) die("SQL Connection error: " . mysql_error()); } $db_selected = mysql_select_db(DB_NAME, $this->conn); if (!$db_selected) { die("SQL Selection error: " . mysql_error()); } } function delete_studentcourse($sid,$cid) { $esc_sid= mysql_real_escape_string($sid, $this->conn); $esc_cid= mysql_real_escape_string($cid, $this->conn); $sql = "DELETE FROM studentcourses where SID='{$sid}' && where CID='{$cid}'"; $result = mysql_query($sql, $this->conn); if (!$result) die("SQL Error: " . mysql_error()); else { $numofrows = mysql_affected_rows($this->conn); return $numofrows; } } function closeDB() { mysql_close($this->conn); } } ?> <?php if($_POST) { $errorID=0; $sid=$_POST['sid']; $cid=$_POST['cid']; $grade = $_POST['grade']; $comments = $_POST['comments']; if($grade<0 && $grade>100 || !is_numeric($grade)) { $errorID=1; $errorMsg="Grade must be a number between 0 and 100"; } } ?> <?php include 'db_studentcourse.php'; //import the class in this web page ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Student-Course Insert new Record</title> </head> <body> <?php $db1 = new db_studentcourse(); $db1->openDB(); $sql = "SELECT SID FROM STUDENTS"; $result = $db1->getResult($sql); $sql = "SELECT CID FROM COURSES"; $result1 = $db1->getResult($sql); if (!$_POST) { ?> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> Select student ID: <select name = "SID"> <option value="default">Select a Student ID</option> <?php while ($row = mysql_fetch_assoc($result)) echo "<option value='{$row['SID']}'>{$row['SID']}</option>"; ?> </select><br/> Select course ID: <select name = "CID"> <option value="default">Select a Course ID</option> <?php while ($row = mysql_fetch_assoc($result1)) echo "<option value ='{$row['CID']}'>{$row['CID']} </option>"; ?> </select><br/> Enter grade:<input type="text" name="grade" value="<?php echo $grade; ?>"/> <?php if($errorID==1) echo "* $errorMsg";?> <br /> Enter comment:<input type="text" name="comments" /><br /> <input type="submit" value="Save" /> <input type="reset" value="Reset" name="reset"/> <input type="button" value="Cancel"/> </form> <?php } else { $sid = $_POST['sid']; $cid = $_POST['cid']; $grade = $_POST['grade']; $comments = $_POST['comments']; $db1 = new db_studentcourse(); $db1->openDB(); $numofrows = $db1->insert_studentcourse($sid, $cid, $grade, $comments); echo "Success. Number of rows affected: <strong>{$numofrows}<strong>"; $db1->closeDB(); } ?> </body> </html> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.