note 35951 added to function.mysql-fetch-array
| From: | phan70m&hotmail dot com at popfile dot sf dot net | Date: | Sat, 20 Sep 2003 08:33:30 +0000 |
| Subject: | note 35951 added to function.mysql-fetch-array | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-56804@lists.php.net to get a copy of this message | ||
Macromedia Dreamweaver is a very popular tool for editing php files, I like it a lot, so here's
a couple of snipets for your coding pleasure:
(most of them or for the purpose of quick copy paste from phpMyAdmin)
name: fetch to array
insert before: $
insert after: = mysql_fetch_array($result);
(include trailing space)
name: fetch to list
insert before: list($
inset after: ) = mysql_fetch_row($result);
name: $result
block: $result = mysql_query($sql, $dbi);
name: $sql warper
before: $sql = "
after: ";
(higly usefull when using phpMyAdmin)
name: sql.php generator
block: <?php
function connect_db() {
$db_server = 'localhost';
$db_user = '';
$db_password = '';
$db_database = '';
$dbi = mysql_connect($db_server, $db_user, $db_password) or die(mysql_error());
mysql_select_db($db_database);
return $dbi;
}
if (!isset($dbi)) $dbi = connect_db();
?>
(this one is good to requier_once() and don't forget to global $dbi; if your in a function,
since if u do like me, it will make all sorts of wierd hardly debugable errors)
----
Manual Page -- http://www.php.net/manual/en/function.mysql-fetch-array.php
Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+35951
Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+35951&report=yes
Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+35951&report=yes