Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search script in MYSQL
- Thread starter mercury1
- Start date
- Thread starter
- #3
Steps are
1. connect to MySql with hostname, username, passwd,
2. select ur database
3. get ur query handle
4. get yr data in yr way. I got in HTML tables. For proper viewing of this file u have to put ithe following code in a webserver and view as web page
u can execute this query in php directly as php filename.php
Last but not least get a good book on PHP and visit
for further PHP queries got o PHP forum at forum434
![[ponder]](/data/assets/smilies/ponder.gif "[ponder] [ponder]")
----------------
ur feedback is a very welcome desire
1. connect to MySql with hostname, username, passwd,
2. select ur database
3. get ur query handle
4. get yr data in yr way. I got in HTML tables. For proper viewing of this file u have to put ithe following code in a webserver and view as web page
u can execute this query in php directly as php filename.php
Last but not least get a good book on PHP and visit
Code:
<HTML>
<BODY>
<?PHP
$host = "linux" ;
$user = "MyName" ;
$paswd = "MyPasswd" ;
$db = "MyDb" ;
$qry = "SELECT * From MyTable" ;
mysql_connect("$host", "$user", "$paswd")
or die("No connection to host") ;
mysql_select_db("$db") or die("Cannot select $db") ;
?>
<!--
Could be wriiten with PHP block using print comd.
Out to show that only needed command in PHP to avoid uneccessary parsing overheads
-->
<TABLE>
<?
$result = mysql_query($qry) ;
while ($row = mysql_fetch_array($result))
{
print("<TR>
<TD>$row[PrtNo]</td>
<TD>$row[Mfr]</td>") ;
$no = $row['Qty'] * 5 ;
// Please note that case the filed name is in quotes.
/* Earlier were already in double quotes so no need to quote twice
Single and double quotes have behaviourail diiference
When field names are used as array subscript names they should match case and spelling of the field in SQL.
i.e. if SELECT Prtno, mfr then subscript would be
$row[Prtno] or $row[mfr]
*/
print("<TD>$no</td></tr>") ;
}
?>
</table>
</body>
</html>----------------
ur feedback is a very welcome desire
- Status