PHP Forum

**hemin** · 12-20-2005, 04:47 AM

hi all there;
any body can help me with this problem ,
i have atable of students degree (marks) which is thousands of records ;

the structure of the table Students_copy;

CREATE DATABASE hn;
USE hn;
--
-- Table structure for table `hn`.`students_copy`
--
CREATE TABLE `students_copy` ( `examid` text,
`student_name` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
`kurdish` varchar(10) default NULL,
`arabic` varchar(10) default NULL,
`english` varchar(10) default NULL,
`sociality` varchar(10) default NULL,
`mathmatic` varchar(10) default NULL,
`biology` varchar(10) default NULL,
`chemistry` varchar(10) default NULL,
`physics` varchar(10) default NULL,
`sum` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 4096 kB; InnoDB free: 10240 kB';
--

--
INSERT INTO `students_copy` (`examid`,`student_name`,`kurdish`,`arabic`,`engli sh`,`sociality`,`mathmatic`,`biology`,`chemistry`, `physics`,`sum`) VALUES
('3726','ÆÇÑÇã ÓÚÏì Úáì','66','50','50','71','54','56','37','31','415' ),
('3727','ÆÇÑÇã Úáì ÇÍãÏ','65','62','54','67','60','84','64','77','533 '),
('3728','ÆÇÑÇã ÝÊÇÍ ÞÇÏÑ','63','58','50','61','31','61','38','54','416 '),
('3729','ÆÇÑì ÕÇÈÑ ÚÒíÒ','50','38','29','57','19','29','10','51','283 '),
('3730','ÆÇÓÄ ËæÔæ ßÑíã','63','54','50','71','50','64','54','56','462 '),
('3731','ÆæãíÏ ÍÓä ßÑíã','56','50','27','55','50','54','29','51','372 '),
('3732','ÆæãíÏ ãÌíÏ ÚãÑ','67','66','58','61','73','75','50','56','506' ),
('3733','ÆæãíÏ ãÍãÏ ÇÈÑÇåíã','64','57','51','65','51','62','30','53',' 433'),
('3734','ÇÍãÏ ÆÇÏã ÇÍãÏ','56','66','34','60','56','72','59','54','457 '),
('3735','ÇÍãÏÎÇä ÚæáÇÎÇä','61','50','32','71','50','60','50','63',' 437'),
('3736','ÇÍãÏ ÕÇÈÑ ÑÓæá','63','50','37','56','33','74','52','64','429 ');
.
.
.
etc....

which has thousands of records but i didnt put all of them because this post will be full of names but here is some sample of it .

and i want to make a page to search a student record just when he inputs his examid html form .
and i maked an html form see it which is named search_students.html ;

<html>
<head>
<title>search for a student</title>
</head>
<body>
<h2>Search for a student degree</h2>
<br>
<form action="students_copy.php" method="post">
Please enter the ID of the Student Exam :
<br>
<input examid="examid" type=text>
<br>
<input type=submit value="search">
</form>
</body>
</html>

and i maked a php script to retrive the table which is named
students_copy.php you can see it;

<?php
$db=mysql_connect("myhost_name","myuser_name","my_ pw");
mysql_select_db("hn",$db);
$query="select * from students_copy where examid like '%".$examid."%'";
$result=mysql_query($query);
while ($record=mysql_fetch_assoc($result)){
while (list($fieldname,$fieldvalue)=each($record)){
echo $fieldname.":<b>".$fieldvalue."</b><br>";
}
echo "<BR>";
}
?>

and this script not work and outputed to me ;
Notice: Undefined variable: examid in C:\Program Files\Apache Group\Apache2\htdocs\hemin\students_copy.php on line 4
and
all the databases content with this error

can any one help me to give approprite script to retrive one record that validate with the input examid and out put only the record that inputed in html form to just this student.

thanks for your help.....

**hiptobesquare** · 12-20-2005, 11:20 AM

<input examid="examid" type=text>

Should this not read

<input name="examid" type=text>

???

**hemin** · 12-21-2005, 12:54 AM

hi;
i tried that and its the same thing......
the problem is still the same undefined variable examid.

**hiptobesquare** · 12-21-2005, 02:12 AM

Have you tried adding this to your page:

$examid = "$_POST[examid]";

I think it depends on your php settings as to whether a form element is immediately recognised as a variable after submission without calling it with post first.

Dont quote me on that though

**hemin** · 12-22-2005, 03:06 AM

hi hiptobesquare ;
thanks to you this udeful info and its now working my code and the problem solved..

thanks to your help