[RESOLVED] Help with insert multiple rows and post queries

[giswoman]

the code is supposed to insert multiple rows and once it's completed it will redirect to another page. Well it redirects but not insert. Here is code.

//remove backlashes
nukeMagicQuotes();
//create database connection
$conn = new mysqli('localhost', $user, $pwd, 'mosquito') or die ('Cannot open database');
  // data that stays static
  $trap = $_POST['TRAP'];
  $day = $_POST['DAY'];
  $week = $_POST['WEEK'];
  $local = $_POST['LOCAL'];
  $date = ('NOW()');
  $same = array("$trap", "$day", "$week", "$local", "$date");
  //grouping first data group
  $s1 = $_POST['SPECIES1'];
  $m1 = $_POST['MALE1'];
  $f1 = $_POST['FMALE1'];
  $group[] = array("$s1", "$m1", "$f1");
  //grouping second data group
  $s2 = $_POST['SPECIES2'];
  $m2 = $_POST['MALE2'];
  $f2 = $_POST['FMALE2'];
  $group[] = array("$s2", "$m2", "$f2");
  //arrainging data into rows 
  foreach ($group as $row) {
	$row[]= array(array_merge($group, $same));
	}
  //preparing data of insert into table
  $query_values = implode(',', $row);

$query = "INSERT INTO collections (SPECIES, MALE, FMALE, TRAP, DAY, WEEK, LOCAL, DATE) VALUES $query_values";
$result = mysql_query($query, $conn);

  //redirect if successful or disply error
if (!result) {
  die ('Error: '.mysql_error());
  }
  else {
  header('Location: mosMain.php');
}

[steven1978]

From what I can see, you are trying to insert constants inside the insert statement, but you have not defined them. The following line:

$query = "INSERT INTO collections (SPECIES, MALE, FMALE, TRAP, DAY, WEEK, LOCAL, DATE) VALUES $query_values";

Where are the constants such as 'TRAP' set?

Should you not be using the variables you have defined using the posted values, e.g: where you have done:

$trap = $_POST['TRAP'];

You should then use the variable $trap in the insert statement. Try echoing the query out to see if there are actual values in there:

echo $query

[steven1978]

actually ignore my last post, I hadn't read your code properly, I can see no that 'TRAP' is a field name! 🙂

[giswoman]

😃 Thanks I fixed it. It was in how i was connecting to my database and a few other little tweeks. THanks