<?php
if(!isset($_SESSION['username']) && !isset($_SESSION['email']))
{
echo '<h2>Geen toegang</h2> U bent niet ingelogt op de website.';
}
else
{
echo '<h2>Produckt informatie</h2>';
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
$sTrans['name'] = 'naam';
$sTrans['cats'] = 'categarie';
$sTrans['price'] = 'prijs';
$sTrans['information'] = 'informatie';
$sTrans['picture1'] = 'Afbeelding 1';
$sTrans['picture2'] = 'Afbeelding 2';
$sRandomCode = substr(md5(rand(0,9999999999)), 0, 5);
// Validatie!
if(empty($_POST['name']))
{
$aError[] = 'Product naam is leeg.';
}
elseif(ctype_alnum($_POST['name']))
{
$aError[] = 'De product naam is niet geldig!';
}
elseif(strlen($_POST['name']) < 3)
{
$aError[] = 'De product naam is te kort! ( > 3 )';
}
elseif(strlen($_POST['name']) > 150)
{
$aError[] = 'De product naam is te lang! ( < 150 )';
}
if(is_float($_POST['cats']))
{
$aError[] = 'Product catogaries is niet een nummer.';
}
if(is_float($_POST['price']))
{
$aError[] = 'Product prijs is geen bedrag!';
}
if(empty($_POST['information']))
{
$aError[] = 'Product information is leeg.';
}
elseif(ctype_alnum($_POST['information']))
{
$aError[] = 'De product information is niet geldig!';
}
elseif(strlen($_POST['information']) < 10)
{
$aError[] = 'De product information is te kort! ( > 10 )';
}
elseif(strlen($_POST['information']) > 500)
{
$aError[] = 'De product information is te lang! ( < 500 )';
}
if(isset($aError) && count($aError) > 0)
{
echo '<ul><span class="red">Er zijn fouten opgetreden:</span>';
foreach($aError as $sError)
{
echo '<li>' . $sError . '</li>';
}
echo '</ul>';
}
else
{
// Start afbeelding 1
if($_FILES['picture1']['type'] == 'image/jpeg')
{
if($_FILES['picture1']['size'] < 1048576)
{
if($_FILES['picture1']['size'] > 50)
{
if($sPicture1 = file_get_contents($_FILES['picture1']['tmp_name']))
{
if(file_put_contents('./images/thumbs/' . strtolower($_SESSION['username']) . '-1-' . $sRandomCode . '-' . strtolower($_FILES['picture1']['name']), $sPicture1))
{
$sSize = getimagesize($_FILES['picture1']['tmp_name']);
if($sSize[0] > 800 && $sSize[1] > 600)
{
$aError2[] = 'Afbeelding 1 is groter dan 800x600.';
}
elseif($sSize[0] < 200 && $sSize[1] < 200)
{
$aError2[] = 'Afbeelding 1 is kleiner dan 200x200.';
}
}
else
{
$aError2[] = 'Kon Afbeelding 1 niet uploaden.';
}
}
else
{
$aError2[] = 'Kon Afbeelding 1 niet uploaden.';
}
}
else
{
$aError2[] = 'Afbeelding 1 is kleiner dan 50 bytes!';
}
}
else
{
$aError2[] = 'Afbeelding 1 is groter dan 5000 bytes!';
}
}
else
{
$aError2[] = 'Afbeelding 1 is niet JPG/JPEG.';
}
// Sluit afbeelding 1
// Start afbeelding 2
if($_FILES['picture2']['type'] == 'image/jpeg')
{
if($_FILES['picture2']['size'] < 1048576)
{
if($_FILES['picture2']['size'] > 50)
{
if($sPicture2 = file_get_contents($_FILES['picture2']['tmp_name']))
{
if(file_put_contents('./images/thumbs/' . strtolower($_SESSION['username']) . '-2-' . $sRandomCode . '-' . strtolower($_FILES['picture2']['name']), $sPicture2))
{
$sSize = getimagesize($_FILES['picture2']['tmp_name']);
if($sSize[0] > 800 && $sSize[1] > 600)
{
$aError2[] = 'Afbeelding 2 is groter dan 800x600.';
}
elseif($sSize[0] < 200 && $sSize[1] < 200)
{
$aError2[] = 'Afbeelding 2 is kleiner dan 200x200.';
}
}
else
{
$aError2[] = 'Kon Afbeelding 2 niet uploaden.';
}
}
else
{
$aError2[] = 'Kon Afbeelding 2 niet uploaden.';
}
}
else
{
$aError2[] = 'Afbeelding 2 is kleiner dan 50 bytes!';
}
}
else
{
$aError2[] = 'Afbeelding 2 is groter dan 5000 bytes!';
}
}
else
{
$aError2[] = 'Afbeelding 2 is niet JPG/JPEG.';
}
// Sluit afbeelding 2
if(isset($aError2) && count($aError2) > 0)
{
echo '<ul><span class="red">Er zijn fouten opgetreden:</span>';
foreach($aError2 as $sError2)
{
echo '<li>' . $sError2 . '</li>';
}
echo '</ul>';
}
else
{
/*
CREATE TABLE `webshop`.`products` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`sid` INT( 5 ) NOT NULL ,
`name` VARCHAR( 150 ) NOT NULL ,
`cats` INT( 5 ) NOT NULL ,
`price` VARCHAR( 50 ) NOT NULL ,
`information` TEXT NOT NULL ,
`picture1` VARCHAR( 200 ) NOT NULL ,
`picture2` VARCHAR( 200 ) NOT NULL ,
`date` DATETIME NOT NULL ,
`remote` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = InnoDB
*/
$sQuery = mysql_query("
INSERT INTO
products
(
pro_sid,
pro_name,
pro_cats,
pro_price,
pro_information,
pro_picture1,
pro_picture2,
pro_remote,
pro_date
)
VALUES
(
'" . mysql_real_escape_string($rowUser['use_id']) . "',
'" . mysql_real_escape_string($_POST['name']) . "',
'" . mysql_real_escape_string($_POST['cats']) . "',
'" . mysql_real_escape_string($_POST['price']) . "',
'" . mysql_real_escape_string($_POST['information']) . "',
'" . mysql_real_escape_string(strtolower($_SESSION['username']) . "-1-" . $sRandomCode . "-" . strtolower($_FILES['picture1']['name'])) . "',
'" . mysql_real_escape_string(strtolower($_SESSION['username']) . "-2-" . $sRandomCode . "-" . strtolower($_FILES['picture2']['name'])) . "',
'" . mysql_real_escape_string($_SERVER['REMOTE_ADDR']) . "',
NOW()
)
");
if(mysql_error())
{
echo mysql_error();
}
else
{
echo 'De volgende produckt is toegevoegt genaamt ' . $_POST['name'] . ' de prijs is ' . $_POST['price'] . ' en zit in catogarie ' . $aProducts[$_POST['cats']] . '.';
}
}
}
}
?>
<form name="form-submit" method="post" enctype="multipart/form-data" action="/account/submit/">
<fieldset>
<legend>Produckt naam:</legend>
<input name="name" type="text" size="50" maxlength="150" value="<?php echo isset($_POST['name']) ? $_POST['name'] : ''; ?>" />
</fieldset>
<fieldset>
<legend>Catogarie:</legend>
<select size="1" name="cats" id="cats">
<option value="0" <?php if(!isset($_POST['cats'])) { echo 'selected="selected"'; } ?>>Keuze:</option>
<?php
foreach($aProducts as $sNumber => $sProduct )
{
echo '<option value="' . $sNumber . '" title="' . $sProduct . '" ' . (isset($_POST['cats']) && $_POST['cats'] == $sNumber ? 'selected="selected"' : '') . '>' . $sProduct . '</option>' . PHP_EOL;
}
?>
</select>
</fieldset>
<fieldset>
<legend>Prijs:</legend>
<input name="price" type="text" size="50" maxlength="150" value="<?php echo isset($_POST['price']) ? $_POST['price'] : ''; ?>" /> Max. 9999.99
</fieldset>
<fieldset>
<legend>Informatie:</legend>
<textarea rows="9" name="information" class="textarea" cols="37"><?php echo isset($_POST['information']) ? $_POST['information'] : ''; ?></textarea>
</fieldset>
<h2>Afbeeldingen toevoegen</h2>
Mocht u geen 2 plaatjes hebben doe dan gelijke plaatjes in de inputs.
<fieldset>
<legend>Afbeelding 1:</legend>
<input name="picture1" type="file" size="59" maxlength="250" /> JPG/JPEG
</fieldset>
<fieldset>
<legend>Afbeelding 2:</legend>
<input name="picture2" type="file" size="59" maxlength="250" /> JPG/JPEG
</fieldset>
<fieldset>
<legend> </legend>
<input type="submit" class="submit2" value=" Toevoegen " />
</fieldset>
<?php
}
?>
|
