Databases
StackOverflow2013
Postsdbo
POUnable to get the Submit Form to show database from select menu
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnable to get the Submit Form to show database from select menu
    text
    copied!<p>Good Afternoon,</p> <p>I have a problem with submit form and show up from database. Please help!!</p> <p>this code from index1.php</p> <pre><code> &lt;?php mysql_select_db($database_conn, $conn); $query_RsCourse = "SELECT FROM tbl_course ORDER BY coursename ASC"; $RsCourse = mysql_query($query_RsCourse, $conn) or die(mysql_error()); $totalRows_RsCourse = mysql_num_rows($RsCourse); $count =0; while ( $row = mysql_fetch_array($RsCourse, MYSQL_ASSOC)) { $course[ $row['courseid'] ] = $row['coursename']; $count++; } ?&gt; &lt;form name="form1" method="post" action="enrol_main.php" target="enrol_main"&gt; &lt;table width="100%" border="0" cellspacing="0" cellpadding="0"&gt; &lt;tr&gt; &lt;td&gt;&lt;table width="209" border="0" align="center" cellpadding="1" cellspacing="1"&gt; &lt;tr&gt; &lt;td height="35"&gt;&amp;nbsp;&lt;/td&gt; &lt;td&gt;&amp;nbsp;&lt;select name="courseid"&gt; &lt;option value="" selected&gt;Select a Course..&lt;/option&gt; &lt;?php foreach( $course as $course_id =&gt; $course_name) { if ( $course_id == $courseid) { $selected = " SELECTED"; } else { $selected = ""; } ?&gt; &lt;option value="&lt;?php echo $course_id; ?&gt;"&lt;?php echo $selected; ?&gt;&gt;&lt;?php echo $course_name; ?&gt;&lt;/option&gt; &lt;?php } ?&gt; &lt;/select&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="48" height="38"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="154"&gt;&amp;nbsp;&lt;input type="submit" name="Submit" value="Process"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; </code></pre> <p>The other pager would be showing up on enrol_main.php</p> <pre><code> &lt;?php $totalRows_RsEnrol = 0; if ( isset($_POST['courseid']) ) { $_GET['courseid'] = $_POST['courseid']; $_GET['courseid'] = $_GET['courseid'] * 1; if (is_integer($_GET['courseid']) ) { $maxRows_RsEnrol = 1000000; $pageNum_RsEnrol = 0; if (isset($_GET['pageNum_RsEnrol'])) { $pageNum_RsEnrol = $_GET['pageNum_RsEnrol']; } $startRow_RsEnrol = $pageNum_RsEnrol * $maxRows_RsEnrol; mysql_select_db($database_conn, $conn); $query_RsEnrol = sprintf("SELECT erid, courseid, staffid FROM tbl_enroll WHERE courseid = %s ORDER BY staffid ASC", $_GET['courseid']); $query_limit_RsEnrol = sprintf("%s LIMIT %d, %d", $query_RsEnrol, $startRow_RsEnrol, $maxRows_RsEnrol); $RsEnrol = mysql_query($query_limit_RsEnrol, $conn) or die(mysql_error()); $row_RsEnrol = mysql_fetch_assoc($RsEnrol); if (isset($_GET['totalRows_RsEnrol'])) { $totalRows_RsEnrol = $_GET['totalRows_RsEnrol']; } else { $all_RsEnrol = mysql_query($query_RsEnrol); $totalRows_RsEnrol = mysql_num_rows($all_RsEnrol); } $totalPages_RsEnrol = ceil($totalRows_RsEnrol/$maxRows_RsEnrol)-1; } else { $totalRows_RsEnrol = 0;} } ?&gt; </code></pre> <p>However, it shows up all of information on the screen. It does not filter up the information from database. Please Help!!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload