"Chip Wiegand" <[EMAIL PROTECTED]> wrote
> I have a database, all the data is numbers. I want to make a query that
> will extract the data and then make it available in an array, so the
> array is populated 'real-time'. I could just enter the number into an
> array manually, but I want to automate the job. I don't know what to
> start looking for, the 3 books I have either don't talk about this or I
> just am missing it.
> Could someone point me in the right direction?
This class makes it possible to return an array in two ways very easy.
Just try this
$db = new Ms_db;
$db->connect(true); // open a persistant connection
$vars1 = $db->query("SELECT * FROM table");
$vars2 = $db->query("SELECT * FROM table","off");
$vars1 is now build this way
$vars1[row][column] contains the required value...
$vars2[column][row] contains the required value...
Maybe this helps:
<?php
/**
mySQL - Database Class
**/
// Database Configuration Variables (local) //
define ("DB_SERVER","localhost");
define ("DB_USER","root");
define ("DB_PASS","");
define ("DB_DB","testfaq");
class Ms_db
{
/**
* Attributes of this class
**/
var $db_result = 0; // Stores the last result_id
var $db_id = 0; // Stores the current Database Connection ID
var $db_datasets = array(); // Stores the last read database-Set as hash
[colum-name][row_number]
/**
* Connect
* @author Marcel Schindler
* @param bool $persistant
* @return void
**/
function connect($persistant =
FALSE,$server=DB_SERVER,$user=DB_USER,$pass=DB_PASS,$database=DB_DB)
{
if (($persistant == FALSE))
{
$this->db_id = @mysql_connect($server,$user,$pass)
or $this->db_error("Failed to connect to
Database-Server",mysql_error());
}
else
{
$this->db_id = @mysql_pconnect($server,$user,$pass)
or $this->db_error("Persistant connection
failed",mysql_error());
}
@mysql_select_db($database) or $this->db_error("Failed to select
Database",mysql_error());
}
/**
* Query
* @param SQL-Query
* @param flip boolean
* @return array $dataset
**/
function query($sql,$flipped="on")
{
$db = $this->db_id;
$wert = array();
$count= 0;
if (!$db) $this->db_error("Keine Verbindung zur Datenbank");
$res = @mysql_query($sql) or $this->db_error("Fehlerhaftes
SQL-Statement",$sql."<br>".mysql_error());
while ($data = mysql_fetch_assoc($res))
{
$wert[$count] = $data;
$count ;
}
if ($flipped == "on") $wert = $this->reorder_array($wert);
$this->db_datasets=$wert;
return $wert;
}
/**
* Close - closes the connection to the Database
**/
function close()
{
mysql_close();
}
/**
* Reorder_array
* @param: $array = array();
* @return: $array;
**/
function reorder_array($arr)
{
$wert = array();
// Array ist vom Typ $wert[Zeile][Spalte], soll aber als
$wert[Spalte][Zeile]
foreach ($arr as $sub)
{
while (list ($key1,$val1) = each ($sub))
{
$wert[$key1][] = $val1;
}
}
$this->db_datasets = $wert;
return $wert;
}
/**
* db_error - displays a well-formatted HTML-Page with the error-message
* @param string errormessage
* @param string mysql-error (optional)
**/
function db_error($message,$error='')
{
echo '<html><head><title>'.$message.'</title></head><body
bgcolor="#eeeeee">';
echo '<table align="center" width="600" height="400"
bgcolor="#ffffff">';
echo '<tr><td><h1>Error:</h1></td></tr><tr><td>';
highlight_string($message);
if ($error!='')
{
echo '<br><br>MySQL said:'.$error;
}
echo '</td></tr></table></body></html>';
die();
}
/**
* NumRows
* Checks the Number of rows affected by the last query
* @return integer $number
**/
function numrows()
{
$number = @mysql_num_rows($this->db_result);
return $number;
}
/**
* DUMP - just dumps the current array (just for informal purposes
* @param VOID
**/
function dump()
{
$x = $this->numrows();
if ($x == 0 ) $this->db_error("There was no query placed
before","");
echo '<strong>Query DUMP</strong><br><table border="1"
cellspacing="0" cellpadding="0" width="100%"><tr>';
$wert = $this->db_datasets;
$spalten = array_keys($wert);
foreach ($spalten as $values)
{
$spaltenname[] = $values;
echo "<th bgcolor=\"#000000\"><font
color=\"#ffffff\">$values</font></th>";
}
echo "</tr>";
for ($t = 0; $t <= $x; $t )
{
if ($t % 2 == 0) echo "<tr bgcolor=\"#dddddd\">";
else echo "<tr bgcolor=\"#eeeeee\">";
foreach($spaltenname as $values)
{
echo "<td vAlign=\"top\">".$wert[$values][$t]."</td>";
}
echo "</tr>";
}
echo "</table>";
}
}
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
