Back To Programming / Scripting / Coding Forum

Fetching out Records from Mysq Database

  • stevewise
  • Newbie
  • Newbie
  • No Avatar
  • Joined: Mar 16, 2009
  • Posts: 7
  • Status: Offline

Post June 25th, 2010, 9:23 am

please I am new to Php and Mysql programming
I am developing a website for a school potal
I am haveing problem fetching records from the database
there are two forms, one of the forms which is the search form
while the other is the result page that is supposed to display the result but I am having problem with my coding please somebody help me out.
The seach page has the following fields which will be used to search for information in the database
MatricNo
Level
Semester
and a button for submit which is supposed to display the records in th result page. That is the result page.
Code: [ Select ]
<?php require_once('dj.php'); ?>
<?php
$matric_no=0009;
$level = "ND1";
$semester = "FIRST SEMESTER";

$host = "localhost";
$account = "root"  
$password = " " 
$database = "student affairs" 
$connect=mysql_connect($host, $account, $password);
mysql_select_db($database, $connect);

$sql="SELECT *
FROM populate
WHERE matricno LIKE '$matric_no'
AND level LIKE '$level'
AND semester LIKE '$semester'";

$result=mysql_query($sql, $connect);
$row=mysql_fetch_array($result);

mysql_close();


?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
#apDiv1 {
    position:absolute;
    width:886px;
    height:340px;
    z-index:1;
}
-->
</style>
</head>

<body>
<div id="apDiv1">
 <table border="1">
  <tr>
   <td>matricno</td>
   <td>firstname</td>
   <td>lastname</td>
   <td>othername</td>
   <td>level</td>
   <td>course1</td>
   <td>course2</td>
   <td>course3</td>
   <td>course4</td>
   <td>course5</td>
   <td>course6</td>
   <td>course7</td>
   <td>course8</td>
   <td>course9</td>
   <td>course10</td>
   <td>grade1</td>
   <td>grade2</td>
   <td>grade3</td>
   <td>grade4</td>
   <td>grade5</td>
   <td>grade6</td>
   <td>grade7</td>
   <td>grade8</td>
   <td>grade9</td>
   <td>grade10</td>
   <td>code1</td>
   <td>code2</td>
   <td>code3</td>
   <td>code4</td>
   <td>code5</td>
   <td>code6</td>
   <td>code7</td>
   <td>code8</td>
   <td>code9</td>
   <td>code10</td>
   <td>cgpa</td>
   <td>department</td>
   <td>semester</td>
  </tr>
  <?php do { ?>
   <tr>
    <td><?php echo $row_Recordset1['matricno']; ?></td>
    <td><?php echo $row_Recordset1['firstname']; ?></td>
    <td><?php echo $row_Recordset1['lastname']; ?></td>
    <td><?php echo $row_Recordset1['othername']; ?></td>
    <td><?php echo $row_Recordset1['level']; ?></td>
    <td><?php echo $row_Recordset1['course1']; ?></td>
    <td><?php echo $row_Recordset1['course2']; ?></td>
    <td><?php echo $row_Recordset1['course3']; ?></td>
    <td><?php echo $row_Recordset1['course4']; ?></td>
    <td><?php echo $row_Recordset1['course5']; ?></td>
    <td><?php echo $row_Recordset1['course6']; ?></td>
    <td><?php echo $row_Recordset1['course7']; ?></td>
    <td><?php echo $row_Recordset1['course8']; ?></td>
    <td><?php echo $row_Recordset1['course9']; ?></td>
    <td><?php echo $row_Recordset1['course10']; ?></td>
    <td><?php echo $row_Recordset1['grade1']; ?></td>
    <td><?php echo $row_Recordset1['grade2']; ?></td>
    <td><?php echo $row_Recordset1['grade3']; ?></td>
    <td><?php echo $row_Recordset1['grade4']; ?></td>
    <td><?php echo $row_Recordset1['grade5']; ?></td>
    <td><?php echo $row_Recordset1['grade6']; ?></td>
    <td><?php echo $row_Recordset1['grade7']; ?></td>
    <td><?php echo $row_Recordset1['grade8']; ?></td>
    <td><?php echo $row_Recordset1['grade9']; ?></td>
    <td><?php echo $row_Recordset1['grade10']; ?></td>
    <td><?php echo $row_Recordset1['code1']; ?></td>
    <td><?php echo $row_Recordset1['code2']; ?></td>
    <td><?php echo $row_Recordset1['code3']; ?></td>
    <td><?php echo $row_Recordset1['code4']; ?></td>
    <td><?php echo $row_Recordset1['code5']; ?></td>
    <td><?php echo $row_Recordset1['code6']; ?></td>
    <td><?php echo $row_Recordset1['code7']; ?></td>
    <td><?php echo $row_Recordset1['code8']; ?></td>
    <td><?php echo $row_Recordset1['code9']; ?></td>
    <td><?php echo $row_Recordset1['code10']; ?></td>
    <td><?php echo $row_Recordset1['cgpa']; ?></td>
    <td><?php echo $row_Recordset1['department']; ?></td>
    <td><?php echo $row_Recordset1['semester']; ?></td>
   </tr>
   <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
 </table>
</div>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
  1. <?php require_once('dj.php'); ?>
  2. <?php
  3. $matric_no=0009;
  4. $level = "ND1";
  5. $semester = "FIRST SEMESTER";
  7. $host = "localhost";
  8. $account = "root"  
  9. $password = " " 
  10. $database = "student affairs" 
  11. $connect=mysql_connect($host, $account, $password);
  12. mysql_select_db($database, $connect);
  14. $sql="SELECT *
  15. FROM populate
  16. WHERE matricno LIKE '$matric_no'
  17. AND level LIKE '$level'
  18. AND semester LIKE '$semester'";
  20. $result=mysql_query($sql, $connect);
  21. $row=mysql_fetch_array($result);
  23. mysql_close();
  26. ?>
  27. <html>
  28. <head>
  29. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  30. <title>Untitled Document</title>
  31. <style type="text/css">
  32. <!--
  33. #apDiv1 {
  34.     position:absolute;
  35.     width:886px;
  36.     height:340px;
  37.     z-index:1;
  38. }
  39. -->
  40. </style>
  41. </head>
  43. <body>
  44. <div id="apDiv1">
  45.  <table border="1">
  46.   <tr>
  47.    <td>matricno</td>
  48.    <td>firstname</td>
  49.    <td>lastname</td>
  50.    <td>othername</td>
  51.    <td>level</td>
  52.    <td>course1</td>
  53.    <td>course2</td>
  54.    <td>course3</td>
  55.    <td>course4</td>
  56.    <td>course5</td>
  57.    <td>course6</td>
  58.    <td>course7</td>
  59.    <td>course8</td>
  60.    <td>course9</td>
  61.    <td>course10</td>
  62.    <td>grade1</td>
  63.    <td>grade2</td>
  64.    <td>grade3</td>
  65.    <td>grade4</td>
  66.    <td>grade5</td>
  67.    <td>grade6</td>
  68.    <td>grade7</td>
  69.    <td>grade8</td>
  70.    <td>grade9</td>
  71.    <td>grade10</td>
  72.    <td>code1</td>
  73.    <td>code2</td>
  74.    <td>code3</td>
  75.    <td>code4</td>
  76.    <td>code5</td>
  77.    <td>code6</td>
  78.    <td>code7</td>
  79.    <td>code8</td>
  80.    <td>code9</td>
  81.    <td>code10</td>
  82.    <td>cgpa</td>
  83.    <td>department</td>
  84.    <td>semester</td>
  85.   </tr>
  86.   <?php do { ?>
  87.    <tr>
  88.     <td><?php echo $row_Recordset1['matricno']; ?></td>
  89.     <td><?php echo $row_Recordset1['firstname']; ?></td>
  90.     <td><?php echo $row_Recordset1['lastname']; ?></td>
  91.     <td><?php echo $row_Recordset1['othername']; ?></td>
  92.     <td><?php echo $row_Recordset1['level']; ?></td>
  93.     <td><?php echo $row_Recordset1['course1']; ?></td>
  94.     <td><?php echo $row_Recordset1['course2']; ?></td>
  95.     <td><?php echo $row_Recordset1['course3']; ?></td>
  96.     <td><?php echo $row_Recordset1['course4']; ?></td>
  97.     <td><?php echo $row_Recordset1['course5']; ?></td>
  98.     <td><?php echo $row_Recordset1['course6']; ?></td>
  99.     <td><?php echo $row_Recordset1['course7']; ?></td>
  100.     <td><?php echo $row_Recordset1['course8']; ?></td>
  101.     <td><?php echo $row_Recordset1['course9']; ?></td>
  102.     <td><?php echo $row_Recordset1['course10']; ?></td>
  103.     <td><?php echo $row_Recordset1['grade1']; ?></td>
  104.     <td><?php echo $row_Recordset1['grade2']; ?></td>
  105.     <td><?php echo $row_Recordset1['grade3']; ?></td>
  106.     <td><?php echo $row_Recordset1['grade4']; ?></td>
  107.     <td><?php echo $row_Recordset1['grade5']; ?></td>
  108.     <td><?php echo $row_Recordset1['grade6']; ?></td>
  109.     <td><?php echo $row_Recordset1['grade7']; ?></td>
  110.     <td><?php echo $row_Recordset1['grade8']; ?></td>
  111.     <td><?php echo $row_Recordset1['grade9']; ?></td>
  112.     <td><?php echo $row_Recordset1['grade10']; ?></td>
  113.     <td><?php echo $row_Recordset1['code1']; ?></td>
  114.     <td><?php echo $row_Recordset1['code2']; ?></td>
  115.     <td><?php echo $row_Recordset1['code3']; ?></td>
  116.     <td><?php echo $row_Recordset1['code4']; ?></td>
  117.     <td><?php echo $row_Recordset1['code5']; ?></td>
  118.     <td><?php echo $row_Recordset1['code6']; ?></td>
  119.     <td><?php echo $row_Recordset1['code7']; ?></td>
  120.     <td><?php echo $row_Recordset1['code8']; ?></td>
  121.     <td><?php echo $row_Recordset1['code9']; ?></td>
  122.     <td><?php echo $row_Recordset1['code10']; ?></td>
  123.     <td><?php echo $row_Recordset1['cgpa']; ?></td>
  124.     <td><?php echo $row_Recordset1['department']; ?></td>
  125.     <td><?php echo $row_Recordset1['semester']; ?></td>
  126.    </tr>
  127.    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
  128.  </table>
  129. </div>
  130. </body>
  131. </html>
  132. <?php
  133. mysql_free_result($Recordset1);
  134. ?>


Please someone tell me what is wrong with the coding.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post June 25th, 2010, 9:23 am

  • SpooF
  • ٩๏̯͡๏۶
  • Bronze Member
  • User avatar
  • Joined: May 22, 2004
  • Posts: 3415
  • Loc: Richland, WA
  • Status: Offline

Post June 25th, 2010, 10:03 am

Are you getting any errors? Or is it just not working?
#define NULL (::rand() % 2)
  • Z-axis
  • Novice
  • Novice
  • No Avatar
  • Joined: Jun 15, 2010
  • Posts: 16
  • Status: Offline

Post June 28th, 2010, 5:39 pm

If using Dreamweaver, under server behaviors, create a new recordset, then bind the desired fields

Page 1 of 1

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 289 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.