PHP/MySQL Database/mysql fetch array
Содержание
An Example of Using the Old MySQL Extension
<source lang="html4strict">
<?php
mysql_connect("localhost", "username", "password");
mysql_select_db("mydatabase");
$result = mysql_query("SELECT * FROM mytable");
while($row = mysql_fetch_array($result)) {
foreach($row as $key=>$value) {
echo "$key = $value
\n";
}
}
mysql_free_result($result);
mysql_close();
?>
</source>
Get data from database
<source lang="html4strict">
<html>
<head> <title>Get data</title> </head> <body>
<?php $conn=@mysql_connect( "localhost", "userName", "password" ) or die( "Err:Conn" ); $rs = @mysql_select_db( "my_database", $conn ) or die( "Err:Db" ); $sql = "select id, first_name from my_table"; $rs = mysql_query( $sql, $conn ); while( $row = mysql_fetch_array( $rs ) ) {
echo( "ID: " . $row["id"] ); echo( " - FIRST NAME: " . $row["first_name"] . "
" );
} ?> </body> </html>
</source>
mysql_fetch_array-2.php
<source lang="html4strict">
<? mysql_connect("localhost","root",""); mysql_select_db("mydatabase"); $query = "SELECT id, title FROM mytable ORDER BY title"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
$title = $row[1]; $id = $row[0]; echo "Product: $title ($id)
";
} ?>
</source>
mysql_fetch_array.php
<source lang="html4strict">
<? mysql_connect("localhost","root",""); mysql_select_db("mydatabase");
$query = "SELECT id, title FROM mytable ORDER BY title"; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$title = $row["title"]; $id = $row["id"]; echo "Product: $title ($id)
";
} ?>
</source>
Retrieving and Displaying Results
<source lang="html4strict">
<?php
function opendatabase ($host,$user,$pass) {
try {
if ($db = mysql_connect ($host,$user,$pass)){
return $db;
} else {
throw new exception ("Sorry, could not connect to mysql.");
}
} catch (exception $e) {
echo $e->getmessage ();
}
}
function selectdb ($whichdb, $db){
try {
if (!mysql_select_db ($whichdb,$db)){
throw new exception ("Sorry, database could not be opened.");
}
} catch (exception $e) {
echo $e->getmessage();
}
}
function closedatabase ($db){
mysql_close ($db);
}
$db = opendatabase ("localhost","root","");
selectdb ("mydatabase",$db);
if ($aquery = mysql_query ("SELECT * FROM mytable ORDER BY id ASC")){
while ($adata = mysql_fetch_array ($aquery)){
echo "ID: " . $adata["id"] . "
";
echo "Title: " . stripslashes ($adata["title"]) . "
";
echo "Artist: " . stripslashes ($adata["myvalue"]) . "
";
}
} else {
echo mysql_error();
}
closedatabase ($db);
?>
</source>
Using timestamp with mysql
<source lang="html4strict">
<html> <head> <title>Using timestamp</title> </head> <body> <?php
$conn = mysql_connect( "localhost", "userName", "password" );
$rs = mysql_select_db( "my_database", $conn );
$sql = "select * from guestbook where id=1";
$rs = mysql_query( $sql, $conn );
#split the timestamp into organized date format
while ( $row = mysql_fetch_array( $rs ) )
{
$datetime = $row["time"];
$year = substr( $datetime, 0, 4 );
$mon = substr( $datetime, 4, 2 );
$day = substr( $datetime, 6, 2 );
$hour = substr( $datetime, 8, 2 );
$min = substr( $datetime, 10, 2 );
$sec = substr( $datetime, 12, 2 );
$orgdate = date("l F dS, Y h:i A", mktime( $hour, $min, $sec, $mon, $day, $year ) );
echo( "Time of entry: " . $orgdate );
}
?> </body> </html>
</source>
while loop and mysql_fetch_array() function
<source lang="html4strict">
<html>
<head>
<title>Get data</title>
</head>
<body>
<?php
$conn = @mysql_connect( "localhost", "userName", "password" ) or die( "Err:Conn" );
$rs = @mysql_select_db( "my_database", $conn ) or die( "Err:Db" );
$sql = "select id,first_name from my_table order by first_name";
$rs = mysql_query( $sql, $conn );
while( $row = mysql_fetch_array( $rs ) )
{
echo( "ID: " . $row["id"] );
echo( " - FIRST NAME: " . $row["first_name"] . "
" );
}
?>
</body>
</html>
</source>
