} if ($_POST['Type']) { $c = array($_POST['Type']); } else { $c[] = array("RO (58 mm)", "RU (58 mm)", "RV (58 mm)"); } if ($_POST['Connection']) { $c = array($_POST['Connection']); } else { $c[] = array("connector", "Cable", "terminals"); } if ($_POST['approval']) { $c = array($_POST['approval']); } else { $c[] = array("cNRTLus (TUV)", "e1"); } $c = utf8_string_array_encode($c); $tableName = "products_7"; $cols = "System,Design,Resolution,Shaft,Output,Features,Bit,Type,Connection,approval,imgurl"; $conn = sqlConnectDefault(); for ($i = 0; $i < $_POST['id']; $i++) { $select = array(); for ($j = 0; $j < 10; $j++) { $select[] = $c[$j][array_rand($c[$j])]; } $select[] = "'https://www.ifm.com/tedo/foto/400_00" . rand(10, 36) . ".gif'"; simpleInsert($select, $tableName, $cols, $conn); } $statusMessage = makeStatusMessage(26, "success", "Product added!"); mysqli_close($conn); return;
mysql_close($conn); return; } $row = $result->fetch_assoc(); if (is_null($row['iid'])) { $cols = "userid"; $data = "'" . $row['uid'] . "'"; $columns = array("fname", "lname", "firm", "address", "city", "country", "phone"); foreach ($columns as $c) { if (!empty($_POST[$c])) { $data .= ",'" . $_POST[$c] . "'"; $cols .= "," . $c; } } $tableName = "user_info"; if (simpleInsert($data, $tableName, $cols, $conn)) { $statusMessage = makeStatusMessage(10, "type:success", "Data saved successfully!"); } else { $statusMessage = makeStatusMessage(11, "error", "DB error while creating data!"); } } else { $update = ""; $columns = array("fname", "lname", "firm", "address", "city", "country", "phone"); foreach ($columns as $c) { if (!empty($_POST[$c])) { $update .= $c . "='" . $_POST[$c] . "',"; } } if (substr($update, -1, 1) == ',') { $update = substr($update, 0, -1); }
$statusMessage = makeStatusMessage(234, "error", "Error getting category properties."); mysqli_close($conn); return; } $cols = array(); $colTypes = array(); $name = "products_" . $catid; while ($row = $result->fetch_assoc()) { $cols[] = $row['name']; $colTypes[] = "varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL"; } $resultCrT = createTable($name, $cols, $colTypes, $conn); if (!$resultCrT) { $statusMessage = makeStatusMessage(234, "error", "Error creating product table for this category."); mysqli_close($conn); return; } $cols = array("catid", "propid"); $tableNames = array("props_to_prods"); foreach ($_POST['fid'] as $f) { $insertData = array($catid, $f); $resultAddProps = simpleInsert($insertData, $tableNames[0], $cols, $conn); } if (!$resultAddProps) { $statusMessage = makeStatusMessage(3, "error", "Could not assign properties to category."); mysqli_close($conn); return; } $statusMessage = makeStatusMessage(21, "success", "Category successfully added!"); mysqli_close($conn); return;