View unanswered posts | View active topics It is currently Thu Dec 14, 2017 5:48 pm



Reply to topic  [ 3 posts ] 
 PHP exam result search page 
Author Message
Junior Member

Joined: Mon Aug 29, 2005 11:13 am
Posts: 17
Post 
I try to design result search page using php and mysql but i failed in mysql so any one there who can help me




//But i dont knw how to put all the data in MySQL, like regno,firstname,division well i'm very

//bad in MYSql bettter say dont know any thing, but intrested in learning.

<HTML>
<HEAD></HEAD>
<BODY>
<?php
$Array["regno"] =trim ($Array["regno"]);

$Host="localhost";
$User="monika";
$Password="monikash";
$DBName="Dbmonika";
$TableName="result";

$Link = mysql_connect($Host, $User, $Password);
$Query="SELECT * from $TableName Where regno= $Array[regno]";
$Result= mysql_db_query ($DBName, $Query, $Link);

while ($Row = mysql_fetch_array ($Result)){



print (" Register No:$Row[regno], $Row[firstname] Division: $Row[division]
");
}
mysql_close ($Link);
?>
</BODY>
</HTML>


Tue Aug 30, 2005 11:28 pm
Report this post
Profile
Junior Member

Joined: Mon Aug 29, 2005 11:13 am
Posts: 17
Post 
hi thanks for ur help....dumping in mysql is no problem now but i'm having problem in searching...

as my search page containg following....this

Students Roll NO
Students Class

user has to fill both and has to press search button..but i dont knw how to make that form box work..

php is good plug to manage..the above search box..but i dont knw what to write..how to make the php search the mysql data and print the result......>>>>>>>>>>>>>>>>>>>>

help me


Fri Nov 11, 2005 10:56 am
Report this post
Profile
Junior Member

Joined: Mon Aug 29, 2005 11:13 am
Posts: 17
Post 
hi thanks for ur help....dumping in mysql is no problem now but i'm having problem in searching...

as my search page containg following....this

Students Roll NO
Students Class

user has to fill both and has to press search button..but i dont knw how to make that form box work..

php is good plug to manage..the above search box..but i dont knw what to write..how to make the php search the mysql data and show the result to the user.....

for eg... if i put Roll No 105 and Class XI in each box and press the search button, then result should come by searching mysql database....thus what is the php cript..for that......


Fri Nov 11, 2005 11:05 am
Report this post
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


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

Search for:
Jump to:  
cron
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.