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

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnable to get the Submit Form to show database from select menu
    primarykey
    data
    text
    <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>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USMahou
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COOld mysql extension (with it's `mysql_` functions) is deprecated as of PHP 5.5.0, and is not recommended for writing new code as it will be removed in the future. Instead, either the mysqli or PDO_MySQL extension should be used. See also the MySQL API Overview for further help while choosing a MySQL API.
      singulars
      1. POUnable to get the Submit Form to show database from select menu
      1. USMołot
    2. COwhat you are expecting? seems like in index.php you are fetching all the records from DB and populate the dropdown. What is the problem you are facing? Also what is the purpose of using `$_GET['courseid'] = $_POST['courseid']; $_GET['courseid'] = $_GET['courseid'] * 1;`
      singulars
      1. POUnable to get the Submit Form to show database from select menu
      1. USuser2720864
    3. COBascially, I am going to show up the how many staff enrolled which course on. course id to show up the course name using tbl_course database. tbl_enroll table is including "erid, courseid, staffid", tbl_course is including "courseid, course name, startdate, enddate", it does not show up how many staff enrolled on which course. It show up all of staffs enrolled on all of course.
      singulars
      1. POUnable to get the Submit Form to show database from select menu
      1. USMahou
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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