Getting Array Error message with Begin PHP4 Ch 13

vaderj · #1 (**permalink**) April 13th, 2005, 10:05 AM

Getting:

Warning: array_push(): First argument should be an array in c:\inetpub\wwwroot\enum_options.php on line 16
ENUM options with the default value:

Warning: array_pop(): The argument should be an array in c:\inetpub\wwwroot\enum_options.php on line 23
ENUM options without the default value:

Anyone have ideas?

Mantis · #2 (**permalink**) April 14th, 2005, 06:25 AM

Perhpas if you show us a bit of the code...

vaderj · #3 (**permalink**) April 15th, 2005, 01:54 PM

<?php
//enum_options.php
include "./common_db.inc";
$link_id = db_connect();
mysql_select_db("sample_db");

$query = "SHOW COLUMNS FROM user LIKE 'usercountry'";
$result = mysql_query($query);
$query_data = mysql_fetch_array($result);

if(eregi("('.*')", $query_data["Type"], $match)) {
$enum_str = ereg_replace("'", "", $match[1]);
$enum_options = explode(',', $enum_str);
}

array_push($enum_options, $query_data["Default"]);

echo "ENUM options with the default value:<BR>";
foreach($enum_options as $value) echo "-$value<BR>";

echo "<P>";

array_pop($enum_options);

echo "ENUM options without the default value:<BR>";
foreach($enum_options as $value) echo "-$value<BR>";
?>

vaderj · #4 (**permalink**) April 15th, 2005, 01:55 PM

<?php
$dbhost = 'localhost';
$dbusername = 'phpuser';
$dbuserpassword = 'phppass';
$default_dbname = 'sample_db';
$default_sort_order = 'ASC';
$default_order_by = 'usernumber';
$records_per_page = 5;
$user_tablename = 'user';
$access_log_tablename = 'access_log';
$MYSQL_ERRNO = '';
$MYSQL_ERROR = '';
$new_win_width = 600;
$new_win_height = 400;

function html_header() {
   global $new_win_width, $new_win_height;
   ?>
   <HTML>
   <HEAD>
   <SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
   
   </SCRIPT>
   <TITLE>User Record Viewer</TITLE>
   </HEAD>
   <BODY>
   <?php
}

function html_footer() {
?>
</BODY>
</HTML>
<?php
}

function db_connect($dbname='') {
   global $dbhost, $dbusername, $dbuserpassword, $default_dbname;
   global $MYSQL_ERRNO, $MYSQL_ERROR;

   $link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
   if(!$link_id) {
      $MYSQL_ERRNO = 0;
      $MYSQL_ERROR = "Connection failed to the host $dbhost.";
      return 0;
   }
   else if(empty($dbname) && !mysql_select_db($default_dbname)) {
      $MYSQL_ERRNO = mysql_errno();
      $MYSQL_ERROR = mysql_error();
      return 0;
   }
   else if(!empty($dbname) && !mysql_select_db($dbname)) {
      $MYSQL_ERRNO = mysql_errno();
      $MYSQL_ERROR = mysql_error();
      return 0;
   }
   else return $link_id;
}

function sql_error() {
   global $MYSQL_ERRNO, $MYSQL_ERROR;

   if(empty($MYSQL_ERROR)) {
      $MYSQL_ERRNO = mysql_errno();
      $MYSQL_ERROR = mysql_error();
   }
   return "$MYSQL_ERRNO: $MYSQL_ERROR";
}

function error_message($msg) {
   html_header();
   echo "<SCRIPT>alert(\"Error: $msg\");history.go(-1)</SCRIPT>";
   html_footer();
   exit;
}

function enum_options($field, $link_id) {
   $query = "SHOW COLUMNS FROM user LIKE '$field'";
   $result = mysql_query($query, $link_id);
   $query_data = mysql_fetch_array($result);
   if(eregi("('.*')", $query_data["Type"], $match)) {
   $enum_str = ereg_replace("'", "", $match[1]);
   $enum_options = explode(',', $enum_str);
   return $enum_options;
} else return 0;
}
?>

BobbyFisher · #5 (**permalink**) April 17th, 2005, 04:37 PM

print_r($enum_options) before the call to array_push() and end the script. Ensure that $enum_options is indead an array.

Everything is temporary, some things are just more temporary than others... except for death, that seems to be pretty permanent

Need to download code?

Navigation