|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2001-04-23 07:39 UTC] joris_van_boven at hotmail dot com
<html><body>
<h1>Kijk hier een database!</h1>
<a href='Prob01.PHP'>Prob 01 (PHP)</a>
<?
$SQLhost = "localhost";
$SQLgebruiker = "Administrator";
$SQLpassword = "xxxxxxxxx";
// connect database-------------------------------------------------------------------------------------------------
@$objconn = mysql_connect($SQLhost,$SQLgebruiker,$SQLpassword)
or die("Da is hier mis gelopen! Kan niet inloggen op de database: ".$SQLhost." ".$SQLgebruiker." ".$SQLpassword );
// Basis SQL-string-------------------------------------------------------------------------------------------------
$Sqlstring = "SELECT id, naam, com FROM prob";
// Ophalen data en in tabel steken----------------------------------------------------------------------------------
echo "<table border=1><TR><TH>ID</TH><TH>Persoon</TH><TH>Commentaar</TH></TR>";
$dbRecordSet = mysql_db_query($SQLgebruiker, $Sqlstring);
while ($dbRecord = mysql_fetch_array($dbRecordSet))
{
echo "<TR><TD>".$dbRecord[id]."</TD><TD>".$dbRecord[naam]."</TD><TD>".$dbRecord[com]."</TD></TR>";
}
echo "</table>";
// Sluiten database--------------------------------------------------------------------------------------------------
$dbRecord=null;
mysql_close($objconn);
$objconn=null;
?>
</body></html>
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Tue Apr 23 10:01:29 2024 UTC |
RTFM: mysql_connect ("localhost"," user", "pw"); $query = "SELECT * from blaat"; mysql_select_db ("db1"); $r = mysql_query ($query); while ($s = mysql_fetch_row($r)) { /* Do Stuff */ }