note 52756 added to ref.array
| From: | a dot lang at freenet dot de | Date: | Wed, 11 May 2005 18:36:20 +0000 |
| Subject: | note 52756 added to ref.array | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-89285@lists.php.net to get a copy of this message | ||
With help of this function you can save a whole db in an Array.
Usage:
$sql = mysql_query("SELECT * FROM DB");
$dbarray = sqlar($sql);
function sql2ar ($sql, $return = true)
{
$sql2 = mysql_fetch_assoc($sql);
$befehl ="";
$keys = array_keys($sql2);
for($i2 = 0;$i2 < count($keys);$i2++)
{
$befehl .= '$array[$i][\''.$keys[$i2].'\'] =
$row[\''.$keys[$i2].'\'];';
}
mysql_data_seek($sql,0);
$i = 0;
while($row = mysql_fetch_assoc($sql))
{
eval($befehl);
$i++;
}
if($return == true)
{
return $array;
}
else
{
echo "<pre>";
print_r($array);
echo "</pre>";
}
}
----
Manual Page -- http://www.php.net/manual/en/ref.array.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+52756
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+52756&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+52756&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+52756&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+52756&report=yes&reason=useless
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+52756&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+52756&report=yes
Search -- http://master.php.net/manage/user-notes.php