note 35951 added to function.mysql-fetch-array

From: 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

« previous php.notes (#56804) next »