note 35951 deleted from function.mysql-fetch-array by dave
| From: | dave@php.net | Date: | Thu, 26 Feb 2004 12:48:23 +0000 |
| Subject: | note 35951 deleted from function.mysql-fetch-array by dave | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-65794@lists.php.net to get a copy of this message | ||
Note Submitter: phan70m&hotmail.com@popfile.sf.net
----
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)