Junior Member
Help in Php?
ma ny mysql ma aik table bnai hy us ka name "mk" hy.
us ma 3 fields hy
1. Roll#
2. Name
3. Marks
isi tara ma ny php ma ak form bnya hy jis ma ma ny aik text box bnaya hy ar label "Enter Roll #".
us k neehny ak "Search" ka button ar dosra "Reset" ka button hy.
ma chata ho k me is ma koi b roll # enter kro ar Roll#, Name & Marks show ho jai.
thanks.
plz help me.
Senior Member+
well aap mujhe email send krein main aap ko code send kar doun ga ......
my email is ..............
Last edited by XoOaiL; 26th August 2009 at 06:28 PM. Reason: email address not allowed
Senior Member+
aap mujhe mail krein main aap ko code send kardoun ga...
my id is..................
Last edited by XoOaiL; 26th August 2009 at 06:29 PM. Reason: email address not allowed
Senior Member+
Emails are not allowed to given in open forums within ITD
Khanqah Daruslam
Member
Solution
pakilala said:
pyariay dost aaj may nay sara din aap k liay lagaya or akhir aik solution dond lia may nay do pages bana li aap is ko use karay
database , host , or password ko change karay , or isay use karay waisay may nay yay apnay sath thay kr lia ta k tab tak khana nahi kao ga jab tak yaya kam mukaml na karo...
dost aap k database table mai aik musla ta jis ki waja say mere 3 ghantay lagay par Allah ka karam hay k wo hal ho gaya ...
wo masla yay ta aaap nay Rool no istrah lika ta Roll# php working with my sql do not accept this sign # ... bt now problem is solved enjoy an plzz pray for me i m physically disable (mazoor ho ) or aik bimari b hay us k liay b dua kray plz...
here is the script..
this is search page....
-------------------------------------------------
<html>
<head>
<title>Checking Result Online</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="result.php">
<p> </p>
<p align="center">Enter Roll #
<input name="rno" type="text" id="rno">
<br>
<br>
<input type="submit" name="Submit" value="search">
<input name="reset" type="reset" id="reset" value="Reset">
</p>
</form>
</body>
</html>
and this is another page...
called result.php
----------------------------------------------
<?php
$db_name1="record";// Database name
$conn=mysql_connect("localhost","root","") or die("I Couldn't connect");
$db=mysql_select_db($db_name1,$conn) or die("I Couldn't select your database");
$query="select * from mk where Roll='$_POST[rno]'";
$result=mysql_query($query,$conn);
$val=mysql_fetch_array($result);
?>
<table width="80%" border="0" align="center">
<tr bgcolor="#CC6600">
<td><strong>Name</strong></td>
<td><strong>Roll # </strong></td>
<td><strong>Marks</strong></td>
</tr>
<tr bgcolor="#000000">
<td><font color="#FFFFFF"><em><strong><?php echo $val["Name"];?> </strong></em></font></td>
<td><font color="#FFFFFF"><em><strong><?php echo $val["Roll"];?></strong></em></font></td>
<td><font color="#FFFFFF"><em><strong><?php echo $val["Marks"];?></strong></em></font></td>
</tr>
</table>
----------------------------------------------------------------
Member
Solution
pyariay dost aaj may nay sara din aap k liay lagaya or akhir aik solution dond lia may nay do pages bana li aap is ko use karay
database , host , or password ko change karay , or isay use karay waisay may nay yay apnay sath thay kr lia ta k tab tak khana nahi kao ga jab tak yaya kam mukaml na karo...
dost aap k database table mai aik musla ta jis ki waja say mere 3 ghantay lagay par Allah ka karam hay k wo hal ho gaya ...
wo masla yay ta aaap nay Rool no istrah lika ta Roll# php working with my sql do not accept this sign # ... bt now problem is solved enjoy an plzz pray for me i m physically disable (mazoor ho ) or aik bimari b hay us k liay b dua kray plz...
here is the script..
this is search page....
-------------------------------------------------
<html>
<head>
<title>Checking Result Online</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="result.php">
<p> </p>
<p align="center">Enter Roll #
<input name="rno" type="text" id="rno">
<br>
<br>
<input type="submit" name="Submit" value="search">
<input name="reset" type="reset" id="reset" value="Reset">
</p>
</form>
</body>
</html>
and this is another page...
called result.php
----------------------------------------------
<?php
$db_name1="record";// Database name
$conn=mysql_connect("localhost","root","") or die("I Couldn't connect");
$db=mysql_select_db($db_name1,$conn) or die("I Couldn't select your database");
$query="select * from mk where Roll='$_POST[rno]'";
$result=mysql_query($query,$conn);
$val=mysql_fetch_array($result);
?>
<table width="80%" border="0" align="center">
<tr bgcolor="#CC6600">
<td><strong>Name</strong></td>
<td><strong>Roll # </strong></td>
<td><strong>Marks</strong></td>
</tr>
<tr bgcolor="#000000">
<td><font color="#FFFFFF"><em><strong><?php echo $val["Name"];?> </strong></em></font></td>
<td><font color="#FFFFFF"><em><strong><?php echo $val["Roll"];?></strong></em></font></td>
<td><font color="#FFFFFF"><em><strong><?php echo $val["Marks"];?></strong></em></font></td>
</tr>
</table>
----------------------------------------------------------------
or ha jab aap ko yay script mil jaye to mujay private msg zaror karay...
Posting Permissions
Reply With Quote
Bookmarks