[PHP][MySQL] Problem z warning i notice Opcje

[eminiasty]

Bledy:

[PHP] pobierz, plaintext 
Warning: trim() expects parameter 1 to be string, array given in C:\xampp\htdocs\M\inc\inc_other\functions.php on line 36
Notice: Undefined index: active in C:\xampp\htdocs\M\inc\script\categories.php on line 64
Notice: Use of undefined constant active - assumed 'active' in C:\xampp\htdocs\M\inc\script\categories.php on line 82
Notice: Undefined offset: 0 in C:\xampp\htdocs\M\inc\script\categories.php on line 101
[PHP] pobierz, plaintext 

Chce dodawac do bazy kategorie o kilku typach.


Robie to w nastepujacy sposob:

[PHP] pobierz, plaintext 
$query2="
INSERT INTO ".$prefix."categories (`categories_id` ,`users_id`,`categories_name`,`categories_colorText`, `categories_colorBg`,`categories_active`, `categories_dateAdd`) 
VALUES('','".$user."','".$name."','".$colortext."','".$colorbg."','".active."', NOW())
"; 
 
$result= mysqli_query($link,$query2) or die(mysqli_error());
 
 
$categories = mysqli_insert_id($link);
 
if(!empty($_POST['type'])) {
$type = array();
$work = 0;		
foreach($_POST['type'] as $i ) { 
    $type[$i] = filtrujDane($link,$_POST['type'][$i]);
	$work=$work+1;
}	
 
for($i=0;$i<$work;$i++){
$query3="
INSERT INTO ".$prefix."categoriestype (`categoriestype_id`, `categories_id`) 
VALUES('".$categories."','".$type[$i]."')";
$result = mysqli_query($link,$query3) or die(mysqli_error());
	}
}
[PHP] pobierz, plaintext 

Kod niby dziala, aczkowlwiek, wystepuja powyze bledy, chcialbym wiedziec jak je wyeliminowac?

w name formularza mam name='type()'

Ten post edytował eminiasty 25.06.2016, 11:44:39

[eminiasty]

Mgógłbyś to rozjaśnic? Pierwszy raz widze cos pokroju mysqli_stmt..