Implode() error

[Eazygo]

Hello all,

Im trying to make a sign up page for my website. The code is fine until I try inserting the data into mysql database.
Here is the full code.
The error im getting is this:

Warning: implode() [function.implode]: Invalid arguments passed

Ive added a little comment in the code where the problem section is.

Any help would be greatly appreciated.

<?php

include("misc.inc.php"); 

foreach($_POST as $item => $value)
{
  if ($item != "camera")
    {
	  if ($value == "")
	  {
	     $blanks[] = $item;
      }
	}
}

if(isset($blanks))
{
   $message_new = "The following fields are blank. Please enter the required information:  ";
   foreach($blanks as $value)
   {
      $message_new .= "$value, ";
   }
   extract($_POST);
   include("signup_form.inc.php");
   exit();
}

foreach($_POST as $item => $value)
{
   if(!empty($value))
   {
      if(eregi("name",$item) or eregi("intro",$item))
      {
	      if(!ereg("^[A-Za-z0-9.,' -]{1,50}$",$value))
		    {
			   $errors[] = "$value is not a valid entry.";
			}
       }
	   if(eregi("email",$item))
      {
       if(!ereg("^.+@.+\\..+$",$value))
         {
            $errors[] = "$value is not a valid email address.";
         }
       }
   }
}

if(@is_array($errors))
{
   $message_new = "";
   foreach($errors as $value)
    {
	  $message_new .= $value." Please try again<br />";
	}
	extract($_POST);
	include("signup_form.inc.php");
	exit();
}

$cxn =mysqli_connect($host,$user,$passwd,$dbname);

foreach($_POST as $item => $value)
{

  if($item != "Button" and $item != "do")
  {
   if($item == "password")
   {
      $password = strip_tags(trim($value));
   }
   else
   {

              $items[]=$item;
  $value = strip_tags(trim($value));
  $values[] = mysqli_real_escape_string($cxn, $value);
  $$item = $value;

   }

  }

}


$sql = "SELECT loginName FROM members WHERE loginName = '$loginName'";
$result = mysqli_query($cxn,$sql)
          or die("Couldn't execute select query.");
$num = mysqli_num_rows($result);
if (num > 0)
{
   $message_new = "loginName already used. Select another User Name. ";

   include("signup_form.inc.php");
   exit();
}

/*error here*/
else
{
                $today = date("Y-m-d");
	$items_str = implode(",",$items);
	$values_str = implode('","',$values);
	$items_str .=",createDate";
	$values_str .='"'.",".'"'.$today;
	$items_str .=",password";
	$values_str .= '"'.","."md5"."('".$password."')";
	$sql = "INSERT INTO Member ";
                $sql .= "(".$items_str.")";
                $sql .= " VALUES ";
                $sql .= "(".'"'.$values_str.")";
                $result = mysqli_query($cxn,$sql)
                or die("Couldn't execute insert query.");
                $_SESSION['auth']="yes"; 
                $_SESSION['logname'] = $loginName; 

header("Location: index.php");
}


include("signup_form.inc.php");

?>

[halojoy]

Probably $items is not an array, or maybe not defined.

This line looks very strange:
implode('","',$values)

I should make a test:

/*error here*/
else
{

echo '<pre>'; // debug
print_r($items);
print_r($values);

            $today = date("Y-m-d");
$items_str = implode(",",$items);
$values_str = implode('","',$values);
$items_str .=",createDate";
$values_str .='"'.",".'"'.$today

[Eazygo]

Ok il give that a go, not at my computer at the moment tho so im going to have to do it later. Il post back with the results 😃
Thanx

[Eazygo]

Hi I tried adding your code and it pretty much comes up with the same error message which is this:

Warning: implode() [function.implode]: Invalid arguments passed in C:\xampp\htdocs\signup.php on line 149

Warning: implode() [function.implode]: Invalid arguments passed in C:\xampp\htdocs\signup.php on line 150

So both the implode statements have invalid arguments.
I see what you mean about $items or $values not being an array, however i thought the array was defined in the following code:

 else
   {

              $items[]=$item;
  $value = strip_tags(trim($value));
  $values[] = mysqli_real_escape_string($cxn, $value);
  $$item = $value;

   }

Thanx for looking.

Eazygo

[johanafm]

foreach($_POST as $item => $value)
{
  if($item != "Button" and $item != "do")
  {
   if($item == "password")
   {
   }
   else
   {
                  $items[]=$item;
      $value = strip_tags(trim($value));
      $values[] = mysqli_real_escape_string($cxn, $value);
      $$item = $value;
   }
  }
}

If ALL of the below:
$_POST has any elements
- $item is not 'Button'
- $item is not 'do'
- $item is not 'password'

only THEN $items will be defined. Otherwise it won't. Yet, every time you get no query results, you

if (num > 0)
{

}
/*error here*/
else
{
    $items_str = implode(",",$items);

[Eazygo]

Hi im still having trouble with my coding. Just cant seem to get it to work and im totally confused.

The following code is fine and i want to keep it(this code checks for errors):

<?php

include("misc.inc.php"); 

foreach($_POST as $item => $value)
{
  if ($item != "camera")
    {
	  if ($value == "")
	  {
	     $blanks[] = $item;
      }
	}
}

if(isset($blanks))
{
   $message_new = "The following fields are blank. Please enter the required information:  ";
   foreach($blanks as $value)
   {
      $message_new .= "$value, ";
   }
   extract($_POST);
   include("signup_form.inc.php");
   exit();
}

foreach($_POST as $item => $value)
{
   if(!empty($value))
   {
      if(eregi("name",$item) or eregi("intro",$item))
      {
	      if(!ereg("^[A-Za-z0-9.,' -]{1,50}$",$value))
		    {
			   $errors[] = "$value is not a valid entry.";
			}
       }
	   if(eregi("email",$item))
      {
       if(!ereg("^.+@.+\\..+$",$value))
         {
            $errors[] = "$value is not a valid email address.";
         }
       }
   }
}

if(@is_array($errors))
{
   $message_new = "";
   foreach($errors as $value)
    {
	  $message_new .= $value." Please try again<br />";
	}
	extract($_POST);
	include("signup_form.inc.php");
	exit();
}

Also here is my code for the signup form:

  <body>

  <form action="signup.php" method="POST">
  <table border="0" width="100%">

  <?php
          if (isset($message_new))
		  {
		     echo "<tr><td style='color: red; font-weight: bold' colspan='2'>
			       <p>$message_new</p></td></tr>";
		  }
  ?>

  <tr><td class="bold_right">First Name</td>
      <td><input type="text" name="f_name"
      value="<?php echo @$f_name ?>"
      size="20" maxlength="20" /></td></tr>
    <tr><td class="bold_right">Last Name</td>
      <td><input type="text" name="l_name"
      value="<?php echo @$l_name ?>"
      size="20" maxlength="20" /></td></tr> 
     <tr><td class="bold_right">Camera</td>
      <td><input type="text" name="camera"
      value="<?php echo @$camera ?>"
      size="30" maxlength="30" /></td></tr>
     <tr><td class="bold_right">Field</td>
      <td><select name = "field">
      <?php
	     $FieldName= getField();
		 for ($n=1;$n<=5;$n++)
		 {
		     $field = $FieldName[$n];
			 echo "<option value='$field'";
			 if ($field== "Other")
              echo " selected";
               echo ">$field\n";
	     }
	  ?>
      </select>
      </td></tr>
      <tr><td class="bold_right">Introduction</td>
      <td><input type="text" name="intro"
      value="<?php echo @$intro ?>"
      size="40" maxlength="150" /></td></tr>
      <tr><td class="bold_right">Email</td>
      <td><input type="text" name="email"
      value="<?php echo @$email ?>"
      size="20" maxlength="20" /></td></tr>
      <tr><td>&nbsp;</td></tr>
      <tr><td>&nbsp;</td></tr>

  <tr><td class="bold_right">Login Name</td>
  <td><input type="text" name="loginName"
  value="<?php echo @$loginName ?>"
  size="20" maxlength="20" /></td></tr>
  <tr><td class="bold_right">Password</td>
  <td><input type="text" name="password"
  value="<?php echo @$password ?>"
  size="20" maxlength="255" /></td></tr>


  <input type="hidden" name="do" value="new">

<tr><td>&nbsp;</td></tr>

<tr>
<td style="text-align: center">
<input type="submit"
value="submit"></td>
</tr>

  </table>
  </form>

  </body>

Now all I want to do is insert the given information into the database table which is shown below:

Field Type Null Key Default

picture varchar(60) YES NULL
member_id int(10) unsigned NO PRI NULL
f_name varchar(20) YES NULL
l_name varchar(20) YES NULL
field varchar(20) YES NULL
camera varchar(30) YES NULL
intro varchar(150) YES NULL
email varchar(60) YES NULL
loginName varchar(20) NO NULL
createDate date NO NULL
password varchar(255) NO NULL

If anyone can give me a solution for this code i would be sooo happy. Sorry to do this, it is a last reort.

Thanx.