Esempio n. 1
0
}
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;
Esempio n. 2
0
    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);
    }
Esempio n. 3
0
    $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;