I have simple form with mutiples of 2 fields: status1 / name1,status2 / name2...
The test1_edit.php file is as below. If I only INSERT $status, the form is working fine, but I don't how to INSERT both $status and $name in FOREACH.Code:<form method="post" action="test1_edit.php"> <input type='checkbox' name='status[]' value='active'>Status1 <input name="name[]" type="text" />Name1<br /> <input type='checkbox' name='status[]' value='active'>Status2 <input name="name[]" type="text" />Name2<br /> <input name="submit" type="submit" /><br /> </form>
Thanks for help! This is really urgent for tomorrow the assingment is due.Code:$status=$_POST['status']; $name=$_POST['name']; foreach ($status as $status ){ mysql_query ("INSERT INTO test (status) VALUES('$status')",$connection); //mysql_query ("INSERT INTO test (status, name)) VALUES('$status','$name')",$connection);// This doesn't work. if (mysql_affected_rows()==1){ continue; } else { echo "<p class='register'> Something went wrong!</p>"; break; } } header("Location: test1.php"); ?>



Reply With Quote
Bookmarks