Sponsored by NuSphere - PHP Software for PHP Application Developers - On Sale This Week for $100



Go Back   PHP-Editors > Editors and Tools > PHP Desktop Editors

PHP Desktop Editors Talk all about PHP Editors.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 2005-08-31, 06:28 AM
Junior Member
 
Join Date: Aug 2005
Posts: 16
monika
Default

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>
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 2005-10-21, 02:51 AM
Member
 
Join Date: Dec 2004
Posts: 62
nirus
Default

Try this mysql_query

$result = mysql_query($query ,$link) or die("$query
" . mysql_error());

-Brent
Reply With Quote
  #3 (permalink)  
Old 2005-11-11, 04:56 PM
Junior Member
 
Join Date: Aug 2005
Posts: 16
monika
Default

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
Reply With Quote
  #4 (permalink)  
Old 2005-11-11, 05:05 PM
Junior Member
 
Join Date: Aug 2005
Posts: 16
monika
Default

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......
Reply With Quote
Must read Review for Serious PHP Developers


NuSphere PhpED 5.0 : The Staff of php-editors.com recently spent a few days working with NuSphere PhpED 5.0 (a popular PHP IDE) and NuCoder 1.4 (a PHP Encoding Utility), read up on all the details.

Sponsored Links
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:48 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.